Skip to content
CtrlKFind a shortcut

Excel Sheet Rename Shortcut

ExcelExcelSheet tabsChecked 2 Nov 2026

Rename sheet

AltHOR

One after another

Older menu keys

AltOHR

Mouse

Alt

Or double click the sheet tab

Mac

Control

Right click the tab, then Rename

The Excel sheet rename shortcut is Alt, then H, then O, then R, pressed one key after another. The current sheet's tab becomes editable; type the replacement name, then confirm with Enter. With a mouse, a double click on the tab gives the same result.

Note that F2 does not rename sheets in Excel; it edits the active cell. The older key sequence Alt, then O, then H, then R from earlier menu versions still works in current Excel too.

Quick facts

  • Rename sheet

    Alt, then H, then O, then R

  • Older sequence

    Alt, then O, then H, then R

  • Mouse

    Double click the tab

  • Next sheet

    Ctrl + PgDn

  • New sheet

    Shift + F11

  • Confirm

    Enter

Excel sheet rename shortcut, step by step

  1. Go to the sheet with Ctrl + PgDn or Ctrl + PgUp.
  2. Press Alt, then H, O and R.
  3. Type the new name; the old one is already selected.
  4. Press Enter to keep it, or Esc to cancel.

Switching sheets is covered in more detail in switch sheets in Excel.

Naming rules for sheets

What Excel allows
RuleDetail
LengthUp to 31 characters
Not allowed\ / ? * : [ ]
Cannot be blankEvery sheet needs a name
UniqueNo two sheets in a workbook can share a name
ReservedHistory cannot be used

Short names such as Apr, May and Jun, or Sales North, make formulas that refer to other sheets easier to read. Avoid spaces if you write many cross sheet formulas, because Excel then wraps the name in single quotes inside every reference. Names like Sales_North or SalesNorth keep formulas shorter and easier to type, and they sort neatly when you later list the sheets in an index sheet with hyperlinks to each one.

Rename many sheets quickly

Excel renames one sheet at a time. A fast rhythm is Alt, then H, then O, then R, type, Enter, then Ctrl + PgDn to the next sheet and repeat. For a monthly workbook, create the first sheet, name it, then add the others with Shift + F11; see new sheet in Excel. Tab colours, set with Alt, then H, then O, then T, help group sheets such as quarters.

Formulas that refer to a renamed sheet update automatically, so renaming is safe even in linked workbooks that are open.

Rename a sheet on a Mac

Excel for Mac has no default rename key. Double click the tab, or hold Control and click it, then choose Rename. You can add your own shortcut in macOS System Settings, Keyboard, Keyboard Shortcuts, App Shortcuts, using the exact menu title Rename Sheet.

When rename does not work

Problems and fixes
ProblemFix
Alt, H, O, R greyed outThe workbook structure is protected; unprotect it under Review
Name rejectedRemove characters such as / or : and keep under 31
F2 edited a cell insteadF2 is for cells; use the Alt sequence
Several sheets selectedClick one tab first; rename works on one sheet
A CA firm's article assistant receives a workbook with Sheet1 to Sheet12. Using Alt, then H, then O, then R and Ctrl + PgDn, he renames all twelve to month names in under a minute.

Frequently asked questions

What is the Excel sheet rename shortcut?
Alt, then H, then O, then R, pressed one after another.
Does F2 rename a sheet in Excel?

No. F2 edits the active cell.

How long can a sheet name be?

Up to 31 characters.

Why can't I rename a sheet?

The workbook structure may be protected.

How do I rename a sheet on a Mac?

Double click the tab, or Control click and choose Rename.

Do formulas break when I rename a sheet?

No. Excel updates references automatically.