Want to leverage awesome features of an Excel table but do not want any formatting in it? This tutorial will teach you how to quickly clear a table format in Excel.
By default, Excel tables are equipped with many great features including predefined styles. In some situations, however, you may want to remove formatting keeping all other functionality of a table. This tutorial will teach you how to quickly do that.
To remove formatting but retain all other features of an Excel table, this is what you need to do:
Or click the More button in the Table Styles group, and then click Clear underneath the table styles.
As the result, you will still have a fully functional Excel table but with no formatting:
Tips and notes:
If the above-mentioned approach has not removed all the formatting in your table, that means the remaining part is your custom format that was done manually.
To clear absolutely all formatting (both predefined and your own one), carry out these steps:
As the result, all formatting in a table is removed:
Note. Please keep in mind that this method clears all formatting entirely, including number formats, alignment, etc.
In case you no longer need data formatted as a table, here's how you can remove a table format and turn it into a regular range of cells:
A prompt will show up asking if you really want to convert the table to a normal range, and you click Yes.
In the result, your data will still look very much like a table because the table style formatting is preserved. From the functional viewpoint, however, it is a usual range - all features of Excel table such as structured references, automatic expansion, inbuilt filters, etc. are gone.
That's how to clear table formatting in Excel. Hopefully, you've found these small tips helpful. I thank you for reading and look forward to seeing you on our blog next week!
Table of contents