Pasting All Formulas in workbook as values

[EvilTwinOfAtrus]

Hi

I'm looking for an easy way of converting all of my formula cells to value cells without having to go through every cell in every sheet.

For example, I want '=2+4' to just be the value '6'

Over to you

Thankyou,
Karl

 

[xlbo]

Select the grey square to the left of col header A and above row 1 - this will select the entire sheet.

Edit>Copy
Edit>PasteSpecial>Values

et voila !

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[EvilTwinOfAtrus]

Heh, sorry, I forgot to mention, it's just a certain range. But the range is the same on every sheet in the workbook.

 

[xlbo]

Use mouse and shift to select all the sheets which need to have this done
Select the range
Edit>Copy
Edit>PasteSpecial>Values
De-Select the sheets

et Voila

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question