The General tab of the Options dialog box. Make sure the General tab is selected.Within Excel, choose Options from the Tools menu.Store the Book.xlt template file in the folder you created.You can name the folder anything you like.
#Default header and footer in word windows#
If you are unsure of where the XLStart folder is located (step 6), use the Find feature of Windows to locate the folder. Now, any time you create a new workbook, Excel uses your template (Book.xlt) as its model for what you want. (Do not save it in the default template folder.)
You can also create any other "customizations" for your worksheet in this same manner.
If you find yourself in this boat, you can set the headers and footers so they default to anything you desire. In fact, you may be getting tired of changing the default headers and footers on each new workbook you create. Let's face it-when you first start Excel, the headers and footers used in your workbook are pretty boring.