Hiding table filter arrows

Range("$A$1").AutoFilter Field:=1, Visibledropdown:=False

https://youtu.be/E6Nj2vIvlpI
http://www.xlorate.com/excel-questio...s%20you%20Type

These example show how to hide the filter arrow

Originally Posted by Obfuscated

I know this is an old post, but someone may be able to use this bit of code.
(Uses VBA)

 Range("A3:H3").Select
    Selection.AutoFilter
    Selection.AutoFilter Field:=4, VisibleDropDown:=False
    Selection.AutoFilter Field:=7, VisibleDropDown:=False

This will put filter dropdown arrows from "A3:H3" for those people who have multiple header rows.

It will then remove the dropdown arrow from the 4th & 7th columns (D & G) so that the only columns that are filtered are A-C and E-F and H.

Hope this clears up some questions about unique filters.

This was answered in post #2

Your post title does not match with the description. Anyway, I am providing you the possible solutions without VBA.

If you are trying to set filter in one column only, but this is not the 1st column then,

1. The easiest way to do that is creating a table. Select the column, then go to Insert tab and click on Table and then ok. That's it. You can hide the arrow also. Just select the table and uncheck the Filter Button on Design tab.

2. Another way is almost manual filtering. Click on the column header, then go to Data tab. Then click on Advanced. Now check "Unique Records Only" if you wan to filter the unique records only. Then ok. Or, if you want to filter with a specific criteria then write down the criteria range. But this is the worst way I think as it is all manual.


If you want to hide the filter arrows from all columns except one then, you need VBA.