How to Delete a Table in Excel (With Examples)


There are two common ways to delete a table in Excel:

Method 1: Delete Table Without Losing Data

Method 2: Delete Table Including Data

The following examples show how to use each method in practice with the following table in Excel:

Example 1: Delete Table Without Losing Data

To delete a table without actually deleting the data values, first click any cell in the table.

Next, click the Table Design tab along the top ribbon, then click the icon called Convert to Range within the Tools group:

This will convert the table to a normal range of data. However, the format with the alternating blue lines will still be present.

To remove this formatting, highlight each cell in the range A1:C10 and then click the Cell Styles icon in the Styles group on the Home tab. Then click Normal:

The formatting will automatically be removed from the cells:

We have successfully deleted the table without actually deleting the data from the cells.

Example 2: Delete Table Including Data

To delete an entire table including the data, first highlight the entire table range A1:C10, then click the Clear icon within the Editing group on the Home tab.

Then click Clear All from the dropdown menu:

The entire table including the data will be deleted from the Excel sheet:

Additional Resources

The following tutorials explain how to perform other common tasks in Excel:

Excel: How to Delete Rows with Specific Text
Excel: How to Delete Filtered Rows
Excel: How to Delete Calculated Field in Pivot Table

Leave a Reply

Your email address will not be published. Required fields are marked *