Ranges & Individual Cells in Excel

Summary

What are ranges and individual cells in Excel?

Body

Question

What are ranges and individual cells in Excel?

Answer

Cell References	Refers to Values
A10	The cell in column A and row 10
A10, A20	Cell A10 and cell A20
A10:E20	The range of cells in columns A through E and rows 10 through 20

As you start to write Excel formulas, you may realize you want to use a range of cells or non adjacent cells in your formula. A range of cells will include the value of every cell within the range specified (for example, the range A1:A4 includes the cells A1, A2, A3 & A4). Ranges of cells are identified with a colon.

Non adjacent cells can be listed in the formula by separating them with a comma rather than a colon. For example, =SUM(A2,A4) will add cells A2 and A4, but not A3.

For more information about Formulas and Functions in Excel, please view the full tutorial from the CTL here: Excel Part 3

If you need further assistance, please click the CTL Support Request button on this page

Details

Article ID: 7962

Created

Thu 12/29/22 3:13 PM

Modified

Fri 11/3/23 5:05 PM

KCS Article Status

WIP: Only Problem & some Environment captured
Not Validated: Complete & Resolution captured, confidence lacks in structure, content, no feedback
Validated: Complete & reusable, used by licensed KCS user, confidence in resolution & std. compliance

Validated

Related Services / Offerings

Related Services / Offerings (1)

CTL Support Request

The Center for Teaching & Learning develops and supports a diverse and inclusive community dedicated to excellent teaching, learning, and student educational experience regardless of location, formality, or modality.