One of the core features of Excel is to make tables with given data. But sometimes, we need to undo the table in Excel to make necessary changes or rebuild the table with different formatting. So, in this article, we will learn how to undo a table in Excel.
Undo a Table in Excel: 2 Easy Methods
There are two methods to undo a table in Excel. Here undo means clearing both the format and the structure. The two methods with proper steps are below.
1. Undo a Table by Converting to Range
In this method, we will use the Excel Ribbon on top of the rows to undo a table. To do so, we will follow these steps.
Steps:
- First, we need to select any of the cells in the table. In the ribbon, a tab named Design or Table Design will appear.
- Next, we will select Convert to Range in the Tools section.
- Then, a confirmation box will appear. We will click on Yes.
- Finally, we will see that the table is converted to a normal dataset like the below image. Here to see the difference, we will select a cell in the table area, but no Format Table tab will appear this time.
Read More: How to Remove Table in Excel
2. Using Context Menu
In this method, we will use Excel Context Menu instead of Ribbon to undo a table. Here are the steps below.
Steps:
- Firstly, we need to click on any of the cells in the table. The context menu will appear.
- Next, we will select Table and Convert to Range.
- Then a dialog box will appear for confirmation. Click on Yes.
- Finally, we will get a normal dataset like the one below.
Read More: How to Remove Table Functionality in Excel
How to Clear Table Format in Excel
There are many occasions where we want to keep the table structure but want to change the format according to our preference. There are multiple ways in which we can do this. These methods are described below.
1. Customizing Table Design
One of the best ways to clear formats is to do it from the Table design panel. The steps are simple:
Steps:
- First, we need to select one cell of the table.
- Then we will go to the Table Design tab in the ribbon.
- Next, we will click on the Quick Styles drop-down arrow in the Table Styles
- Finally, in the drop-down list, we will select Clear. This will clear all types of formatting while keeping the table structure like the below image.
2. Using Clear Formats Command
We can also clear formatting using the Home tab as well. The steps are below:
Steps:
- In the beginning, we will select the entire table.
- Furthermore, we will select Clear in the Editing section in the Home tab.
- Again, in the Clear menu, we will select Clear Formats.
- Finally, we will get a table without any formatting.
Read More: How to Remove Format As Table in Excel
Things to Remember
- Undoing a table will remove the structure of the table as well.
- If you see a filter button in a table, you need to untick it from the Table Design tab before converting it to the range.
- All these pictures for the demonstration are taken using Microsoft Excel 365. So, the user interface may vary for different versions.
Download Practice Workbook
You can download the practice workbook from here.
Conclusion
This article was about undoing a table in Excel and also clear formatting of any table. Hope this article will help you. If you’re still having trouble with any of these methods, let us know in the comments. Our team is ready to answer all of your questions.
Related Articles
- How to Insert or Delete Rows and Columns from Excel Table
- How to Extend Table in Excel
- How to Mirror Table in Excel
- How to Make an Excel Table Expand Automatically
- Excel Table Formatting Problems
- How to Use Sort and Filter with Excel Table
- How to Rename a Table in Excel
- [Fix]: Formulas Not Copying Down in Excel Table
<< Go Back to Remove Table | Excel Table | Learn Excel
Get FREE Advanced Excel Exercises with Solutions!