Excel Shortcut to Rename a Sheet in Windows and Mac

In Excel for Microsoft 365 on Windows, press Alt, then H, O, and R to rename the active sheet. Press the keys in sequence—not all at once—then type the new name and press Enter. If you prefer a mouse action, double-click the sheet tab, enter the name, and press Enter.

The Windows shortcut, step by step

The shortcut uses Excel’s ribbon Key Tips to reach the Rename Sheet command. Start with the worksheet whose name you want to change, then follow this sequence:

Press Alt to display Key Tips on the ribbon.
Press H to select the Home tab.
Press O to open the Format menu in the Cells group.
Press R to choose Rename Sheet.
Type the new name and press Enter.

After you choose Rename Sheet, Excel selects the current tab name for editing. You can type over it, or use the arrow keys to move within the existing name. Pressing Enter confirms the change; pressing Escape cancels the edit. If the key sequence does not appear to work, check that you are using the desktop Windows version of Excel and that no dialog box or cell-editing mode is intercepting your keystrokes.

Why the shortcut uses Alt, H, O, R

This is a ribbon command sequence rather than a dedicated shortcut that performs the rename with one simultaneous key combination. The letters are Key Tips: they guide you through the ribbon’s tabs and menus. In the English Windows interface, H opens Home, O opens Format, and R selects Rename Sheet. Excel may display the available Key Tips on screen as you go.

That distinction matters if you are used to shortcuts such as Ctrl+C, which you press together. For the rename command, press and release each key in order. The active cell can remain selected; you do not need to click a cell or switch to a particular ribbon group first. The command acts on the active worksheet tab, not on a cell selection or on every sheet in the workbook.

Key Tip letters can differ in localized versions of Office, and Microsoft may adjust ribbon details between versions. If your interface is not in English, follow the letters shown on screen instead of assuming the English sequence. The tab-based methods below are useful fallbacks when you cannot remember the sequence.

Mouse and context-menu alternatives

Renaming from the sheet tab is often the quickest option when the tab is visible. Double-click the tab name, type the replacement, and press Enter. This method works well for a single sheet and makes it obvious which tab you are changing.

You can also right-click the sheet tab and select Rename from the context menu. On a touchpad or a device without a conventional right mouse button, use the device’s context-click gesture. Another option on Windows is the ribbon path Home > Format > Rename Sheet, which reaches the same command as Alt, H, O, R.

Double-click the tab: best when the target sheet is already visible.
Right-click the tab, then Rename: useful when you want to see the sheet-specific menu.
Home > Format > Rename Sheet: helpful when using the ribbon or teaching someone the command.
Alt, H, O, R: convenient when you want to keep your hands on the keyboard.

All of these methods change the name of the current worksheet; none duplicates, deletes, or moves it. If a workbook has many tabs and the target is off-screen, first navigate to that sheet, then use whichever rename method is most comfortable.

Worksheet name rules to know

Excel allows descriptive worksheet names, but there are limits. A name can contain up to 31 characters, and it must be unique within the workbook. Names are not distinguished by capitalization for this purpose, so Excel will not allow one tab named Sales and another named sales.

Some characters cannot appear in a worksheet name: a colon, backslash, forward slash, question mark, asterisk, or square bracket. A name also cannot begin or end with an apostrophe. The name cannot be left blank. If you type an invalid name or one already used by another sheet, Excel displays a message and keeps the rename field active so you can correct it.

For example, Q4 Sales is a valid, readable name, while Q4/Sales is not because it contains a slash. A name such as Regional Results – West is clearer than a generic label such as Sheet7 when a workbook is shared or revisited later. Use concise names that identify the data or purpose without exceeding the character limit.

What changes when a sheet is renamed?

Renaming a tab changes the worksheet’s label, not the sheet’s contents, position, visibility, or protection settings. Data, formatting, charts, and the cells on that worksheet remain in place. It is therefore different from creating a new sheet and copying data into it, which can affect formulas, links, formatting, or workbook structure.

Excel generally updates direct worksheet references in formulas within the workbook when you rename the referenced sheet. For example, a formula that refers to a cell on a sheet being renamed is normally adjusted to use the new sheet name. However, text that merely looks like a reference is not necessarily updated. A sheet name written inside a text string, a note in a cell, or a name embedded in external documentation may need a manual edit. Macros or other automation that construct sheet names as text can also depend on the old label.

