The new range name box improves navigation in Google Sheets

Google has introduced a new range name box to improve navigation in Sheets. Located to the left of the formula bar, it can be used to jump directly to named coordinates and ranges in Google Sheets.

You can name ranges to keep track of them and create cleaner formulas. For example, instead of using “A1: B2” to describe a range of cells, users might name the range “budget_total”. In this way, a formula like “= SUM (A1: B2, D4: E6)” could be written as “= SUM (budget_total, quarter2)”.

Also, the new range name box provides a drop-down menu to easily access and manage the creation of new named ranges in the sheet.

Previously, active cells were indicated only by a blue outline and could be found by scrolling or using the arrow keys.

The range name box in Google Sheets will be available for Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard and Enterprise Plus, as well as for G Suite Basic, Business, Education, Enterprise for Education, Nonprofits customers and users with personal Google accounts.

The new functionality has been fully rolled out to fast release domains, while the phased rollout of scheduled release domains will begin on January 25.

News Highlights:

  • The range name box in Google Sheets will be available for Google Workspace Essentials, Business Starter, Business Standard, Business Plus, Enterprise Essentials, Enterprise Standard and Enterprise Plus, as well as for G Suite Basic, Business, Education, Enterprise for Education, Nonprofits customers and users with personal Google accounts.
  • The new range name box improves navigation in Google Sheets