AutoFilter - Using Selectable Rows

[Ralph Wiggum]

(first time poster, long time reader)

Greetings,

There's probably a ridiculously simple answer to this but for the life of me, I can't find it anywhere.

If I create a pivot table, I'm able to click the arrow to the right on my row header, unselect "Show All" and then manually check boxes next to the rows I want to show. The pivot table then shows only the rows I'm interested in.

I can't figure out how to do this with filtering outside of the pivot table. I can select AutoFilter and then select "All", "Top 10" or individual rows, but I don't have the option to use a checkbox style selection to choose multiple, but not all, rows.

How can I set this up to have checkboxes associated with the AutoFilter dropdown so I can pick and choose which rows show?


thanks.

 

[Ralph Wiggum]

Did you look at the link I posted?
It shows you exactly how to do what you are asking.

Sorry, I must be missing something because that link doesn't show what I'm after, i.e. an autofilter with the ability to check multiple selections from the filter dropdown rather than just a single value or all or Top 10.


This is what I'm after:

Spreadsheet is set up with columns A/B/C

Jones/Red/Turtle
Smith/Green/Dog
Thomas/Yellow/Cat
Doe/Green/Turtle
etc..

I need to filter column A (the name) so that I can click a checkbox next to the rows Jones and Thomas, and thus not show the Smith and Doe rows. The same type of multiple selection checkbox filter that a pivot table has.


Thanks.