Naming a Cell Range in Google Sheets: Steps, Uses, and Tips

To name a cell range in Google Sheets, select the cells, choose Data > Named ranges, enter a name in the sidebar, and click Done. You can then use that name in formulas instead of typing the cell addresses, making a spreadsheet easier to read and maintain.

What a named range does

A named range is a label attached to a cell or rectangular group of cells. For example, instead of referring to the sales figures in B2:B13, you could name those cells MonthlySales. A formula can then use the label, which makes its purpose more apparent to someone reviewing the sheet.

Named ranges are useful when a range appears repeatedly in formulas, when a formula refers to cells on another tab, or when a workbook has a lot of data and ordinary references are hard to interpret. They do not change the underlying values, formatting, or permissions of the cells. They are a way to refer to a range, not a separate copy of the data.

A named range belongs to the spreadsheet, rather than being limited to the tab where it was created. This means a formula on one tab can use a range named on another tab without writing the tab name and cell coordinates each time. Because the name is spreadsheet-wide, it needs to be unique among the spreadsheet’s named ranges.

Name a range in Google Sheets

In Google Sheets in a web browser, create a name through the Named ranges sidebar:

Select the cells you want to label. Drag across the cells, or click the first cell and use Shift-click on the last cell to select a rectangular range.
Choose Data > Named ranges from the menu bar. A sidebar opens on the right.
Enter a name in the name field. Sheets may show the selected cell reference as the initial entry; replace it with a meaningful name that follows the naming rules.
Check the range reference in the sidebar. If it is not the cells you intended, edit the reference or reselect the correct cells.
Click Done to save the named range.

For instance, if the monthly totals are in cells B2 through B13, select B2:B13 and give the range a name such as MonthlySales. The exact range reference appears in the sidebar, so confirm the tab name and cell addresses before saving. If you later select a different cell, the named range remains available to formulas; creating it does not require moving or copying the data.

Google Sheets naming rules

Google Sheets places limits on range names so that it can distinguish them from cell references and formula syntax. Use letters, numbers, and underscores, and choose a name that starts with a letter or underscore rather than a number. Spaces are not allowed, so use an underscore or combine words, as in ProductCosts or Product_Costs.

Do not use a name that looks like a cell address, such as A1 or R1C1.
Do not use TRUE or FALSE as the name.
Avoid spaces and punctuation; a clear name made from letters, digits, and underscores is the safest choice.
Use a different name for each named range in the spreadsheet.

Names are not case-sensitive for practical use in formulas: MonthlySales and monthlysales refer to the same named range. Still, consistent capitalization makes names easier to scan. A name such as Q1_Revenue is more informative than Data1, while a very long label can become cumbersome to type and review.

Use a named range in a formula

After you save a named range, you can enter its name where a formula would otherwise use the range’s cell reference. Suppose B2:B4 contains 120, 150, and 130, and those cells are named MonthlySales. With those values in B2:B4 and the named range set to B2:B4, enter =SUM(MonthlySales) in another cell; it returns 400. The formula still calculates from the original cells.

Named ranges can also make formulas that combine several inputs easier to understand. If a range called TaxRate refers to a single cell containing 0.08, a calculation can refer to the label rather than a coordinate such as B1. The cell’s value and the formula’s purpose are then easier to identify, especially if the input is on a separate tab. Keep in mind that a name is only meaningful if its label is clear and its range points to the right place.

When typing a formula, enter the named range exactly as saved. If Sheets does not recognize it, check the spelling and whether the name exists in the Named ranges sidebar. You can also use the name in formulas on other tabs in the same spreadsheet. A name does not automatically make a formula dynamic: if the source data grows, check whether the named range includes the new rows.

View, edit, or delete a named range

To inspect existing names, open Data > Named ranges. The sidebar lists the names and their associated ranges. Select a listed name to edit its label or change the range reference, then save the change with Done. This is also a practical way to check which cells a formula’s name currently represents.

