View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Pete_UK
 
Posts: n/a
Default Copy worksheet and keep all formating

You can do a CTRL-drag of the worksheet tab, either into the same
workbook or into another open one. This retains all formatting, column
widths etc.

Hope this helps.

Pete