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
182 Chapter 8 Creating Tables
Autofilling
Autofilling is a feature that lets you paste the contents of the upper-left cell in a
contiguous group of cells into all other cells in the group. Any data, number
formatting, or formula associated with the upper-left cell is pasted into all cells in the
group, but background style formatting isn’t. (See “Using Formulas” on page 183 to
learn about using formulas in table cells.)
If the upper-left cell is empty, autofilling clears all data from cells in the group. Any
number formats or formulas associated with cells in the group are changed to match
those of the upper-left cell.
Autofilling doesn’t set up an ongoing relationship among cells in the group. After
autofilling, you can change the data, number formatting, or formula in any of the cells
in the group.
To autofill a range of cells:
1 Select the cell whose data, number formatting, and/or formula you want to paste into
other cells.
2 Select adjacent cells to autofill, making sure that the cell whose contents you want to
paste is the upper-left cell in the group. Cells in the group can be in the same row or
column and in adjacent rows or columns, but they must be contiguous. See “Selecting
Table Cells” on page 167 for selection instructions.
3 Open the Table Inspector. Click Inspector in the toolbar (or choose View > Show
Inspector), and then click the Table Inspector button.
4 Click the Numbers button, and then click the Fill button.
Paste the contents of the
upper-left selected cell into
the other selected cells.