Hi Dave,

Thank you. I've tried the big button for Filter, which has the shortcut Ctrl
+ Shift + L. However, it appears the resulting dialog box behaves very
differently than in previous versions. I used to be able to select a column,
and then go to Data > Filter > AutoFilter and be able, for example, to
select a single City or Name, and be able to filter everything out but the
one I selected.

Now it seems I have to clear all the check boxes but the one I want. That's
too tedious and time-consuming. I'm sure there are other ways, but I'd like
something direct and easy as the title of this message. Any ideas? I'm still
hoping I am missing something obvious to somebody else, "male blind" type of
thing.

I don't think MS deleted any functionality, but it sure "feels" that way
because of how things were moved around so much. It looks like this upgrade
will require even experts to train for the upgrade.

Hi Dave,

I discovered that clicking on Select All will toggle all from selected to
deselected, then I can click the value that I want. So it appears as if an
extra mouse click or two are now required, where before I could do it in one
shot.