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

Vatican Iraq envoy tests positive for COVID but says pope's trip is on

The Vatican ambassador to Iraq, the point man for Pope Francis trip to the country next week, has tested positive for COVID-19 but the visit will go ahead, he said on Saturday. Archbishop Mitja Leskovar, who has been the key person planning...

Myanmar's U.N. ambassador vows to fight after junta fired him

Myanmars United Nations envoy in New York vowed to fight on Saturday after the junta fired him for urging countries to use any means necessary to reverse a Feb. 1 coup that ousted the nations elected leader Aung San Suu Kyi.I decided to fig...

Dominican Republic to construct fence along border with Haiti

The Dominican Republic will begin constructing a fence along its 376-kilometer 234 mi border with Haiti later this year to curb unauthorized migration and illicit trade, President Luis Abinader said on Saturday. In a period of two years, we...

Saudi Arabia says it intercepts missile attack over capital

Saudi Arabia said Saturday it intercepted a missile attack over its capital and bomb-laden drones targeting a southern province, the latest in a series of airborne assaults it has blamed on Yemens rebel Houthis.The Saudi-led military coalit...

Give Feedback