August 2011
Beginner
730 pages
16h 29m
English
To make your formulas and functions work correctly, you need to refer to the cells and ranges you want. You can create references to cells and ranges in different locations:
To refer to a cell on the same worksheet, enter its column lettering and its row number. For example, use =A10 to refer to cell A10.
You can either type in the reference or click the cell—whichever you find easier. You'll see examples of this shortly.
Similarly, to refer to a range, enter the range's address. For example, use =A10:A20 to refer to ...