T
Teacher
How do I keep the same format in a worksheet after it is moved/copied to
another workbook?
another workbook?
G
Gary''s Student
Cell formats and row heights and column widths should all be preserved when
the worksheet is copied.
the worksheet is copied.
R
Red
Lets say you want to copy Sheet1 into another workbook. All you should have
to do is right click on the worksheet tab labeled "Sheet1" and select Move or
Copy. A new window will open and you select the workbook you want to copy
the worksheet to, select the sheet in question, and then click the "create a
copy" box at the bottom before pressing ok. Once this is done your worksheet
should be exactly the same as it is in the original file.
Hope this helps
to do is right click on the worksheet tab labeled "Sheet1" and select Move or
Copy. A new window will open and you select the workbook you want to copy
the worksheet to, select the sheet in question, and then click the "create a
copy" box at the bottom before pressing ok. Once this is done your worksheet
should be exactly the same as it is in the original file.
Hope this helps
E
Ed Cones
You can also use your mouse and click in the column headers or row headers
and drag across the columns or rows you want, right-click and copy (or
Ctrl-C). When you paste it to a new spreadsheet you'll get formatting. This
also works for specific rows or columns instead of the entire sheet.
and drag across the columns or rows you want, right-click and copy (or
Ctrl-C). When you paste it to a new spreadsheet you'll get formatting. This
also works for specific rows or columns instead of the entire sheet.
T
Teacher
Hi Red,
When I copy a worksheet with formatting and a Chart to another workbook, the
"new" worksheet in the new workbook takes on the theme formatting of the
destination workbook instead of just copying the worksheet as is. This is in
excel 2007. Any ideas?
When I copy a worksheet with formatting and a Chart to another workbook, the
"new" worksheet in the new workbook takes on the theme formatting of the
destination workbook instead of just copying the worksheet as is. This is in
excel 2007. Any ideas?
T
Teacher
Yes, thank you; however, in Excel 2007 the copied worksheet takes on the
format that is alrady in another sheet in the workbook. How do we keep the
original format in the sheet from the source workbook?
Thank you.
format that is alrady in another sheet in the workbook. How do we keep the
original format in the sheet from the source workbook?
Thank you.
E
Ed Cones
It works on my Excel 2003 and 2007. I'm talking about clicking on the column
header (A, B, C, D . . . .) and dragging across to highlight the entire
column. Copying and pasting from there will get all formatting -- at least
on mine.
I'm probably not using the right name for what I'm calling "column headers."
;o)
header (A, B, C, D . . . .) and dragging across to highlight the entire
column. Copying and pasting from there will get all formatting -- at least
on mine.
I'm probably not using the right name for what I'm calling "column headers."
;o)