Saving subsets of a data list as custom views

Custom views are perfect for saving subsets of a data list using different filtering criteria. That way, instead of having to go through all the tedium of turning on AutoFilter and then selecting the filtering criteria in all the relevant fields, you can re-create and display the subset in a flash simply by selecting the name of its view in the Custom Views dialog box (View → Custom Views).

To create a custom view that re-creates and displays a filtered subset of your data list, you need to manually turn on AutoFilter, select the filtering criteria for the appropriate fields, and then click the Add button in the Custom Views dialog box.

When creating a new custom view that shows a subset of a filtered data list, you must be careful not to clear the Hidden Rows, Columns, and Filter Settings check box in the Add View dialog box. Otherwise, you are unable to turn on AutoFilter and hide the rows with records that don't meet your filtering criteria for the view you create.