Double-click the sheet tab, type the new name and press Enter. You can also right-click the tab and choose Rename, or go to Home → Format → Rename Sheet; each one puts the tab into edit mode with the old name selected, and Esc cancels.
From the keyboard, move to the sheet with Ctrl + Page Down or Ctrl + Page Up, then press Alt, H, O, R one key after another, type the name and press Enter. The key sequence is for Windows; on a Mac, use the double-click or right-click method.
A sheet name can be up to 31 characters and must be unique in the workbook, and Excel ignores case, so Sales and SALES clash. It can’t be blank, can’t contain \ / ? * : [ ], can’t start or end with an apostrophe, and can’t be History.
When you type a reference to a sheet whose name contains spaces or starts with a number, wrap the name in single quotes, as in ='Q1 Sales'!B2. Excel adds the quotes itself when you click into the other sheet while building a formula.
Formulas that point to the sheet update to the new name automatically, but names stored as text don’t. An INDIRECT formula such as =INDIRECT("'Old Name'!A1") returns #REF!, and VBA such as Sheets("Old Name") stops with a Subscript out of range error until you change them to the new name.
Excel is a widely used tool in various fields, from business to academia, for its powerful data management and analysis capabilities.
One of the basic skills of using Excel is understanding how to rename a sheet. Doing so can help you keep your work organized and easy to understand.
Today, we’ll walk you through the process step by step.
Rename a Sheet from the Option Menu
The default way to rename a sheet is to use the right-click options menu. See the steps below:

- First, click on the sheet you want to rename. Once you click it, it will be activated.
- Next, right-click on the sheet tab to open the right-click menu. From that menu, click on the “Rename” option.
- The old name is now highlighted. Type the new name you want to give to that sheet (it replaces the old name), or use the Delete key to delete the old name first.
- In the end, to apply the name, hit the Enter key.
Keyboard Shortcut to Rename a Sheet in Excel
There is also a keyboard shortcut that you can use to rename a sheet in Excel.
This can be especially handy if you’re working with multiple sheets and need to quickly rename them without using your mouse.
Alt ⇢ H ⇢ O ⇢ R
Here are the step-by-step instructions:
Make sure you’re on the Excel sheet you want to rename. You can navigate between sheets using the Ctrl + Page Down shortcut to move to the next sheet or Ctrl + Page Up to move to the previous one.
Once you’re on the sheet you want to rename, press Alt, then H, then O, then R on your keyboard (one after the other).
This specific combination of keys is a shortcut to Excel’s “Rename Sheet” option.
- The Alt + H shortcut opens the “Home” tab in the ribbon.
- The O key selects the “Format” option under the “Cells” group.
- The R key finally selects the “Rename Sheet” option.
After pressing these keys, the current name of the sheet will be highlighted on its sheet tab, ready for editing.
Type the new name for your sheet on the tab.
Once you’ve typed the new name, press Enter on your keyboard. Your sheet now has the new name you just typed.
Double-Click to Rename a Sheet
You can also double-click the sheet tab to edit the sheet’s name and rename it.
- Open Excel Workbook: Begin by opening your Excel workbook. At the bottom of the window, you will see various sheet tabs. By default, these are named “Sheet1”, “Sheet2”, and so on, depending on the number of sheets in your workbook.
- Double-Click on the Tab: Identify the sheet you want to rename and double-click on its tab. This action will highlight the current name, enabling you to edit it.
- Delete the Existing Name: With the existing name highlighted, you can now type in the new name for your sheet. Whatever you type replaces the existing name.
- Enter New Name: Once you enter the new name, press the Enter key on your keyboard. This action will save your changes, and the sheet will now be renamed according to the new name you’ve entered.
If you need to rename more sheets, simply repeat the process for each sheet you wish to rename.
Using the Format Options
In the same way, you can rename a worksheet using the Format option on the Home tab of the ribbon.

