Apple Numbers '08 - Manual (Page 69)

Chapter 3 Using Tables 69
To create new values based on numeric patterns, select two or more cells before
dragging. For example, if two selected cells contain 1 and 2, the values 3 and 4 are
added when you drag through the adjacent two cells. And if two selected cells contain
1 and 4, the values 7 and 10 are added when you drag through the adjacent two cells
(values are incremented by 3).
Autofilling doesn’t set up an ongoing relationship among cells in the group. After
autofilling, you can change the cells independently of each other.
Working with Rows and Columns
You can quickly add or remove rows and columns, create a header row or column or a
footer row, and more.
When you insert, remove, resize, hide, or show rows or columns in a table, other objects
on the sheet may be moved to avoid overlapping or to maintain relative object
positions. To prevent automatic movement of objects, choose Numbers > Preferences
and in the General pane deselect “Automatically move objects when tables resize.”
Adding Rows
You can add rows within a table or at the end of a table.
If the table contains a footer row, rows added at the bottom of the table are added
above the footer row. If the table has filtering criteria associated with it, you can’t add
new rows until you stop filtering rows; see “Filtering Rows” on page 78 for instructions.
Here are ways to add rows:
m To add a single row, hover your pointer over a row’s reference tab to see its menu
arrow, and then click the arrow and choose Add Row Above or Add Row Below from
the pop-up menu. You can also choose these commands from the Table menu.
m To add a row at the end of the table, press Return when the last cell is selected. Press
Return twice if you’ve just added or changed the cell value.
If “Return key moves to next cell” under Table Options in the Table Inspector isn’t
selected, press Tab instead from the last cell in the row.
m To add one or more rows at the end of the table, you can use the Row handle in the
lower left, visible when a cell is selected.
To add a row at the end of the table, click the Row handle once.
To add multiple rows at the end of the table, drag the Row handle or the Column and
Row handle (in the lower right) down.
To add rows and columns at the same time, drag the Column and Row handle
diagonally.
m You can split cells into two equal rows. “Splitting Table Cells” on page 74 tells you how.