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
188 Chapter 8 Creating Tables
m Select a table cell, click Inspector in the toolbar, and click the Table Inspector button.
In the Numbers pane, choose Formula Editor from the Insert Formula pop-up menu.
To add a new formula using the Formula Editor:
1 Select the cell in which you want to display the result of the formula.
2 Open the Formula Editor. For example, type the equal sign (=).
3 Type a formula in the text field, or click the Insert Formula button to use a predefined
function.
See “Using Cell References” on page 189 to learn techniques for including cell
references in your formulas.
See “Using Predefined Functions” on page 191 to learn how to insert a function into a
formula by using the Formula Editor’s Insert Formula button.
See “Performing Arithmetic Operations” on page 191 to learn how to add a formula
that performs arithmetic.
See “Operators and Functions for Advanced Table Formula Users” on page 193 for
detailed information about using specific operators and functions in formulas.
4 Click the Accept button to save your formula.
To edit an existing formula:
m Double-click a table cell that contains a formula. The Formula Editor opens, with the
formula displayed in the text field. You can use the arrow keys to move the insertion
point around in the text field.
To save a formula:
m In the Formula Editor, press Return, press Enter, or click the Accept button.
m Click outside the table.
To discard changes you’ve made to a formula:
m In the Formula Editor, press Esc or click the Cancel button.
m To close the Formula Editor and discard changes, click the Close button.