In Excel: double-click the sheet tab, type the new name and press Enter — or right-click the tab ▸ Rename.
Double-click the sheet tab (or right-click ▸ Rename, or Alt+H, O, R on Windows).
Type a name of 31 characters or fewer, avoiding : \ / ? * [ and ].
Press Enter. Formulas referring to the sheet update themselves.
Search the workbook for INDIRECT and for the old name in quotation marks — those are the references that will not have updated.
To rename a table instead: click inside it, then Table Design ▸ Table Name.
What this does
Sheet names are limited to 31 characters and cannot contain : \ / ? * [ or ], cannot be blank, cannot be "History" (Excel reserves it), and must be unique within the workbook. Renaming a sheet is safe for formulas: every reference to it, on any sheet, updates automatically, because Excel stores the link to the sheet rather than to its name. Two things do NOT update — text you built yourself with a hard-coded name, such as ="Sales"&"!A1" fed to INDIRECT, and external references in other workbooks that are currently closed. Renaming COLUMNS is a different job: worksheet columns are always A, B, C, so what people mean is either editing the header text in row 1 or, in a Table, editing the header cell, which does update every structured reference. Renaming the FILE is done in File Explorer or Finder with the workbook closed. The same idea underpins a lot of everyday Excel work, so the few minutes spent getting it right here pay back across every sheet you build afterwards. Treat it as a pattern, not a one-off, and it stops being something you look up and starts being something you reach for. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “change excel sheet name”. Start on a copy or a tiny sample, keep the affected sheet visible, and compare the result with the tool above before you touch the real workbook. When this is a ribbon command, the selection matters more than the button: confirm the range, apply the command, then spot-check the output before saving. The point is a workflow that saves repeating the same clicks every week, but the practical win is that someone else can open the file and understand what happened without asking you.
A worked example
Sheet1 holds January figures and Summary!B2 contains =Sheet1!B10. Double-click the Sheet1 tab, type Jan, press Enter. Summary!B2 now reads =Jan!B10 with no action from you. But a cell containing =INDIRECT("Sheet1!B10") still points at a sheet that no longer exists and returns #REF!. Sheet1, Sheet2, Sheet3 is the single fastest thing to fix in an inherited workbook, and knowing that references follow the rename is what makes people willing to do it. A practical tip before you scale it up: build it once on a small block of test data, confirm the number against the tool on this page, and only then point it at your real sheet. That one habit catches almost every mistake while it is still cheap to fix, long before a wrong figure reaches a report or a colleague.
In Google Sheets
Google Sheets handles this almost identically to Excel. The formula syntax above is the same, and the menu lives under a slightly different label rather than a ribbon tab. Use the platform toggle at the top of the page to switch every keyboard shortcut between Windows and Mac, and expect at most cosmetic differences in naming. The aim was to get you unstuck fast and leave you a little more capable than a copy-paste would. The answer is at the top, the tool proves it, and the detail above shows why it holds — so the next time a colleague asks, you can answer without reaching for search. If you take one thing from this page on “change excel sheet name”, make it the habit rather than the keystrokes: set the problem up with labelled inputs, reference those cells, and let Excel do the recomputing. Bookmark the page for the syntax, but do the example once in a blank sheet and check it against the tool above — five minutes of hands-on practice fixes the method in memory far better than re-reading, and it surfaces the small snags while they are still harmless. After that the technique is genuinely yours: faster than searching for it again, and reliable enough to drop into work that other people depend on.
Common mistakes
- Using a name longer than 31 characters, or one containing a slash or colon, and getting a rejection dialog with no explanation of which character was the problem.
- Assuming formulas break — they do not, except for
INDIRECTand other text-built references. - Renaming a sheet that a closed external workbook links to, which leaves that workbook with a broken link.
- Trying to rename column letters; the header text or the Table column name is what is actually editable.
- Renaming a file while it is open, which leaves Excel saving back to the old name.
Frequently asked questions
How do I rename a sheet in Excel?
Double-click the sheet tab, type the new name and press Enter. Right-click ▸ Rename does the same.
Will renaming a sheet break my formulas?
No — normal references update automatically. Only text-built references such as INDIRECT("Sheet1!A1") and links from closed workbooks need fixing by hand.
Why will Excel not accept my sheet name?
It is over 31 characters, contains : \ / ? * [ or ], duplicates an existing sheet name, is blank, or is the reserved word History.
How do I rename a column in Excel?
Column letters are fixed. Edit the header text in row 1, or — inside a Table — edit the header cell, which updates every structured reference to it.
Other ways people ask this
On the way here you may have searched this as “how to change name in excel sheet” and “how to change name of excel sheet” — it is all the same task, and this page is the single, complete answer to it.
Why do people search for this in so many different ways?
Because the same task has many names. “how to change name in excel sheet”, “how to change name of excel sheet” all point at the one operation explained on this page, which is why they all lead here.