To create a new default Excel workbook template:
Overview: Creating a New Excel Workbook Template You can’t use book1 or customor another variation.
(This required name assumes English is the interface language). The trick behind this magic in Microsoft Excel is creating a template file named book.xltx (or book.xltm if your default workbook contains macros), and then saving this file to the appropriate location on your hard drive. It’s fairly straightforward to create an entirely customized standard workbook. Do you frequently print your worksheets on legal-size paper with a landscape orientation? Does your company require a disclaimer or confidentiality footer on key Excel workbooks? If you frequently change the standard Excel worksheets, customizing the default Excel workbook can be a big time-saver.Īs it turns out, Excel gives you quite a bit of control over the look and layout of your worksheets. Or possibly you prefer a different default font style or size, typically use the comma number format or you often change the layout of column widths when you create a new worksheet. But what if you don’t like that workbook? Maybe you have a standard header that you always (or almost always) use on pages of your workbook. When you create a new Excel workbook, you get a standard default Excel workbook.
