"prakash" ha scritto nel messaggio
...
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.



Hi Prakash,

You have some different criteria you can use to filter with autofilter...

Try to select "Custom..." or "First 10..." in drop down list of filter.


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy