How to Add Filters in Apple Numbers

How to Add Filters in Apple Numbers

You can control what data to display in your spreadsheet document with Apple Numbers’ filter function. Navigating this function is easy and simple when you follow these steps.

• Step 1: Choose a Template or Spreadsheet File

  

  Open the Apple Numbers application on your device and choose a template. Open an existing file or create a new spreadsheet. For the purpose of this tutorial guide, a sample table and chart from the template gallery will be used. Using the filter tool in Apple Numbers requires you to have data that you can analyze and apply specific criteria.

• Step 2: Select the Data

  

  The next step is to select or highlight the data you want to apply a filter to. In the example above, Column B is highlighted. Once you’ve selected a column, open Column Actions, and in the pop-up menu, you will find Quick Filter and Add a Filter listed in the options. You can choose either one depending on your needs.

• Step 3: Use the Table Organizer Tool

  

  As another option, you can also click on the table organizer icon to add a filter. The table organizer icon is the button with the three horizontal lines next to the paintbrush button. Open it and select the Filter tab. Simply click the + icon to add a new filter.

• Step 4: Apply Filters and Rules

  

  As soon as you add a filter, you will be presented with several options. You can add a quick filter to your table to instantly view only selected data or you can choose from dozens of predetermined rules. Under Choose a Rule, click on either Number, Text, Date, Duration, or Cell to view and apply a rule. For example, you can filter a column or category and choose to only display values that are less than or equal to a certain number. If you want to delete a rule, simply click on the trash bin icon.