Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Combine Workbooks as separate worksheets
I lose column widths and row heights when I copy unto a new worksheet. Does
anyone have any suggestions. I have four separate workbooks that need to be combined into one workbook but on a separate worksheet. I am using Microsoft Office XP, Excel 2002. Thanks, SAL |
#2
|
|||
|
|||
Hi Sal
You can use copy pastespecial (column width) line for the columns But there is no option for rows. If all the rows have the same row height then it is easy to do also. See also http://www.rondebruin.nl/copy3.htm If you need help with the pastespecial code line post back -- Regards Ron de Bruin http://www.rondebruin.nl "SAL" wrote in message ... I lose column widths and row heights when I copy unto a new worksheet. Does anyone have any suggestions. I have four separate workbooks that need to be combined into one workbook but on a separate worksheet. I am using Microsoft Office XP, Excel 2002. Thanks, SAL |
#3
|
|||
|
|||
Are you trying to copy the whole worksheet? If so, try right clicking on the sheet tab, select "Move or Copy...", and follow the dialog to make an exact copy (column widths and all) of the worksheet. -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=375649 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting worksheets to workbooks. Is there an easy way? | Excel Discussion (Misc queries) | |||
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) | |||
How can I combine 3 separate mailing list? | New Users to Excel | |||
WorkBooks In Separate Windows. | New Users to Excel |