Thread: Filtering
View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

You have to filter from A:C (you can ignore D if you want).

But you need to use some code to hide the arrow in column B. The link that Ron
posted to Debra's site has some sample code.

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

JB wrote:

Here is an example of what I mean. I have data in columns A-D, but only want
a filter on A and C. Is this possible . . . or do I have to have auto filter
on A-D?????

"Ron de Bruin" wrote:

Hi JB

Do you mean that you don's see the other arrows ?
Look here
http://www.contextures.com/xlautofilter03.html#Hide


--
Regards Ron de Bruin
http://www.rondebruin.nl



"JB" wrote in message ...
Hello,

Is there a way to only us the auto filter on specified columns????

Thanks,

JB





--

Dave Peterson