Office Settings & Configuration

How to Fix Microsoft Excel Opening New Workbooks with 53 Worksheets

Natalie Taylor Oct 10, 2026 869 views

Question details

The user needs to change the default configuration in Excel because every newly created workbook automatically contains 53 worksheets.

How to Fix Microsoft Excel Opening New Workbooks with 53 Worksheets

Product: Microsoft Excel
Device & OS: not provided
Scenario: Creating a new blank workbook in Microsoft Excel.
Observed behavior: The newly created workbook opens with 53 blank worksheets instead of the standard default of one.

Before you start

Ensure you have saved your work in any open Excel files, as adjusting application-wide options will immediately apply to all future workbooks you create.

Solution 1Recommended

Modify the Default Worksheet Count in Excel Options

Adjust the built-in General settings in Microsoft Excel to restore the default number of sheets for new workbooks to one.

Excel allows users to specify how many blank worksheets should be included whenever a new workbook is created. If this setting was accidentally changed to a high number, you can easily revert it from the Options menu.

Access Excel Options

Open Microsoft Excel. Click on the 'File' tab located in the top-left corner of the ribbon, and then select 'Options' at the very bottom of the left-hand menu.

Locate General Settings

In the Excel Options dialog box that appears, make sure the 'General' category is selected in the left navigation pane.

Adjust the Sheet Count

Scroll down to the section labeled 'When creating new workbooks'. Find the input box for 'Include this many sheets', delete the number 53, and type '1' (or your preferred number of default sheets).

Save and Verify

Click the 'OK' button to save your new settings. Press 'Ctrl + N' on your keyboard to open a new workbook and confirm it now contains only a single worksheet.

Modify the Default Worksheet Count in Excel Options

Application Scope: This configuration change applies immediately to all future new workbooks but will not remove extra sheets from workbooks you have already saved.

Free Microsoft Office alternative

Switch to WPS Office for a Reliable Spreadsheet Experience

If you are tired of unexpected configuration changes and bloated settings in Microsoft Excel, consider switching to WPS Office. It provides a lightweight, highly compatible, and easy-to-use alternative for all your spreadsheet tasks.

1. Download and Install: Visit the official WPS website to download WPS Office and run the simple installation wizard.
2. Open WPS Spreadsheet: Launch WPS Office and click on 'Spreadsheet' to instantly create a clean, single-sheet workbook without complex configurations.
3. Work with Excel Files: Drag and drop your existing Microsoft Excel files directly into WPS Office to view and edit them seamlessly.

Fully compatible with Microsoft Excel formats (.xls, .xlsx, .csv)Lightweight software that installs quickly and runs smoothlyFamiliar tabbed interface requiring zero learning curveFree to use with powerful built-in data analysis tools

microsoft office alternative - wps office

Frequently Asked Questions

How do I quickly delete the 52 extra sheets in my existing workbook?

To delete multiple sheets at once, click on the first sheet tab you want to remove, hold the 'Shift' key, and click the last sheet tab to select the entire range. Right-click any selected tab and choose 'Delete'.

What is the maximum number of default worksheets I can configure in Excel?

Microsoft Excel allows you to set the default number of worksheets for a new workbook to any integer value between 1 and 255.

Will changing this setting alter the sheets in my previously saved files?

No, adjusting the 'Include this many sheets' setting in Excel Options only impacts new, blank workbooks created after the setting is applied. Your existing files will remain entirely unaffected.

Office App Problems