Jump to content

Make a Default Custom Footer in Excel


Recommended Posts

Make a Default Custom Footer in Excel

You can get your footer to become a default by adding the desired footer to the default workbook template. In Excel 2002, the default template is typically found in C:\Program Files\Microsoft Office\Office10\XLStart (for other versions, look up template in the Help system). Open the file Book.xlt if it is present in that folder. If not, create a new file, select Save As from the File menu, choose Templates (*.xlt) from the Save as type list, and save your new blank file as Book.xlt.

One way or the other, you now have Book.xlt open for editing. Create your standard custom footer, save the template, and close it. Book.xlt is the default template for new workbooks, so each time you create a new workbook your custom footer will be selected by default. For the other 20 percent of your spreadsheets, simply choose a different footer or none at all.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...