beautypg.com

Autofilling – Apple Pages 2 User Manual

Page 182

background image

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.