Setup Default Template for New Workbooks in Excel

In this Microsoft Excel tutorial, I will teach you how to set up a default template so that when you create a new workbook, it will automatically be set to whatever settings you prefer, including font, font size, column widths, row heights, background colors, and so on. I'll show you how to set up a Book.XLTX file. This way, you don't have to keep making changes every time you create a new spreadsheet.

Ellen from Gulf Shores, Alabama (a Platinum Member) asks: Microsoft just updated Office and they set the default font to this new Aptos, which I don't like. How can I get back Calibri without having to change it for every new document I create? This is annoying. Help.

Notes

• Create a Book.XLTX file (or XLTM with macros)
• Put in: C:\Program Files\Microsoft Office\root\Office16\XLSTART\
• Your folder may be different depending on Excel version
• Find at: File - Options - Trust Center - Trusted Locations - Excel Startup
• Remember to Disable Start Screen (File - Options - General - at bottom)

Links

• Word Default Template: https://599cd.com/WordDefaultTemplate

Recommended Courses

• Excel Beginner, Expert Courses: https://599cd.com/Excel

Want More Excel?

Most of what I do is Microsoft Access, so if if you want to see me post more Excel videos, make sure to comment below: "I want more Excel!"

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Excel, excel 2021, excel 2016, excel 2019, excel 365, microsoft excel, ms excel, ms excel tutorial, #msexcel, #microsoftexcel, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #techhelp, default template Excel, workbook settings, font customization, Book.XLTX, row height adjustment, column width, background color, Trust Center, Trusted Locations, startup folder, change default font, template creation, start screen configuration, file save options, version differences