See all How-To Articles

How to Use the Name Box in Excel & Google Sheets

This tutorial will demonstrate how to use the name box in Excel and Google Sheets.

 

Range Names NameBox

 

Create a Range Name Using the Name Box

1. To create a named range, highlight the cells that you want to name: for example, C5:C7.

 

Range Names Select Cells

 

2. Click in the box in the top left-hand corner of the screen. It will show the current cell address: for example, C5. This box is known as the name box.

3. Type in text to replace the cell address with a name and press Enter. In this example, the new name is January.

 

Range Names NameBox

 

Now when you select the cells you just named, the name will appear in the name box.

View Named Ranges Using the Name Box

You can use the name box in Excel to view all the named ranges in the workbook.

Click on the drop-down arrow to the right of the name box to see a list of all the range names.

 

Range Names ListOfNames

 

Select Cells Using the Name Box

You can use the name box to jump to specific named cells or ranges of cells by selecting the named range in the name box.

1. Click the New sheet button in Excel to create a new sheet.

 

Range Names NameBox AddSheet

 

2. In Cell A1, click in the Name Box, type a name for the cell (e.g., Begin), and press Enter.

 

Range Names NameBox AddName

 

3. Go back to the previous sheet (in this example, Sheet1), click in the name box, and select Begin.

 

Range Names NameBox SelectName

 

Excel will select the named range Begin in the new sheet.

How to Use the Name Box in Google Sheets

You can create a range name in Google Sheets using the name box, just as in Excel.

Highlight the cells to name, then type the new name in the name box. Press Enter to create the range name.

 

Range Name Google Sheets Name Box

 

To view all the range names in the Google sheet, click the drop-down arrow to the right of the name box.

 

Range Names Google Sheets DropDownList

 

As in Excel, you can use the name box to navigate to a range name.

 

Range Names NameBox GoogleSheets

 

Here, selecting the name Begin moves the cursor to Sheet2!A1.

 

RangeNames NameBox Googlesheets SelectName