Control how workbooks and sheets are created

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

Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×