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

Biden marks Selma anniversary with order to expand voting access

U.S. President Joe Biden will sign an executive order on Sunday designed to make it easier for Americans to vote, White House officials said, as Republicans across the country seek to limit voting rights in the wake of the 2020 election.Bid...

'A side of shares': Deliveroo to offer 50 million pounds of stock to customers

Deliveroo said shares worth 50 million pounds 69 million would be earmarked for customers in its upcoming flotation, with the offer branded Great food with a side of shares. The Amazon-backed food delivery firm announced plans on Thursday t...

Reopening England's schools is step towards normality, PM Johnson says

The reopening of Englands schools to all pupils on Monday will mark the first step back towards normality, and is only possible because of the efforts of the public to bring COVID-19 infection rates down, British Prime Minister Boris Johnso...

Meghan and Harry to lift lid on royal split in Oprah interview

A highly anticipated Oprah Winfrey interview with Prince Harry and his wife Meghan airs on U.S. television later on Sunday, amid what one royal watcher called a toxic atmosphere between the couple and the British monarchy.Not since the late...

Give Feedback