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