sodcalculator

10 Tech How-To

How to Delete or Remove a Table in Excel

Guide 10-58353 · Updated · Step by step

This guide shows you how to delete or remove a table in Microsoft Excel, whether you want to clear the data, remove the table formatting, or delete the table entirely. It covers the difference between deleting the table structure and just clearing its contents, so you can choose the method that fits your needs.

What You’ll Need

  • A computer with Microsoft Excel installed (2010 or later, including Microsoft 365).
  • An Excel workbook containing a table you want to delete or remove.
  • Basic familiarity with opening and navigating Excel files.

Step-by-Step

  1. Open your Excel workbook and navigate to the worksheet that contains the table you want to delete.
  2. Click anywhere inside the table to select it. This activates the Table Tools on the ribbon.
  3. Look at the ribbon – you’ll see a new tab labeled “Table Design” (or “Table Tools Design” in older versions). Click on it.
  4. Find the “Tools” group on the far left of the Table Design tab. Click the “Convert to Range” button. Excel will ask for confirmation with a dialog box: “Convert table to a normal range?” Click “Yes.”
  5. Your table is now a normal range – the filter arrows and the blue table formatting are gone. The data remains intact, but it’s no longer a structured table.
  6. If you also want to delete the data itself, select the range of cells that contained the table (or press Ctrl+A if you want the whole worksheet), then press the Delete key on your keyboard. This clears the contents.
  7. To remove the table entirely including its data, you can simply select the table range and press Delete. This removes both the table structure and the data, leaving blank cells.
  8. If you want to delete the entire worksheet that contains the table, right-click the sheet tab at the bottom, choose “Delete,” and confirm. This removes the sheet and everything on it.

Common Mistakes

  • Pressing Delete while only a cell is selected – This only clears that one cell, not the whole table. Always select the entire table range first.
  • Using “Clear Contents” instead of “Convert to Range” – Clearing contents removes data but leaves the table structure (filter arrows, formatting). If you want to keep the data but remove the table, use Convert to Range.
  • Deleting the worksheet by accident – Be careful when right-clicking sheet tabs; choose the correct sheet before deleting.
  • Forgetting about formulas or references – If other cells or formulas refer to the table, deleting it may break those references. Check for dependencies first.

Tips

  • Use “Convert to Range” when you want to keep the data but lose the table features like structured references and automatic formatting.
  • To quickly select the entire table, click anywhere in the table and press Ctrl+A twice – the first selects the data, the second includes the header row.
  • If you want to delete the table but keep the formatting, you can convert to range and then reapply formatting manually, but note that the automatic formatting will be gone.
  • Consider using “Undo” (Ctrl+Z) immediately if you accidentally delete something you didn’t mean to.
  • Save a backup copy of your workbook before making major changes, especially if the table contains important data.

Troubleshooting

  • “Convert to Range” is greyed out – This happens if you haven’t selected a cell inside the table. Click anywhere in the table first, then try again.
  • Table still shows after deleting – If you only cleared contents, the table structure remains. Use Convert to Range to remove the table format.
  • Formulas referencing the table break – If you delete a table that is used in formulas, those formulas will return errors. Update or remove the formulas before deleting the table.
  • Can’t delete a table because it’s part of a PivotTable – If the table is used as a data source for a PivotTable, you need to change the PivotTable’s data source first, or delete the PivotTable, then delete the table.
  • Table is on a protected sheet – If the worksheet is protected, you may not be able to delete the table. Unprotect the sheet (Review tab > Unprotect Sheet) before proceeding.

Frequently Asked Questions

What is the difference between deleting a table and clearing its contents?

Deleting a table (via Convert to Range or pressing Delete) removes the table structure, including filter arrows and formatting. Clearing contents only removes the data, leaving the table structure intact.

Can I undo deleting a table?

Yes, you can press Ctrl+Z immediately after deleting to undo the action. However, if you save and close the file, you may not be able to undo it.

Will deleting a table affect my formulas?

If your formulas reference the table (e.g., using structured references like =SUM(Table1[Column1]), deleting the table will break those formulas. You’ll need to update them to reference the new range.

How do I delete a table but keep the data?

Use the “Convert to Range” option on the Table Design tab. This removes the table formatting and features but keeps all the data in the cells.

Can I delete multiple tables at once?

Yes, you can select multiple tables by holding Ctrl and clicking in each table, but you’ll need to convert each one individually. There’s no one-click method to delete all tables in a workbook.

What happens if I delete a table that is used in a PivotTable?

The PivotTable will lose its data source and may become empty or show an error. You should first change the PivotTable’s data source to a different range, or delete the PivotTable, before deleting the table.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →