How To Clear Filters In Excel

To clear filters in Excel, go to the Data tab in the toolbar, click on the Clear button, and select the Clear Filters option.

Excel is one of the most widely used tools for data analysis and organization. It provides a wide range of features to help users manipulate and filter data efficiently. Filters in Excel are a handy feature that allows users to quickly narrow down their data set based on specific criteria. However, after applying filters, it is important to know how to clear them to restore your data to its original state. In this blog post, we will walk you through the step-by-step process of clearing filters in Excel, ensuring that you have complete control over your data and can easily revert back to the unfiltered view. So, let’s get started and learn how to efficiently manage and clear filters in Excel.

How To Clear Filters In Excel: Step-by-Step


Step 1: Open Excel application

To launch Microsoft Excel, locate the Microsoft Office suite in your program list on your computer. Click on it to open, then search for the Excel application and open it to begin using its powerful features.

Next Step

Step 2: Open the File

To clear filters in Excel, open the file by clicking ‘File’ then ‘Open’ or pressing ‘Ctrl+O’. Browse to the saved location of the document.

Next Step

Step 3: Select Filtered Data

In order to identify filtered columns, simply click on any cell within the filtered column. You will notice a visible funnel icon in the column header, indicating that filters have been applied to that specific column.

Next Step

Step 4: Go to ‘Data’ Tab

In Excel, simply locate and click on the ‘Data’ tab in the top menu bar. This tab houses a range of helpful data tools such as sort and filter, which can assist in organizing and managing your data easily.

Next Step

Step 5: Clear Filter

In the ‘Sort & Filter’ group on the ‘Data’ tab, simply click ‘Clear’ to instantly remove any filters currently applied on your sheet.


In conclusion, knowing how to clear filters in Excel is a valuable skill that can save you time and effort in data analysis. By following the simple steps outlined in this blog post, you can easily remove filters from your spreadsheets and regain access to the full range of data. Whether you are working with small or large datasets, understanding how to clear filters allows you to approach your analysis with a fresh perspective and make informed decisions based on accurate and comprehensive information. So, don’t let filters hinder your productivity any longer. Take advantage of the techniques shared here and become a more efficient Excel user.

Table of Contents