What Is a Range in Google Sheets? Meaning and Examples

A range in Google Sheets is one cell or a group of cells identified by their addresses. For example, A1 refers to one cell, while A1:B10 refers to the rectangular block from column A, row 1, through column B, row 10. Ranges let formulas, charts, formatting rules, and other spreadsheet tools work with selected cells.

What the term means

In spreadsheet terminology, a range is a standard term, not slang or an informal abbreviation. It describes the cell or set of cells a task refers to. A range can contain one cell, a row or column, or a block of cells. In ordinary English, range means an extent or span; the spreadsheet use applies that idea to cells covering part of a worksheet.

The English word has a history going back through Middle English and Old French, where related forms meant arranging things in a row. The spreadsheet sense is a technical use of the familiar idea of an extent; it is not a separate acronym, and there is no reason to treat it as internet slang. Google Sheets uses the term in its interface and help materials, including the feature for named ranges.

In a sentence, someone might say, “Select the range A1:B10 before creating the chart.” That means select all the cells in that rectangular area. The word can also describe a reference in a formula, as in “The SUM formula uses a range of sales figures.”

How to read range notation

Google Sheets commonly identifies cells with A1 notation: the letter names the column and the number names the row. A colon between two cell addresses describes the rectangular range that extends from the first cell to the second, including both endpoints. The order of the endpoints does not change which block is described.

C4 is a one-cell range: column C, row 4.
A2:A12 covers cells A2 through A12 in one column.
B1:F1 covers five cells across row 1.
B2:D6 covers three columns and five rows, or 15 cells.
A:A refers to the entire A column, while 2:2 refers to the entire second row.

A range can also refer to cells on another sheet. For example, Inventory!A2:C20 identifies that block on a sheet named Inventory. If the sheet name contains a space or punctuation, put it in single quotation marks: 'Annual Report'!A2:C20. The exclamation mark separates the sheet name from the cell reference.

The colon is important: A1:B5 is one continuous rectangular range. A comma inside a formula can instead separate distinct arguments. For example, a function may take two separate ranges as two arguments; that does not make the ranges one continuous block.

Using ranges in formulas

Ranges make formulas easier to write and maintain because one reference can represent many cells. A formula can calculate a result from every value in a range, count matching entries, or compare data across rows. The range belongs inside the formula as an argument, usually enclosed in parentheses after the function name.

Suppose monthly sales are in cells B2 through B10. With sales in B2:B10, enter =SUM(B2:B10) in an empty cell to add those nine values. If the cells contain 10, 15, 20, 5, 12, 8, 14, 6, and 10, the result is 100. The range reference tells Sheets which cells to include; it does not itself perform the addition.

Other common examples include =AVERAGE(B2:B10) to calculate the mean and =COUNT(B2:B10) to count cells containing numbers. For a condition-based count, with status values in C2:C20, =COUNTIF(C2:C20,"Complete") counts cells that contain Complete. In these examples, the range is the part of the formula that identifies the input cells. A function’s rules determine what is calculated from them.

Ranges can also be used as inputs to charts, filters, conditional formatting, and data validation. A chart can use one range for category labels and another for values. A conditional formatting rule can apply to a selected range and then evaluate each cell against the rule. The exact range and settings depend on what the sheet is meant to show.

Selecting and editing a range

For a small block, click the first cell and drag to the last cell. You can also click a cell, hold Shift, and click another cell to select the rectangular block between them. To select an entire column or row, click its letter or number heading. Google Sheets displays the selected cells with a highlight and shows the selection’s address near the formula bar.

For a large range, entering its address is often more precise than dragging. Click the name box near the formula bar, type an address such as D5:F200, and press Enter to select it. To use the selection in a formula, you can type the address directly after the function’s opening parenthesis, or select the cells while editing the formula.

A selected range and a range reference are related but not identical ideas. Selection is the current highlighted area on screen. A reference is the address a formula or tool uses, and it can keep referring to those cells even when they are not selected. Clicking elsewhere does not remove a range reference already written in a formula.

Relative, absolute, and mixed references

When you copy a formula, Google Sheets normally adjusts its cell references relative to the new location. For example, with values in A2:A4, enter =A2*2 in B2 and copy it down one row: the copied formula refers to A3. This behavior is useful when the same calculation should use the corresponding value on each row.

