ExcelBanter - Q25: How to paste values in excel sheet.

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!
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dawn" wrote:
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 dont want to do it manually,
How to automatic realize it ?
Thanks.
Dawn