| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
| I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
| Can't Copy and Paste between Excel 2003 Workbooks | Excel Discussion (Misc queries) | |||
| Copy and Paste and keep format the same | Excel Discussion (Misc queries) | |||
| copy paste cell character limit | Excel Discussion (Misc queries) | |||
Linear Mode
