Google Sheets Named Ranges: View, Create, and Manage

How-to basics · Updated November 21, 2026

To see the named range list in Google Sheets, open the spreadsheet and choose Data > Named ranges. A sidebar displays the named ranges and their cell references; select an entry to inspect or change it, or use the controls beside it to edit or remove it.

What the named range list shows

A named range gives a cell or group of cells a readable label. Instead of referring to a block only by coordinates such as Orders!A2:A100, you might call it OrderDates. The Named ranges sidebar is the built-in place to review those labels and the ranges they point to in the current spreadsheet.

This is useful when you inherit a workbook, return to a project after a break, or need to check which cells a formula uses. For example, a list might show TaxRate beside Settings!B4 and QuarterSales beside Sales!B2:E20. The names do not change the underlying values; they make references easier to understand and maintain.

The sidebar is a management view, not a new worksheet tab. It does not automatically put a printable inventory into cells, and Google Sheets does not provide a standard worksheet formula that spills every named range and its address into a table. If you need a report you can sort, share, or print, you can copy the details manually or use Apps Script to retrieve named-range information.

How to open and use the list

  1. Open the Google Sheets file in a web browser and make sure you have access to it.
  2. Choose Data > Named ranges from the menu.
  3. Review the names and range references shown in the sidebar. Select a name or its reference when you need to inspect or navigate to that part of the sheet.
  4. Use the edit or remove control for an entry if you need to update it. Check dependent formulas before removing a name.

If the sidebar is already open, you do not need to reopen it to inspect another entry. If you cannot see the menu item, confirm that the file has finished loading and that you are in Google Sheets rather than viewing a downloaded Excel file in another program. The exact appearance of the sidebar can change as Google updates its interface, but the menu path is the dependable starting point.

Create a named range

To add an entry to the list, select the cells first, then choose Data > Named ranges. In the sidebar, choose the option to add a range, enter a name, confirm the cell reference, and save. You can also open the sidebar and enter the reference there when setting up the name. Verify both the name and the range before saving; a well-named range pointing at the wrong cells can make formulas misleading.

Suppose monthly sales figures are in Sales!B2:B13. You could name those cells MonthlySales. A formula that totals them can then be written as =SUM(MonthlySales). The name gives the formula context that a bare coordinate does not. For a small file, ordinary cell references may be perfectly clear; named ranges become more helpful when the same input is used in several formulas or when a workbook has many tabs.

Google Sheets applies naming rules, so a descriptive phrase cannot always be entered exactly as written in ordinary text. A range name can use letters, numbers, and underscores, but cannot contain spaces or punctuation, cannot begin with a number, and cannot be a cell reference such as A1. For example, Annual Budget is not a valid name; Annual_Budget is. Choose a name that is short enough to use comfortably and specific enough to distinguish it from other inputs.

Read range references correctly

The reference in the list tells you where the named range points. A reference such as Inputs!B2 identifies one cell on the Inputs tab, while Inputs!B2:B8 identifies a vertical block. A rectangular range can cover more than one column, such as Sales!B2:E20. The sheet name matters: B2:B8 by itself is less informative than a reference that identifies the tab.

Sheet names containing spaces or certain characters may appear in a reference with single quotation marks, for example 'Quarter 1'!A2:C12. Those marks are part of the reference syntax, not part of the tab name. If a range appears to point to an unexpected place, compare the tab name and the coordinates, then inspect the actual cells rather than relying only on the label.

A named range is not a copy of the cells. It refers to cells in the spreadsheet, so changing a value inside the range changes what formulas using that range calculate. Structural edits, such as inserting or deleting rows, can also affect references. After reorganizing a sheet, inspect important names and formulas to confirm they still describe the intended data.

Edit, rename, or delete an entry

Open Data > Named ranges and use the sidebar controls to edit an existing entry. Editing can mean changing the label, changing the reference, or both. For example, if a list of product codes grows from rows 2–50 to rows 2–80, update the range so formulas that use the name include the new rows. If the data has moved to a different tab, update the sheet reference as well.

Renaming a range can make a workbook clearer, but treat the change as a maintenance task. Review formulas that depend on the old name and check for errors after saving. References inside the same spreadsheet may be adjusted by Sheets when a named range is renamed, but copied text, notes, external files, or instructions do not update themselves. If other people use the workbook, tell them about a name change that affects their workflow.

Deleting a named range removes the label, not the cells or their contents. Any formula that depends on the deleted name may stop working or show an error, so search for its use or test key calculations before removing it. If you only want to stop using a name in one formula, replace that formula’s reference rather than deleting a range that other formulas might still need.

