This Excel macro filters data in Excel without the filter "arrow" appearing in the column that is being filtered. This macro can be used to make a filtered data set appear more aesthetically pleasing ot to simply to try mask the fact that data has been filtered or make it harder for the user to re-filter the data in Excel.
However you want to use this macro, know that it might take some tinkering to get it to work just like you want it to work. This is because of the fact that by default the only column that wont have the filter arrow is the column that is being filtered. Also, to use the macro simply update the field number and replace "Enter Criteria Here" with your own criteria.
All of the elements below often appear within autofilter macros.
Range
Field
Criteria
Operator
Sub AutoFilter_in_Excel_No_Arrow()
'This option is a bit finicky depending on how many of the fields you want the drop-down arrow to not be displayed over.
'By default, the visibledropdown option being set to false will only remove the drop-down arrow from the frield(s) being filtered.
Range("A1").AutoFilter Field:=1, Criteria1:="Enter Criteria Here", VisibleDropDown:=False
End Sub