We often insert Table for data in Excel because the Table command has some advantages that help to understand and analyze data in a better way. Then also we need to remove the Table functionality in some cases. So I hope this article will be a quick guide to remove Table functionality from a worksheet in Excel.
Download Practice Workbook
You can download the free Excel template from here and practice on your own.
3 Ways to Remove Table Functionality in Excel
To explore the methods, I’ll use the following dataset given below which represents some salespersons’ sales in different regions.
Method 1: Use Excel Convert to Range Command to Remove Table Functionality
In our very first method, We’ll use the Convert to Range command from the Table Design tab to clear the table functionality from the worksheet. And it’s the best method to do it because other methods will not be able to remove the table functionality like this method. It will remove all the table features such as structured references, automatic expansion, inbuilt filters, etc. but will just keep the table formatting. Now let’s try the method.
Click any data on your table.
Then click through the following serial:
Table Design > Convert to Range.
Or click any cell of the table then right-click your mouse.
Later, select Table > Convert to Range from the context menu.
Soon after, a dialog box will appear to ensure your command.
Just press Yes.
Then you will see that the table functionality is gone properly and it is converted as a usual range but just the table formatting is remaining.
Read More: How to Remove Table in Excel (6 Methods)
Method 2: Use Clear Command from the Table Design Tab to Delete Table Style
This method is useful when you prefer to keep the functionality of a table but you want to keep the existing cell formatting that you set before applying the Table command. So we won’t be able to remove the table functionality completely. Only we’ll be able to remove the Table Style. That means it will only clear the Table Formatting not the custom formatting excluding table formatting that you have applied manually. All our original fonts, colors, filling, borders, etc. will remain the same.
Like the previous method, click any data from your table.
Then click as follows:
Table Design > Quick Styles > Clear.
Or click as follows:
Table Design > Quick Styles > None.
After that, you will notice that the Table Style is gone but some functionality still exists like the Filter option.
Read More: How to Remove Table from Excel (5 Easy Ways)
- How to Remove #DIV/0! Error in Excel (5 Methods)
- Remove Panes in Excel (4 Methods)
- How to Remove Header and Footer in Excel (6 Methods)
- Remove Comments in Excel (7 Quick Methods)
- How to Remove Outliers in Excel (3 Ways)
Method 3: Apply Clear Command from the Home Tab to Erase Table Format
Lastly, we’ll use the Clear command from the Home tab to erase Table Format. Actually, the Clear command will not only remove the table format but also every formatting in your data table like number formats, alignments, etc.
Click any cell within the Table.
Later, click as follows:
Home > Editing > Clear > Clear Formats.
Now all the formatting including the Table formats is removed from the data table.
I hope the procedures described above will be good enough to remove the table functionality in Excel. Feel free to ask any question in the comment section and please give me feedback.