Excel Auto Filter

Let's talk about Autofilter function! This is one of the most commonly used tool in Excel.

This is a relatively easy formatting & data manipulation technique.

Putting an AutoFilter into a column header allows user to specify the type of information to view. A filter acts as a drop down menu in the header column. A filter does not sort your data, it simply hides the information that you choose not to display.

Creating AutoFilter

Data>Filter>AutoFilter

If you like to know more, "Daily Dose of Excel" always have good illustrations. Click here to view.