Sorting rows in a table – Apple Numbers '09 User Manual

Page 67

Advertising
background image

Chapter 3

Using Tables

67

To hide multiple rows or columns, select the rows or a cell in each of them and
then choose Hide Selected Rows or Hide Selected Columns from a reference tab pop-
up menu.

To show all hidden rows and columns in a table, select the table or an element in it

m

and then choose Table > Unhide All Rows or Table > Unhide All Columns.
You can also choose these commands from any reference tab’s pop-up menu.
To show rows hidden immediately above a row or columns hidden immediately to

m

the left of a column, click the reference tab for the row or column and then
choose “Unhide Rows row numbers“ or “Unhide Columns column letters” from the pop-
up menu.

To show rows or columns hidden in a selected range of rows or columns, select the

m

range and then choose Unhide Selected Rows from the pop-up menu of any of the
selected rows or columns.

Rows or columns that are hidden in Numbers tables are removed when the tables are
copied into other iWork applications.

Rows and columns that contain merged cells can’t be hidden.

Sorting Rows in a Table

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.

Advertising