How do I keep the same format in a worksheet after it is moved/copied to
another workbook?

Cell formats and row heights and column widths should all be preserved when
the worksheet is copied.
--
Gary''s Student - gsnu200766


"Teacher" wrote:

How do I keep the same format in a worksheet after it is moved/copied to
another workbook?

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

"Teacher" wrote:

How do I keep the same format in a worksheet after it is moved/copied to
another workbook?

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.

"Ed Cones" wrote:

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.

"Teacher" wrote:

How do I keep the same format in a worksheet after it is moved/copied to
another workbook?

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)




"Teacher" wrote:

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.

"Ed Cones" wrote:

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.

"Teacher" wrote:

How do I keep the same format in a worksheet after it is moved/copied to
another workbook?