Publishers of technology books, eBooks, and videos for creative people

Home > Articles

  • Print
  • + Share This
This chapter is from the book

Using Cell References

When you build a formula, you don’t type the cell references yourself—Numbers inserts them for you when you select cells. A reference appears in the formula bar as a colored oval placeholder holding the name or reference-tab address of the cell(s). The color of each placeholder is coordinated to match the highlight color of the corresponding cells in the table circle-a.jpg. You can easily redefine any cell reference in your formula circle-b.jpg.

To insert a cell reference in a formula:

  1. In the formula bar, position the insertion point where you want the reference to appear or, to replace an existing reference, tap its placeholder to select it.
  2. Do any of the following:
  • + Share This
  • 🔖 Save To Your Account