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