Setting up multiple filters

[rkrause]

I need to be able to set up filters for different columns. My challenge is that their are sub columns to filter by instead of the main column header...

When i click the auto filter button, it immediately filters the row i've selected. If i attempt to filter sub category in another column, I lose my filter at the top...

How can i choose which columns or set of data I want to filter?


Thanks,
Ryan.

[jasoncw]

Highlight the actual range to filter, including the header row, then select Data > Filter > AutoFilter from the menu.

HTH

Jason