Duplicate Excel sheet without formulas

Question

Hello,  I have an Excel workbook with several Excel sheets containing tables, formulas, etc. The first page of this workbook summarizes all the table results succinctly, thanks to formulas like "=C3" very simply.  I would like to duplicate this first sheet into another one, maintaining the layout, etc., and displaying the results without these formulas. This way, we could modify the results in this new sheet without affecting the cells in the future.  If anyone has a tip ;) Thank you  Configuration: Windows 7 / Internet Explorer 8.0

Frenchie83 · Answer

Hello  Copy and paste "the sheet will be identical to the one being copied"  then do a "special paste values" to keep only the values without the formulas  Best regards

PHILOU10120 · Answer

Hello  Once the sheet is duplicated, do a copy / paste values; this will remove the formulas  -- Practice makes perfect. - It’s when you’re up against the wall that you see the bricklayer - one always learns from their mistakes.

mrvk · Answer

Thank you. I did copy/paste-values.  I have the same sheet (without the formatting :/) but what I would like is that when I change a value in my first sheet, it gets automatically updated in my new sheet, without having to copy/paste every time.  Is it possible?

PHILOU10120 · Answer

Hello  The question is poorly phrased Do you want an identical sheet without the formulas Or Do you want an identical sheet that references the values of the cells from the first one with a formula link For example, on sheet 2 in A1 you want the information from sheet 1 The formula would be =sheet1!A1  -- Practice makes perfect. - It's at the wall's foot that one sees the mason - one always learns from their mistakes

Duplicate Excel sheet without formulas

4 réponses

Canon mb5350 - cartridge replacement impossible

Texture issues in enshrouded

Select next line csh foreach

Win32 kamso then rootkit detection

Win32:spyware-gen [trj] detected by avast

Unknown video error on the freebox player

Make it or break it

How to open a cbr file

Please log in with manager privileges.

Wake on lan with livebox