View original (French)

Duplicate Excel sheet without formulas

mrvk -  
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
    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