How to rename an Excel worksheet and change its tab color
In Excel for Windows, double-click a worksheet tab at the bottom of the window to rename it. To change its color, right-click the tab and pick a color from Tab Color. Both changes apply to the sheet inside the workbook.
Rename a worksheet
- Double-click the tab you want to change. When the current name is highlighted, type the new one and press Enter. Check that the tab now displays the new name.
- You can also right-click the tab and choose Rename. Press Esc to cancel while the name is still being edited.
When Excel rejects a name
A name cannot be blank, longer than 31 characters, or identical to another sheet name in the workbook. It cannot start or end with an apostrophe or contain any character listed below. For example, use 2026-10 instead of 2026/10.
/ \ ? * : [ ]
If Rename is unavailable, check on the Review tab whether the workbook structure is protected. In a shared file, ask the workbook owner to make the change if you lack permission.
Microsoft Support worksheet naming rules
Set or clear a tab color
- Right-click the worksheet tab and choose a color from Tab Color. Select another sheet to see how the color looks on an inactive tab.
- To restore the default appearance, choose No Color in the same menu.
Gray can mark raw-data sheets and blue can mark summaries. Include words like Raw data and Summary in the names too, so the purpose is clear when someone cannot distinguish the colors. Tab color has no effect on cell fill or print formatting.
Microsoft Support guide to worksheet tab colors
Check formulas and links after renaming
In a copy of the workbook, put 100 in B2 of a sheet named Jan. Enter the first two formulas below in separate cells on another sheet. Both return 100. Rename Jan to Jan 2026.
=Jan!B2
=INDIRECT("Jan!B2")
='Jan 2026'!B2
Excel normally updates the first, direct reference to the third formula and still returns 100. The quoted Jan!B2 inside INDIRECT stays as text. If the old sheet name no longer exists, the formula returns a reference error until you update the text.
Compare calculations and charts before and after the rename. Refresh any queries or connected workbooks and review the sheet name in macros that store it as text.




