How to Reset the Autofilter Area in MS Excel

1. Open the worksheet in which you would like to clear the filter.
2. Click the 'Filter' button on the column heading. It looks like a funnel in Row 1.
3. Click 'Clear Filter from
.' For example, if you have a filter in column A, click 'Clear Filter from A.'