How to Remove Format As Table in Excel (3 Quick Methods)

While working in Excel, we often apply different types of styles and formatting in table cells. Most of the time these formattings are helpful. But, at times, they can be distracting too. Fortunately, there are some very easy and quick ways to erase the format as a table in our Excel dataset. With this in mind, we will discuss 3 suitable methods to remove format as the table in Excel. Take a look at the overview of this article below for a better understanding.

Table of Contents hide

Download the Practice Workbook

3 Quick Methods to Remove Format As Table in Excel

1. Delete Format from Table Design Tab in Excel

2. Remove Format as Table from Editing Group in Excel

3. Convert Table to Range and Clear Format in Excel

Conclusion

Download the Practice Workbook

You can download the practice workbook that we have used to prepare this article.

Remove Format As Table.xlsx

3 Quick Methods to Remove Format As Table in Excel

1. Delete Format from Table Design Tab in Excel

Before removing formatting from a table, let’s create a table from a date range. Suppose, we have a data range containing fruit sales details.

To create a table from this data range just select the data and type Ctrl+T. The table will be created with default formatting.

Now, we will go through the steps to delete this formatting.

Steps:

First, select any cell of the table.
Next, go to the Table Design This is a Contextual tab, that only appears when a table cell is selected.

Then, go to the Table Styles group and click on the More icon (down to the right side scroll bar).

After that, click on the Clear option.

Finally, the table is free of all types of auto-generated formats.

Sample title

If you apply any formatting manually to the table, those won’t be removed using the above method.

2. Remove Format as Table from Editing Group in Excel

Now, we will explain another method regarding removing format from an Excel table.

Steps:

Firstly, select the entire table.

Secondly, go to the Home tab from the Ribbon.

Thirdly, go to the Editing group and click on the Clear

Then, click on the Clear Formats option from the Clear drop-down.

Lastly, all the formats from the table will be deleted.

Read more: How to Edit a Pivot Table in Excel

Similar Readings

3. Convert Table to Range and Clear Format in Excel

Sometimes we need to convert tables to data range and then clear the formats. Now, we will discuss the steps involved in that process.

Steps:

First, select any cell of the table.

Next, go to the Table Design Tab and click on Convert to Range from the Tools group.

After that, the MS Excel window will pop up to confirm the table-to-range conversion. Click Yes.

Then, the table will be converted to a data range. Yet, all the formatting is present.

Now, select the entire data range and follow the steps mentioned in Method 2.

(Go to Home > Clear (Editing Group) > Clear Formats)

Finally, here is the data range, free of any formatting.

Sample title

You can convert tables into data ranges through a right-click also. To do this, right-click any cell of the table, and then from the Table option click on Convert to Range.

Read more: How to Convert Table to List in Excel

Conclusion

In the above article, we elaborately discussed all the methods to remove format as the table in Excel. Hopefully, these methods and explanations will be enough to solve your problems. Please let me know if you have any queries. Also, you can find similar problem-solving articles on our Exceldemy website.