Start Excel with your custom parameters

Start Excel with your custom parameters
Last Updated on 16/05/2023
Reading time: 2 minutes

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.

Negative numbers in parenthesis

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)
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 custom template

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

Excel starts with your custom parameters

2 Comments

  1. Rajeev
    30/06/2021 @ 08:34

    it work perfect however i have one question so in data base we 0 ,positive value like 67 ,negative value -58 so how we can see this 0 figures as - to be more focus on value with positive and negative value

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Start Excel with your custom parameters

Reading time: 2 minutes
Last Updated on 16/05/2023

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.

Negative numbers in parenthesis

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)
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 custom template

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

Excel starts with your custom parameters

2 Comments

  1. Rajeev
    30/06/2021 @ 08:34

    it work perfect however i have one question so in data base we 0 ,positive value like 67 ,negative value -58 so how we can see this 0 figures as - to be more focus on value with positive and negative value

    Reply

Leave a Reply

Your email address will not be published. Required fields are marked *