Before renaming a sheet in a workbook used by other people or by automated processes, consider whether those processes look up the sheet by its name. If they do, coordinate the change or update the dependent process. In ordinary workbooks, a descriptive rename is usually straightforward; the main caution is to check anything that treats the name as text rather than as a worksheet reference.

When the rename command does not work

If Excel rejects the new name, check the naming rules first: it may be too long, blank, duplicated, or contain a prohibited character. Replace the problem text and try again. If the name field will not activate, make sure you clicked the tab itself rather than a nearby navigation arrow or the horizontal scroll bar.

A protected workbook structure can prevent adding, deleting, moving, hiding, or renaming sheets. If Rename is unavailable or Excel reports that the workbook is protected, ask the workbook owner or an authorized administrator to review the structure protection. Do not confuse workbook-structure protection with protecting individual cells or a worksheet’s contents; they are different controls.

The letters seem to do nothing: press Alt first and watch for Key Tips, then enter H, O, and R in order.
The wrong sheet is renamed: cancel if the edit is still active, select the intended tab, and repeat the command.
Excel says the name is invalid: remove forbidden characters, shorten it, or choose a unique name.
Rename is disabled: check whether workbook structure protection or an active dialog is preventing the command.
The keyboard is editing a cell: press Escape to leave cell-edit mode, then retry the sheet command.

If a workbook is shared or controlled by an organization, permissions and collaboration settings may also affect which structural changes are allowed. Save the workbook after making the change, and check any dependent formulas, reports, or automation if the file is part of a larger process.

Using Excel on Mac or in a browser

The Alt, H, O, R Key Tip sequence is for Excel on Windows and should not be treated as a Mac shortcut. On Excel for Mac, the straightforward method is to double-click the worksheet tab, type the new name, and press Return. You can also open the tab’s context menu and choose Rename. Keyboard mappings and menu labels can differ by Mac version, so the tab-based method is a dependable choice.

In Excel for the web, use the sheet tab’s context menu and select Rename, or double-click the tab name if that interaction is available in your browser and device. The Windows desktop ribbon sequence should not be assumed to work in a browser: the web app has its own interface and keyboard handling. If the tab is not visible, use the sheet navigation controls to locate it before renaming.

On both platforms, confirm the edit with Enter or Return as appropriate. If you use screen-reading or other accessibility tools, the context menu or ribbon command may be easier to identify than relying on a memorized sequence of letters.

Choosing names that make workbooks easier to use

A useful sheet name tells readers what they will find without requiring them to open several tabs. Names such as Raw Data, Monthly Summary, and Assumptions communicate purpose. When a workbook contains repeating periods, use a consistent pattern such as 2026-01, 2026-02, and 2026-03; consistent labels are easier to scan than a mix of abbreviations and formats.

Try to avoid names that are ambiguous or dependent on private context, such as New, Final2, or John’s version. If you need to distinguish drafts, communicate status clearly and keep the naming convention consistent. A worksheet name is visible to anyone opening the workbook, so clarity can reduce navigation mistakes and make handoffs easier.

For a workbook with many sheets, group related tabs next to each other and use names with a shared pattern. Renaming does not change a sheet’s order, so drag the tab separately if you also need to reorganize the workbook. Do not try to encode every detail into a tab name: the 31-character limit makes concise labels more practical, while a title row or cell can hold a longer description.

Frequently Asked Questions

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

Do I press Alt, H, O, and R together?
No. Press Alt, release it, then press H, O, and R one at a time. They are ribbon Key Tips, not a simultaneous four-key combination.

Can I rename a sheet with a double-click?
Yes. Double-click the worksheet tab, type the new name, and press Enter on Windows or Return on Mac.

Why can’t I rename a worksheet?
The name may violate Excel’s rules, or the workbook structure may be protected. Check for a duplicate name, forbidden characters, and the 31-character limit; if the command remains unavailable, ask the workbook owner about protection.

Does renaming a sheet break formulas?
Excel generally updates direct worksheet references in formulas when a sheet is renamed. Still, check text-based references, external documentation, and macros or automation that may rely on the old name.

What is the Mac shortcut for renaming a sheet?
The Windows Alt, H, O, R sequence is not the Mac equivalent. On Mac, double-click the tab or open its context menu and choose Rename.

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.