Select High as shown in the following screen shot.Д¬lick OK.By default, all the values will be selected. A drop-down box appears with all the values in the position column. If you want to display the data only for Position = High, click the arrow next to Position. Only those rows containing the selected values in the chosen column will be displayed. You can choose what data is to be displayed by clicking the arrow next to a column header and selecting the Values in the column.

You can also reapply the filters when data changes occur. You can remove the filters that you have in your data. This will make the AutoFilter on for the Range. In case of a Range, you can provide the column headers in the first row of the range and click on filter in the Editing group on Home tab. When you click a Filter option or when you click on Custom Filter that appears at the end of the Filter options, Custom AutoFilter dialog box appears, wherein you can customize your filtering options. For example, if the column contains numbers, when you click on the arrow next to the column header, Number Filter Options appear. Each AutoFilter has filter options based on the type of data you have in that column. AutoFilter is represented by the arrow next to column header. In a table, the column headers are automatically tagged to filters, known as AutoFilters.

Cell icon if the column you selected contains cell icons.

Font color if the column you selected contains font with color.

Number filters if the column you selected contains numbers.

Date filters if the column you selected contains dates.

Text filters if the column you selected contains text.You can Filter data in a Range, table or PivotTable. This is a quick way to display only the information that is needed by you. Filtering allows you to extract data that meets the defined criteria from a given Range or table.

Data analysis excel 2003 download