Google Sheets Named Ranges

Named ranges in Google Sheets let you give a range a readable name, such as ApprovedBudget, ClientList, or StatusOptions. They make formulas easier to understand and reduce confusion when a workbook has several sheets or recurring lookup areas.

Use named ranges for important inputs, lookup tables, validation lists, and dashboard source ranges.

Create a named range

Step 1. Select the cells you want to name.

Step 2. Choose Data -> Named ranges.

Step 3. Enter a clear name.

Step 4. Click Done.

The name can then be used in formulas instead of a raw cell reference.

Example named range formula

If ApprovedBudget refers to Budget!B2:B13, you can sum it like this:

That is easier to read than a formula that points to a hidden or distant sheet tab.

Named ranges are useful in small business budgets, sales pipelines, and project trackers where summary formulas refer to important source blocks.

Use named ranges for dropdowns

Named ranges also work well for data validation lists. For example, a range named StatusOptions can feed a dropdown for Open, Blocked, Waiting, and Done.

That keeps status labels consistent across project trackers, content calendars, CRM sheets, and expense approval workflows.

Naming rules

Use names that describe the business meaning, not just the location. ClientList is better than Range1. BudgetMonths is better than Headers.

Avoid spaces. Use plain names that will still make sense when another person audits the formula.

Common named range mistakes

The Griddy way

Named ranges make sheets cleaner, but only when the names reflect how people use the workbook.

"Find the important lookup lists and summary ranges, give them clear names, and update formulas so they are easier to audit"

Griddy can identify the ranges worth naming and simplify formulas that currently depend on hard-to-read references.