Boost Your Google Sheets Productivity with the Name Box

Google Sheets’ Name box is my favorite time saver of the year. It is situated to the left of the formula box and, by default, shows the coordinates of the current selected range.

The Name box to the left of the formula box
The Name box to the left of the formula box

You can activate the Name box by pressing Ctrl + J on Windows/Linux or ⌘ + J on Mac.

It looks deceptively simple while packing a punch when working with named and regular ranges. Let’s look at what the Name box can help you do.

Create Named Range

To create a named range via the Name box:

  1. Select the range you want to name.
  2. Click in the Name box (or use a keyboard shortcut).
  3. Type in the name of the range and press enter. Now you have created a new range.
Create a named range via the Name box
Create a named range via the Name box

The Name box makes it easy to follow best naming practices for ranges in Google Sheets.

Rename Range

To rename a named range via the Name box:

  1. Select the whole named range.
  2. The Name box will switch to displaying the current name of the range.
  3. Type in the new name and press enter.
Rename a range via the Name box
Rename a range via the Name box

Jump to Named Range

To quickly get to a named range:

  1. Click on the Name box.
  2. Start typing the name of the range.
  3. Select the range from filtered results. The range will be automatically selected.
Jump to a named range via the Name box
Jump to a named range via the Name box

Jump to Any Cell

With the Name box, you can also jump to any cell by typing its coordinates and pressing enter:

Jump to any cell via the Name box
Jump to any cell via the Name box

It is very convenient when you are dealing with large sheets.

Go to Named Ranges Panel

The Name box also gives an easier way to open the standard named ranges interface:

Access the Named ranges panel via the Name box
Access the Named ranges panel via the Name box