Maybe it's time to learn about data|filter|Advanced filter.

Debra Dalgleish has some notes:
http://www.contextures.com/xladvfilter01.html
http://www.contextures.com/xladvfilter02.html

You could also cheat.

Set up another column that contains a formula that evaluates to true or false
based on your criteria--then filter by that column.

prakash wrote:

Hi,
I have an excel sheet where there are around 20 names in one column and
various data related to those names in other columns.
I want to view only 5 names and the data related to them in one click.
I have put the autofilter options for those columns, but I can view a
maximum of 2 names (Custom option - equal to). Otherwise I have select each
name once and view the name and their corresponding data in other columns,
which I do not want to do.

Is there a way to select more than 2 (5 in my case) in just one click.

Regards,
Prakash

--

Dave Peterson