Apple numbers Manual De Usuario

 Using Tables

 

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.”

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.

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.