Rename a Sheet in Excel Without a Mouse

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, R in sequence. Type the new sheet name and press Enter. This uses Excel’s ribbon KeyTips, so you can rename a tab without reaching for the mouse.

The steps below also explain how to move between sheets first, choose a valid name, and recover if the keyboard sequence does something unexpected. The Windows desktop steps are the main instructions; Mac and Excel for the web work somewhat differently.

What You’ll Need

  • A keyboard and an open Excel workbook that contains the worksheet you want to rename.
  • Permission to change the workbook structure. If the workbook structure is protected, the sheet cannot be renamed until protection is removed by someone with the password or appropriate access.
  • A name that follows Excel’s worksheet naming rules: it can be up to 31 characters, must be unique in the workbook, and cannot contain a colon, backslash, forward slash, question mark, asterisk, or square bracket. It also cannot be blank or begin or end with an apostrophe.

Step-by-Step

  1. Make sure Excel is ready for a command. Click-free navigation works best when focus is in the worksheet, not in a cell being edited or in the formula bar. If you see a text cursor inside a cell, press Esc to cancel the edit, or Enter to accept it. Then continue. If a dialog box is open, close it or respond to it before trying the rename sequence.
  2. Select the worksheet you want to change. Press Ctrl+Page Up to move to the previous sheet tab, or Ctrl+Page Down to move to the next one. Repeat as needed and check the active sheet name on the tab area before renaming. These shortcuts move among worksheets in the current workbook; they do not move the cell selection around the grid.
  3. Use the Rename Sheet ribbon command. Press and release Alt, then press H, O, and R one after another. Do not hold all four keys down together. The sequence opens the Home tab’s Format menu and runs Rename Sheet. It is the keyboard equivalent of choosing Home > Format > Rename Sheet.
  4. Enter the new name. Excel puts the selected sheet tab into rename mode, usually with the current name highlighted. Type the replacement name. If the old name is not highlighted and the text cursor is active in the tab name, press Ctrl+A to select that name, then type the replacement. Only use Ctrl+A once the tab name is being edited; in the worksheet grid, it can select cells instead.
  5. Commit the change. Press Enter. Excel applies the new name to the tab. Look at the tab to confirm that the spelling is right and that the intended worksheet—not a neighboring one—was renamed.
  6. Check formulas and references if the name is important. Excel normally updates formulas that refer to a renamed sheet, such as a formula on another sheet that points to it. If the workbook includes external links, macros, charts, or instructions that mention the old name as plain text, those items may not update automatically. Check any workflows that depend on the old label.
  7. Repeat for another sheet if needed. Use Ctrl+Page Up or Ctrl+Page Down to select another tab, then repeat the Alt, H, O, R sequence. Rename one sheet at a time and verify each change; this makes it less likely that you will accidentally give a tab the wrong label.

For example, if the active tab is named Sheet3 and it contains the April figures, select that tab, invoke Rename Sheet, type April Summary, and press Enter. If a sheet named April Summary already exists in the same workbook, Excel will not accept the duplicate. Choose a distinct name such as April Summary 2 or April Detail instead.

On many laptops, the Page Up and Page Down functions share keys with other controls. You may need to press Fn together with Ctrl and the relevant key, depending on the keyboard layout and function-key settings. The ribbon rename sequence itself remains Alt, H, O, R in Windows desktop Excel.

Common Mistakes

Holding the KeyTips down as a chord: The letters in the ribbon sequence are pressed in order after Alt, not all at once. If the command does not open, press Esc to clear any visible KeyTips and start again, making sure the worksheet is active.

Renaming the wrong tab: The active worksheet is the one the command affects. Before pressing Alt, H, O, R, use the sheet-navigation shortcut and verify which tab is active. This matters especially in workbooks with many tabs that have similar names.

Using a name Excel rejects: A name can look reasonable but still contain a prohibited character, be longer than 31 characters, or duplicate another tab’s name. Make the label shorter or replace punctuation with a space, dash, or underscore. Sheet names must be unique within a workbook, even if the difference is only capitalization.

Typing while the cell is active: If the Rename Sheet command was not triggered, typing may replace the contents of the selected cell. Stop if you see characters appearing in the grid. Press Esc immediately to cancel the cell edit, then restart with the correct sheet active.

Expecting the name to change everywhere: Excel updates many formula references, but not every mention of a tab name is a formula reference. A note, printed instruction, VBA code, or external process may still contain the old name. Check those separately if the rename is part of a larger handoff or reporting process.

Tips

