How to Remove Format As Table In Excel

In this article, we will discuss how to remove format as the table in Excel. Often, while working in Excel, we 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 remove format from tables.


Download the Practice Workbook

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


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.

Delete Format from Table Design Tab in Excel

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

Delete Format from Table Design Tab in Excel

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, only appearing when a table cell is selected.

Delete Format from Table Design Tab in Excel

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

Delete Format from Table Design Tab in Excel

  • After that, click on the Clear option.

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

Note:

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.

Remove Format from Editing Group in Excel

  • Secondly, go to the Home tab from the Ribbon.

Remove Format from Editing Group in Excel

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

Remove Format from Editing Group in Excel

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

Remove Format from Editing Group in Excel

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


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.

Convert Table to Range and Clear Format in Excel

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

Convert Table to Range and Clear Format in Excel

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

Convert Table to Range and Clear Format in Excel

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

Convert Table to Range and Clear Format in Excel

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

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

Convert Table to Range and Clear Format in Excel

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

Note:

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 the Convert to Range.


Conclusion

In the above article, I have tried to discuss all the methods elaborately. Hopefully, these methods and explanations will be enough to solve your problems. Please let me know if you have any queries.


Related Articles

How to Remove Table Formatting in Excel (2 Smart Ways)

Excel Table Formatting Tips – Change the Look of the Table

How to Make Excel Tables Look Good (8 Effective Tips)

Hosne Ara

Hi, This is Hosne Ara. Currently, I do write for ExcelDemy. I have a long experience working with different industries and I have seen how vast the scope of Microsoft Excel is. So, eventually, I started to write articles on Excel and VBA. Basically, my articles are targeted to help people who are working in Excel. By profession, I am an Engineer. Materials and Metallurgical Engineering is my major. Besides, I am a certified Project Manager (PMP) too. I have worked with Power Plant and IT industry earlier. As a person, I am detail-oriented and love doing research. Establishing a greener world is one of my mottos.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo