"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