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.
Download Practice Workbook
You can download the practice workbook from here.
2 Easy Methods to Undo a Table in Excel
There are mainly 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.
- Second, we will select Convert to Range in the Tools section.
- Third, 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 Undo and Redo in Excel (2 Suitable Ways)
Similar Readings
- [Fixed!] Undo and Redo in Excel Not Working (3 Simple Solutions)
- How to Redo in an Excel Sheet (2 Quick Ways)
- Undo Text to Columns in Excel (3 Simple Methods)
- How to Undo Remove Duplicates in Excel (3 Ways)
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. Context menu will appear.
- Secondly, we will select Table and Convert to Range.
- Thirdly a dialog box will appear for confirmation. Click on Yes.
- Finally, we will get a normal dataset like the one below.
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:
- At 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 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.
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 demonstration are taken using Excel 365. So the user interface may vary for different versions.
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. For any excel related problems, you can visit our website Exceldemy for all types of excel related problem solutions.