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

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

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