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

Venezuela detects Brazilian variant of coronavirus in the country -President Maduro

Venezuelas President Nicolas Maduro on Wednesday said authorities have detected the Brazilian variant of the novel coronavirus in the country.Officials have recorded cases of the coronavirus variant in Caracas, the capital, and in two state...

U.S. calls German warship's plan to sail South China Sea support for rules-based order

The United States on Wednesday hailed plans by NATO ally Germany to sail a warship across the contested South China Sea, calling it welcome support for a rules-based international order in the region, something Washington says is threatened...

GLOBAL MARKETS-Yen near 7-month low, Asian shares fall as bond yields rise

The Japanese yen hit a seven-month low on the dollar on Thursday as hopes that vaccine distribution and more government stimulus will drive the U.S. economy into a solid rebound lifted the greenback and benchmark Treasury yields. But the cr...

Soccer-We never threw away the Cup, says proud Barca boss Koeman

Barcelona coach Ronald Koeman praised his side for their never-say-die attitude after they reached the Copa del Rey final with a 3-0 win after extra time over Sevilla on Wednesday to pull off the latest in a series of great turnarounds in t...

Give Feedback