How to remove table in excel

Microsoft Excel offers some very interesting ways to remove either the entire table or just the table formatting in excel.  We can use these functionalities of excel to our use and in turn remove the table. We can perform the below mentioned 2 ways to get rid of a table in excel:

• Removing the entire table
• Removing the table format and keeping the data

We’ll learn about each of these options step by step.

Option 1- Removing the entire table:

Option-1 (Step-1): Ideal table in excel

To do this yourself, please follow the steps described below;

• Open the desired Excel workbook in which you want to enable this feature and make sure you have a table in it
• Now select the entire table by clicking on any cell in the first row, i.e., the heading row, and then press “CTRL + A”, this will highlight the entire table.

Option-1 (Step-2): Selecting the entire table in excel

• Now go to the “Home” section on the menu bar in excel, and then go to the “Editing” pane. Click on the “Clear” option here.

Option-1 (Step-3): Selecting the Clear option in Editing pane in the Home menu

• Now select the “Clear All” option to remove the entire table

Option-1 (Step-4): Selecting the “Clear All” option

• All the contents are cleared and the table is removed as we can see in the image below.

Option-1 (Final Image): Table removed

• Alternatively, we can use the excel shortcut to clear the entire table as well. To perform this, go to the first row, i.e. the header, and click “CTRL + A” to select the entire table. Now press “ALT + H + E+ A”. This will perform the same activity as we did in the above mentioned steps.

Option 2 – Removing the table format and keeping the data:

Let’s get started with the second option. This option allows us to remove the table format, but lets us keep the original contents of the table .

Option-2 (Step-1): Ideal table in excel

To do this yourself, please follow the steps described below;

• Open the desired Excel workbook in which you want to enable this feature and make sure you have a table in it
• Now select the entire table by clicking on any cell in the first row, i.e., the heading row, and then press “CTRL + A”, this will highlight the entire table.

Option-2 (Step-2): Selecting the entire table in excel

• Now go to the “Home” section on the menu bar in excel, and then go to the “Editing” pane. Click on the “Clear” option here.

Option-2 (Step-3): Selecting the Clear option in Editing pane in the Home menu

• Now select the “Clear Formats” option to remove the formatting of the table

Option-2 (Step-4): Using the Clear Formatting option in excel

• Now we will be able to see that the table format has been erased completely, and the data is still present as it was before.

Option-2 (Final Image): Table format removed

• Alternatively, we can use the excel shortcut to clear the entire table as well. To perform this, go to the first row, i.e. the header, and click “CTRL + A” to select the entire table. Now press “ALT + H + E+ F”. This will perform the same activity as we did in the above mentioned steps.