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.
Save as template
Once you have create your custom format, you must save your workbook as a template.
- Open the Save As menu (or F12)
- 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 😀😎
- Open the Visual Basic Editor from the Developer tab (or Alt + F11)
- In the Visual Basic Editor, open the Immediate Window (View > Immediate Window)
- Write the following command line
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 template
Then, now each time you open a new workbook, you load automatically your custom parameters 😉😍😎