Hide filter buttons
Each column header in the table below has a drop-down arrow 🔽
It was filtering the data range based on the country – the UK.
Therefore, you can see a filter icon on the country column heading (Column B).
The Excel sheet only displays filtered rows.
You may wish to hide Excel AutoFilter arrows for a variety of reasons.
For example, to keep your data table simple, to avoid mistakenly removing filters, and so on.
What happens if the table’s filtering buttons are removed? 🤔
The filtering settings will be deleted 😟
Therefore, while filtering your data range, how can each filter drop-down list be hidden?
To hide filter arrows in a filtered range, simply follow the instructions listed below 😍
- Create a criteria values table with the same column headers.
So you can filter based on that list.
In the previous example, there is a separate table with the column header “Country” and the criteria “UK”.
So, text values of the UK are filtered from the “country column in the above example without filter arrow buttons.
You can even create a filtering range with multiple criteria of many columns.
For example, you can expand your criteria values as shown below if you wish to select names from the UK, and who are under 20 years old.