How To Delete Table In Excel

To delete a table in Excel, select the table, right-click on it, and choose the “Delete” option.

In today’s digital age, Microsoft Excel has become an indispensable tool for organizing and analyzing data. With its vast array of features and functionalities, Excel allows users to create and manipulate tables effortlessly. However, at times, you may find yourself needing to delete a table in Excel. Whether it’s to eliminate redundant data, make room for a new table, or simply reorganize your spreadsheet, knowing how to delete a table can greatly enhance your productivity. In this blog post, we will explore various methods and techniques to effectively delete tables in Excel, providing you with the knowledge and confidence to streamline your data management tasks. So, let’s dive in and master the art of removing tables in Excel.

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


Step 1: Select the Table

To delete the correct table in the Excel file, simply click anywhere inside the desired table. This step is crucial to avoid mistakenly deleting other data.

Next Step

Step 2: Table Tools

Once you have selected the table, click on the Design tab under Table Tools on your Excel toolbar to access additional options and features for the table formatting and design.

Next Step

Step 3: Convert to Range

This option allows you to convert a table in the Design tab under Table Tools to a range in Excel. A dialog box may appear seeking confirmation, simply click ‘Yes’.

Next Step

Step 4: Delete Data

Once your table is in a regular range format, you can easily delete it using the ‘delete’ key on your keyboard. This will remove all the data including text, formulas, and more, while retaining formatting details like cell color and font color.

Next Step

Step 5: Delete Remaining Formatting (if necessary)

To remove all remaining cell formatting in Excel, select the cells with deleted table data, go to the Home tab, click “Clear” > “Clear Formats”. Note that this removes all formatting.


In conclusion, deleting a table in Excel may seem like a daunting task at first, but with the right knowledge and tools, it can be a quick and straightforward process. By following the steps mentioned in this blog post, you can confidently delete tables in Excel without any hassle.

Remember to always review your data and make a backup before deleting a table to ensure that you do not accidentally lose any important information. Additionally, familiarize yourself with the different methods of deleting tables, such as using the Table Tools Design tab or converting the table back to a range.

Whether you are cleaning up your data or reorganizing your spreadsheet, knowing how to delete a table in Excel is an essential skill that will streamline your work process and make your data management more efficient.

So go ahead and put your newfound knowledge into practice. Start deleting tables in Excel confidently and effortlessly, making your spreadsheets more organized and visually appealing. Good luck!

Table of Contents