How to Remove a Table (Table Formatting) in Excel

This tutorial demonstrates how to remove a table or table formatting in Excel.

 

table formatting cleared

 

Clear Formatting From an Excel Table

The table feature is an excellent way to work with data in Excel and has some incredibly powerful features that enable you to easily manipulate your data, such as pivot tables and filtering. When your data is put into a table, it is usually formatted with one of the built-in table styles that Excel contains.

If you import data into Excel, or link to a database, the data comes into Excel automatically formatted as a table. Alternatively, if you create a table from a range of data, Excel also automatically formats the data.

 

table formatted

 

Tip: To create a table from a range of data, highlight the range and press CTRL + T.

  1. To clear formatting from the table, highlight or click in the table you wish to remove the formatting from.
  2. In the Ribbon, select Table Design > Table Styles and then click on the little down arrow at the bottom right-hand corner of the group.
    Note that the Table Design tab of the Ribbon is a contextual tab and is only visible when you are clicked in an Excel data table.

 

table table styles

 

  1. Click on Clear at the bottom of the list shown.

 

table table styles clear style

 

The formatting is removed, but the data is still retained as a table. The Table Design tab of the Ribbon is still visible.

 

table design ribbon

 

Remove an Excel Table

To convert the Excel table to an ordinary range of cells, follow these steps:

  1. In the Ribbon, select Table Design > Tools > Convert to Range.

 

table design convert to range

 

Alternatively, right-click somewhere in your table, and then select Table > Convert to Range.

 

table design right click

 

  1. Click Yes to convert to a range.

 

table design convert to range yes no

 

The Table Design tab in the Ribbon is no longer visible when clicked in the set of data.

Removing Formatting From a Range

If you convert a formatted table to a range, the formatting remains.

  1. To remove the formatting from the range, select the entire range of data.

 

table format select all

 

  1. In the Ribbon, select Home > Editing > Clear > Clear Formats.

 

table format clear format

 

All the formatting is removed from the range of data.