Simple Tip, Save Time, Save a Template

If you find yourself making the same changes to Excel every day such as setting custom number formats, fonts, cell styles, colours, print headers and footers then you should set up a template. Even better than this is you can set it to open automatically every time you start excel or a new file.

How?

Simply create a file with all the number formats, fonts, cell styles and print headings you want then save as Book.xltx in one of these following folders (depends on your system): 

C:\Users\ [username] \AppData\ Roaming\  Microsoft\Excel\XLSTART\Book.xltx

or

C:\Documents and Settings\  [username] \Application Data\ Microsoft\Excel\XLSTART\Book.xltx

or

C:\Program Files\Microsoft Office>OFFICE14\XLSTART\Book.xltx 

If none of the above exist do a search on your C: Drive for XLSTART

DONE!   It’s that easy, the next time you start Excel it will automatically open with that file

See more at: https://www.accessanalytic.com.au/article/saving-a-default-template.html