Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
holding worksheet formats when copying/pasting
When I copy a worksheet into a new worksheet, the columns, rows, fonts etc do
not remain the same as the original format which causes us to have to manually resize the new worksheet to match the existing one. Does anyone have a solution? thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
holding worksheet formats when copying/pasting
This might not retain every thing you want moved over but you can 'copy' the
1st sheet and then 'paste special' ... 'column widths' to get the width info, then copy your data over. "hsyrddy" wrote: When I copy a worksheet into a new worksheet, the columns, rows, fonts etc do not remain the same as the original format which causes us to have to manually resize the new worksheet to match the existing one. Does anyone have a solution? thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
holding worksheet formats when copying/pasting
Try copying and "Paste Special" (by right clicking on a cell in the new
worksheet and selecting 'paste special'). In the Paste Special window select "Format" and "OK" to apply it. All your formats should be preserved. "hsyrddy" wrote: When I copy a worksheet into a new worksheet, the columns, rows, fonts etc do not remain the same as the original format which causes us to have to manually resize the new worksheet to match the existing one. Does anyone have a solution? thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with copying and pasting dates from one worksheet to anot | Excel Discussion (Misc queries) | |||
copying and holding certain cells in the function | Excel Discussion (Misc queries) | |||
copying and holding certain cells in the function | Excel Discussion (Misc queries) | |||
Copying and Pasting a Worksheet | Setting up and Configuration of Excel | |||
Hided values appears when I'm copying/pasting it to other worksheet | Excel Discussion (Misc queries) |