To turn off AutoFiltering in Excel, follow these steps:
- Click the Data tab.
- Click the Filter button.
- Click Clear Filter from [column name].
Note: If you don't see the Filter button, click the Options button, and then check the Show Filter Button option.