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
|