Excel Question

[Anna22]

Hi
I have an excel spreadsheet and i only want to give the user a filter on a few of the columns. The autofilter function works great but applies the filter to every column is there a way of removing the filter off some of the columns?

Any help would be greatly appreciated

Cheers Anna

 

[SkipVought]

Hi,

Sure. Just select the column(s) and turn on the AutoFilter.



Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[Anna22]

Thanks for the reply, that worked great. Howvere is there a way of selecting columns which arent consecutive?

Cheers

 

[xlbo]

AFAIK - no I'm afraid - you can filter all columns or one column or a set of consecutive columns. A workaround may be to re-order your data so all the filterable columns are together....

Rgds, Geoff
It's Super Happy Campo Funtime!
Want the best answers to your questions ? - then read me baby one more time - faq222-2244