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

[Guest]

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?

 

[Fredrik Wahlgren]

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

 

[Gord Dibben]

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

 

[Lady Layla]

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


: 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?