How to Rename a Sheet in Excel Using the Keyboard

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 name and press Enter. This keyboard route renames the active sheet without needing to right-click its tab or use the mouse.

A clear sheet name makes a workbook easier to navigate and helps people understand what each worksheet contains. Before you start, decide on a name that is short, descriptive, and allowed by Excel. The instructions below are for the desktop Windows version of Microsoft Excel for Microsoft 365; Mac and Excel for the web work differently in some places.

What You’ll Need

  • An Excel workbook open in the desktop app, with the worksheet you want to rename available in the workbook.
  • Permission to change the workbook structure. If its structure is protected, Excel may block sheet renaming until the protection is removed by someone authorized to do so.
  • A replacement name that is not already used by another sheet and meets Excel’s naming rules: no more than 31 characters, not blank, and no colon, backslash, slash, question mark, asterisk, or square brackets. A name also cannot begin or end with an apostrophe.

Step-by-Step

  1. Open the workbook and activate a worksheet. Click a cell on the sheet you want to rename, or use the keyboard to select it. On Windows, press Ctrl+Page Down to move to the next worksheet tab or Ctrl+Page Up to move to the previous one. The active sheet is the one whose tab is selected. These shortcuts move among worksheets in tab order, not among open workbooks.
  2. Make sure Excel is ready to accept a ribbon shortcut. If you are editing text inside a cell, press Esc to cancel that edit or Enter to finish it. If a menu or dialog is open, close it first. The rename sequence is intended for the normal worksheet view; it will not work as expected while you are typing into a cell or editing a chart object.
  3. Open the Rename Sheet command using KeyTips. Press and release Alt, then press H, followed by O, followed by R. Do not hold all four keys down together. In Excel’s ribbon, H selects the Home tab, O opens the Format menu in the Cells group, and R chooses Rename Sheet. Excel should switch the current tab name into an editable state.
  4. Enter the new sheet name. Type the name you want. In the usual case, the current name is selected, so typing replaces it. If the existing name is not selected, press Ctrl+A only when the sheet-name edit field has focus, then type the replacement. Avoid using Ctrl+A when a worksheet cell is active, because that can select worksheet cells instead.
  5. Confirm the name. Press Enter. The edited tab label should appear at the bottom of the workbook, and the worksheet remains active. If Excel rejects the name, it usually keeps the rename edit open or restores the previous name; check the rules and try again.
  6. Check that the right sheet changed. Look at the active tab and confirm the new label is on the intended worksheet. If there are many tabs with similar names, use Ctrl+Page Up or Ctrl+Page Down to review nearby tabs. Save the workbook with Ctrl+S when you are satisfied.

The equivalent ribbon route with a mouse is Home > Format > Rename Sheet. You can also double-click a sheet tab to edit its name. Those options are useful if the KeyTip sequence differs in a customized ribbon, but the steps above keep the main renaming process on the keyboard.

Common Mistakes

  • Holding the keys down together. Alt, H, O, and R are a sequence of KeyTips, not a single modifier shortcut like Ctrl+S. Press each key in order and wait briefly for Excel to display or respond to the next KeyTip.
  • Using the shortcut while editing a cell. If the insertion point is inside a cell, Excel may enter letters or behave differently instead of opening the ribbon command. Press Enter or Esc to leave cell-edit mode, then try again.
  • Trying to use a name that Excel will not accept. Sheet names have a 31-character limit and cannot include certain punctuation. Excel also will not allow two sheets in the same workbook to have the same name, even if the capitalization differs. For example, a sheet called Sales cannot be renamed to sales if Sales already exists.
  • Expecting a formula or link to update in every situation. Excel generally adjusts many references when a sheet is renamed, but names embedded in text, external links, queries, macros, or other applications may need separate attention. If a workbook depends on those connections, verify them after renaming.
  • Confusing the selected cell with the selected sheet. The tab that is active determines which sheet the Rename Sheet command affects. Check the active tab before entering the new name, especially when worksheets are grouped or tab colors make the selection hard to see.

