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

Hungary extends lockdown, sees 'exceptionally difficult' two weeks ahead as infections rise

The government in Hungary has decided to extend a partial lockdown until March 15 as coronavirus infections are expected to rise further in the next two weeks, Prime Minister Viktor Orbans chief of staff said on Thursday.Gergely Gulyas also...

Malaysia's AirAsia Group postpones Q4 results to end-March

Malaysian budget carrier AirAsia Group Bhd has postponed its fourth-quarter earnings release by about a month, just as its shuttered Japan unit commences bankruptcy proceedings.The airline confirmed that it has delayed the results announcem...

CEAT Specialty presents Indian Tractor of the Year (ITOTY) Awards 2021

Tractor Junction, Indias leading digital Marketplace for Tractors and Farm equipment, announced its plans to host an online edition of its much-awaited ITOTY Awards. Speaking on occasion, Mr. Rajat Gupta, the Founder of Tractor Junction, sa...

Arjun Rampal shares appreciation post for his 'Dhaakad' team

Bollywood actor Arjun Rampal on Thursday shared an appreciation post for the team of his upcoming film Dhaakad while announcing the conclusion of the current shooting schedule of the film. The Daddy actor took to his Instagram account and s...

Give Feedback