How To Delete A Table In Excel

To delete a table in Excel, select the entire table range and press the ‘Delete’ key on your keyboard. The table will be removed from the worksheet.

Excel is a powerful tool for organizing and analyzing data. However, there may come a time when you need to remove a table from your Excel worksheet. Whether you no longer need the data or want to make room for a new table, knowing how to delete a table in Excel is an essential skill for any Excel user. In this blog post, we will guide you through the step-by-step process of deleting a table in Excel, so you can confidently manage your data and streamline your workspace.

How To Delete A Table In Excel: Step-by-Step


Step 1: Selecting the Table

To delete a table in Excel, open the worksheet and select any cell within the table you want to remove. This helps Excel recognize the specific table you are referring to.

Next Step

Step 2: Open Design Tab

After selecting the table, you will find a new tab called “Design” on the menu bar. Click on it to reveal its contents and access additional customization options for the table.

Next Step

Step 3: Navigate to Table Tools

Under the Design tab, towards the far left, there is a “Table Tools” option where you can access a range of related tools. Click on it to open up and explore the available features.

Next Step

Step 4: Select “Convert to Range”

In the “Table Tools” section, you will find the “Convert to Range” option. Simply click on this option to convert the selected table into a regular range format.

Next Step

Step 5: Confirm Conversion

After choosing to convert the table to a regular range, a dialogue box will appear seeking confirmation. Simply click on “Yes” to proceed with the conversion process.

Next Step

Step 6: Clear Content

Once the table is converted to a range and the cells are selected, right-click and choose “Clear Contents” to delete the rows, columns, table data, design, and layout.

Next Step

Step 7: Deleting Rows or Columns (if required)

To remove a row or column in a spreadsheet, simply click its header to select it, right-click, and choose the ‘Delete Row’ or ‘Delete Column’ option. This action will delete the selected row or column from the spreadsheet.


Deleting a table in Excel is a simple process that can help you organize and manage your data effectively. By following the step-by-step instructions provided in this article, you now have the knowledge and confidence to remove unwanted tables from your spreadsheets. Remember to save your work regularly and double-check your actions when deleting a table to avoid any unintended consequences. With this newfound skill, you can keep your Excel documents neat and streamlined, making it easier to analyze and interpret your data. Excel’s versatility and functionality are further enhanced when you have the ability to remove tables efficiently. So go ahead and put this knowledge into practice, and enjoy the benefits of a clutter-free Excel experience.

Table of Contents