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
190 Chapter 8 Creating Tables
m To add a reference to a range of cells, click the Insert Formula button in the Formula
Editor and choose a function from the pop-up menu. Drag over the cells you want to
add. The Formula Editor inserts the first and last cell references of the range, separated
by a colon (A2:A4). See “Using Predefined Functions” on page 191 for more
information about the Insert Formula button.
You can also type or click the first cell, type a colon, and then type or click the last cell.
m To refer to all the cells in a column, type the column’s letter. If the column has a
header row, you can click the column header cell instead.
m To refer to all the cells in a row, enter 1:1 for the first row header, 2:2 for the second
row header, and so on. If the row has a header column, you can click it instead.
Adding a Formula to Multiple Cells
When a table has header cells, you can use them to quickly add a formula to multiple
rows or columns.
To use a column header to sum the values in each row:
1 Select the header for the column whose cells you want to contain the formula. We’ll
use column header C1 as an example.
2 Open the Formula Editor. For example, type the equal sign (=).
3 To add a formula that sums the values in columns A and B, click the column header
cell for column A, and then click the column header cell for column B. The Formula
Editor text field displays =A+B.
You could also type A+B in the text field.
4 Click the Accept button or press Return or Enter to save the formula.
Every cell below the header in column C now contains a version of the formula that
refers to cells in only its row. For example, if you select C2 and type the equal sign (=)
to open the Formula Editor, you’ll see =A2+B2 displayed in the text field.
As this example illustrates, you can type a cell reference instead of clicking a header
cell. To refer to all the cells in a column, type the column’s letter, as in the example. To
refer to all the cells in a row, type 1:1 for the first row header, 2:2 for the second row
header, and so on.