How to hide filter buttons in Excel

You can watch a video tutorial here.

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

– Go to Data > Sort & Filter
– Click the Filter button

Step 2 – Check the result

– The arrows for the in-column filters disappear