How do you start Excel with your custom parameters? You must create a template and save it in a specific folder.

Create a custom format.

In Excel, you can create a custom format, like a negative number in parenthesis, dash for 0, or customize the colors and font of your Excel themes.

Save as template

Once you have created your custom format, you must save your workbook as a template.

1. Open the Save As menu (or F12)
2. In the section Save As Type, select the extension Excel Template (*.xltx)

But when you click on this option, Excel automatically changes the folder path to the default path. But It's wrong DON'T save the file Template in this folder.

Where to save your template?

This question is the key point of this tutorial. You must save your workbook in your Start Excel folder. But where is it? 🤨🤔 Let's use a VBA command line to return the path for this specific folder 😀😎

1. Open the Visual Basic Editor from the Developer tab (or Alt + F11)

2. In the Visual Basic Editor, open the Immediate Window (View > Immediate Window)

3. Write the following command line ?Application.StartupPath
4. This is where you MUST save your file Template

What is the name of the template?

This question is really important because it depends of the language of your Office.

• If your Office is in English, you must name your template Book.xltx
• Office in French, the name must be Classeur. xltx
• In Spanish, the name is Libro. xltx
• German: Mappe.xltx
• Arabic: المصنف.xltx
• Amharic: ደብተር.xltx
• Chinese, simplified: 活頁簿.xltx
• ....

Start Excel with your custom template.

Then, now each time you open a new workbook, you load automatically your custom parameters 😉😍😎

• Custom color
• Column width
• Custom number format