restrict columns that have auto filter

G

Guest

Is it possible to only have the autofilter on 1 column? I have offices in
coumn A and then dates in B through Z. The users do not need to filter on B
through Z but do on A - is there a way to only show the autofilter on column
A ?
Thanks
 
G

Guest

Just make sure that only Column A is selected when you turn on the AutoFilter.

The one problem you might run into by doing this is if you use the
AutoFilter to sort your data. By default, only column A would be sorted, but
Excel should prompt you whether to include adjacent data or not.

HTH,
Elkar
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filter/Hide 4
how to filter spreadsheet by multiple variables? 5
Auto-filter selection 1
Filter for "blanks" in multiple columns simultaneously 2
Using the Median function with Auto-filter 1
column filter 1
Dynamic autofilter field 2
Multiple criteria for filters 4

Top