2
Table Of Contents
- User’s Guide
- Contents
- Welcome to Pages
- Overview of Pages
- Creating a Document Using the Pages Templates
- Formatting a Document’s Layout and Table of Contents
- Setting Page Orientation and Size
- Setting Page Margins
- Creating Columns
- Varying Column and Page Layouts
- Creating a Document With Left- and Right-Facing Pages
- Adding Headers, Footers, Page Numbers, Footnotes, and Endnotes
- Varying Document Formatting Using Section Breaks
- Adding a Repeated Background Image
- Using a Table of Contents
- Formatting Text and Paragraphs
- Working With Styles
- Working With Graphics andOther Media
- Changing Object Properties
- Creating Tables
- Adding a Table
- Using Table Cells and Borders
- Formatting Tables
- Adding Images or Background Colors
- Formatting Numbers
- Sorting Cells
- Autofilling
- Using Formulas
- A Tour of Using Formulas
- Adding a Quick Formula
- Removing a Formula
- Using the Formula Editor to Add and Edit Formulas
- Using Cell References
- Adding a Formula to Multiple Cells
- Performing Arithmetic Operations
- Using Predefined Functions
- Operators and Functions for Advanced Table Formula Users
- Defining Formulas That Use Operators
- Defining Formulas That Use Functions
- Creating Charts
- Personalizing Documents With Address Book Data
- Printing and Exporting Your Document to Other Formats
- Designing Your Own Document Templates
- Index
Chapter 8 Creating Tables 189
Using Cell References
When the Formula Editor is open, cell reference tabs appear on the table’s top and left
sides.
The reference tabs help you quickly create a cell reference. A cell reference identifies a
column (using letters) and a row (using numbers). For example, A1 is the top left cell.
A4 is the cell in the fourth row of the first column.
To add cell references to the Formula Editor’s text field:
m To refer to a specific cell, click to place the insertion point in the text field where you
want the reference to appear, and then click a cell in the table. The Formula Editor
inserts a reference to the cell.
You can also type a cell reference (A4) in the text field, using the reference tabs as
guides.
m To add a reference to a list of individual cells, click each cell. The Formula Editor
automatically inserts an addition operator (+) between them.
You can also type multiple cell references separated by a comma (or a semicolon if
you’re in a locale where the decimal separator is a comma). For example, to sum
values in three cells, you could type SUM(C2,D2,E2) in the text field of the Formula
Editor.
Columns are referenced
alphabetically.
Rows are referenced
numerically.
This is cell B2.