How to hide filter buttons in Excel
By
SpreadCheaters
Page last updated:
17/11/2022 |
Next review date:
17/11/2024
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
