Do you find yourself creating new workbooks in Excel, then making the same changes to every one?
Maybe you like to change font size, zoom percent, or the default row height?
The biggest challenge with this tip is figuring out the right location for the template file.
This can be maddeningly complex, depending on which platform and version of Excel you use.
controls that can be saved in a template
A template can hold many custom options.
The key is to put your template file into this folder so that Excel will find it.
Unfortunately, the exact location of XLSTART varies according to the versions of Excel and Windows you use.
Here are some common locations:
Can’t find XLSTART?
Once you’ve confirmed the location of XLSTART, drop in your template file.
Once you’re sure things are working, remove the marker.
In Excel 2016, according to Microsoft,there is currently no startup folder.
Note: Tested again in January 2020.
Step #5 above (removing the extension) was not needed.
Also, I was able to use ‘book.xltx’ for the filename, like the Windows version.
When you insert a new sheet, it will inherit Excel’s sheet defaults.
If you want to control new sheets with your own template, follow the process below.
** If using a non-English version of Excel, you may need to localize this name.
To test that the sheet template is working, open a workbook and add a new sheet.
You should see your customizations in all newly inserted sheets.
