Question

what are the different ways in which you can remove the filter from a column ?

Answer 1

Click the Filter button next to the column heading, and then click Clear Filter from <"Column Name">. For example, the figure below depicts an example of clearing the filter from the Country column. Note: You can't remove filters from individual columns. Filters are either on for an entire range, or off.

Answer 2

Answer:

Go to the Data tab > Sort & Filter group, and click Clear. Go to the Home tab > Editing group, and click Sort & Filter > Clear.