Apple numbers User Manual

    Using Tables 

 

m

If cell values aren’t visible because rows are too narrow, you can use the Fit button next 
to the Row Height controls in the Table Inspector to make values visible. Select a cell, 
row(s), or the table, and then click the Fit button. As row content is added or removed, 
row height automatically changes to match content height.

You can also resize a row by clicking the bottom border of its reference tab and 
dragging down, or by using the Row Height controls in the Table Inspector.

m

You can also resize columns and rows to accommodate content by using the reference 
tabs.

To increase the height of a row to accommodate its largest content, double-click the 
lower border of the row’s reference tab. Column width does not adjust automatically 
when you make content changes.

To increase the width of a column to accommodate its largest content, double-click the 
right border of the column’s reference tab.

You can apply a format to a cell so its value is displayed in a particular way. For 
example, you can format cells that hold monetary values so that a currency symbol 
(such as $, £, or ¥) appears in front of numbers in them. Or you can format cells to 
contain controls, such as checkboxes and sliders, which are used to add or change cell 
values. 

When you use a cell format, you are only setting the display characteristics of a value. 
When the value is used in formulas, the actual value is used, not the formatted value. 
The only exception is when there are too many numbers following a decimal point, in 
which case the number is rounded.

You define cell formats using the Format Bar or the Cell Format pop-up menu in the 
Cells Inspector. To display cell values exactly as you type them, choose Automatic; 
otherwise, choose the item that provides the specific formatting you want to use.

m

To add a value to an empty cell that has a format, select the cell and enter a value. The 
format is applied when you leave the cell.

m

To apply a cell format to an existing value, select one or more cells that contain values. 
Use the Cells Inspector or the Format Bar to define a cell format. The format you define 
is applied to values in the selected cell(s). 

m

To display a value exactly as you type it, select the cell, and then choose Automatic 
from the Format Bar or the Cell Format pop-up menu of the Cells Inspector. The value 
remains, but its formatting is removed.

m

If you delete a value from a cell with a format, the format isn’t deleted. To delete the 
format, choose Automatic from the Format Bar or the Cell Format pop-up menu of the 
Cells Inspector.