Hiding table filter arrows

[torch0395]

Is there a way to hide the arrows except for one of the columns. I know if I take it off filter it will hide all the arrows but I just need one of the columns to be able to filter the data. Thanks for any help

[davesexcel]

Please Login or Register  to view this content.

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

These example show how to hide the filter arrow

[sanram]

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.

[torch0395]

that was perfect. repped

[Obfuscated]

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

Please Login or Register  to view this content.

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.

[davesexcel]

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

Please Login or Register  to view this content.

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