In this article, we will discuss how to remove format as the table in Excel. Often, while working in Excel, we apply different types of styles and formatting in table cells. Most of the time these formattings are helpful. But, at times, they can be distracting too. Fortunately, there are some very easy and quick ways to remove format from tables.
Download the Practice Workbook
You can download the practice workbook that we have used to prepare this article.
3 Quick Methods to Remove Format As Table in Excel
1. Delete Format from Table Design Tab in Excel
Before removing formatting from a table, let’s create a table from a date range. Suppose, we have a data range containing fruit sales details.
To create a table from this data range just select the data and type Ctrl+T. The table will be created with default formatting.
Now, we will go through the steps to delete this formatting.
Steps:
- First, select any cell of the table.
- Next, go to the Table Design This is a Contextual tab, only appearing when a table cell is selected.
- Then, go to the Table Styles group and click on the More icon (down to the right side scroll bar).
- After that, click on the Clear option.
- Finally, the table is free of all types of auto-generated formats.
Note:
If you apply any formatting manually to the table, those won’t be removed using the above method.
2. Remove Format as Table from Editing Group in Excel
Now, we will explain another method regarding removing format from an Excel table.
Steps:
- Firstly, select the entire table.
- Secondly, go to the Home tab from the Ribbon.
- Thirdly, go to the Editing group and click on the Clear
- Then, click on the Clear Formats option from the Clear drop-down.
- Lastly, all the formats from the table will be deleted.
Read more: How to Edit a Pivot Table in Excel
Similar Readings
- Convert Range to Table in Excel (5 Easy Methods)
- What is the Difference between a Table and a Range in Excel?
- Use Slicers to Filter a Table in Excel 2013
- How to Make an Amortization Table in Excel (4 Methods)
3. Convert Table to Range and Clear Format in Excel
Sometimes we need to convert tables to data range and then clear the formats. Now, we will discuss the steps involved in that process.
Steps:
- First, select any cell of the table.
- Next, go to the Table Design Tab and click on Convert to Range from the Tools group.
- After that, the MS Excel window will pop up to confirm the table to range conversion. Click Yes.
- Then, the table will be converted to a data range. Yet, all the formatting is present.
- Now, select the entire data range and follow the steps mentioned in Method 2.
(Go to Home > Clear (Editing Group) > Clear Formats)
- Finally, here is the data range, free of any formatting.
Note:
You can convert tables into data ranges through a right-click also. To do this, right-click any cell of the table, and then from the Table option click on the Convert to Range.
Read more: How to Convert Table to List in Excel
Conclusion
In the above article, I have tried to discuss all the methods elaborately. Hopefully, these methods and explanations will be enough to solve your problems. Please let me know if you have any queries.
Further Readings
- How to Refresh Pivot Table in Excel (4 Effective Ways)
- Types of Tables in Excel: A Complete Overview
- Group Columns in Excel Pivot Table (2 Methods)
- How to Use Excel Table Reference (10 Examples)