View Single Post
  #1   Report Post  
wamorgan1956
 
Posts: n/a
Default 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?