CAn Autofilter be used to hide different columns?

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

Max

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

Excel 2003 1
VBA: How can I use a string variable as autofilter criteria? 4
Autofilter 1
Auto-filter selection 1
Excel 2003: Autofilter with Multiple Entries 1
Problem with filtering columns in Excel 2007 1
Filter/Hide 4
Can I Make AutoFilter to be Case-Sensitive? 7

Top