Data - Auto Filter - Set as Selection Conditions

Once auto filter criteria have been specified, select Set as Selection Conditions from the Data � Auto Filter submenu to display the Spreadsheet Case Selection Conditions dialog. The options in this dialog will be completed using the current auto filter criteria. Review the criteria and click OK to set the auto filter criteria as selection conditions for the current spreadsheets. Once selection conditions are set for a spreadsheet, only those cases that meet all selection conditions will be used in analyses and graphs.