How Do You Use Autofilter In MS Excel?
• Input all of your data, or open the spreadsheet that contains all of your data. It is best that your data have column heading such as categories to specify the data below it. If you don’t already have these, input them before you filter. Click to enlarge data. • Select all the data you wish to filter. Click to enlarge data. • Because the AutoFilter option is an automatic process that does not receive any specific inputs on how to filter, it is recommended that you choose ‘’all’’ of the data you have. This will avoid the possibility that you lose data associations across rows and/or columns. • Click “Data”, then “Filter” which opens a sub-menu, then click “AutoFilter”. Click to enlarge data. • You will immediately notice that the categories have drop-down buttons. Using these buttons, you can set your filter options. Click to enlarge data. • Sort Ascending: sorts data in ascending order based on the data in that column; numbers are sorted 1, 2, 3, 4, 5, etc. and words are sorted alpha
