Q25: How to paste values in excel sheet.

[Dawn]

I have an excel, it contains about 20 sheets.
Every sheet has formula in it.
I want another excel , it is the copy of the above excel,
While in it there is no formula , only the value of the above excel.
Because the sheets are too many , I don’t want to do it manually,
How to automatic realize it ?
Thanks.
Dawn

 

[Max]

A couple of simple steps to group all sheets, then kill the lot with an
"in-place" entire sheet copy n paste special as values, followed by
ungrouping should do it in a matter of seconds ..

1. Save as a copy
2. In the copy, group all sheets:
Hold down SHIFT, click on 1st (leftmost) tab, then click on last (rightmost)
tab - this groups all tabs in-between, inclusive for ensuing collective
action at one go
3. Freezing all the grouped sheets:
Select the entire sheet > copy
Right-click > paste special > Check "Values" > ok
Press Esc to clear the dotted marquee
Click on say A1, to deselect the entire sheet
4. Ungroup the sheets by right-clicking on any tab > Ungroup sheets > Done!