Excel 2007 Filter

[marina p.]

Hello everyone,

I feel really silly asking this question, but I'm stuck! I am trying to add Filter to columns D,E and R. I have no trouble with the D and E because they are adjoining and can be selected together. But as soon as I also select R the message appears that Filter can't be used on multiple selections. I've used that tool hundreds times before, but not in Excel 2007.

Appreciate any thoughts

Marina

[benishiryo]

hi marina, Autofilter can only have 1 continuous range in 1 worksheet. u'll have to select from D-R

[marina p.]

Thanks Benishiryo. But what if I don't want the filter buttons on every column between D and R? Any way around it?

[JosephP]

you could move or copy column R so it's next to col D?

[benishiryo]

not that i know of. is it just a presentation issue? u may cut column R to paste after column D & now just do an Autofilter for D-F it that is ok

[mmmarks]

Hi
I think there is a way but I dont know what exatent It will help You

As you told you , you are using excel 2007
then just select those two column and press CTRL+T
and just select single colum that's is E colum and press CTRL+T

You can see auto filter.

[JosephP]

I'm not sure I'd recommend making parts of the data into separate tables

[marina p.]

Thanks everyone, I'll try your suggestions, at least I know this is as good as it gets.

Marina:-)