O'Reilly logo

Office 2010 Made Simple by Guy Hart-Davis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required