If you save your templates in the official custom templates folder Office uses (whether that’s the default Documents\Custom Office Templates location or you configured a new save location in Settings), those templates become available on the Office splash screen. Now that you’ve got your template saved, you can use it to create new documents. There’s “Browse” button for some reason, so type the full path to the folder you want to use or copy and paste the location from a File Explorer address bar. On the right, you’ll see a “Default personal templates location” box where you can type a path to a custom save location for templates. In the “Excel Options” window, slick the “Save” category in the left column. On the “File” menu, click the “Options” command.
If you want an even more organized approach, you can change the default location where Excel saves templates. In the file type dropdown (just underneath the file name text box), select the “Excel template (.xltx)” option.īy default, Excel likes to save templates in Documents\Custom Office Templates, but you can save them wherever it makes sense to you.
