Take Control of Numbers, 3rd Edition

Filter 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 the higher-than-some-threshold values in column B, or checkmarks in column F. You can do this, and more, when you use Quick Filters (described just ahead). More-sophisticated options, such as multiple criteria for filters, are described in Filter with the Inspector.

Tip: Remember that you don’t filter out a value, you filter for it. So, define filters by what you want left, not by what you want hidden.

Because this chapter is divided between the use of the Quick Filter submenu in a table’s column menus and that of the Organize inspector for filtering, I’ll mention here two items here that apply to filtered ...