Select Name Box: What It Is & How to Use It

The Name Box in Excel (and Google Sheets) is the small box to the left of the formula bar. It shows the address of the selected cell (like A1) or the name of the selected range, and you can type into it to jump to a cell or create a named range. This article explains exactly what the Name Box does, how to use it, and how to fix common problems.

What Is the Name Box?

The Name Box sits at the left end of the Formula Bar in Microsoft Excel and Google Sheets. It normally displays the reference of the active cell—for example, B7 or Sheet2!A1. When you select a named range, it shows that name instead. The Name Box is not just a readout; it is an interactive field. You can click into it, type a cell address or a range name, and press Enter to jump to that location. It is also the fastest way to create a named range: type a name, press Enter, and the selected cells are named instantly.

How to Use the Name Box

You can do three main things with the Name Box. First, jump to a cell or range: click in the box, type a reference like Z100 or A1:C50, and press Enter. Second, create a named range: select the cells you want to name, click in the Name Box, type a name (no spaces, no cell-like references), and press Enter. Third, select a named range: click the drop-down arrow to the right of the Name Box to see all defined names, then click one to select that range. The drop-down only appears when there is at least one named range in the workbook. In Google Sheets, the Name Box is called the “Name Box” as well, and it works the same way, though the drop-down list is less prominent.

How to Choose a Good Name

When naming a range, follow these rules:

• Names must begin with a letter, an underscore (_), or a backslash (\)—not a number.
• After the first character, you can use letters, numbers, periods, and underscores.
• Spaces are not allowed. Use an underscore or a period instead, like Sales_2024 or Q1.Total.
• Names cannot look like a cell reference (e.g., A1 or R2C2 are invalid).
• Names are not case-sensitive in Excel, but they are stored with the case you type.
• You cannot use the word TRUE or FALSE as a name.

Good names are short, descriptive, and easy to remember. For example, TaxRate or ProductList. Avoid vague names like Range1 that do not tell you what the range contains.

Common Problems and Fixes

The most common issue is that the Name Box is hidden. In Excel, if you do not see the Name Box, it is usually because the Formula Bar is hidden. Go to the View tab and check the Formula Bar checkbox. In Google Sheets, the Name Box is always visible, but if the Formula Bar is hidden, you can show it via View > Show > Formula bar. Another frequent problem: you type a name and press Enter, but nothing happens. This usually means the name is invalid (contains a space or looks like a cell reference) or the name already exists. Excel will show an error message; Google Sheets may silently reject it. Also, if you type a cell reference and press Enter, the selection moves to that cell, but the Name Box may still show the old address until you click elsewhere.

Name Box vs. Defined Names

The Name Box is the entry point, but defined names are the feature behind it. A defined name is a label you assign to a cell, range, formula, or constant. Once defined, you can use the name in formulas instead of cell references. For example, if you name A1:A10 Sales, you can write =SUM(Sales) instead of =SUM(A1:A10). Names make formulas easier to read and maintain. The Name Box is just a shortcut for creating and selecting these names. You can also manage names through the Formulas tab in Excel (Name Manager) or the Data > Named ranges menu in Google Sheets.

Alternatives to the Name Box

If you do not want to use the Name Box, there are other ways to navigate and name ranges. To jump to a cell, you can press Ctrl+G (or F5) to open the Go To dialog, type the address, and press Enter. To create a named range, you can use the Define Name dialog (Excel) or the Named ranges pane (Google Sheets). For selecting a range, you can also use the Name Manager in Excel, which lists all names and lets you click Go To. In Google Sheets, the Named ranges panel shows a list and you can click a name to select it. These alternatives are useful when you need to edit or delete names, which the Name Box cannot do.

Frequently Asked Questions

Why is my Name Box not showing the cell address?

If the Name Box shows a name instead of a cell address, it means the active cell is part of a named range. Click on a cell outside any named range to see its address. If the Name Box is completely empty, check that the Formula Bar is visible. In Excel, go to View and tick Formula Bar. In Google Sheets, go to View > Show > Formula bar.

Can I use the Name Box to jump to a cell on another sheet?

Yes. Type the sheet name followed by an exclamation mark and the cell address, like Sheet2!A1. If the sheet name contains spaces, enclose it in single quotes, like 'My Sheet'!A1. Press Enter and Excel or Sheets will take you to that cell.

How do I delete a named range using the Name Box?

You cannot delete a name from the Name Box. Use the Name Manager in Excel (Formulas tab) or the Named ranges panel in Google Sheets (Data menu). Select the name and click Delete. The Name Box only lets you create and select names, not edit or delete them.

Why can’t I type a name with a space in the Name Box?

Spaces are not allowed in defined names because they would make formula references ambiguous. Use an underscore or a period instead. For example, use Q1_Total or Q1.Total. If you type a name with a space, Excel will show an error, and Google Sheets will ignore it.

Does the Name Box work in Google Sheets?

Yes. Google Sheets has a Name Box in the same position, left of the formula bar. It shows the cell reference or named range, and you can type a cell address to jump to it. To create a named range, select the cells, type the name in the Name Box, and press Enter. The drop-down arrow shows a list of named ranges.

Can I use the Name Box to select multiple non-adjacent cells?

Yes. Type a comma-separated list of references, such as A1:A5,C1:C5, and press Enter. Excel will select both ranges. Google Sheets also supports this. You can also combine named ranges and cell references, like Sales,C1:C5.

Related

• OnePlus Buds Z2 ANC Flash Charge India Launch
• Buffer Queue Timing & Limits: Schedule X Posts
• Can You Safely Run Liquid Through an FDM 3D Print?

in t | Finish time | min | 50 | 0
in d | Distance | km | 10 | 0
out pace | Average pace | min/km | t / d | 2
out speed | Average speed | km/h | d / (t / 60) | 2