A dollar sign makes a reference absolute or partly absolute. With a tax rate in D1 and item prices in A2:A10, enter =A2*$D$1 in B2 and fill it down. The A2 reference changes to A3, A4, and so on, while $D$1 stays fixed. In $A2, the column is fixed but the row can change; in A$2, the row is fixed but the column can change.

Absolute references are especially useful when a formula repeatedly uses one constant, such as an exchange rate, target, or percentage stored in a cell. Without the dollar signs, copying the formula can shift that reference and produce unintended results. Check a copied formula in the formula bar if the output looks wrong.

Named ranges and common uses

A named range gives a cell or range a readable label, such as Quarterly_Sales, rather than requiring every formula to show an address. To create or manage one in Google Sheets in a web browser, select the cells and choose Data > Named ranges. Enter a name and confirm it. You can then use the name in supported formulas, which can make a complex sheet easier to understand.

Names must follow Google Sheets’ naming rules; for instance, a name cannot be written like a cell address. Avoid names that are confusingly close to references, and use a clear label that helps explain the data. If the underlying cells move or the range needs to expand, review the named range settings so the name still points to the intended cells.

Ranges also appear in several everyday workflows:

For conditional formatting, select the cells and choose Format > Conditional formatting. Set the range to apply the rule to, then choose the condition and formatting.
For data validation, select the target cells and choose Data > Data validation. The rule controls what entries are allowed in those cells.
For a chart, select the data and use Insert > Chart. Check the chart’s data range and label settings if Sheets has not identified the desired columns correctly.
For sorting or filtering, include the relevant rows and columns so that values stay with their associated records. Include headers only when the tool is configured to recognize them as headers.

Common range problems

A mistyped or deleted reference can cause a #REF! error. This often means the formula points to a cell or range that no longer exists or cannot be referenced as written. Check the formula’s sheet name, punctuation, and endpoints, and undo a recent deletion if appropriate. If a formula was copied from another sheet, confirm that its sheet reference is valid.

A formula may return an unexpected total because its range omits a row, includes a heading, or stops before the final entry. Read the address carefully: B2:B10 includes row 10 but excludes row 11. Also check whether the cells contain numbers or text that looks like numbers; functions such as SUM do not treat every text value as a numeric value.

Whole-column ranges such as A:A can be convenient when new entries will be added over time. However, a formula that repeatedly processes entire columns may do more work than necessary, especially in a large or calculation-heavy sheet. If the data has a known extent, a bounded range such as A2:A500 can be clearer and more efficient. Expand it when the data grows, or choose an approach that fits how the sheet will be maintained.

Another common confusion is assuming a range always means a list of adjacent cells. A conventional A1 range written with a colon describes one continuous rectangle. If a task involves separate blocks, use a function or tool that accepts multiple range arguments, or handle the blocks separately. Check the instructions for the particular function, because not every feature accepts multiple ranges in the same way.

How ranges compare with Excel

The basic idea and familiar A1 notation are shared by Google Sheets and Microsoft Excel: a reference such as A1:B10 identifies a block of cells, and formulas use references to work with data. A person moving between the two programs will recognize many simple range formulas.

Some spreadsheet features differ. Excel tables can use structured references based on column names, while Google Sheets commonly uses A1 references and named ranges for readable labels. Functions, menus, and supported formula behavior can also vary by product or version. If a workbook is imported or exported, check formulas and formatting rather than assuming every feature will behave identically. This article describes Google Sheets in a web browser, not Excel’s interface.

Frequently Asked Questions

Is one cell a range in Google Sheets?
Yes. A range can consist of a single cell, such as A1, as well as a group of cells. The word does not require multiple cells.

What does A1:B10 mean?
It means the rectangular block from A1 through B10, including both endpoint cells. The block covers columns A and B and rows 1 through 10, for 20 cells total.

How do I select a range without dragging?
Use the name box near the formula bar: enter the address, such as A2:D50, and press Enter. You can also type a range address while editing a formula.

What is the difference between a range and a cell reference?
A cell reference identifies a location, such as C7. A range reference identifies one or more cells, and may be a single cell or a larger area. In everyday use, people often call both kinds of references ranges.

Can a range include cells on another sheet?
Yes. Include the sheet name, an exclamation mark, and the cell address, as in Summary!A1:C10. Use single quotation marks around a sheet name that contains spaces, such as 'Monthly Summary'!A1:C10.

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.