View original (French)

Duplicate Excel sheet without formulas

mrvk Posted messages 2 Status Member -  
PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   -
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

4 answers

  1.
    Frenchie83 Posted messages 2254 Status Member 339
     
    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
    0