Choose names that explain what the sheet contains, rather than relying on labels such as Sheet1 or Data2. Short names like Inputs, Q1 Sales, or Archive are easy to scan. For recurring periods, use a consistent pattern—such as 2026-01, 2026-02, and 2026-03—so the tabs are easy to distinguish. Keep names concise because long labels can be difficult to read when a workbook has many visible tabs.

Before renaming, consider whether other people, saved instructions, or automated processes rely on the current name. Formulas that directly refer to a worksheet are generally adjusted by Excel when it is renamed, but a macro that searches for a particular tab by its old name may fail. If the workbook is shared or used for routine reporting, tell collaborators what changed and check any related automation.

You can use the same keyboard sequence in a workbook with hidden sheets only after selecting a sheet that is available to you; a hidden tab cannot be selected by cycling through the visible worksheet tabs. If you need to rename a hidden sheet, it must first be made visible, and the workbook’s protection settings may restrict that change. Avoid changing protection or visibility settings unless you have permission to do so.

When navigating through a long row of tabs, move one sheet at a time and watch the active tab rather than trying to remember how many presses you made. If you overshoot, press the opposite Page Up or Page Down shortcut to return. This simple check prevents a correct rename command from being applied to the wrong worksheet.

Troubleshooting

Nothing happens after Alt, H, O, R: Confirm that you are using Excel desktop on Windows and that you pressed the keys in sequence. If KeyTips appear but the menu does not advance, press Esc and try again. If another application or a remote desktop is intercepting Alt-key commands, click-free ribbon access may be affected by that environment; check its keyboard-shortcut settings or use Excel’s displayed KeyTips to see the available choices.

The sequence opens a different command: KeyTips can vary with the active context, workbook state, or interface. Watch the letters shown on screen after pressing Alt and follow the displayed KeyTips for Home, Format, and Rename Sheet rather than continuing with a sequence that no longer matches. Press Esc to leave the KeyTips without making a change.

Excel says the name is invalid: Check that the name is not blank, is no more than 31 characters, contains none of the prohibited characters, and does not start or end with an apostrophe. Also check for another sheet with the same name, including one that differs only by uppercase or lowercase letters. Try a shorter, unique label made of ordinary letters, numbers, spaces, hyphens, or underscores.

The rename command is unavailable or does not take effect: The workbook structure may be protected, or the file may be in a state that prevents structural changes. Check Review > Protect Workbook for workbook-structure protection. If protection is on, ask the workbook owner for access or the required password; do not try to bypass it. In a shared or restricted workbook, confirm that you have editing permission.

The name appears in a cell instead of on the tab: Press Esc to cancel the unintended cell edit. Confirm that the worksheet—not a cell formula or text field—has focus, then start the ribbon command again. If you already pressed Enter and changed a cell, use Ctrl+Z to undo that cell edit before proceeding, provided no later action has made undo unsuitable.

You are using a Mac: Excel for Mac does not use the same Windows Alt KeyTips sequence. Switch sheets with Control+Page Up or Control+Page Down; on some keyboards you may also need Fn. To rename using menus, use Format > Sheet > Rename. To operate that menu without a mouse, use your macOS keyboard navigation to focus the menu bar, then navigate with the arrow keys; the key to focus the menu bar can depend on your macOS keyboard settings.

Frequently Asked Questions

Can I rename an Excel sheet without using the mouse?
Yes. In Windows desktop Excel, select the sheet with Ctrl+Page Up or Ctrl+Page Down, press Alt, H, O, R in sequence, type the new name, and press Enter.

Does renaming a sheet change formulas that refer to it?
Excel generally updates direct worksheet references in formulas when you rename a sheet. Still, check external links, macros, chart labels, and plain-text instructions, because those may refer to the old name in ways Excel does not revise.

Why will Excel not accept my new sheet name?
The name may be too long, blank, duplicated, or contain a prohibited character. Use a unique name of 31 characters or fewer, and avoid : \ / ? * [ ] and apostrophes at the beginning or end.

Can I rename a sheet in Excel for the web using the same shortcut?
Keyboard access in Excel for the web can depend on the browser and its shortcuts, so do not assume the Windows desktop sequence will behave identically. Use the web app’s displayed access keys and ribbon commands, or open the workbook in desktop Excel and follow the Windows steps above.

Can I rename a protected worksheet?
Worksheet protection and workbook-structure protection are different. Protecting individual cells does not necessarily prevent a tab rename, but protecting the workbook structure does. If Excel blocks the rename, check Review > Protect Workbook and ask the owner for authorization if needed.

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.