Excel 2003 - Filters
The table below shows all the data in a table.
We will now use a FILTER to display only the Cars which have 2 doors.
Filters are easy to use.
Step 1: Highlight the Header cells of your table
Step 2: Click on Data
Step 3: Click on Filter
Step 4: Click on AutoFilter
You will now see that there is a small arrow on the right hand side of each heading.
Step 5: Click the arrow of the column you want to FILTER. The following box will appear
Step 6: If the option you are looking for appears, click on the appropriate title. If you do not see what you are looking for, click on (Custom…)
The Custom AutoFilter window allows you to define up to two filters.
If you click on the left hand side box’s down arrow you will be given a variety of options, including equals, greater than, less than and so on. Choose the setting you require.
The right hand box allows you to type in your criteria. These can be numeric or text, depending on the content of the column.
Click on OK when you are done.
NB: The small arrows in the headers do not print.
- Word Processing
- Web Site Authoring