Ranges & Individual Cells in Excel

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

CTL Support Request

Details

Article ID: 7962
Created
Thu 12/29/22 2:13 PM
Modified
Fri 11/3/23 4: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 (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.