Combine Workbooks as separate worksheets

G

Guest

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
 
R

Ron de Bruin

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
 
M

MrShorty

Are you trying to copy the whole worksheet? If so, try right clickin
on the sheet tab, select "Move or Copy...", and follow the dialog t
make an exact copy (column widths and all) of the worksheet
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying excel worksheets to new worksheet 2
Extract rows from workbooks 2
Collate Worksheets into single workbook 3
Combine multiple workbooks into one workbook 1
Copying and pasting table info and cell formating in one hit 3
Combine 7 files then create 1 master 2
multiple workbooks in one file 3
TWO SEPARATE WORKBOOKS NEEDED ON EXCEL 07??? 2

Top