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.
BECOME A MEMBER:
YouTube: / @599cd
or My Site: https://599cd.com/THMember
LEARN MORE:
https://599cd.com/ExcelDefaultTemplate'>https://599cd.com/ExcelDefaultTemplate
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!"
ADDITIONAL RESOURCES:
Donate to my Tip Jar: https://599cd.com/TipJar
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/DevNet
Twitter: / learningexcel
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/enus/excel
https://microsoft.com/enus/microsoft...
KEYWORDS
TechHelp 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
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.