When you download an Excel file from the internet, the table format may not suit your data table creation requirements. If so, you can delete the table format in Excel so you can set up another format if needed. There are many ways to delete table formatting in Excel, according to the instructions in the article below.
How to delete Excel table formatting via the Design tab
Step 1:
You open an Excel table that needs to delete formatting. Next, us Highlight the table area to be deleted format then click Design section above.
Step 2:
Next comes at Table Styles section you click arrow icon to display a menu of styles for the table. At this point you will Click Clear to delete the table style.
Immediately you will see that the table style has been deleted but the data formats in the table are still retained.
How to completely remove Excel table formatting
When you completely delete an Excel table format, all table styles and formats for data in the table will also be completely deleted.
We will Press Ctrl + A to quickly select the entire table. Next, click Clear icon at the corner as shown. You will now see a number of options to delete Excel table formatting including:
- Clear Formats: Clear formats without deleting data.
- Clear All: Delete all formats, including deleting the data table.
Here we will Click Clear Formats to remove Excel table formatting completely.
Delete Excel table format with data area
The Excel data area will help you remove some special formatting such as data filtering symbols while still retaining the data in the table.
Step 1:
At the Excel table interface, click Right click on any cell Which is in the table? Select Table in the displayed listpoop, choose next Concert to Range to convert to data area format.
Step 2:
Display a pop-up asking if you are sure you want to switch to area format, Click Yes to proceed.
As a result, you will see that the filter icon is no longer displayed in the table.
Step 3:
Next we click Clear icon then select continue Clear Formats to remove formatting in an Excel table.
How to delete Excel table formatting using VBA
When running a VBA command, all custom operations with the table are performed automatically, including deleting table formatting.
Step 1:
We press Key combination Alt + F11 to open the VBA interface in Excel. Next we right click on the existing module Select Insert and then click Module.
Step 2:
Show interface to Enter VBA code according to the content below.
Sub RemoveFormatAsTable()
Dim tbl As ListObject
' Check if the active cell is within a table
If ActiveCell.ListObject Is Nothing Then
MsgBox "Active cell is not within a table.", vbExclamation
Exit Sub
End If
' Set tbl to the table of the active cell
Set tbl = ActiveCell.ListObject
' Remove the table format
tbl.Unlist
MsgBox "Format as Table removed successfully.", vbInformation
End Sub
Continue press F5 to run the entered command. Now you see the interface as shown Click RemoveFormatAsTable already in the interface Click Run to run the delete table format command.
How to delete Excel table format on phone
You need to take a few more steps to remove formatting in Excel on your smartphone or tablet. However, the process is still quite easy. Here are the steps you need to follow:
- Highlight the areas you want to remove formatting from.
- Click the three-dot icon on the bottom toolbar.
- Scroll down Clear and select this option to display the options list.
- Click Clear Formats. The contents in the table will then return to default.

After deleting Excel table formatting, you can easily reorganize the spreadsheet if needed. And if you decide you don't want to remove the table formatting, you can always undo the process easily.