How to Rename a Cell in Excel: A Complete Guide

How-to basics · Updated November 22, 2026

To rename a cell in Excel, you use the Name Box (located to the left of the formula bar) to assign a custom name, or you use the Define Name dialog. There is no built-in way to change the cell’s default address (like A1), but you can give it a meaningful, human-readable name that works in formulas and navigation.

What “Renaming a Cell” Actually Means in Excel

In Excel, every cell has a fixed address based on its column letter and row number, such as B4 or F12. You cannot change that address—it is the cell’s physical location. However, Excel lets you assign a defined name to a single cell, a range, a formula, or a constant. This name acts as an alias. For example, instead of writing =B4*C4, you could write =Price*Quantity if you named B4 “Price” and C4 “Quantity”. The name does not replace the address; it simply provides a more intuitive reference.

How to Rename a Cell Using the Name Box (Fastest Method)

The Name Box is the small text field at the left end of the formula bar. Here are the steps:

  1. Click the cell you want to name.
  2. Click directly inside the Name Box (it currently shows the cell address, e.g., B4).
  3. Type the name you want, for example Price.
  4. Press Enter on your keyboard. The name is now assigned.

On a Mac, the Name Box is in the same location (left of the formula bar) and the steps are identical. In Excel for the web, the Name Box exists but is smaller; you can still click it, type a name, and press Enter.

How to Rename a Cell Using the Define Name Dialog

If you want more options (like a comment or a scope), use the Define Name dialog:

  1. Select the cell or range.
  2. Go to the Formulas tab.
  3. Click Define Name (in the Defined Names group).
  4. In the dialog, type a name in the “Name” field.
  5. Check the “Refers to” box to confirm the correct cell reference (e.g., =Sheet1!$B$4).
  6. Set the “Scope” to either the entire workbook or a specific sheet (see below).
  7. Click OK.

On Mac, the path is Formulas > Define Name as well. In Excel for the web, you can also use the Formulas tab, but the dialog is slightly simplified.

Naming Rules and Best Practices

Excel enforces strict rules for names. If you violate them, you’ll get an error. The rules are:

  • Names must begin with a letter, an underscore (_), or a backslash (\).
  • After the first character, you can use letters, numbers, periods, and underscores.
  • Spaces are not allowed. Use an underscore or a period instead (e.g., Unit_Price or Unit.Price).
  • Names cannot look like cell references (e.g., B4 is invalid, but B4_Value is fine).
  • Names are case-insensitive, but Excel preserves the case you type. So Price and price refer to the same name.
  • Maximum length is 255 characters, but keep them short for readability.

A common misconception is that you can rename a cell to something like “MyCell” and then type =MyCell in another cell to get its value. That actually works—it is the whole point of defined names. However, if you type a name that does not exist, Excel will show a #NAME? error.

Using Named Cells in Formulas and Navigation

Once a cell is named, you can use the name directly in formulas. For example, if you name cell B4 as Price and cell C4 as Quantity, you can write:

With Price in B4 and Quantity in C4, put this formula in D4:

=Price*Quantity

That returns the product. If Price is 10 and Quantity is 5, the result is 50.

Names also help with navigation: click the drop-down arrow in the Name Box, and you’ll see a list of all defined names. Click one to jump to that cell or range instantly.

How to Rename or Delete an Existing Named Cell

If you want to change the name of a cell you already named, you cannot simply “rename” it in place—you must delete the old name and create a new one. Here’s how:

  1. Go to the Formulas tab.
  2. Click Name Manager (in the Defined Names group).
  3. In the Name Manager dialog, select the name you want to change.
  4. Click Edit to change the name or the reference, or click Delete to remove it entirely.
  5. If you delete, you’ll need to create a new name using the Name Box or Define Name dialog.

On Mac, the Name Manager is under Formulas > Name Manager. In Excel for the web, the Name Manager is also available under the Formulas tab, but it has fewer features (you can edit and delete, but not filter).

Be careful: if you delete a name that is used in formulas, those formulas will return #NAME? errors until you fix them.

Scope: Workbook-Level vs Sheet-Level Names

When you create a name, you can choose its scope. The scope determines where the name is recognized:

  • Workbook scope: The name is available on every sheet in the workbook. This is the default when you use the Name Box.
  • Sheet scope: The name is only available on the specific sheet where it was defined. Use this if you have the same name on different sheets (e.g., Price on Sheet1 and Price on Sheet2).

To set the scope, you must use the Define Name dialog (not the Name Box). In the dialog, choose “Workbook” or a specific sheet from the “Scope” drop-down. The Name Box always creates workbook-scoped names.

Common Problems and How to Fix Them

Here are frequent issues people run into when naming cells:

  • “Enter a valid reference” error: This usually means the name you typed is invalid (e.g., contains a space or starts with a number). Check the rules above.
  • Name already exists: If you try to create a name that already exists in the same scope, Excel will ask if you want to replace it. Be careful—replacing a name can break formulas that used the old reference.
  • Name not recognized in formulas: If you type a name in a formula and get #NAME?, make sure the name is spelled exactly and that it exists in the current scope. Also, if you used the Name Box, the name is workbook-scoped, so it should work everywhere.
  • Can’t see the Name Box: On some laptops, the Name Box may be hidden if the ribbon is collapsed. Click the small arrow at the bottom-right of the ribbon to expand it, or press Ctrl+F1 (Windows) or Cmd+Option+R (Mac) to toggle the ribbon.

Frequently Asked Questions

Can I rename a cell to a number like “123”?

No. Names must start with a letter, underscore, or backslash. Numbers are allowed after the first character, so Price_2024 is fine, but 123 is not.

What is the difference between a cell name and a cell comment?

A cell name is a defined name used for references in formulas and navigation. A cell comment (now called a “note” in newer Excel versions) is a text annotation attached to a cell, visible when you hover over the red triangle. They serve completely different purposes.

Does renaming a cell change its address in formulas?

No. The address (like B4) remains the same. The name is an additional alias. If you reference the cell by its address, it still works. If you reference it by name, it also works. The underlying address never changes.

Can I use a named cell in a chart series?

Yes. In chart data ranges, you can use defined names. For example, in the “Edit Series” dialog, you can enter a name like =Sheet1!Price as the series name or values. This is useful for dynamic charts.

Why does my name disappear when I save and reopen the workbook?

Names are saved with the workbook, so they should not disappear. If they do, you might have saved as a different file type (like CSV) that does not support names, or the name was defined in a different scope. Check the Name Manager after reopening.

Is there a keyboard shortcut to open the Name Manager?

Yes. On Windows, press Ctrl+F3. On Mac, press Control+Option+F3 (or use the Formulas tab). This opens the Name Manager directly.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.