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

Death toll from explosions in Equatorial Guinea rises to 98

The death toll from a series of explosions at a military barracks in Equatorial Guinea rose by dozens to at least 98 killed after more bodies were recovered, the government said Tuesday. The blasts on Sunday in the Mondong Nkuantoma neighbo...

Dr. Narayan Hulse's Book on Joint Replacement Unveiled by Shri Tejasvi Surya

The book aims to address various concerns pertaining to joint replacements Bengaluru, Karnataka, India NewsVoir A book authored by Dr. Narayan Hulse- Director - Department of Orthopedics Joint Replacement at Fortis Hospital, Bannerghatta R...

Intranasal COVID vaccine candidate in early clinical stage of development in India: Govt

An intranasal vaccine candidate BBV154, being developed by Bharat Biotech, is in early clinical stage of development in India, Minister of State for Health Ashwini Choubey told the Rajya Sabha on Tuesday.Choubey was responding to a question...

Kremlin says Italian Sputnik V vaccine production plans will help sate foreign demand

Kremlin spokesman Dmitry Peskov said on Tuesday that plans to produce Russias Sputnik V vaccine against COVID-19 in Italy would help quickly satisfy the demand for the shot abroad. Peskovs comments come after the Moscow-based RDIF sovereign...

Give Feedback