How to Remove a Table (Table Formatting) in Excel

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on July 10, 2023

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

table formatting cleared



When you have an Excel table, there are plenty of benefits (see Different Types of Tables), but there are plenty of reasons you might want to remove an Excel table’s formatting and/or functionality too.

Clear Formatting From an Excel Table

  1. To clear formatting from the table, highlight or select a cell within the table you wish to remove the formatting from.
  2. In the Ribbon, go to Table Design > Table Styles and then click 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 have selected a cell within an Excel data table.

tableformat design tab

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

tableformat 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

  1. To convert the Excel table to an ordinary range of cells, in the Ribbon, go to Table Design > Tools > Convert to Range.

table design convert to range

  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.
Tip: The shortcut CTRL + T creates an Excel table from a range of data.

Remove 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, go to Home > Editing > Clear > Clear Formats.

tableformat clear format

All the formatting is removed from the range of data.

tableformat format cleared

Delete Entire Table and Data

To remove an entire range of data, select the table by pressing CTRL + A and then, in the Ribbon, go to Home > Cells > Delete > Delete Cells.
tableformat delete table

  1. If your data is formatted as a table, click anywhere within the table.
  2. Press CTRL+A to select the rows.
  3. Then, press CTRL+A again to include the headers in the selection.
  4. Right-click and go to Delete > Delete Rows.

tableformat delete rows

Remove a Range Table in Google Sheets

Google Sheets doesn’t have anything like Excel’s table feature, but you might have a formatted range you want to clear the formatting from or remove entirely.

Clear Formatting

Select your data in Google Sheets, and then, in the Menu, select Format > Clear Formatting.
tableformat gs clear format

This removes the row colors from the format but doesn’t remove any number formatting applied.

tableformat gs cleared format

Delete All

  1. To remove the entire table of data, first select the table.
  2. In the Menu, go to Edit > Delete and then choose:
    • Values, if you have removed the formatting as detailed above, or
    • Rows to remove the entire row including any formatting.

tableformat gs delete table

AI Formula Generator

Try for Free

See all How-To Articles