Tips

  • Use names that explain a sheet’s purpose. Labels such as January, Inventory, or Q4 Budget are easier to scan than Sheet1 or Data2. If a workbook has repeated periods, include the year or quarter so the tabs remain distinguishable.
  • Keep a consistent naming pattern. For monthly tabs, use the same style throughout, such as Jan 2026, Feb 2026, and Mar 2026. Consistency makes it easier to move through a long workbook and reduces the chance of choosing the wrong tab.
  • Use keyboard navigation before renaming. If the tab you need is not visible, Ctrl+Page Up and Ctrl+Page Down can move through sheets without scrolling the tab bar. Press the shortcut the required number of times, then verify the active sheet before using the rename sequence.
  • Remember that sheet names are not workbook filenames. Renaming a worksheet changes only its tab label. To change the workbook file’s name, use Save As; that is a separate action and does not rename any sheet.
  • Check references in workbooks with automation. If VBA code refers to a sheet by its tab name, renaming it may affect that code. Excel’s VBA code name is a separate property from the visible tab name, but code that uses a quoted tab name can be sensitive to changes.
  • Save after important changes. Renaming is normally undoable with Ctrl+Z, but saving a copy before broader workbook maintenance is sensible. If you are unsure whether dependent reports or links rely on the old name, keep a backup until you have checked them.

Troubleshooting

The Alt, H, O, R sequence does nothing. First confirm that the Excel desktop window is active and that you are not editing a cell. Press Esc once or twice to close an open menu or finish an in-progress action, then try the sequence again, pressing and releasing each key. If your keyboard or remote desktop handles the Alt key differently, use the ribbon route Home > Format > Rename Sheet instead, or double-click the tab.

Excel opens a menu, but the next letter does not work. KeyTips can depend on the selected ribbon tab, Excel build, and customizations. Watch for letters displayed on screen and press the letter Excel shows for the command. The Rename Sheet command is in the Home tab’s Format menu under the Cells group in the standard Windows ribbon. If the letters shown differ, follow the on-screen prompts rather than repeatedly entering the old sequence.

The tab name will not change, or Excel says the name is invalid. Check that the name is at most 31 characters, contains none of the prohibited characters, does not start or finish with an apostrophe, and is not already in use. Remove leading or trailing spaces if the name is confusing or difficult to reference. Try a simple name such as Sales 2026 to identify whether a particular character caused the problem.

Rename Sheet is unavailable or Excel refuses the change. The workbook structure may be protected. In Excel for Windows, check Review > Protect Workbook; if workbook protection is enabled, an authorized person must unprotect the structure, often by supplying the required password. A protected worksheet is not the same as a protected workbook structure, so check the workbook-level setting. Do not try to bypass a password; ask the workbook owner for access.

You are using Excel for Mac. The Windows Alt+H,O,R KeyTip sequence is not the standard Mac route. In the Mac menu bar, choose Format > Sheet > Rename, then type the name and press Return. Menu-bar keyboard access depends on macOS settings; on many Macs, Control+F2 (or Fn+Control+F2) focuses the menu bar, after which you can navigate with arrow keys. To change the active sheet on Mac, use Control+Page Up or Control+Page Down where those keys are available; compact keyboards may require the Fn key.

You are using Excel for the web. Do not assume the desktop KeyTip sequence will behave identically in a browser. Use the sheet-tab menu or double-click the tab if supported by your browser and Excel view. Browser shortcuts can intercept keys, and ribbon keyboard access may vary, so use the visible Rename option if a keyboard sequence does not appear on screen.

Frequently Asked Questions

What is the keyboard shortcut to rename a sheet in Excel for Windows?

Press Alt, H, O, and R one after another, type the new tab name, and press Enter. It is a ribbon KeyTip sequence rather than a combination of keys held down at once.

Can I rename a sheet without using the mouse?

Yes. Select the worksheet with Ctrl+Page Up or Ctrl+Page Down, then use Alt, H, O, R on Windows. Type the replacement name and confirm with Enter.

How do I rename a sheet on a Mac using the keyboard?

Excel for Mac does not use the same standard Windows KeyTip sequence. Open Format > Sheet > Rename from the menu bar. You may be able to focus the menu bar with Control+F2 or Fn+Control+F2, depending on your Mac keyboard and settings.

What are the rules for Excel sheet names?

A sheet name can contain up to 31 characters. It cannot be blank, duplicate another tab’s name, include a colon, backslash, slash, question mark, asterisk, or square bracket, or begin or end with an apostrophe. A shorter, distinctive name is usually easier to navigate and maintain.

Will renaming a worksheet break formulas?

Excel typically updates many formulas that refer directly to the renamed sheet. However, text-based references, external workbooks, queries, and macros may not update automatically in every case. Check important formulas and connected processes after changing a name.

Why is the Rename Sheet command disabled?

The workbook structure may be protected, or Excel may be in a mode that prevents the action. Close cell editing, check Review > Protect Workbook, and ask the workbook owner to remove protection if you do not have permission or the password.

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.