In Excel for Microsoft 365 on Windows, select the worksheet you want to rename and press Alt, then H, O, and R in sequence. Type the new tab name and press Enter. On a Mac, use the sheet-tab context menu or double-click the tab; the Windows key sequence is not the Mac equivalent.
The Windows shortcut, one key at a time
The shortcut is often written as Alt+H, O, R. The commas matter: this is a sequence of key presses, not a combination to hold down together. Press and release Alt, then press H, then O, then R. Excel uses these ribbon Key Tips to move through Home, Format, and Rename Sheet.
- Click a cell on the worksheet whose tab you want to change. This makes that worksheet active.
- Press
Alt, thenH,O, andR. - When the existing tab name is selected for editing, type the replacement name.
- Press
Enterto apply the name, or pressEscto cancel the edit.
You do not need to select the tab with the mouse first if the worksheet is already active. If you are unsure which sheet is active, check which tab appears highlighted before starting. A workbook may have many tabs, and a shortcut renames only the active worksheet; it does not rename every tab in a selection or change the workbook filename.
Rename a tab with the mouse
The mouse methods are useful when you do not remember the key sequence, when you are working on a Mac, or when Excel is running in a browser. Both methods act on the worksheet tab you choose:
- Double-click: Double-click the sheet tab, type the new name, and press
Enter. - Context menu: Right-click the tab, choose Rename, type the name, and press
Enter. On a Mac, Control-clicking the tab commonly opens the context menu if you do not have a right mouse button.
These are alternatives to the Windows ribbon sequence, not different ways to rename the workbook. If the tab is too narrow to read, the context menu still lets you pick the sheet by its visible tab. You can also use the sheet-navigation arrows at the lower-left of the workbook to move through tabs, then select the one you want to rename.
Rules for worksheet names
Excel restricts worksheet names so they can be identified unambiguously in tabs and formulas. A name can contain up to 31 characters, cannot be blank, and cannot include any of these characters: colon (:), backslash (\), slash (/), question mark (?), asterisk (*), or square brackets ([ ]). Names also need to be distinct within the workbook; Excel will not allow two tabs to have the same name.
Choose a name that tells a reader what the sheet contains, such as Q1 Sales, Inventory, or 2026 Budget. Spaces are allowed, and names do not have to begin with a letter. If Excel rejects a name, check its length and characters first, then check whether another tab already uses it. An error message usually means the proposed name violates one of these workbook naming rules.
Names appear in formulas that refer to a worksheet. When a sheet is renamed within the workbook, Excel normally updates its direct worksheet references automatically. For example, a formula that refers to Sales!B2 will be adjusted to use the new sheet name. A sheet name containing spaces is written with single quotation marks in a formula reference, as in 'Q1 Sales'!B2; Excel generally adds the required marks when it creates or updates the reference.
How the shortcut works
Alt+H, O, R is a ribbon Key Tip sequence in Excel for Windows. Pressing Alt displays letters or prompts for ribbon commands. H opens the Home tab’s Key Tips, O opens the Format menu, and R chooses Rename Sheet. The sequence is therefore a keyboard route through the ribbon rather than a dedicated shortcut that directly edits a tab name.
This distinction helps explain why the letters may not be obvious and why the sequence can vary across applications or versions. If your Excel interface displays different Key Tips, follow the letters shown on screen rather than assuming another program’s shortcuts apply. Key Tips are also affected by the active application: Excel for the web and other spreadsheet programs may handle keyboard access differently.
Excel on Mac and Excel for the web
The Windows Key Tip sequence is not the standard Mac shortcut for renaming a worksheet. In Excel for Mac, double-click the tab or Control-click it and choose Rename. You can also use the ribbon’s Home > Format > Rename Sheet command when it is available in your Excel layout. These methods work without trying to translate the Windows letters to Mac keys.
Excel for the web also lets you rename a sheet through its tab, typically by double-clicking the tab or opening its context menu and choosing Rename. The Windows ribbon sequence may not behave the same way in a browser because the browser and web app handle keyboard commands differently. If a shortcut seems to switch browser focus or does nothing, use the tab menu instead. The desktop Excel application remains the most predictable place to use Alt+H, O, R.
Common problems and quick fixes
If the sequence does not rename the sheet, check the workbook state before repeating it. A common cause is that Excel is editing a cell or formula: press Enter or Esc to finish or cancel that edit, then try the tab command again. Also confirm that Excel, rather than another window, has keyboard focus and that the intended worksheet is active.
- The name is not accepted: Remove any prohibited characters, keep the name to 31 characters or fewer, and make sure it is not already used by another sheet.
- Rename is unavailable: The workbook structure may be protected. Worksheet protection and workbook-structure protection are different; protecting cells on a sheet is not the same as preventing changes to the workbook’s tabs. If you have permission, remove workbook-structure protection before renaming.
- The wrong tab changes: Select the correct worksheet first. The shortcut targets the active sheet, not necessarily the tab nearest the pointer.
- The letters do something unexpected: Press and release each key in order instead of holding all four down. If you are on a Mac or in a browser, use the context-menu method.
Do not confuse renaming a worksheet with renaming the Excel file. The worksheet tab name is changed inside the workbook, while the file name is changed through Excel’s title bar or the operating system’s file-management tools. They are separate names and can be different.
Choosing names and keeping references clear
Good tab names make a workbook easier to navigate, especially when it is shared or contains many periods, departments, or scenarios. Prefer labels that distinguish sheets clearly: Actuals 2025 and Forecast 2025 are more useful than Sheet1 and Sheet2. Consistent wording also helps users scan a row of tabs without opening each sheet.
Before renaming a worksheet in a workbook used by other people, consider whether instructions, documentation, or external processes refer to the old name. Excel updates many direct references inside the same workbook, but a name may also appear as ordinary text in notes, documentation, or a formula that constructs a reference indirectly. Check important formulas and workflows after a substantial rename. If the workbook is shared, tell collaborators what changed so they can find the information again.
When there are many tabs, rename them deliberately rather than grouping sheets and assuming one command will give each a different name. A worksheet name identifies one sheet, so each tab needs its own unique label. For a one-off change, the shortcut is fast; for a broader cleanup, decide on a naming pattern first and apply it consistently.
Frequently Asked Questions
What is the shortcut to rename a sheet in Excel for Windows?
Use Alt+H, O, R: press and release each key in order, type the new name, and press Enter.
Do I hold Alt, H, O, and R at the same time?
No. Press Alt, release it, and then press H, O, and R in sequence. It is a Key Tip path through the ribbon.
What is the Mac shortcut to rename an Excel tab?
There is no matching Windows Key Tip sequence to use as the Mac equivalent. Double-click the tab, or Control-click it and select Rename.
Can I rename a tab by double-clicking it?
Yes. Double-click the worksheet tab, enter the new name, and press Enter. Right-clicking the tab and choosing Rename is another option.
Why will Excel not let me rename a worksheet?
The name may be too long, contain a prohibited character, or already belong to another sheet. Workbook-structure protection can also block tab changes; check that separately from worksheet protection.
Related
- Ungroup Cells in Excel: Keyboard Shortcut and Steps
- How to Ungroup Excel Windows on the Windows 11 Taskbar
- How to Ungroup Rows in Excel With a Keyboard Shortcut
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel: How to Calculate Workdays Between Two DatesTo calculate workdays between two dates in Excel, use NETWORKDAYS: with a start date in A2 and an…
- How to Change Excel Shortcut Keys in Microsoft 365To change an Excel shortcut on Windows, assign a shortcut to a macro in Developer > Macros >…
- Combine in Excel: Text, Cells, and DataYou can combine text in Excel with the ampersand operator (&), CONCAT, or TEXTJOIN; for example, with a…
- Excel Merge Cells Greyed Out in a Table? Here’s WhyIn Excel for Microsoft 365 on Windows, Merge & Center is usually greyed out because the selected cells…
- Clear Email Cache in Outlook 365: Safe StepsTo clear the email cache in classic Outlook for Microsoft 365 on Windows, close Outlook, then rename the…
- Excel Unmerge Cells Shortcut: Keys, Steps, and FixesIn Excel for Microsoft 365 on Windows, select a merged cell and press Alt, H, M, U—one key…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.