CAn Autofilter be used to hide different columns?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

imail - 19 May 2008 03:25 GMT

I have an excel with rows as area and skill levels.Columns contains names.
I need to get a particular area and different skill levels.
I can use auto filter to select the correct area. But then my columns are
not filtered and I get the entire list of names around 200 names. But I need
to display only skill level say 5. Can I use auto filter to filter out the
columns also simultaneously.

Reply to this Message

Max - 19 May 2008 04:26 GMT

Could you upload your sample data* using a free filehost
and post a **link** to it here
*desensitized as appropriate

Eg, you could use this free filehost:
http://www.freefilehosting.net/

Copy the "direct link" which is generated after you upload your sample,
then paste the link into your reply here

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

>I have an excel with rows as area and skill levels.Columns contains names.
> I need to get a particular area and different skill levels.
[quoted text clipped - 3 lines]
> to display only skill level say 5. Can I use auto filter to filter out the
> columns also simultaneously.

Reply to this Message