How to Use Autofilter in MS Excel

1.
Look at your data and decide what columns (or rows) you want to be able to sort with. Highlight those columns or rows and select 'Data' on the main menu. Then select 'Filter' and then click on 'Autofilter.'
2.
You now have drop down arrows in each title box. Each arrow can be clicked on to filter your data according to that column. Whatever you click on will become the only data visible.
3.
If you go to the 'DRAFT' title cell and click on the arrow, then click on '3/25/2008' in the autofilter column, you will be left only with data that matches.
4.
Notice that the arrow in 'DRAFT' is now blue. This tells you that the spreadsheet has been filtered by that column's data.
5.
You can apply additional filters. Click on the arrow in the 'WRITTEN' title cell, then click on '3/28/2008.' You now have only data that meets those two criteria, drafted on 3/25 and written on 3/28. You notice that both of those arrows are now blue.
6.
There are two ways to go back to your original data. You can remove all the autofilters. To remove all the autofilters at once, click on 'Data' then click on 'Filter' then click to remove the check mark on 'Autofilter.' This will restore all your data and remove the check boxes.
If you just want to restore your data one column at a time, click on the arrow, then click on 'all.' All the data in that column will be visible again.
The illustration shows both methods.