Excel is a powerful tool for data management, and one of its most useful features is the ability to filter data. By filtering data, you can quickly and easily find the information you need, without having to manually search through rows and columns. However, once you are done with filtering, you may need to clear or remove the filter. In this blog post, we will go over the steps to clear or remove filters in Excel.
How to Clear or Remove Filter in Excel Video
How to Clear or Remove Filter in Excel
0:18 How to Recognise That Filter Is Used in Excel 0:44 How to Clear the Filter from All Columns at Once in Excel 1:06 How to Turn the Filter off in Each Column Individually in Excel 1:26 How to Remove the Filter from the Excel Table Entirely
Step 1. Open the Excel file with the filtered data.
Step 2. Go to the Data tab in the ribbon at the top of the screen.
Step 3. Look for the Sort & Filter group.
Step 4. Click on the Clear button to remove the filter from the entire worksheet.
Step 5. Alternatively, you can click on the Filter button to turn off the filter for a specific column.
Once you have cleared the filter, all of the data will be displayed in its original format.
Things to keep in mind
- Be careful when clearing filters, as this action cannot be undone.
- Always make a backup copy of your file before making any changes.
- Clearing filters will affect the entire worksheet, so make sure you only do this when you want to remove all filters.
- If you need to reapply the filter, simply click on the Filter button again and choose your filter criteria.
If you want to learn Excel then my site is here to help you weather you are an excel expert or just starting with Excel.