Remove filter arrows from specific columns?

%3CLINGO-SUB%20id%3D%22lingo-sub-2731991%22%20slang%3D%22en-US%22%3ERemove%20filter%20arrows%20from%20specific%20columns%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2731991%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20can%20I%20remove%20the%20filter%20arrow%20from%20some%20columns%20that%20should%20not%20be%20used%20as%20filters%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20small%20sheet%20with%205%20columns.%20I%20would%20like%20to%20filter%20all%20data%20only%20on%20one%20column.%20But%20of%20course%20I%20have%20to%20select%20all%20data%20as%20part%20of%20the%20filter%20data.%20By%20doing%20this%2C%20I%20get%20filter%20arrows%20on%20all%20columns%20in%20the%20data%20range.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20I%20in%20some%20way%20hide%20the%20filter%20arrows%20from%20the%20columns%20that%20are%20not%20used%3F%20Or%20is%20it%20all%20or%20nothing%2C%20when%20using%20filters%20like%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20hurts%20my%20eye%20having%20filter%20arrows%20in%20the%20columns%20that%20are%20just%20plain%20tekst%2C%20comments%20or%20other%20data%20that%20are%20not%20used%20as%20filters.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20you%20get%20my%20question%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2731991%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2732008%22%20slang%3D%22en-US%22%3ERe%3A%20Remove%20filter%20arrows%20from%20specific%20columns%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2732008%22%20slang%3D%22en-US%22%3EClick%20over%20the%20column%20selecting%20all%20the%20column%20you%20want%20to%20filter%20and%20then%20apply%20filter.%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
New Contributor

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

3 Replies
Click over the column selecting all the column you want to filter and then apply filter.
I know how to create a filter already, that's not my question.
I want to remove the filter arrow from the columns that should not be used as filters, and only leave the filter arrow to the one column that should be used.

@sorendamsgaard 

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.

 

 

Untitled.png