View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Pete
 
Posts: n/a
Default In EXCEL copy sheet layout to another sheet

If you CTRL-drag the sheet tab along the bottom of the sheet, you will
be able to copy the sheet in its entirety (i.e. including all
formatting, column widths etc) - a small black arrow will indicate
where the new sheet will be inserted. Once you have done this, it is
relatively easy to delete any data etc and rename the sheet .

Hope this helps.

Pete