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

WRAPUP 2-Soccer-Arsenal and Milan reach Europa League last 16, Napoli and PSV exit

Arsenal needed a late comeback to secure their place in the draw for the Europa League last 16 where they will be joined by Ajax Amsterdam, Manchester United, Milan and Rangers but Napoli and PSV Eindhoven crashed out on Thursday. Pierre-Em...

U.S. president, Saudi king speak ahead of expected Khashoggi report release

U.S. President Joe Biden on Thursday told Saudi King Salman he would work for bilateral ties as strong and transparent as possible, the White House said, ahead of the expected release of a sensitive U.S. intelligence report on the 2018 murd...

U.S. Senate panel sets hearing for Biden's No. 2 and No. 3 Justice Department picks

The U.S. Senate Judiciary Committee on Thursday announced it will hold a confirmation hearing on March 9 for President Joe Bidens nominees to serve in the No. 2 and No. 3 top jobs at the U.S. Justice Department. Lisa Monaco, a former federa...

US president believes it's important to modernise immigration system: WH

US President Joe Biden believes that it is important and long overdue to modernise the immigration system, and this includes taking steps to help ensure high skilled workers can stay in the country, the White House has said.Biden has revoke...

Give Feedback