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 187
To perform a basic calculation using row values:
1 Select a range of adjacent cells in a row.
2 Click Inspector in the toolbar, click the Table Inspector button, and click Numbers.
3 Choose a formula from the Formula pop-up menu.
Pages places the formula and its result in the first empty cell to the right of the
selected cells. If there is no empty cell, Pages creates a new column to hold the result.
If the row has a header cell and you want the formula to use all the values in the row,
click the header cell before choosing the formula.
Removing a Formula
To remove a formula from a cell:
1 Select the cell.
2 Press the Delete key.
Using the Formula Editor to Add and Edit Formulas
The Formula Editor lets you create and modify formulas.
To open the Formula Editor:
m Select a table cell and type the equal sign (=).
m Select a table cell that contains a formula, and click in the cell or press Return or Enter.
Insert Formula button
Press and hold to choose a
predefined function from
the pop-up menu.
An equal sign is
always the first
element in a formula.
Text field
View or edit a formula
in this field.
Cancel button
Discard changes.
Accept button
Save changes.