Control how workbooks and sheets are created

Note: This article has done its job, and will be retiring soon. To prevent "Page not found" woes, we're removing links we know about. If you've created links to this page, please remove them, and together we'll keep the web connected.

Do any of the following:

Change the number of sheets in a new workbook

  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.

Change the preferred font and font size for new sheets

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. On the Standard font pop-up menu, click the font that you want to use.

  4. In the Size box, 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.

Insert a new sheet

You can insert a new blank sheet, or a special chart sheet, macro sheet, or dialog sheet into your workbook.

  • On the Insert menu, point to Sheet, and then click the type of sheet that you want to insert.

See also

Change the usual file format for saving workbooks

Customize how Excel opens workbooks and sheets

Connect with an expert
Contact us
Expand your skills
Explore training

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×