How to Use the Name Box in Excel & Google Sheets

range names name box

Now when you select the cells you just named, the name appears 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 the drop-down arrow to the right of the name box to see a list of all the range names.

range names list of names

Select Cells Using the Name Box

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

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

range names name box add sheet

  1. In Cell A1, click in the name box, type in a name for the cell (e.g., Begin), and press ENTER.

range names name box add name

  1. Go back to the previous sheet (here, Sheet1), click in the name box, and click Begin.

range names name box select name

This selects the range named Begin in the new sheet.

The Name Box in Google Sheets

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

  1. Highlight the cells to name, and then type in the new name in the name box.
  2. Press ENTER to create the range name.

Range Name Google Sheets Name Box

  1. 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, clicking the name Begin moves the cursor to Sheet2!A1.