Sometimes we need to remove a table from the worksheet in Excel although it makes the worksheet dynamic. We can also remove the table formatting style. In this article, we are going to see how to remove a table in Excel with some easy examples and explanations.
Practice Workbook
Download the following workbook and exercise.
6 Quickest Methods to Remove Table in Excel
1. Excel Remove a Table by Converting to Range
We can remove the table by converting it to the regular range. Here the values inside the table will remain the same as before. Assuming we have a dataset containing a table (B4:E9) of different project expenses. We are going to remove the table.
STEPS:
- In the Excel table, select any cell at first.
- Next, go to the Table Design tab.
- Now select the ‘Convert to Range’ option from the Tools group.
- We can see a confirmation box on the screen.
- Then click on the Yes.
- Finally, the table is removed and it is converted into range.
Read More: How to Remove Table from Excel (5 Easy Ways)
2. Remove Excel Table without Formatting
Here we have a dataset containing a table (B4:E9) of different project expenses. The table does not contain any formatting. So we are going to remove the table style from this table.
STEPS:
- First, select the header of the table and press ‘Ctrl+A’. This helps us to select the whole table. We can do this by selecting a non-header cell and pressing ‘Ctrl+A’ twice. We can also select all the cells by dragging them with a mouse.
- Now go to the Home tab.
- Then from the Cells group, select the Delete drop-down.
- Next Click on the ‘Delete Table Rows’.
- In the end, we see that the table is removed with all the data.
3. Remove Excel Table with Formatting
Let’s say we have a table (B4:E9) of different project expenses with formatting. We are going to remove the table.
A format has been applied in this table. So if we simply press the ‘Delete’ key after selecting the entire table, the formatting will remain like the below picture. To avoid this problem, we have to follow some steps.
STEPS:
- In the beginning, select the whole table like the previous method.
- Next, go to the Home tab.
- From the Editing group, click on the Clear drop-down.
- Now select ‘Clear All’.
- Finally, we can see that the table is removed with all of its data.
Related Content: How to Remove Conditional Formatting in Excel (3 Examples)
Similar Readings
- How to Remove Print Lines in Excel (4 Easy Ways)
- Remove Strikethrough in Excel (3 Ways)
- How to Remove Data Validation in Excel (5 Ways)
- Remove Password from Excel (3 Simple Ways)
- How to Remove Leading Zeros in Excel (7 Easy Ways + VBA)
4. Keyboard Shortcut to Remove Table in Excel
We can use a keyboard shortcut for removing a table in excel. For that, select the whole table at first. Then from the keyboard press ‘Alt’. After succession press the ‘H’ key which takes us to the Home tab. Next press the ‘E’ key and this takes us to the Clear drop-down from the Editing group. Now press the ‘A’ key which indicates the ‘Clear All’ option and this clears the whole table with data.
5. Excel Remove Table Formatting While Keeping the Data
Sometimes we need to keep the data of the table but not the table formatting. Here we have a dataset containing a table (B4:E9) of different project expenses. We are going to keep only data and remove the table formatting.
STEPS:
- First, select any cell in the Excel table.
- Now go to the ‘Table Design’ tab.
- From the Table Styles group, click on the more icon at the right-bottom of the group.
- Next click on the ‘Clear’ option.
- In the end, this will remove the Excel table formatting. We can see the filters option is available still. This removes only the formatting and keeps the data as before.
Read More: How to Remove Table Functionality in Excel (3 Methods)
6. Clear Formats’ Option to Remove Excel Table Formatting
‘Clear Formats’ is an Excel built-in option. This removes all the formats on a dataset. So we can use this option for the below dataset containing a table (B4:E9) of different project expenses.
STEPS:
- Select any cell in a table at first.
- Now go to the Home tab.
- Then click on the Clear drop-down from the Editing group.
- After that, select the ‘Clear Formats’ option.
- Finally, we can get the dataset as below. It removes all the formats like all the alignments, number formats, etc.
Read More: How to Remove Formatting in Excel Without Removing Contents
Conclusion
By using these ways, we can easily remove a table in Excel. There is a practice workbook added. Go ahead and give it a try. Feel free to ask anything or suggest any new methods.
Related Articles
- How to Remove Decimals in Excel (13 Easy Ways)
- Remove Subtotals in Excel (2 Easy Tricks)
- How to Remove Checkboxes from Excel (5 Easy Ways)
- Remove Numbers from a Cell in Excel (7 Effective Ways)
- How to Remove Carriage Returns in Excel: 3 Easy Ways