Excel Tab Rename Shortcut: Windows and Mac Quick Guide

How-to basics · Updated November 20, 2026

In Excel for Microsoft 365 on Windows, select the worksheet you want to rename, then press Alt, H, O, and R in sequence. Type the new tab name and press Enter. This shortcut opens the rename command for the active sheet; on a Mac, use the sheet-tab menu or double-click the tab instead.

Renaming a tab gives a worksheet a useful label, such as “January Sales” or “Inventory,” so it is easier to identify in a workbook. The steps below cover the Windows desktop shortcut first, then the practical alternatives for Mac and Excel for the web.

What You’ll Need

  • An Excel workbook with at least one worksheet open. You can rename a sheet in a blank workbook, too.
  • Permission to edit the workbook. If the workbook structure is protected, you may need its password or the owner’s help.
  • A new sheet name that follows Excel’s naming rules: up to 31 characters, not blank, and without the characters :, \, /, ?, *, [, or ].

Step-by-Step

  1. Open the workbook and identify the sheet. Look at the worksheet tabs along the bottom of the Excel window. Click the tab you want to rename so it becomes the active sheet. The shortcut applies to the active sheet, not necessarily the sheet whose tab you last noticed. If the tab is outside the visible area, use the sheet navigation arrows at the lower left to scroll through the tabs, or use the sheet list menu beside those arrows when available.
  2. Make sure you are not editing a cell. If the insertion point is inside a cell or the formula bar, press Esc once to leave cell-edit mode. The rename command is for the worksheet, and leaving edit mode first avoids sending keystrokes into a cell or formula.
  3. Start the ribbon shortcut. On a Windows keyboard, press and release Alt. Do not hold Alt while pressing all the remaining letters. Excel displays KeyTips, the small letters or combinations that identify ribbon commands.
  4. Open the Home tab commands. Press H, then O, then R, one key at a time. The complete sequence is often written as Alt+H, O, R. It means press Alt, release it, then press H, O, and R in order. It is not one four-key chord. Excel selects the current sheet name for editing when the command succeeds.
  5. Enter the new name. Type the label you want. For example, change “Sheet2” to “Quarter 1 Budget” or “Orders – 2026.” Typing replaces the selected old name. If the text is not selected, press Ctrl+A only while the sheet name is in edit mode to select that name, then type the replacement.
  6. Confirm the change. Press Enter. The new label appears on the tab. Click a cell to return focus to the worksheet, then check that the intended tab—not a neighboring one—was renamed.
  7. Use a mouse alternative if the shortcut is unavailable. In Windows desktop Excel, right-click the worksheet tab and choose Rename, or double-click the tab name. Type the new label and press Enter. In Excel for Mac, double-click the tab or Control-click/right-click it and choose Rename. Excel for the web also allows you to open the tab’s context menu and choose Rename; a context menu is often more reliable there than assuming the Windows ribbon sequence applies.

There is no need to select the old text with the mouse before using the Windows shortcut. The Rename command activates the tab label for editing and normally selects its existing name. If you prefer to work entirely from the keyboard, verify that the active sheet is correct before beginning the sequence, because the command does not ask you to choose a sheet.

Common Mistakes

  • Pressing every key at once. Alt+H, O, R is a sequence of KeyTips. Holding Alt and pressing H, O, and R as a single combination may not open Rename. Tap Alt, release it, then enter each following letter.
  • Renaming the wrong worksheet. The active worksheet is the one affected. Check the selected tab before using the shortcut, especially when several tabs have similar colors or names.
  • Using an invalid name. Excel rejects a blank name, a name longer than 31 characters, or one containing a prohibited character. A colon, slash, asterisk, question mark, backslash, or square bracket is not allowed in a sheet name. Excel may display an error rather than accept it.
  • Trying to give two sheets the same name. Sheet names must be unique within a workbook. Names that differ only by capitalization are treated as the same for this purpose, so “Sales” and “SALES” cannot identify separate tabs.
  • Typing while a cell is active in edit mode. If the cell cursor is still active, your new text may alter a cell rather than the tab. Press Esc, confirm the correct sheet is selected, and restart the rename action.
  • Expecting the sheet name to change in every place automatically. A tab rename changes the worksheet’s name, but it does not rewrite ordinary text labels in cells, chart titles, or external documents. Excel updates many internal references to the sheet, but check important formulas, links, and documentation after a workbook reorganization.

