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

Get FREE Advanced Excel Exercises with Solutions!

While working in Excel, we often apply different types of styles and formatting in table cells. Most of the time, these formats 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 the format as the table in Excel. Take a look at the overview of this article below for a better understanding.

remove format as table in excel


Remove Format As Table in Excel: 3 Quick Methods

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 Table Design. This is a Contextual tab that only appears 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.

Delete Format from Table Design Tab in Excel

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

Output

Note:

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

Read More: How to Remove Table in Excel


2. Remove Format as Table from Editing Group in Excel

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

Steps:

  • First, select the entire table.

Remove Format from Editing Group in Excel

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

Editing Group in Excel

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

Clear Feature

  • After that, 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.

Removing Format from Editing Group in Excel Output

Read More: How to Remove Table Functionality in Excel


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 Microsoft 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

  • 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

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

Convert Table to Range and Clear Format in Excel Output

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

Accessing Table Options

Read more: Excel Table Formatting Problems


Download the Practice Workbook

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


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.


Further Readings


<< Go Back to Change Table Style | Make an Excel Table | Excel Table | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Hosne Ara
Hosne Ara

Hosne Ara is a materials and metallurgical engineer who loves exploring Excel and VBA programming. To her, programming is like a time-saving superhero for dealing with data, files, and the internet. She's skilled in Rhino3D, Maxsurf C++, MS Office, AutoCAD, and Excel & VBA, going beyond the basics. With a B. Sc. in Materials and Metallurgical Engineering from Bangladesh University of Engineering and Technology, she's shifted gears and now works as a content developer. In this role, she... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo