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
- Open a spreadsheet in the Google Sheets app.
- Tap More Named ranges. A list of your named ranges will open.
- Tap a named range to see it in your sheet.
- To close the menu, tap Close .
Note: You can't add or edit named ranges on Android.