How to Remove Table and Table Formatting in Excel
Excel Table is a fantastic feature that makes working with data very simple. As more advanced tools such as Power Query and Power Pivot rely on Excel tables as a source, this feature has become more important. But in today’s Anzel Web training, we don’t want to talk about the benefits of Excel tables, but we want to talk about how to delete a table in Excel, and how to delete a table format in Excel. When we convert a range of data into an Excel table, this program automatically applies some formatting to it. Also, when you convert an Excel table to a range, the Excel table format remains. Next, we will teach you how to solve this problem, stay with us.
How to remove the table format in Excel
Suppose we have a data set like the image below.
When we convert this data into an Excel table (with the help of the Ctrl + T shortcut keys), we get something like the image below. As you can see, some formats are automatically applied to the table. Most of the time we don’t like the Excel format to be applied automatically and we need to change it.
To solve this problem, we select the desired cells in the table. If your Excel file has a password, you can use the 7 ways to remove the password of the Excel file and sheet that we taught earlier.
Click on the Design tab (this tab only appears when you click on a table cell).
In Table Styles, click on the More icon.
Click on the Clear option.
By doing these steps, you will remove the Excel table format while still keeping your data in tabular form. Now, if you wish, you can set the format of the Excel table manually, which we will explain how to do later. If you are facing the problem of automatic deletion of zero, insertion of zero, deletion of zeros before the number, etc. in Excel, follow our previous tutorial.
Changing the appearance of the table in Excel
If you don’t like the default format applied to the Excel table, you can change it manually. to do this:
Click on one of the cells in your table.
Click on the Design tab.
In Table Styles, click on the More icon.
Choose one of the available styles.
When you hold your mouse pointer over the styles, you can see a preview and how the style will appear in the Excel table. When you find the format you want, simply click on it.
If you don’t like any of the Excel styles, you can create your own format by clicking on New Table Styles. This will open a window where you can set the format of your table.
Delete table in Excel
Converting data to a table in Excel is easy, and it is just as easy to convert a table to a data range in Excel. The only thing that is a bit annoying is that when you convert an Excel table to a data range, the format remains and you have to remove it manually.
Suppose we have the following Excel table.
Now we remove it with the following steps.
Right-click on one of the cells in the Excel table.
Select Table from the menu that appears and click Convert to Range.
Now you will see a box where you have to click on Yes.
This removes the table but the format remains.
Now you can manually change the format or you can remove it altogether.
Follow the steps below to remove all formats:
Select the cells that have the format
Go to the Home tab.
In the Editing group, click Clear (clear the table in Excel).
From the options that appear, click on Clear Formats.
Delete the Excel table in general
If you want to get rid of the Excel table altogether, follow the steps below:
Select the entire table.
Press the Delete key.
This will delete the Excel table, as well as any formatting you’ve applied (except those you applied manually).
If you have applied the formatting manually and you want to delete it when you delete the table in Excel, use the following steps:
Select the entire Excel table.
Go to the Home tab.
Click Clear.
Click on Clear All.
The shortcut key for this is Alt + H + E + A.
Delete table rows in Excel
Select the rows in your table.
Go to the Home tab.
Click Delete from the Cells group.
Select Delete Table Rows from the following options.
If you have selected and deleted all the rows of the table, you will get the following result.
Delete the table column in Excel
To delete a part of the table or the whole table in Excel, you can use the same steps mentioned above and delete the columns instead of the rows. to do this:
Select the entire table or the desired section of your table.
Go to the Home tab.
Click Delete from the Cells group.
Select Delete Table Column from the following options.
Your comments and suggestions?
In the complete training on 6 ways to delete a table in Excel today, we tried to answer the question of how to delete table lines in Excel. You can clear your table by removing the table mode in Excel with the help of Convert to Range and then removing the table format manually. With this, it is easy to remove the vertical lines of the table in Excel or remove the line between the table in Excel. What solution do you have to remove the table mode in Excel? Share your comments and suggestions with us in the comment section of this article.
One Comment