Apple numbers User Manual
68
Chapter 3
Using Tables
8
To add another rule, click + and repeat steps 5 through 7.
If more than one rule is defined for a cell and the cell’s content satisfies the conditions
of multiple rules, the colors associated with the higher rule in the list of rules are
applied to the cell.
of multiple rules, the colors associated with the higher rule in the list of rules are
applied to the cell.
To stop using a rule, click its – button to delete the rule, or deselect Fill Color and Text
Color to disable the rule. To stop using a list of rules, deselect “Highlight cells using the
following rules.”
Color to disable the rule. To stop using a list of rules, deselect “Highlight cells using the
following rules.”
Adding Images or Color to Cells
You can add graphics or color to individual table cells or to an entire table.
To add an image or color to a table cell:
1
Select the cell.
2
Click Inspector in the toolbar, and then click the Table Inspector.
3
To add an image, choose Image Fill from the Cell Background pop-up menu. See
“Filling an Object with an Image” on page 162 for instructions.
“Filling an Object with an Image” on page 162 for instructions.
4
To add background color, choose Color Fill or Gradient Fill from the Cell Background
pop-up menu. See “Filling an Object with Color” on page 160 for more information.
pop-up menu. See “Filling an Object with Color” on page 160 for more information.
Autofilling Table Cells
Autofilling lets you use the content in one or more cells to automatically add values to
adjacent cells.
adjacent cells.
Here are ways to autofill table cells:
m
To paste the content and fill of a cell into adjacent cells, select the cell and then drag
the Fill handle in its lower right corner over the cells into which you want to paste.
the Fill handle in its lower right corner over the cells into which you want to paste.
Any data, cell format, formula, or fill associated with the selected cell is pasted, but
comments aren’t pasted. If any target cell contains data, autofilling overwrites that data
with the value you’re repeating.
comments aren’t pasted. If any target cell contains data, autofilling overwrites that data
with the value you’re repeating.
m
To paste the content and fill of a cell into one or more cells in the same row or column,
select two or more adjacent cells. Choose Insert > Fill Right to assign selected cells the
value that resides in the leftmost selected cell(s). Choose Insert > Fill Down to assign
selected cells the value that resides in the topmost selected cell(s).
select two or more adjacent cells. Choose Insert > Fill Right to assign selected cells the
value that resides in the leftmost selected cell(s). Choose Insert > Fill Down to assign
selected cells the value that resides in the topmost selected cell(s).
Any data, cell format, formula, or fill associated with the selected cell is pasted, but
comments aren’t pasted. If any target cell contains data, autofilling overwrites that data
with the value you’re repeating.
comments aren’t pasted. If any target cell contains data, autofilling overwrites that data
with the value you’re repeating.
m
You can also add values to cells based on value patterns. For example, if a cell contains
a day of the week or a month, you can select the cell and then drag to the right or
down to add the next day of the week or month to the adjacent cell.
a day of the week or a month, you can select the cell and then drag to the right or
down to add the next day of the week or month to the adjacent cell.