New range name box improves navigation in Google Sheets

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

Devdiscourse News Desk | California | Updated: 20-01-2021 07:12 IST | Created: 20-01-2021 07:12 IST
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 coordinates and named ranges in Google Sheets.

Ranges can be named to keep better track of them and create cleaner formulas. For instance, instead of using "A1:B2" to describe a range of cells, users could name the range "budget_total." This way, a formula like "=SUM(A1:B2, D4:E6)" could be written as "=SUM(budget_total, quarter2)."

Additionally, the new range name box provides a dropdown menu to easily access and manage to create new named ranges in the sheet.

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

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

The new feature is fully rolling out to Rapid Release domains while the gradual rollout for Scheduled Release domains will commence on January 25.


TRENDING

OPINION / BLOG / INTERVIEW

Why unequal access to coronavirus vaccines is a threat to us all

... ...

India’s love affair with fossil fuels: the path to sustainable development?

... ...

Videos

Latest News

Odd News Roundup; German woman becomes TikTok fitness star; Pakistan police pop their rollerblades on to catch Karachi's criminals and more

Following is a summary of current odd news briefs.Pakistan police pop their rollerblades on to catch Karachis criminalsPolice in Pakistans largest city, Karachi, are deploying an armed rollerblading unit to curb theft and harassment on its ...

COVID-19 cases slow in Americas, but vaccine impact on virus to take months -PAHO

COVID-19 cases and deaths in the United States fell by 30 in the last week and were declining in most South American nations, but vaccines will take months to have an impact on the virus, the Pan American Health Organization PAHO said on We...

Entertainment News Roundup: Cat-and-mouse hijinks return in new 'Tom & Jerry' movie; Top Amazon India executive questioned by police over video series and more

Following is a summary of current entertainment news briefs.French actor Depardieu strongly contests rape charges lawyerFrench actor Gerard Depardieu strongly contests rape and sexual assault charges leveled against him, his lawyer said on ...

People News Roundup: Tiger Woods awake and responsive after crash; Beat poet Lawrence Ferlinghetti dies at age 101 and more

Following is a summary of current people news briefs.French actor Depardieu strongly contests rape charges lawyerFrench actor Gerard Depardieu strongly contests rape and sexual assault charges leveled against him, his lawyer said on Wednesd...

Give Feedback