Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Default headers in Excel 97 1

Status
Not open for further replies.

garrym01

Technical User
Jul 17, 2001
14
US
How do I set up a default header in Excel 97. Is there another way other than setting up a blank workbook?
 
If you want the headers to be included without firther intervention you need to save them in the default templates, which are Book.xlt and Sheet.xlt and both should be in your xlStart folder.

You need to include the header on all sheets in Book.xlt and also in Sheet.xlt, which should only be one sheet.

Any new books/sheets you create would then contain the preset header.


AC
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top