How to clear table formatting style without losing table data in Excel?
Sometimes you may need to clear the table formatting style from a table but reserve table data in Excel. Apart from copying the table and pasting as values, this article will introduce a couple of ways to clear/delete table formatting style without losing table data in Excel.
Recommended Productivity Tools for Excel
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 71% of your time and solve 82% Excel problems for you. 300+ advanced tools designed for 1500+ work scenario, make Excel much easy and increase productivity immediately.60-day Unlimited Free Trial
Actually we can apply the Convert to Range feature to remove table formatting style from a table easily. Please do as follows:
1. Select any cell in the table you will clear table formatting from to activate the Table Tools, and then click Design > Convert to Range. See screenshot:
Note: You can also right click any cell in the table, and then click Table > Convert to Range from the right-clicking menu. See screenshot:
2. In the popping up Microsoft Excel dialog box, please click the Yes button.
And now you will see the table formatting style has been removed/cleared from original table. However, original table’s fill color, font color and other formatting styles are reserved. See screenshot:
If you need to remove all table formatting styles, including fill color, font color, etc. from a table, you can try Kutools for Excel’s Clear All Cells Formatting utility.
Kutools for Excel - Combines more than 300 Advanced Functions and Tools for Microsoft Excel
1. Select the entire table that you will remove the table formatting style from, and click Kutools > Format > Clear All Cells Formatting.
Now you will see all table formatting styles, including the fill color and font color are removed from original table as below screenshot shown: