Skip to content

How to remove table formatting in Excel?

  • by
  • 3 min read

Microsoft Excel is a powerful data analysis, organisation, and visualisation tool. One of its handy features is the ability to format data into tables, which makes it easier to manage, sort, and filter information. However, sometimes you might want to remove table formatting to revert to the original state or apply a different formatting style.

Whether you’re working on a complex spreadsheet or a simple dataset, knowing how to remove table formatting in Excel is a valuable skill that can save you time and ensure your data is presented exactly how you want it.

In this article, we have discussed various ways to remove table formatting and keep all other table functionalities in Excel.

Also read: How to copy a formula in Excel?

Remove table formatting in Excel

If you want to remove the basic table formatting from the Exel table, follow the steps below.

Step 1: Select any cell in your table, click on the Table Design tab in the toolbar ribbon and then on the More (down arrowhead below a minus sign) button in the Table Styles section.

Step 2: In the table style, choose the first style — None; selecting the None style will remove the table formatting.

Alternate Step: In the table style, click on the Clear option available at the end of the table style.

Also read: How to poke someone on Facebook?

Remove all formatting from the table

If the above method did not remove all the formatting from the table, the remaining formatting is your custom format that was inserted manually. To remove all the formatting (predefined and custom) from an Excel table, follow the steps below.

Step 1: Click on the Home tab in the toolbar ribbon and then click on the Clear (Eraser) button in the Editing section.

Step 2: In the dropdown menu, click on the Clear Formats option.

Step 3: It will clear all the formatting from the table.

Also read: How to remove a table from Excel?

Akash Singh

Akash Singh

Akash is a law graduate who likes to go for bike rides on the weekends soul-searching for answers to his many existential questions. You can contact him here: