Advanced

Start Excel with your custom parameters

Reading Time: 2 minutes

You can custom your Excel workbook when you open a new blank workbook. You just have to create a template and save it in a specific folder.

Create a custom format.

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

Negative numbers in parenthesis

Save as template

Once you have create 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)
File extension xlst

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)
Menu Visual Basic Editor
  1. In the Visual Basic Editor, open the Immediate Window (View > Immediate Window)
Immediat Windows
  1. Write the following command line

?Application.StartupPath

Command line Startup Path

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

Excel Option Template path

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
  • ....
Template file in the folder XLSTART

Start Excel with your template

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

Excel starts with your custom parameters

Related posts

Change the language of Office

Frédéric LE GUEN

Change the color of holidays

Frédéric LE GUEN

Displaying Negative Numbers in Parentheses – Excel

Frédéric LE GUEN

Leave a Comment