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

Released Senegal opposition leader calls for more protests

Senegal opposition leader Ousmane Sonko called on Monday for more protests against President Macky Sall after being indicted and released on bail over a rape charge that has sparked violent unrest across the country. Sonkos release was chee...

Lebanese army fires at Israeli drone flying over Meiss Ej Jabal -Al-Manar TV

The Lebanese army fired at an Israeli drone flying over its station in Meiss Ej Jabal, Lebanese Hezbollahs Al-Manar TV said late on Monday.Israeli forces fired flares at the border with Lebanon, near Meiss Ej Jabal, but no injuries were con...

Biden grants temporary protected status to Venezuelans in U.S. -officials

The Biden administration is granting temporary protected status to Venezuelan migrants living in the United States and is also working to coordinate international pressure against Venezuelan President Nicolas Maduro to hold free and fair el...

GLOBAL MARKETS-Stocks dip as yields hold near one-year high

A gauge of global stocks dipped in choppy trading on Monday as investors eyed the yield on U.S. Treasuries for signs of inflation pressures in the wake of the U.S. Senates passage of a 1.9 trillion stimulus bill.After climbing as high as 1....

Give Feedback