Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering
Dear all,
Using the autofilter option it is possible to hide rows that contain irrelevant data to the selected filter. Is there a similar tool to hide uncessary columns? Thanking-you in advance, Neil |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering
I'll be interested to see if anyone has a way. As a possible alternative, try
to copy and paste special Transpose on another sheet, then autofilter it. This has limitations as you can only have 256 columns so if you have a lot of data it wont work. -- -John Please rate when your question is answered to help us and others know what is helpful. "Neil Pearce" wrote: Dear all, Using the autofilter option it is possible to hide rows that contain irrelevant data to the selected filter. Is there a similar tool to hide uncessary columns? Thanking-you in advance, Neil |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering
One link for horizontal filter - try Andrew Engwirda's page at:
http://blog.livedoor.jp/andrewe/archives/50283818.html There's a d/l link for a sample file on the page -- Max Singapore http://savefile.com/projects/236895 Downloads:15,700 Files:353 Subscribers:53 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering | Excel Discussion (Misc queries) | |||
Filtering by row | Excel Discussion (Misc queries) | |||
filtering | Excel Discussion (Misc queries) | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
filtering | New Users to Excel |