In Excel for Microsoft 365 on Windows, press Alt, then H, O, and R to rename the active sheet. Type the new name and press Enter; the keys are pressed one after another, not all at once.
The Windows shortcut, step by step
The sequence Alt+H, O, R uses Excel’s ribbon KeyTips to reach the Rename Sheet command. It works when the workbook is open and a worksheet is active. Follow these steps:
- Click a cell on the sheet you want to rename, or otherwise make that sheet active.
- Press and release
Alt. Excel displays letters over ribbon tabs and commands. - Press
Hfor the Home tab, thenOfor the Format menu, thenRfor Rename Sheet. - When the current tab name is selected for editing, type the replacement name and press
Enter.
Do not hold the four keys down together as if they were a conventional combination such as Ctrl+C. The commas in shortcut notation mean to press each key in sequence. If you need to abandon the edit before committing a name, press Esc.
What the shortcut does
The shortcut opens the name field for the active worksheet tab. It does not rename the workbook file, a table, a chart, or a named range. For example, if the tab at the bottom of the window says Sheet2, the command selects that sheet name so you can replace it with something descriptive such as March Sales.
Excel uses KeyTips to make ribbon commands reachable from the keyboard. The letters can appear on screen as you move through the sequence, which is useful if you forget the next key. KeyTips are tied to the ribbon interface and can differ if you use a different Office language or a customized ribbon, so follow the displayed letters if they do not match the sequence described here.
Mouse and ribbon alternatives
For a one-off change, using the mouse may be more convenient than memorizing a sequence. Double-click the worksheet tab, type the new name, and press Enter. Another option is to right-click the tab and choose Rename. Both methods target the sheet whose tab you clicked, so they can be helpful when several sheets are open and you want to avoid renaming the wrong one.
You can also use the ribbon: select the sheet, then choose Home > Format > Rename Sheet. The command has the same result as the keyboard sequence. If the tab strip is crowded, right-clicking the relevant tab can be easier than searching for it among many tabs.
- Keyboard:
Alt+H, O, Ron Windows; useful for a fast, repeatable workflow. - Double-click: double-click the tab, type, and press
Enter; useful when the target tab is visible. - Context menu: right-click the tab and select Rename; useful when you prefer to see the command before choosing it.
- Ribbon: Home > Format > Rename Sheet; useful when learning where the command lives.
Excel for Mac and Excel for the web
The Windows KeyTip sequence Alt+H, O, R is not the standard Mac equivalent. In Excel for Mac, double-click the sheet tab or Control-click or right-click it and choose Rename. Menu organization and available keyboard access can vary with the Mac version and settings; using the tab’s context menu is a dependable way to find the command without assuming a Windows shortcut works on a Mac.
In Excel for the web, you can also double-click a sheet tab or open its context menu and choose Rename. The browser and operating system can affect which keys are intercepted, so do not assume that a desktop ribbon shortcut will behave identically in a browser. If the tab is difficult to reach, use the available sheet-tab navigation controls to bring it into view, then rename it from the tab.
Sheet-name rules to know
Excel permits useful labels such as Q1 Budget, 2026, or North Region, but worksheet names have restrictions. A name cannot be blank, cannot exceed 31 characters, and cannot contain these characters: colon, backslash, forward slash, question mark, asterisk, or square brackets. Names also cannot begin or end with an apostrophe. In a workbook, two sheets cannot have the same name, even if the capitalization differs.
Spaces are allowed, and names do not have to start with a letter. A short, readable name is usually better than using the full 31-character allowance: tabs take up room, and long names can be harder to scan. If Excel rejects a name, check the forbidden characters, length, and whether another sheet already uses that name. Excel will normally explain or indicate why the proposed name cannot be accepted.
- Good examples: Jan Sales, Inputs, West_Region, and 2026 Plan.
- Invalid examples: Sales/Costs because it contains a slash, or a name longer than 31 characters.
- Potentially confusing examples: generic names such as Sheet1 and Sheet2 when the workbook contains many similarly structured tabs.
What happens to formulas and references?
Renaming a worksheet usually updates formulas in the workbook that refer to that sheet. For instance, a formula that refers to cell A1 on a sheet named January will be adjusted when that sheet is renamed to Jan Sales. Excel uses the new sheet name in the formula reference, so you generally do not need to edit each formula yourself.
When a sheet name contains a space or certain other characters, Excel encloses it in single quotation marks in a formula reference. A reference might appear as ='Jan Sales'!A1. A simple name without spaces may appear without those quotation marks. This is normal formula syntax, not a sign that the rename failed.
Renaming a tab does not rewrite every occurrence of the old wording everywhere in the workbook. Text typed into cells, labels in documentation, and text embedded inside a formula as a text value are not necessarily sheet references. Code or other automation that looks up a worksheet by its old name may also need attention. If the workbook contains macros, external connections, or documentation that mentions the sheet by name, review those items after a rename rather than assuming every reference has changed.
Common problems and quick fixes
If the keyboard sequence seems not to work, first check that Excel has focus and that a worksheet—not a dialog box or another application—is active. Press Alt and look for the KeyTips; if they do not appear, click the workbook and try again. Pressing the letters too quickly or holding them as a simultaneous combination can also lead to a different result.
- The wrong sheet is renamed: the command acts on the active sheet. Check the selected tab before starting, or use the mouse directly on the intended tab.
- Excel will not accept the new name: shorten it, remove prohibited characters, avoid a leading or trailing apostrophe, and check for a duplicate name.
- The name is selected but typing does not replace it: click the tab again or use the Rename command, then type while the name is in edit mode.
- The sequence opens something unexpected: use the visible KeyTips to identify the current ribbon keys, particularly if the interface language or ribbon customization differs.
- You are in a protected workbook or unusual editing state: some workbook restrictions can limit changes. Check whether the workbook or sheet is protected and whether you have permission to edit it.
Sheet protection and workbook-structure protection are different. Protecting cells on a worksheet controls what users can change on that sheet, while protecting the workbook structure can restrict actions such as renaming, moving, or deleting sheets. If rename commands are unavailable or Excel refuses the change, check the Review tab for protection controls and confirm that you are authorized to remove any restriction.
Choosing useful worksheet names
A good sheet name helps readers understand the workbook without opening every tab. Use names that describe the content or purpose, such as Raw Data, Summary, Assumptions, or a month and year. If a workbook has one sheet per region, use a consistent pattern—North, South, East, and West—rather than mixing abbreviations and full names.
Consistency matters when people filter, print, or review the workbook, and it can make formulas easier to interpret. Avoid names that are nearly identical, such as Data and Data2, unless the difference is clear. For recurring reports, include a period where useful, but remember the 31-character limit. A clear name can reduce mistakes, yet it does not replace labels within the sheet: readers should still be able to tell what rows, columns, and units represent.
Frequently Asked Questions
What is the shortcut to rename a sheet in Excel?
In Excel for Microsoft 365 on Windows, press Alt, H, O, and R in order. Type the new worksheet name and press Enter.
Do I press Alt+H, O, R all at the same time?
No. Press and release each key in sequence. The notation uses commas to show that these are successive KeyTips, unlike a shortcut such as Ctrl+C, where keys are held together.
Can I rename a sheet by double-clicking its tab?
Yes. Double-click the worksheet tab, type the new name, and press Enter. You can also right-click the tab and choose Rename.
Does renaming a sheet break formulas?
Excel generally updates direct worksheet references in formulas when you rename the sheet. However, ordinary text that happens to contain the old name, and some code or external references that depend on a name, may need separate review.
Why will Excel not let me use my sheet name?
The name may be blank, longer than 31 characters, contain a forbidden character, begin or end with an apostrophe, or duplicate another sheet name. Workbook-structure protection can also prevent renaming.
Is there a different rename shortcut on Mac?
The Windows sequence is not the standard Mac method. In Excel for Mac, double-click the tab or open its context menu and select Rename; the precise keyboard behavior can depend on the Mac version and settings.
Related
- Excel File Too Large to Email? Practical Fixes
- Excel File Size Too Large? How to Reduce It
- Excel File Too Big? How to Reduce Workbook File Size Safely
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Advanced Excel Power Query: Techniques and WorkflowsAdvanced Excel Power Query is the practice of building repeatable, well-organized data import and transformation workflows in Excel,…
- Excel Row Height and Column Width: Make Cells SquareYes. To make an Excel cell square, make its column width and row height occupy the same number…
- Excel Data Validation From Another Workbook: Best MethodsYes, but the dependable approach is to bring or refresh the list in the workbook that needs the…
- Compressing Pictures in PowerPoint: Settings and StepsTo compress pictures in PowerPoint for Microsoft 365 on Windows, select a picture, go to Picture Format >…
- Excel Unmerge Cells: What Happens to the Text?To unmerge cells in Excel for Microsoft 365 on Windows, select the merged cell, then choose Home >…
- Actual vs Forecast in Excel: Compare ResultsActual vs forecast in Excel means comparing what happened with what was expected. Put the forecast in one…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.