Learn Excel 2011 for Mac

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. This section makes sure you know how to refer to cells and ranges, both when they're on the same worksheet as the formula and when they're on a different worksheet. You can even refer to cells and ranges in another workbook—as long as it will remain in the same place in your Mac's file system.

Referring to a Cell

To refer to a cell on the same worksheet, simply use its column lettering and its row number. For example, use =A10 to refer to cell A10.

To refer to a cell on a different worksheet, enter the worksheet's name followed by an exclamation point and the cell reference. For example, ...