How to 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)

Where to save your template?

This question is really important because you must save your workbook in your Start Excel folder. But where it is? 🤨🤔 But, there is 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

It's in this folder that you MUST save your template and NOT is the default Template folder (File > Options > Save)

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 😉😍😎