Office Settings & Configuration

Reset Excel Automatic New Sheet Numbering

Huma Ashraf ChHuma Ashraf Ch Nov 12, 2026 868 views

Question details

The user wants to understand why Excel assigns a high default number to a new worksheet and how to avoid confusing automatic sheet names.

Product
Microsoft Excel
Device & OS
not provided
Scenario
A workbook currently contains only a few worksheets, but Excel creates the next worksheet with a name such as Sheet120 after previously created sheets were deleted.
Observed behavior
Excel continues using a higher internal worksheet naming sequence instead of restarting at the lowest available number. There is no normal Excel command to reset this sequence.
Before you start

Review the workbook tabs and note which sheets are used in formulas or navigation. Decide on clear names such as Basic Data, Summary, or Calculations before renaming sheets.

Solution 1Recommended

Rename worksheets with descriptive names instead of resetting the sequence

Use this approach when Excel assigns a confusing default name such as Sheet120; meaningful names make tabs and formulas easier to understand.

Excel may retain its internal worksheet creation sequence even after sheets are deleted, so the next worksheet can receive a high number. Worksheet names do not need to follow the default numbering pattern, and the sequence cannot normally be reset from Excel's standard interface.

1
Select the worksheet tab

At the bottom of the Excel window, right-click the worksheet tab with the confusing default name, such as Sheet120.

2
Open the Rename command

Choose Rename from the worksheet-tab shortcut menu, or double-click the tab name.

3
Enter a descriptive name

Type a clear name such as Basic Data, Current Summary, or Background Calculations, then press Enter.

4
Check references after renaming

Review formulas, charts, and navigation links that use the renamed sheet, especially if the workbook contains external references.

The numbering sequence cannot normally be reset: Deleting worksheets does not usually make Excel restart automatic names at Sheet1. Renaming each new worksheet is the practical way to avoid ambiguous default names.
Free Microsoft Office alternative

Use WPS Spreadsheet for Clearer Worksheet Organization

WPS Spreadsheet provides a familiar, lightweight spreadsheet workspace for creating, renaming, and organizing worksheets. It supports Microsoft Excel formats, making it easier to move a workbook to WPS while preserving a familiar editing experience.

  1. 1. Open the workbook in WPS Spreadsheet: Launch WPS Office, select Spreadsheet, and open the existing XLSX or XLS workbook.
  2. 2. Select the worksheet tab: At the bottom of the WPS Spreadsheet window, right-click the worksheet tab you want to clarify.
  3. 3. Rename the worksheet: Choose Rename, enter a descriptive name such as Summary or Calculations, and press Enter.
Rename worksheet tabs with descriptive names for clearer navigation and formulas.Open, edit, and save Microsoft Excel XLSX and XLS files.Enjoy a free, lightweight alternative with a familiar spreadsheet interface.Move existing Excel workbooks to WPS with seamless format compatibility.
QA img-9

Frequently Asked Questions

Why does Excel create Sheet120 when only three worksheets remain?

Excel may retain its internal count of worksheets created in the workbook. Deleted worksheets are no longer visible, but their creation history can cause the next default name to use a higher number.

Can I reset Excel's automatic worksheet numbering to Sheet1?

Excel does not provide a normal command to reset the automatic worksheet naming sequence. The practical solution is to rename new worksheets manually from the worksheet tab's Rename command.

Will renaming a worksheet break formulas in Excel?

Excel normally updates formulas that refer to a worksheet when you rename its tab. After renaming, review formulas, charts, named ranges, and external links to confirm that all references remain correct.

What worksheet names are easier to understand than Sheet120?

Use names that describe the content or purpose of the sheet, such as Basic Data, Current Summary, Calculations, Assumptions, or Background Calculations. Keep names concise and avoid characters Excel does not allow in sheet names.