How to hide filter buttons in Excel
You can watch a video tutorial here.
![](https://spreadcheaters.com/wp-content/uploads/Final-Image-How-to-hide-filter-buttons-in-Excel.png)
Excel is widely used to collect and analyze data. Many times you will need to sort and/or filter data to understand it better or to create subsets of data. Excel provides in-column buttons for sorting and filtering. Having completed the sorting or filtering operation, you may want to hide the filter buttons.
Step 1 – Hide the in-column filter buttons
![](https://spreadcheaters.com/wp-content/uploads/Step-1-–-How-to-hide-filter-buttons-in-Excel.png)
– Go to Data > Sort & Filter
– Click the Filter button
Step 2 – Check the result
![](https://spreadcheaters.com/wp-content/uploads/Step-2-–-How-to-hide-filter-buttons-in-Excel.png)
– The arrows for the in-column filters disappear