Saving without formulas

[Guest]

Is it possible to save a spreedsheet with only the the cell values and not the associated formulas. Basically, what I want to do is a giant Copy PasteSpecial Values across an entire workbook

Thanks

Bob

 

[Paul]

Is it possible to save a spreedsheet with only the the cell values and not

the associated formulas. Basically, what I want to do is a giant Copy
PasteSpecial Values across an entire workbook.

Thanks.

Bob

Group the worksheets (by clicking the first tab and holding down Shift
whilst clicking the last tab). Then whatever you do in one worksheet will be
done to all. So, select the whole visible worksheet (by pressing the grey
button at the intersection of row numbers and column letters). Copy and
Paste Special > Values.

 

[Guest]

Paul,

Thanks for the help.

Bob