Excel Filtering 07

What does filtering do for me?

Filtering can help if you want to data mine, mine for information.  I can view my information by Males only and by SSG, or by Females and SSG. Anything that I want I can filter for as long as it is in my information.

Where to find the Filter Button?

You can find the Filter button on the Home Tab at the right hand side under Sort and Filter.

Set up Filtering

Click into your Labels row (Last Name, First Name, etc…)

Choose the Filter Button.

Drop Down arrows will appear in your Labels, in the lower right corner.

You can select what you wish to view by making sure that the check box has a check mark in it. The quickest way to uncheck everything is to click the (select all).

You may filter by as many criteria as you need.

Cautions when filtering

If you save the filtered workbook and open it again and you have not cleared the filters the information will still be filtered.  After the heart attack moment check to see

If the filter buttons are on

Are the Numbers to the left out of sequence and blue?

Is the filter button glowing orange/gold?

If the answer to any of these questions a yes, the filters are still turned on and the information is still filtered.