| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CAn Autofilter be used to hide different columns?
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide ALL dropdowns on autofilter | Excel Discussion (Misc queries) | |||
| Hide/Unhide columns using button on top over relevant columns | Excel Discussion (Misc queries) | |||
| autofilter does not hide unwanted results | Excel Worksheet Functions | |||
| autofilter on many columns | Excel Discussion (Misc queries) | |||
| Can I use autofilter to hide random postcodes? | Excel Worksheet Functions | |||
Threaded Mode