Tips

  • Choose names that explain the content. “West Region,” “2026 Forecast,” or “Read Me” is more useful than “Sheet3.” A consistent naming style makes a workbook easier to scan and reduces the chance of working on the wrong data.
  • Keep names short enough to read. Excel allows up to 31 characters, but long names may be clipped when there are many tabs. Put the distinguishing word first, such as “2026 Sales – East” rather than “Sales – East Region – 2026.”
  • Use a predictable format. For monthly worksheets, names such as “2026-01,” “2026-02,” and “2026-03” sort clearly when viewed as text and make the period obvious. For departments, use the same capitalization and punctuation on each tab.
  • Use color as a secondary cue. Right-click a tab and choose Tab Color to group related sheets visually. Color can help, but keep meaningful names because colors may be hard to distinguish or may not print as expected.
  • Save after meaningful changes. Renaming a tab is usually undoable with Ctrl+Z on Windows or Command+Z on Mac, but saving afterward protects the updated workbook. If the workbook is shared, confirm that your changes have synchronized before closing it.

Troubleshooting

The shortcut does nothing. Confirm you are using the desktop Windows version of Excel and that the workbook window is active. Press Alt once and look for KeyTips; if they appear, continue with H, O, R, pausing between keys. If KeyTips do not appear, the focus may be in a dialog, cell edit, or another application. Press Esc to close or leave the current action, click the workbook, and try again. You can always right-click the tab and choose Rename.

The key sequence opens a different command. Excel’s KeyTips can vary with ribbon layout, language, or product version. After pressing Alt, follow the letters displayed on your screen rather than forcing a sequence that does not match. Use the tab context menu as a dependable alternative. On Mac, use the tab’s Rename command rather than expecting the Windows Alt sequence to behave identically.

Excel says the name is invalid or already in use. Shorten the name to 31 characters or fewer, remove prohibited punctuation, and check for a duplicate tab name. Try a descriptive alternative such as “Sales 2026” instead of “Sales/2026.” If the name appears valid but is still rejected, remove leading or trailing apostrophes; Excel does not allow a sheet name to begin or end with an apostrophe.

Rename is unavailable or the workbook will not let you change it. The workbook structure may be protected. In Windows Excel, check Review > Protect Workbook for a protection setting; if structure protection is enabled, you must unprotect it with the required password before renaming sheets. If the workbook is read-only or you have view-only access to a shared file, request edit permission or save an editable copy if permitted. Do not remove protection unless you are authorized to do so.

The tab is missing from view. The sheet may be hidden, or there may be so many tabs that it is off-screen. Use the sheet navigation controls at the bottom left to move along the tab row. To display a hidden sheet in Windows desktop Excel, right-click a visible sheet tab and choose Unhide, then select the sheet. If Unhide is unavailable, there may be no normally hidden sheet, or workbook structure protection may be preventing the change.

Frequently Asked Questions

What is the keyboard shortcut to rename an Excel tab?
In Excel for Microsoft 365 on Windows, press Alt, then H, O, and R in sequence. Type the new name and press Enter.

Do I press Alt, H, O, and R at the same time?
No. Press Alt and release it, then press H, O, and R one after another. Excel uses these as ribbon KeyTips.

Is there a direct equivalent of Alt+H, O, R on Mac?
Do not rely on that Windows sequence on a Mac. Double-click the sheet tab, or Control-click/right-click it and choose Rename.

Can I rename a sheet in Excel for the web?
Yes. Open the worksheet tab’s context menu, choose Rename, enter the new name, and press Enter. The Windows desktop KeyTip sequence may not work the same way in a browser.

What are the rules for Excel sheet names?
A name can contain up to 31 characters, must be unique in the workbook, and cannot be blank or contain :, \, /, ?, *, [, or ]. It also cannot begin or end with an apostrophe.

Will renaming a tab break formulas?
Excel usually adjusts formulas that refer to the renamed sheet. Still, check formulas, charts, links, and any outside instructions that depend on the old name, particularly in a complex or shared workbook.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.