Copy Paste

[Jack Brackson]

Is there a way to convert all the formulas in a spreadsheet to values.

I tried copy-paste special-values but there are merged cells and that does
not work.

TIA.

 

[Bernie Deitrick]

Jack,

It will work as long as you don't change the selection in between copying and pasting.

HTH,
Bernie
MS Excel MVP