HOW DO I PRESERVE FORMATTING WHEN PASTING INTO A NEW WORKBOOK?
 

i recently downloaded an excel sheet with an inventory list (06082717.xlt)
and would like to copy the formatted worksheet to multiple worksheets so that
each worksheet lists only one inventory item. if i select the formatted cells
and copy them, when i paste them to a new worksheet all the formatting is
lost and i have to re-do it by hand. surely there must be an easier way?

"wamorgan1956" wrote in message
...
i recently downloaded an excel sheet with an inventory list
(06082717.xlt)
and would like to copy the formatted worksheet to multiple worksheets so
that
each worksheet lists only one inventory item. if i select the formatted
cells
and copy them, when i paste them to a new worksheet all the formatting is
lost and i have to re-do it by hand. surely there must be an easier way?

After copying, use Edit Paste Specialn... and check "All".

/Fredrik

sorry, that does not help. the formatting is lost!

"Fredrik Wahlgren" wrote:


"wamorgan1956" wrote in message
...
i recently downloaded an excel sheet with an inventory list
(06082717.xlt)
and would like to copy the formatted worksheet to multiple worksheets so
that
each worksheet lists only one inventory item. if i select the formatted
cells
and copy them, when i paste them to a new worksheet all the formatting is
lost and i have to re-do it by hand. surely there must be an easier way?

After copying, use Edit Paste Specialn... and check "All".

/Fredrik

What type of formatting are you losing?

Row heights and column widths?

Data formats, like colors or dates turn to numbers or.........?

Just for info........an *.XLT file is a Workbook Template, not a sheet.


Gord Dibben Excel MVP

On Tue, 12 Apr 2005 14:34:35 -0700, "wamorgan"
wrote:

sorry, that does not help. the formatting is lost!

"Fredrik Wahlgren" wrote:


"wamorgan1956" wrote in message
...
i recently downloaded an excel sheet with an inventory list
(06082717.xlt)
and would like to copy the formatted worksheet to multiple worksheets so
that
each worksheet lists only one inventory item. if i select the formatted
cells
and copy them, when i paste them to a new worksheet all the formatting is
lost and i have to re-do it by hand. surely there must be an easier way?

After copying, use Edit Paste Specialn... and check "All".

/Fredrik

Hold your control key down and click on the tab of the sheet in question, drag
to the right -- you should have exact duplicates


"wamorgan1956" wrote in message
...
: i recently downloaded an excel sheet with an inventory list (06082717.xlt)
: and would like to copy the formatted worksheet to multiple worksheets so that
: each worksheet lists only one inventory item. if i select the formatted cells
: and copy them, when i paste them to a new worksheet all the formatting is
: lost and i have to re-do it by hand. surely there must be an easier way?