Like this article? We recommend
Like this article? We recommend
Like this article? We recommend
Sorting and Filtering
If you hover over a column’s letter after selecting a table, an arrow appears at its right-most edge. Click the arrow to reveal a pop-up menu that includes options for sorting information according to the column’s contents. You can also add columns before or after the selected column, delete the column, or hide/unhide columns.
With the exception of sorting, these options are available in a similar pop-up menu that appears after you select a row’s number (as well as in the Table menu). You can also sort and filter data using the Sort and Filter panel (available from the same pop-up menu or by clicking the toolbar’s Sort and Filter button) shown in Figure 2, which allows more complex sorting by applying multiple sort criteria (sort by date and then by name, for example).
)
You can also use the Sort and Filter panel to set filters that determine which data is visible in the table. To do this, select the "Show rows that match the following" checkbox and specify one or more filters. To specify a filter, select a row from the first pop-up menu (the header names will be displayed if header rows are used).
Next, select how to filter results by choosing is, is not, greater or lesser than, and so on from the second pop-up menu.
When that’s done, enter the filter value (date, amount, and so on). If necessary, you can string together multiple filters.
After you’ve filtered the data in your table, the hidden information will no longer appear, even though it’s all still there—just tucked away from view.
To remove a filter, deselect the "Show rows that match the following" checkbox. To reset a filter or sort, click the appropriate reset button.