Sorry, it should have said Sheet.xlt, not Sheet.xla.

Pete

On Jul 12, 1:56 am, Pete_UK wrote:
If you CTRL-drag a sheet tab into the same workbook you get an exact
copy of the sheet including any headers that are set up on it,
formats, column widths etc as well as any data and formulae in that
sheet. So, you might like to set up a blank template on the first
sheet with headers how you want them to appear and just keep using
CTRL-drag for new sheets.

If, instead, you use Insert | Worksheet then the new sheet is taken
from Sheet.xla in your startup folder (if it exists) or from Excel's
default new sheet. If neither of these have the headings you talk
about, then this is how you should insert a new sheet without the
headers.

Presumably you mean Excel 2007 and not Word 2007 !

Hope this helps.

Pete

On Jul 12, 1:16 am, DHM wrote:



Word 2007
I have a workbook and I insert new worksheets. I use the tab at the bottom
to insert the worksheet. I want the same header for all the worksheets in
that workbook. How can I customize the inserted worksheet so that I do not
have to add the header. But I do not want those headers on other workbooks
when I insert a worksheet.- Hide quoted text -

- Show quoted text -