X hits on this document

261 views

0 shares

0 downloads

0 comments

25 / 65

Enter formulas

Use cell references

Cell references identify individual cells or cell ranges in columns and rows.

Cell references tell Excel where to look for values to use in a formula.

Excel uses a reference style called A1, which refers to columns with letters and to rows with numbers. The numbers and letters are called row and column headings.

This lesson shows how Excel can automatically update the results of formulas that use cell references, and how cell references work when you copy formulas.

the range of cells in columns A through E and rows 10 through 20

A10:E20

Refer to values in

the range of cells in column A and rows 10 through 20

A10:A20

the range of cells in row 15 and columns B through E

B15:E15

cell A10 and cell A20

A10,A20

the cell in column A and row 10

A10

Cell references

Document info
Document views261
Page views261
Page last viewedWed Dec 07 00:34:18 UTC 2016
Pages65
Paragraphs433
Words3509

Comments