| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
restrict columns that have auto filter
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
restrict columns that have auto filter
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 "Patricia" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto filter columns while keeping groups of verticle cells togethe | Excel Discussion (Misc queries) | |||
| I need a specific value in auto filter to fill a combo box and than match the select value in 2 other columns. | Excel Worksheet Functions | |||
| Suggestion to add Auto Filter option for columns | Excel Worksheet Functions | |||
| Restrict-Filter-Limit-Validate user input in Excel | Excel Discussion (Misc queries) | |||
| can i restrict data entry from certain columns | Excel Discussion (Misc queries) | |||
Linear Mode
