How to Rename a Sheet in Excel

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. Most people learn this as a sequence of clicks and forget it by next week; learning it as a pattern instead is what lets you apply it to the next, slightly different version of the problem without starting from scratch. That is the difference this page is trying to make. Treat “rename a sheet in excel” as a small repeatable workflow rather than a one-off click you hope to remember next time. Use a small test block before the live file, so any surprise in the affected sheet shows up while it is still harmless. 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. That turns a layout choice that keeps the sheet readable and sortable into a method you can reuse, explain, and defend when the workbook leaves your screen.

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: try it on a copy of the sheet or a handful of sample rows first and check the result before you apply it to the real data. That one habit catches almost every surprise while it is still cheap to reverse.

In Google Sheets

This is a command rather than a formula, so there is no syntax to carry over. Google Sheets arranges its commands in menus across the top instead of a ribbon, names some of them differently and does not have every Excel command — look for the equivalent in the Sheets menus or its help before assuming the steps match. 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 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 “rename a sheet in excel”, make it the order of checks rather than the individual clicks: confirm what is selected, apply the step, and look at the result before moving on. That small routine is what keeps Excel work predictable when the same task comes back in a slightly different workbook.

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 INDIRECT and 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