To remove all the filters from a table or range. Select any cell inside your table or range and, on the Data tab, click the Filter button. This will remove the filters from all the columns in your table or range and show all your data.
This May Work,
Peter