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?