Use names in formulas and understand the limits

Named ranges are most valuable when they make formulas easier to interpret or reuse. For instance, a tax calculation might use a named cell such as TaxRate rather than repeating a reference like Settings!B4 in multiple formulas. A summary can use =SUM(QuarterSales) to communicate the purpose of the calculation more clearly than a formula containing only coordinates.

Names do not replace good range design. If a named range stops at row 20, adding data in row 21 does not necessarily mean the name now covers that row. Check the reference shown in the sidebar when a formula leaves out new records. A range that is too broad can be just as confusing: including headers, notes, or totals in a block intended for numeric data may affect calculations.

  • Use a name for important inputs reused in multiple places, such as an exchange rate or reporting period.
  • Use a clear range name for a dataset that appears in many formulas.
  • Keep ordinary cell references when a formula is short and the location is obvious.
  • Review names after moving or expanding data, and test formulas that rely on them.

Named ranges are not the same thing as named functions. A named range points to cells; a named function is a separately defined custom function. If you are looking for an inventory of names, the Named ranges sidebar is the relevant feature.

Make a reusable inventory of names

For a quick check, the sidebar is usually enough. If you need a documented list, create a sheet with columns such as Name, Range reference, and Purpose. Record each entry from the sidebar and add a short explanation for names whose meaning would not be obvious to a colleague. This manual inventory is simple, but it can become outdated when someone edits the names later.

For a regularly refreshed inventory, Google Apps Script can read the spreadsheet’s named ranges through its spreadsheet service and write their names and associated range details to a worksheet. That is an automation option rather than a built-in Sheets list formula; it requires authorization and should be maintained if the spreadsheet structure changes. Before running a script that writes to a sheet, choose a destination that will not overwrite useful data and make a copy if the workbook is important.

When reviewing or documenting a shared spreadsheet, include the tab name in the address and note whether a range includes a header row. A label such as CustomerData does not reveal whether the first row is a header. That distinction can matter to formulas, charts, and later edits, so the inventory should explain the range’s intended use, not just repeat its coordinates.

Google Sheets compared with Excel

In Google Sheets, use Data > Named ranges to open the named-range sidebar. Microsoft Excel has its own name-management tools, including Name Manager, and its interface and rules are not identical. If a spreadsheet is opened in Excel, do not assume that a Google Sheets menu path or every name behavior will be the same there. For this page, the steps apply to Google Sheets in a web browser.

Likewise, downloading a Sheets file as an Excel workbook changes the application in which you manage it. The underlying concepts are similar—both programs can use descriptive names in formulas—but the list location, editing controls, and some details of compatibility differ. If a file is shared between the programs, check the names and formulas after conversion instead of assuming the list will behave identically.

Common problems and fixes

  • The list looks empty: Confirm that you opened the correct spreadsheet. Named ranges belong to a spreadsheet file, not to every file in your account.
  • A name is rejected: Remove spaces and punctuation, do not start with a number, and avoid a label that looks like a cell address. Use underscores to separate words.
  • A formula returns an error: Check that the named range still exists and points to the intended cells. Also verify the formula and the data in the referenced range.
  • New rows are missing from a result: Inspect the range reference in the sidebar. The name may still cover only the original rows.
  • You cannot find a list-formula option: There is no standard worksheet function that returns all named ranges as a live table. Use the sidebar, document entries manually, or consider Apps Script for an automated inventory.

When a problem affects a shared file, avoid deleting names just to make the sidebar shorter. A name may be supporting formulas on another tab that is not currently visible. First check its references and test the workbook’s important outputs; then remove only entries that are genuinely unused.

Frequently Asked Questions

Where is the named range list in Google Sheets?
Open the spreadsheet and choose Data > Named ranges. The sidebar shows each named range and its cell reference.

Can I display all named ranges in a worksheet with a formula?
Google Sheets does not have a standard worksheet formula that returns the complete named-range inventory. Use the sidebar for a quick review, copy the details into a sheet, or use Apps Script if you need automation.

How do I find what cells a named range refers to?
Open the Named ranges sidebar and read the reference beside the name. Check the sheet tab and cell coordinates, then inspect those cells if you need to confirm their contents.

Can a named range contain spaces?
No. Use letters, numbers, and underscores, and do not start the name with a number. For example, use Project_Costs instead of Project Costs.

Does deleting a named range delete its cells?
No. It deletes the label, not the referenced data. Formulas that used the name may be affected, so review dependent calculations before removing it.

How do I add a new name to the list?
Select the cells, choose Data > Named ranges, add a range in the sidebar, enter a valid name, verify the reference, and save.

Related

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.