Referring to Cells and Ranges in Formulas and Functions

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:

  • On the same worksheet as the formula
  • On a different worksheet than the formula
  • In a different workbook than the formula

Referring to a Cell or Range on the Same Worksheet

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 ...

Get Office 2010 Made Simple now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.