Named ranges in Google Sheets - Step-by-Step Guide

Introduction

Named ranges let you give a simple name to a group of cells. This makes it easier to use those cells in formulas without remembering cell addresses.

When you want to sum sales data from a specific month without typing cell addresses each time

When you create a budget sheet and want to refer to expense categories by name

When sharing a sheet and you want others to understand formulas easily

When you have a list of products and want to use that list in dropdown menus

When you want to protect or highlight a specific data area by name

Steps

Step 1: Select the cells you want to name

- Spreadsheet grid

The selected cells are highlighted

💡 Make sure to select all cells you want included in the named range

Step 2: Click Data in the top menu

- Top menu bar

A dropdown menu appears

Step 3: Select Named ranges from the dropdown

- Data menu

The Named ranges pane opens on the right side

Step 4: Type a name for your range in the Name box

- Named ranges pane

The name appears in the box ready to be saved

💡 Use simple, descriptive names without spaces, like SalesJan or Expenses

Step 5: Check the cell range shown is correct

- Named ranges pane

You see the exact cells included in the range

Step 6: Click Done

- Named ranges pane

The named range is saved and listed in the pane

Step 7: Use the named range in a formula by typing its name

- Any cell in the sheet

The formula uses the named range instead of cell addresses

💡 For example, type =SUM(SalesJan) to add all values in the named range SalesJan

Before vs After

Before

Formulas use cell addresses like =SUM(A1:A10) which can be hard to read

After

Formulas use named ranges like =SUM(SalesJan) which are easier to understand

Settings Reference

Name

📍 Named ranges pane

To identify the range with a simple, memorable name

Default: No default, user-defined

Range

📍 Named ranges pane

Defines which cells the name refers to

Default: Selected cells when creating the named range

Common Mistakes

Using spaces or special characters in the named range

Google Sheets does not allow spaces or some special characters in names

Use underscores or camel case, like Sales_Jan or SalesJan

Not selecting the correct cells before creating the named range

The named range will refer to wrong or empty cells

Always double-check the selected range in the Named ranges pane before saving

Trying to use a named range that does not exist in a formula

The formula will show an error because the name is not defined

Create the named range first, then use it in formulas

Summary

Named ranges let you give easy names to groups of cells for simpler formulas

You create named ranges from the Data menu in Google Sheets

Use named ranges in formulas to make them easier to read and maintain