QUICK ANSWER
Three ways to rename a sheet
| Method | Steps |
|---|---|
| Fastest Double-click | Double-click the sheet tab → type a new name → press Enter |
| Menu Right-click | Right-click the tab → Rename → type the name → Enter |
| Ribbon Home tab | Home → Format → Rename Sheet → type → Enter |
STEP BY STEP
Rename a worksheet
1
Double-click the sheet tab
The tab name becomes editable and is highlighted.
2
Type the new name
Type over the highlighted text. Excel replaces the old name.
3
Press Enter
Press Enter (or click elsewhere) to confirm. Press Esc to cancel.
✅ Pro Tip: To rename many sheets, press
Alt + H, then O, then R on Windows to jump straight to the Rename command.
NAMING RULES
What Excel won't let you name a sheet
When a rename is rejected, it is usually one of these rules:
| Rule | Detail |
|---|---|
| Length | Maximum 31 characters |
| Forbidden characters | \\ / ? * [ ] : |
| No blank name | A sheet name cannot be empty |
| Unique names | Two sheets in the same workbook can't share a name |
⚠️ Beware of formulas: If formulas reference the old sheet name, they may break after renaming. Excel usually updates references automatically within the same workbook — but check any external links.
TROUBLESHOOTING
Common problems & fixes
"That name is already taken"
Another sheet in the same workbook already uses that name. Choose a different name or rename the other sheet first.
Can't edit the tab / Rename is grayed out
The workbook structure is protected. Go to Review → Unprotect Workbook. See the Unprotect Worksheet guide.
Mac users
Double-click the sheet tab, or go to the Format menu → Sheet → Rename.
FREQUENTLY ASKED
Frequently Asked Questions
How do I rename a worksheet in Excel?
Double-click the sheet tab and type a new name, or right-click the tab and choose Rename, then press Enter.
What characters are not allowed in an Excel sheet name?
Excel sheet names cannot contain: \ / ? * [ ] : and cannot be more than 31 characters long.
Can I rename multiple worksheets at once?
You cannot type different names at once, but you can select multiple sheets and rename them together if you want the same name pattern; otherwise rename each tab individually.
How do I rename a sheet on a Mac?
Double-click the sheet tab and type the new name, or use the Format menu, then Sheet, then Rename.
QUICK LINKS
Continue Exploring
SOURCES
Sources & References
Written and fact-checked against Microsoft's official Excel documentation.
Disclaimer: This guide is for informational purposes only. Last Updated: September 16, 2026.