Apple numbers User Manual

 Using Tables

 

m

To delete a comment, click the X in the upper right of the comment box.

m

To include comments when you print a sheet, show any comments you want to print, 
and then choose File > Print Sheet. 

Reorganizing Tables 

You can use sorting and filtering to reorganize the data in tables.
 Sorting:  Lets you arrange values in some or all the cells in a column in ascending or 

descending order. Rows containing cells being sorted are reordered.

 Filtering:  Lets you hide rows in a table that don’t contain the values you specify.

You can arrange values in some or all the cells in a column in ascending or descending 
order. Rows containing cells being sorted are reordered. Header cells aren’t sorted. 

Sorting takes into account values in hidden rows and hidden columns.

m

To sort all the cells in a column, choose Sort Ascending or Sort Descending from the 
pop-up menu for the column’s reference tab.

You can also click Sort & Filter in the toolbar or choose Show Sort & Filter Panel from a 
reference tab’s pop-up menu. Use the pop-up menus under Sort to choose a column 
and sort order.

m

To re-sort values after changing them, click Refresh in the Sort & Filter panel.

m

To sort only some of the cells in a column, select the cells, open the Sort & Filter panel, 
choose a sort order, and then click Refresh.

m

To sort all the cells in a column and then re-sort the results using another column’s 
values, open the Sort & Filter panel, choose a column and sort order in the Sort pop-up 
menus, click +, choose another column and sort order, and then click Refresh.

To use additional sort criteria, click + to define each one you want to add.