ExcelBanter - Copy Paste

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - Copy Paste (https://www.excelbanter.com/new-users-excel/37564-copy-paste.html)

Jack Brackson

Copy Paste

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

"Jack Brackson" wrote in message
...
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.

All times are GMT +1. The time now is 02:46 PM.