How to remove filters from table headers in Excel

This tutorial is about the steps required to remove the column filters from the table headers in Excel 2016, 2013 & 2010. Having filters is useful when you filter the values based on different criteria. But if you do not wish to use this feature then turn off this feature using the options available as part of Home or Data menu

Data menu

Click the Data menu and navigate to Sort & Filter section. Click the Filter toggle switch to turn on or off the feature.


Home menu

Click the Home menu and navigate to Editing section. Then select Filter option available under Sort & Filter menu drop down list to turn on or off the Table column filters.


In Category: Excel 2010, Office 2010

Ravi Shankar

A Software developer and blogger who is always looking to provide technical help to the wider community.

Show 0 Comments
No comments yet. Be the first.

Leave a Comment

Get your free copies of the following tech guides by joining the Digital Answers mailing list.