How to Remove Table Formatting in Excel (2 Easy Methods)

In this article, I am going to show you “How to Remove Table Formatting in Excel”. Sometimes it is important to remove table formatting in Excel. People often face difficulties while doing that but actually, it`s not that difficult. All you need is some set of tasks which shall be done in a sequence for removing the table formatting in Excel. Here, I will be describing two methods for achieving the goal of the task.

Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.

2 Useful Methods to Remove Table Formatting in Excel

To illustrate the methods, first, let’s take a sample table like this below.

Now we will try to remove the Table formatting of this table using two easy methods. First, Let’s learn the first method.

1. Remove Table Formatting with Clear Formats Option

Let`s say your table contains formatting with filters. The easiest way to clear table formatting is to use the Clear Formats option. Moreover, after using that you need to remove the filter option also. We can clear the format by taking two different approaches. Let’s see the first approach.

1.1 Apply Clear Format Tool from Editing Group

• First, select the entire table.

• After this press on to the Home tab and in the Editing group of Home tab look for the Clear option.

• After selecting the Clear option, you will get a drop-down list. From there, select the Clear Formats option.

• After pressing the Clear Formats option, you will see all the colors from your table have gone and it will have black font color and white background color. But, you will still have the Filters which we need to remove.

1.2 Apply Clear Table Format Tool from Table Design Tab

• You can do the same task in an alternate way. Just select any Cell>Go to Table Design tab>Go to Table Styles Group>Click On the Down Arrow

• Now, at the bottom of the menu, Select Clear Option.

• Here you will get the same result.
• 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. 
• In the Sort & Filter drop-down list, you will find that the Filter command is active. To make it inactive, just click on it.

• Alternatively, you can also disable the Filter option by selecting the Filter option under the Data tab.

• After this, you will see all the filters in your worksheet will be gone.

This is how you can remove table formatting in your Excel worksheets.

Read More: How to Remove Format As Table in Excel

Similar Readings

• Excel Table Formatting: Problems and Fixes You Need to Know
• Use Formula in an Excel Table Effectively (With 4 Examples)
• Does TABLE Function Exist in Excel?
• What is the Difference between a Table and a Range in Excel?

2. Remove Table Formatting by Converting Table to a Range

Another process of removing table formatting is to convert the table to a normal range and then change the theme, font, and border color. Unfortunately, this process is much longer than the previous process. The process of this method is as follows.

• First, select any cell from your table.

• 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.

• After selecting Convert to Range option, you will get to see the below window. Click Yes there.

• After doing this you will see that the filters from your table disappear. Now you have to change the font, theme, and border color.

• To change the theme color, select all the cells which were in the table, and under the Font section of the Home tab, select the Fill Color option and press No Fill. By pressing it, you will see the orange color from the cells disappears leaving the white theme color.

• Now for changing the font color, select all the cells of the table and press on to the Font Color option beside the Fill color option in the Home tab, and select the Automatic button which is actually the black color.

• Now select the No Borders button under the All Borders option which is under the Home tab just beside the Fill color and Font Color options.

• After doing all these you will see that the table formatting is removed from your worksheet. By doing all these the cells from the table will now look like the picture below.

Read More: Excel VBA to Create Table from Range (6 Examples)

Conclusion

Removing table formatting from Excel is an interesting and important task. In this article, I described two methods of doing that. Hopefully, after reading this article, you will not face any difficulties while removing the table formatting in Excel. Stay connected and comment below to ask any questions regarding this article.

Related Articles

• How to Make Excel Tables Look Good (8 Effective Tips)
• Excel Table Formatting Tips – Change the Look of the Table
• Excel Table Formatting: Problems and Fixes You Need to Know
• How to Make a Comparison Table in Excel (2 Methods)
• Provide Table Reference in Another Sheet in Excel
• Excel VBA Code for Each Row in a Table (Add, Overwrite, Delete, etc.)