How to Rename an Excel File

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. Before you run it on a workbook other people depend on, try it on a copy or a few rows first. Undo only reaches back through the current session, so a quick trial run is the cheapest way to see exactly what will change before the file is saved and shared. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “rename an excel file”. Start on a copy or a tiny sample, keep the affected cells 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 data step that keeps your analysis trustworthy, 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: 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. The short version of “rename an excel file”: the answer is at the top of this page, and the sections above explain why each step matters, so a variation of the problem does not stump you. Try it once on a copy of a real file and the steps stick far better than re-reading them.

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