To remove a name, open the same sidebar, select the named range, and use the delete or trash control shown for that entry. Deleting a name does not delete the cells or their contents, but formulas that depend on that name can stop working until you replace the name with a valid reference or create the name again. Before removing one, search or review formulas that may use it, especially in a shared spreadsheet.

If the goal is to use a different set of cells, editing the range reference is usually preferable to deleting and recreating the name. This preserves the label for formulas that already use it. After changing the reference, review important results because the formulas may now include different data.

Choose names and ranges that stay useful

Good names describe what the cells contain or how they are used. Names such as CustomerIDs, HourlyRates, and QuarterlyRevenue give a reader useful context. Avoid labels tied only to a temporary position, such as BlueCells or ColumnB, unless that is genuinely what the range represents.

Choose a range size that matches the job. A range limited to B2:B13 is precise when a report should include exactly twelve months. If you expect to append new records, consider whether the range needs to be updated as the table grows. Sheets does not automatically turn every named range into an expanding table just because data is added below it. After inserting rows or changing a layout, inspect the range in the sidebar and check formulas that depend on it.

For a single input, naming one cell can be helpful when it is an important assumption, such as a discount rate or report date. For a large table, naming every small block may create more labels to manage than the spreadsheet needs. Prioritize repeated formula inputs, key totals, and ranges whose meaning is otherwise difficult to see.

Named ranges compared with cell references and Excel

A direct reference such as B2:B13 is compact and perfectly suitable for a short formula used once. A named range is more descriptive, but it requires setup and ongoing care. In a small sheet with few formulas, ordinary cell references may be simpler. In a larger model with repeated calculations, meaningful names can make formulas easier for colleagues to audit.

Google Sheets also has a name box near the formula bar that helps you navigate to a cell or range. It is useful for jumping to an address or existing named range, but the standard way to create and manage named ranges is Data > Named ranges. A name is not the same as a filter, a protected range, or a tab name: it does not hide data, prevent edits, or change the spreadsheet’s structure.

Excel also supports named ranges, but the menus and some scope behavior differ. In Excel for Microsoft 365 on Windows, names are managed from Formulas > Name Manager, and Excel can have workbook-scoped or worksheet-scoped names. Google Sheets manages named ranges from its Data menu and makes them available across the spreadsheet. If you move data between the programs, check named ranges and formulas rather than assuming their management rules are identical.

Common problems and how to fix them

If Sheets rejects a name, check for spaces, punctuation, an initial number, or a label that resembles a cell reference. Replacing spaces with underscores and starting with a letter usually resolves common naming errors. If the name already exists, choose a distinct label or update the existing range instead.

If a formula reports an unknown name or an error, confirm that the range was saved, that the spelling is exact, and that the name has not been deleted or changed. Open Data > Named ranges to verify both the name and its cell reference. Also check that the formula is in the same spreadsheet; a named range in one spreadsheet is not automatically available in another.

If a formula calculates but returns an unexpected value, the name may point to the wrong tab or omit rows. This can happen after a layout change or when new records are appended beyond the original range. Inspect the sidebar’s range reference, compare it with the data you intended to include, then correct it and verify the formula result. Naming a range improves readability, but it does not validate the data or guarantee that the selected cells are appropriate.

Frequently Asked Questions

Can I name a single cell in Google Sheets?
Yes. Select the cell and use Data > Named ranges just as you would for a larger selection. A single-cell name is useful for a key input that appears in multiple formulas.

Can I use spaces in a named range?
No. Use letters, numbers, and underscores instead. For example, name a range AnnualBudget or Annual_Budget, not “Annual Budget.”

Can I use a named range on another tab?
Yes. Named ranges are available throughout the same Google Sheets spreadsheet. Use the name in a formula on a different tab without creating a separate copy of the range.

Does a named range expand when I add rows?
Do not assume it will include newly added data. Check the range in the Named ranges sidebar after adding rows, and adjust the reference if the new cells should be included.

Will deleting a named range delete its cells?
No. Deleting the name removes the label, not the underlying data. However, formulas that used the name may break, so update those formulas or restore the name if needed.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.