How to Rename a Cell 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. The difference between a quick fix and a sheet you can trust is the extra minute you spend validating “rename a cell in excel”. 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 layout choice that keeps the sheet readable and sortable, 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. If this is something you do often, add the command to the Quick Access Toolbar (right-click it on the ribbon and choose Add to Quick Access Toolbar) or learn its shortcut, so next time it is one click instead of a hunt through the menus.

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. Keep this page bookmarked for the next time the same question comes up. Better still, repeat the steps once in your own workbook — doing it yourself is what turns a copied answer into something you remember. Here is the takeaway for “rename a cell in excel”: follow the steps at the top, check the result on the sheet itself, and keep undo in mind while you experiment. Done once deliberately, it becomes something you do from memory in Excel rather than something you search for again.

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