How to Change the Number of Sheet Tabs in a Default Excel 2013 Workbook

When you create a new .xlsx file in Microsoft Excel 2013, you are creating a new workbook. An Excel workbook includes a variable number of worksheets, which means that you can have more than one spreadsheet within a single Excel file. These are typically denoted by the tabs at the bottom of the window.

If you find that you are often deleting or creating new worksheet tabs, then you might find it helpful to learn how to change the default number of worksheets that open with any new Excel workbook.

This is a setting that you can change in Microsoft Excel 2013 and have it apply to any new workbook that you create within the program.

Change Default Number of Worksheets in Excel 2013

The steps in this article will show you how to change the default number of worksheets that are included when you create a new workbook in Microsoft Excel 2013.

This will not affect any workbooks that you have previously created, or that you receive from other people. It will simply change the number of sheets when you create a new workbook.

Step 1: Open Microsoft Excel 2013.

Step 2: Click the File tab at the top-left corner of the window.

click the file tab

Step 3: Click Options at the bottom of the column on the left side of the window.

click the options button

Step 4: Click the General option in the left column of the Excel Options window.

click the general tab

Step 5: Click inside the field to the right of Include this many sheets, then change the number to to the amount of worksheets that you want to have in any new workbook that you create.

change the number of sheets to include

Step 6: Click the OK button at the bottom of the window to apply your changes.

click the OK button

Now that you know how to change the default number of sheet tabs in a Microsoft Excel workbook, you can use this option to save yourself some time if you are always adding or removing tabs.

Are you looking for a way to make certain worksheet tabs stand out from the rest? Learn how to change the color of an Excel 2013 worksheet tab and make it easier to visually distinguish between different tabs.

Join Our Free Newsletter

Featured guides and deals

You may opt out at any time.
Read our Privacy Policy