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 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 .

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