As long as you name the template correctly, and put it in the correct location, Excel will use your custom template to create all new workbooks.

This can be maddeningly complex, depending on which platform and version of Excel you use.

If you get frustrated and cant make things work, you can set your own startup folder manually, as described below.

Here are a few examples of settings that can saved in a workbook template.

For example, if youre using the Czech version, you need to to use Seit instead of book.

The key is to put your template file into this folder so that Excel will find it.

One easy way to do this is to (temporarily) give cell A1 in your template a bright yellow or orange fill.

That way, you can immediately see if your custom template is being used.

Again, confirming the startup folder can be tricky, depending on whether y ou have Excel 2011 or 2016 installed (2008 not tested).

In Excel 2016, according to Microsoft, there is currently no startup folder.

Also, I was able to use book.xltx for the filename, like the Windows version.

When you insert a new sheet,it will inherit Excels sheet defaults.

If you want control new sheets with your own template, follow the process below.

We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.

Excel For Mac 2016 Not Saving The Settings