Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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:

  1. In the Finder, type startup in the Search box and press RETURN.

  2. In the results, double-click the Startup folder, and then double-click the Excel folder.

  3. 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.

  1. In the Finder, type startup in the Search box and for search type, click This Mac.

  2. In the search results, double-click the Startup folder, and then double-click the Excel folder.

  3. Move the workbook out of this folder.

  1. On the Excel menu, click Preferences.

  2. Under Authoring, click General  General Preferences button.

  3. 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.

  1. Open the template that you want to use as the new default template.

  2. Click File > Save As.

  3. 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).

  4. In the Save as dialog box, click the downward arrow next to Save As.


    image showing the Save As dialog

  5. In the Search box, type "startup" and press RETURN.

  6. In the search results, double-click the Startup folder, double-click the Excel folder, and then click Save.

    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".

  7. 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. 

  1. 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. 

screen shot of the File locations preference panel from Microsoft Word

  1. On the Excel menu, click Preferences.

  2. Under Authoring, click General  General Preferences button.

  3. 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.

  1. On the Excel menu, click Preferences.

  2. Under Authoring, click General  General Preferences button.

  3. In the Default font list, click the font that you want to use.

  4. 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.

  1. On the Excel menu, click Preferences.

  2. Under Authoring, click General  General Preferences button.

  3. Clear the Open Workbook Gallery when opening Excel check box.

    The next time you open Excel, it opens a blank workbook.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×