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

TMC writes to Rajya Sabha Chairman seeking adjournment of Parliament session in wake of assembly polls in several states.

TMC writes to Rajya Sabha Chairman seeking adjournment of Parliament session in wake of assembly polls in several states....

Over 2.8 million entries made in Delhi Police e-Beat Book

As part of its efforts to handle crime, criminals, maintenance of law and order, and deliver other citizen-centric services, over 2.8 million data entries have been uploaded on the Delhi Polices e-Beat Book server, a critical project and di...

Meghan Markle, Prince Harry reveal second baby's gender in Oprah Winfrey interview

Meghan Markle and Prince Harry are set to become proud parents to a little girl The couple revealed the gender of their second child during their interview with American talk show host Oprah Winfrey on Sunday. As per E News, the Duke and Du...

International Women's Day: PM Modi salutes 'Nari Shakti', says India takes pride in accomplishments of women

On the occasion of International Womens Day, Prime Minister Narendra Modi said India takes pride in the many accomplishments of the women of the nation and added it is his Governments honour to be getting the opportunity to work towards fur...

Give Feedback