Take Control of Numbers

Filtering Data

You may not always want to see all the data in a table. Perhaps you want to see only rows with a specific value in column A, or a higher-than-some-threshold value in column B, or a checkmark in column F. Numbers provides quick filtering for rows through a table’s Column menus, which I describe in Quick Filters. More sophisticated options, such as multiple criteria for filters, are described in Filtering with the Inspector.

Because this chapter is divided between the use of Filter menus and that of the Sort & Filter Inspector for filtering, I’ll mention here two quick items that are common to filtered tables in general:

• You can’t add rows to a filtered table; the Add commands are dimmed.
• Data in hidden rows—those that disappear ...