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?