| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy all but Formulas
You can also paste special, column widths.
|
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy several formulas from.... | Excel Worksheet Functions | |||
| Copy formulas | Excel Worksheet Functions | |||
| automatically copy formulas down columns or copy formulas all the | Excel Worksheet Functions | |||
| How do I copy formulas but using the same range each time I copy | Excel Worksheet Functions | |||
| Copy Value not formulas | Excel Worksheet Functions | |||
Linear Mode
