Sep 08 2021 04:10 AM
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 have to select all data as part of the filter data. By doing this, I get filter arrows on all columns in the data range.
Can I in some way hide the filter arrows from the columns that are not used? Or is it all or nothing, when using filters like this?
It hurts my eye having filter arrows in the columns that are just plain tekst, comments or other data that are not used as filters.
I hope you get my question?
Thanks
Sep 08 2021 04:18 AM
Sep 08 2021 04:38 AM
Sep 08 2021 04:44 AM
I understood.
What I meant is, Lets say you just want to apply filter on column A.
By selecting the whole column A, instead more columns the filter will be applied only on that column.
Feb 09 2023 07:01 AM
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
May 19 2023 06:59 AM
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?
Jul 19 2023 02:05 PM
You very clearly did not understand his question. It would be most helpful for you to cease attempts at assisting others seeking advanced advice. Thank you. @Juliano-Petrukio