How to Remove Filter by Color in Excel (5 Methods)

We have a dataset where we already applied Filter by Color. We want to remove the Filter by Color execution. In this case, we only applied the Filter for the City Column.

Dataset-How to Remove Filter by Color in Excel


How to Remove Filter by Color in Excel: 5 Easy Ways


Method 1- Using the Filter Icon Option to Remove Filter by Color

  • Click on the Filter Icon.
  • Choose Clear Filter From “City”. As only the City column is subjected to filtration, Excel only allows the defiltration of data from that column.

Filter Icon-How to Remove Filter by Color in Excel

  • Excel clears the Filter by Color or any other filtration and returns the data as it was prior to the filtration.

Filter Icon result


Method 2 – Using the Clear Feature

  • Go to Data.
  • Select Clear from the Sort & Filter section.

Clear Feature-How to Remove Filter by Color in Excel

Excel delivers similar results as in Method 1.

Filter Icon result


Method 3 – Using the Clear Option to Remove Filter by Color

  • Go to Home.
  • Select Sort & Filter (from the Editing section).
  • Select Clear.

Clear Option-How to Remove Filter by Color in Excel

Here’s the result.

Filter Icon result


Method 4 – Using Keyboard Shortcuts

  • Press Alt + D.
  • Press F and then another F.

Keyboard shortcuts-How to Remove Filter by Color in Excel

Here’s the result.

Keyboard shortcuts result


Method 5 – Unselecting Filter to Remove Filter by Color

  • Go to Home.
  • Select Sort & Filter (from the Editing section).
  • Deselect Filter.

Deselecting Filter-How to Remove Filter by Color in Excel

  • Alternatively, hover to the Data tab and deselect Filter (from the Sort & Filter section).

Deselecting filter

Both options clear any Filter operations applied to the worksheet.

Keyboard shortcuts result


Download the Excel Workbook


<< Go Back to Color Filter | Filter in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Maruf Islam
Maruf Islam

MARUF ISLAM is an excellent marine engineer who loves working with Excel and diving into VBA programming. For him, programming is like a superhero tool that saves time when dealing with data, files, and the internet. His skills go beyond the basics, including ABACUS, AutoCAD, Rhinoceros, Maxsurf, and Hydromax. He got his B.Sc in Naval Architecture & Marine Engineering from BUET, and now he's switched gears, working as a content developer. In this role, he creates techy content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo