Microsoft Excel is a crucial tool for handling and studying data. One of its standout capabilities is creating tables, which not only enhance the look of your data but also provide extra functions like sorting, filtering, and organising. Yet, there could be instances where you want to delete a table due to alterations in data design or style preferences.
In this article, we discussed how to add a table and remove a stable in Excel in a few simple and easy steps.
Also read: How to move a row in Excel?
How to add a table in Excel?
If you wish to create a table in your spreadsheet, then follow the steps below.
Step 1: Open your Excel document, select the cells and click on the Home tab in the toolbar ribbon and then click on the Format as Table button in the Style section.
Step 2: You will see a variety of table styles provided by Excel, choose any table style that you see fit for your data.
Step 3: A create table box will appear, If you have headers in your table then checkmark the box beside My table has headers and then click on the OK button.
Step 4: Your table will be created in the style you have chosen.
Also read: How to add borders in Excel?
Remove a table and the data with it from Excel
If you want to know how to remove a table and the data in the table from your spreadsheet in Excel then follow the steps below.
Step 1: Open your Excel document, select the cells and click on the Home tab in the toolbar ribbon and then click on the Clear button in the Editing section located at the extreme right of the toolbar.
Step 2: In the dropdown menu, click on the Clear All option.
Remove a table without losing the data with it from Excel
To remove a table without losing the data in it from Excel, follow the steps below.
Step 1: Select the cells and click on the Table Design and then click on the Convert to Range button in the Tools section.
Step 2: Click on the Yes button.
Step 3: Notice that the dropdown filters, sorting choices, and organised labels are gone. Also, even though the table is no longer there, the formatting style stays the same. To remove the formatting style, click on the Home tab and then click on the Clear button.
Step 4: In the dropdown menu, click on the Clear Formats option.
Also read: How to hide and unhide rows in Excel?
