O'Reilly logo

Learn Excel 2011 for Mac 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. 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, ...

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