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

Addressing conflict-related sexual violence at long last

... ...

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

Cong protests at U'khand Assembly holding sugarcanes

The Congress Party under the leadership of state chief and Chakrata MLA Pritam Singh on Friday protested holding sugarcanes outside Uttarakhand Assembly. The protest was against Trivendra Singh Rawat-led BJP governments demanding an increas...

Correction in prices makes Delhi's luxury residential properties attractive: HDFC

Luxury residential properties in the national capital have become attractive because of correction in prices, a temporary cut in circle rates by 20 per cent and lower interest rates, HDFC MD Renu Sud Karnad said on Friday.Homebuyers are act...

Pope Francis lands in Baghdad on first-ever papal visit

Pope Francis landed in Baghdad on Friday to start a historic four-day visit to Iraq, the first-ever papal visit to the country.Franciss plane touched down at Baghdad International Airport, Reuters reporters said....

Red Cross says volunteers hurt in Myanmar, urges halt to violence

Red Cross volunteers have been injured while helping people hurt in violence in Myanmar, where security forces are cracking down on pro-democracy protests, the International Federation of Red Cross and Red Crescent Societies said on Friday....

Give Feedback