Name a range of cells

You can name ranges in Google Sheets to keep better track of them and create cleaner formulas.

For example, instead of using "A1:B2" to describe a range of cells, you could name the range "budget_total." This way, a formula like "=SUM(A1:B2, D4:E6)" could be written as "=SUM(budget_total, quarter2)."

View range names

  1. Open a spreadsheet in the Google Sheets app.
  2. Tap More More and then Named ranges. A list of your named ranges will open.
  3. Tap a named range to see it in your sheet.
  4. To close the menu, tap Close Close.

Note: You can't add or edit named ranges on Android.

Was this helpful?
How can we improve it?
true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
Search Help Center
true
35
false
false