Clear filter by condition or cell fill color

To clear the filter applied to a column by condition or fill color without resetting the sorting, follow this steps:

1.Click /  Sort and filter.

2.In the window that opens, select By value filtering type.

3.Click Apply.

To clear the filter by condition or fill color applied to a column along with sorting:

1.Click /  Sort and filter.

2.In the window that appears, click Clear.