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


"Stan" wrote in message
...
In EXCEL I want to copy a sheet layout and put it in a new sheet. I have
data results which I want to put in sheets for each month of the year, but
I
don't want to re-copy all the headings and row names for each month. I am
sure there is a way, but can't find it in the HELP. Thanks for any
suggestions you may have. Stan.......


Right click the tab at the bottom of the sheet, then click Move or Copy.
Now, smile when you see how easy it is. You can copy the sheet into the same
workbook (and it'll increment its own name), or into a different workbook.