Saving without formulas

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Bob Ewers said:
Is it possible to save a spreedsheet with only the the cell values and not
Click to expand...
the associated formulas. Basically, what I want to do is a giant Copy
PasteSpecial Values across an entire workbook.
Thanks.

Bob
Click to expand...

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.
 
Back
Top