Now you have to change the font, theme and border color. After doing this you will see that the filters from your table disappear.After selecting Convert to Range option, you will get to see the below window.By selecting a cell from your table, you will get to see the Design Under the Design tab in the Tools section select the Convert to Range option.First, select any cell from your table.This process is much longer than the previous process. Remove Table Formatting by Converting Table to a RangeĪnother process of removing table formatting is to convert the table to a normal range and then changing the theme, font and border color. Note: In the above process, table formatting and Filtering options of the table are removed but it will still work as a table. This is how you can remove table formatting in your Excel worksheets. After this, you will see all the filters in your worksheet will be gone.You can also disable the Filter option by selecting the Filter option under the Data tab.In the Sort & Filter drop-down list, you will find that Filter command is active.Now to disable the filters, select any cell which has the filter button with it and under the Home tab select the Sort & Filter option which is placed in the Editing.You will still have the Filters which needs to be removed.
From there, select the Clear Formats option. After selecting the Clear option, you will get a drop-down list.After this press on to the Home tab and in the Editing section of Home tab look for the Clear option.After using that you need to remove the filter option also. The easiest way to clear table formatting is to use the Clear Formats option. Let`s say your table contains formatting with filters. Further Readings Remove Table Formatting with “Clear Formats” option