Question

Filter can be removed by clicking on button in Sort & Filter group of MS Excel 2007.​

Answer 1

Answer:

Turning Off the AutoFilter

From the Data command tab, in the Sort & Filter group, click Filter. AutoFilter is disabled; the AutoFilter buttons are removed from the Table.

Answer 2

Answer:

Select a cell within the Table. » deselect Filter. From the Data command tab, in the Sort & Filter group, click Filter. AutoFilter is disabled; the AutoFilter buttons are removed from the Table.