Forum Discussion
sorendamsgaard
Sep 08, 2021Copper Contributor
Remove filter arrows from specific columns?
How can I remove the filter arrow from some columns that should not be used as filters? I have a small sheet with 5 columns. I would like to filter all data only on one column. But of course I ha...
Juliano-Petrukio
Sep 08, 2021Bronze Contributor
Click over the column selecting all the column you want to filter and then apply filter.
BethanyFontenot
Feb 09, 2023Copper Contributor
The instructions are very vague. I'm not able to follow how you are applying filters to only some columns of a table.
Bethany Fontenot
- HowardParrMay 19, 2023Copper Contributor
That works, but only for a single column, but it cannot be used on multiple ranges. But if I set a filter on the first range, then attempt to set a filter on the second range, the filter on the first range is removed.
If I use AutoFilter then select only the column I want to turn off AutoFilter, doing so removes all filters.
Do you have any other solutions?