How to Use the Name Box in Excel & Google Sheets

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on July 27, 2023

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

range names name box

Create a Range Name Using the Name Box

  1. To create a named range, highlight the cells that you want to name (e.g., C5:C7).

Range Names Select Cells

  1. Click in the box in the top-left corner of the screen. It shows the current cell address: for example, C5. This box is known as the name box.
  2. Type in text to replace the cell address with a name and press ENTER. In this example, the new name is January.

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.

RangeNames NameBox Googlesheets SelectName

AI Formula Generator

Try for Free

See all How-To Articles