Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying excel worksheets to new worksheet
I know how to copy a worksheet to make a new worksheet but can anyone tell me
how to copy a worksheet so that when it is copied across the column widths and row heights are excatly the same as the original. It is becoming a pain that after copying it I have to go through the whole of the new worksheet(s) changing column widths and row heights to the original widths and heights. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying excel worksheets to new worksheet
When you copy an entire worksheet, it should preserve columns width. If
you're manually copying sections of the worksheet over, when you go to paste, right-click select paste special, and select column width. Then you immediately do a regular paste on top on that. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Ian" wrote: I know how to copy a worksheet to make a new worksheet but can anyone tell me how to copy a worksheet so that when it is copied across the column widths and row heights are excatly the same as the original. It is becoming a pain that after copying it I have to go through the whole of the new worksheet(s) changing column widths and row heights to the original widths and heights. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying excel worksheets to new worksheet
You can copy a worksheet into the same workbook by holding the CTRL
key down and dragging the sheet tab to where you want it to appear (a little arrow indicates where). Excel will add (2) or (3) etc to the name of the new sheet, but you can easily rename it by double-clicking the tab. This gives you an exact copy, so all formatting including column widths etc remains the same. Hope this helps. Pete On Dec 19, 3:31*pm, Ian wrote: I know how to copy a worksheet to make a new worksheet but can anyone tell me how to copy a worksheet so that when it is copied across the column widths and row heights are excatly the same as the original. It is becoming a pain that after copying it I have to go through the whole of the new worksheet(s) changing column widths and row heights to the original widths and heights. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying fixed cell value from different worksheets to new worksheet | Excel Discussion (Misc queries) | |||
Copying changes from one worksheet to other worksheets | Excel Worksheet Functions | |||
Copying Numerical Totals of separate worksheets to a single Summary Worksheet | Setting up and Configuration of Excel | |||
Copying Numerical Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) | |||
Copying Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) |