CAn Autofilter be used to hide different columns?

  • Thread starter Thread starter imail
  • Start date Start date
I

imail

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Filter more than once 2
Can I Make AutoFilter to be Case-Sensitive? 7
Display Chosen Autofilter Value 6
VBA: How can I use a string variable as autofilter criteria? 4
Hide ALL dropdowns on autofilter 15
Excel 2003 1
Filter/Hide 4
Autofilter: Does Not Contain 2

Back
Top