Copy all but Formulas
 

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

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

Copy all but Formulas
 

Almost!

I now have the format (ie borders and cell borders) along with the values
but the column and row sizes are all back to default!

Nick

"Sean Timmons" wrote in message
...
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

Copy all but Formulas
 

You can also paste special, column widths.

Copy all but Formulas
 

Thanks to you both - for some reason I thought it was easier than that - but
must have been thinking of something else

Your help is really appreciated

Nick

"charlie" wrote in message
...
You can also paste special, column widths.