When you open Excel, do you want to see a specific workbook right away? Or do you have a custom template that you want to use every time you create a new workbook? With a few easy steps, you can customize what you see when Excel opens or when a new workbook or sheet is created.
Do any of the following:
Move the workbook that you want to use to the Startup/Excel folder:
-
In the Finder, type startup in the Search box and press RETURN.
-
In the results, double-click the Startup folder, and then double-click the Excel folder.
-
Move your workbook to this folder.
If the workbook that you want to use is stored on a network drive, or if you don't want to move the workbook from its current location, create an alias for the file. For help with creating aliases, see Apple Help.
-
In the Finder, type startup in the Search box and for search type, click This Mac.
-
In the search results, double-click the Startup folder, and then double-click the Excel folder.
-
Move the workbook out of this folder.
-
On the Excel menu, click Preferences.
-
Under Authoring, click General
-
In the At startup, open all files in box, enter the location of the files that you want Excel to open automatically.
When Excel opens a new workbook, the new file is created from a template called Workbook. To use a custom template, you must replace the default Workbook template with your own.
-
Open the template that you want to use as the new default template.
-
Click File > Save As.
-
In the Save As box, type "Book" and in the File Format dropdown box, select Excel Template (.xltx) or Excel Macro-Enabled Template (.xltm), whichever appropriate.
You will need to save this template in the Startup folder, and the file must be named "Book.xltx" (or .xltm).
-
In the Save as dialog box, click the downward arrow next to Save As.
-
In the Search box, type "startup" and press RETURN.
-
In the search results, double-click the Startup folder, double-click the Excel folder, and then click Save.
This file will only be used as the new workbook template if it has the name "Book.xltx" or "Book.xltm".
-
Close and reopen Excel for the new template to take effect.
The Personal templates folder is where you can store custom templates that will show up in the "Personal" tab when you choose "New from Template" in Excel.
-
The personal templates folder can be set in Microsoft Word, since the folder is used by Word and Excel. To change the location of person templates, launch Microsoft Word, then go to the Word menu > Preferences > File Locations. Select User Templates and set it to the desired folder.
-
On the Excel menu, click Preferences.
-
Under Authoring, click General
-
In the Sheets in new workbook box, enter the number of sheets that you want in the workbook.
You can change the default font that Excel uses whenever you open a new workbook. By default, the text in every Excel workbook is 12 point Body Font.
-
On the Excel menu, click Preferences.
-
Under Authoring, click General
-
In the Default font list, click the font that you want to use.
-
In the Font size list, type or click a font size.
Note: You must quit and then reopen Excel to begin using the new default font and font size. The new default font and font size are used only in new workbooks that you create after you reopen Excel. Existing workbooks are not affected.
-
On the Excel menu, click Preferences.
-
Under Authoring, click General
-
Clear the Open Workbook Gallery when opening Excel check box.
The next time you open Excel, it opens a blank workbook.
