How to Hide Filter Buttons in Excel

- Written by Puneet

Hide Filter Buttons

In Excel, if you want to hide the filter buttons, you need to use the Advanced Filter. The Advanced filter allows you to filter data without showing the buttons on the column’s header cell.

And in this tutorial, we will learn this method in a simple but detailed way. So, let’s get started.

We have data with dates and amounts. You need to filter data where the amount is less than 1500.

Steps to Filter Hide Buttons in Excel

  1. First, go to the Data tab and click the “Advanced” button to open the Advanced Filter dialog box.
    2-go-to-data-and-select-advanced-1
  2. You will see the Advanced filter dialog box when you click the “Advanced” button. In this dialog box, you have a few options to specify.
    3-advanced-filter-dialog-box-1
  3. After that, in the dialog box, you need to select the range for the List range. This range is where you have the actual data.
  4. Next, specify the criteria in the criteria range input box. For this, refer to the range A1:A2. In this range, we have the column heading and the criteria (lower than 1500).
    4-select-list-range-and-criteria-range-1
  5. In the end, when you click OK, the data is filtered using the criteria you specified in the dialog box.
    5-click-ok-and-filter-the-data-1

The above snapshot shows that it has filtered all the rows where the value in the amount column is below 1500. You can also use multiple filters to filter the data.

Clear Filter

Once you apply the advanced filter, you can remove it. To do so, click the “Clear” button on the Data Tab > Sort & Filter.

You can also use the keyboard shortcut, Ctrl + Shift + D. This shortcut removes the advanced filter and applies the normal filter.

Get the Sample File