Microsoft Excel X for Mac OS X: Visual QuickStart Guide

3-D References

3-D cell references let you write formulas that reference cells in other worksheets or workbooks. The links are live—when a cell's contents change, the results of formulas in cells that reference it change.

Excel offers several ways to write formulas with 3-D cell references:

• Use cell names. I tell you about cell names in the first part of this chapter. Figure 18 shows an example.

  Figure 18. This example uses the SUM function to add the contents of the cells named John, Joan, Joe, and Jean in the same workbook.

  

• Type them in. When you type in a 3-D cell reference, you must include the name of the sheet (in single quotes, if the name ...