Below is a detailed step-by-step guide on how to do this:
- Open the Excel Workbook: Begin by opening the Excel workbook that contains the sheet you want to rename. You can do this by locating the file on your computer, double-clicking it, or by opening Excel and selecting ‘Open’ from the ‘File’ menu, then navigating to the correct file.
- Select the Sheet to Rename: Once your workbook is open, you will see tabs for each sheet at the bottom of the Excel window. These tabs are labeled with the sheet’s name. Click on the tab of the sheet you want to rename to select it.
- Click Format on the Home Tab: After selecting the sheet, go to the Home tab and click the Format drop-down in the Cells group. This will open a menu with various options.
- Select ‘Rename Sheet’ from the Menu: In the menu, find and click on the ‘Rename Sheet’ option under Organize Sheets. This will highlight the sheet’s name on its tab.
- Type the New Name: With the old name of the sheet highlighted, you can now type in your desired new name. As you type, the old name will be replaced by what you are typing.
- Press ‘Enter’ to Save the New Name: After typing the new name, press the ‘Enter’ key on your keyboard to save it. The tab at the bottom of the window will now display the new name of the sheet.
For this method (and the keyboard shortcut), you need to activate the sheet first, as the Rename Sheet option always renames the active sheet.
You can also use VBA to rename a sheet.
Rules You Need to Know (Naming a Sheet)
You need to follow a few rules when renaming a sheet.
- Unique Names per Workbook: Each sheet within a single workbook must have a unique name. Excel does not allow duplicate sheet names within the same workbook. This helps to avoid confusion when navigating through your workbook.
- Non-Blank Name: An Excel sheet name cannot be left blank. If you try to delete the name of an Excel sheet without replacing it with a new name, Excel will automatically revert to the previous name.
- Character Limit: The sheet’s name cannot exceed 31 characters, including alphanumeric and special characters. If the name exceeds this limit, you must shorten it before successfully renaming the sheet.
- Apostrophe: An apostrophe (‘) can only be used somewhere in the middle of a name, not at the start or end.
- Restricted Characters: Certain characters cannot be used in an Excel sheet name. These include the following: \, /, ?, *, :, [, and ]. Excel will not allow you to rename the sheet if you attempt to use any of these characters.
- Word History: You can’t use “History” as the name of a sheet; Excel reserves this name.
- No Spaces at the Start or End: Avoid spaces at the beginning or the end of the sheet name. They are hard to spot, and they make it easy to type the wrong sheet name in a formula.
What Happens to Formulas When You Rename a Sheet
When you rename a sheet, Excel updates every formula that refers to it, in the same workbook and in other open workbooks linked to it. So, if a formula refers to Jan!A1 and you rename the sheet “Jan” to “January”, the formula changes to January!A1 on its own.
If the new name has a space or a special character, Excel wraps it in single quotes in the formula, like this:
='Sales Data'!A1
The one thing Excel doesn’t update is a sheet name written as text inside a formula, like in the INDIRECT function below. If you rename the “Sales Data” sheet, this formula returns a #REF! error until you change the text in it as well.
=INDIRECT("'Sales Data'!A1")
Why You Can’t Rename a Sheet
If the Rename option is greyed out and double-clicking the tab does nothing, the workbook structure is protected. To fix this, go to the Review tab and click Protect Workbook to turn off the protection (Excel asks for the password if one was set). After that, you can rename sheets again.
Excel also shows an error message when the name you type breaks one of the rules above, like a name that’s already used by another sheet or one with a character that’s not allowed. In that case, change the name and press Enter again.
Frequently Asked Questions
Can I rename multiple sheets at once?
No, Excel lets you rename one sheet at a time. If you need to rename a lot of sheets, you can use a VBA macro that loops through the sheets and renames each one.
Do formulas break when I rename a sheet?
No. Excel updates all the formulas that refer to the sheet with the new name. Only sheet names typed as text, like inside INDIRECT, need to be changed by hand.
What is the shortcut to rename a sheet in Excel?
Press Alt, H, O, R one after the other. The name on the active sheet’s tab gets highlighted, and you can type the new name and press Enter.
Written by
Puneet Gogia
Microsoft MVP — Excel · Founder, Excel Champs
Twelve years of teaching Excel, and a decade before that using it as a data analyst. Every tutorial here is written from a file I actually built.