Copy all but Formulas
Try doing copy-paste special values, then without moving anything, right
click again and do paste special, formats.
"Nick Wakeham" wrote:
I am using Office 2007 and want to copy a worksheet in an Excel workbook
that contains formats, values, and formulas - I want to copy everything
intact EXCEPT for the formulas. I have tried Copy and Paste Special but that
either doesn't keep the format of the page or I get the format but no
values. What on earth am I doing wrong - I'm sure I used to just do a Copy
and Paste Special and it worked but something somewhere has changed.
Help appreciated
Nick
|