![how to clear formatting in excel how to clear formatting in excel](https://quickexcel.com/wp-content/uploads/2021/06/clear-formatting-clear-contents.png)
Alternately, right-click in the formatted table, go to Table and select Convert to Range option.Click on Design tab and select Convert to Range in Tools section.We can achieve this by converting the table into a normal range of cells in the following way
![how to clear formatting in excel how to clear formatting in excel](https://www.getbasicidea.com/wp-content/uploads/2022/04/How-to-Clear-Formatting-in-Excel-Get-Basic-Idea.png)
We may need to keep the formatting styles of colors, shades, banded rows and remove additional features only. Table View After Clearing Table Formatting Convert to RangeĪs we are aware that table formatting carries additional features like integrated sorting and filtering, table referencing, etc.
#How to clear formatting in excel how to#
Therefore, we need to learn how to remove table formatting.
![how to clear formatting in excel how to clear formatting in excel](https://i.ytimg.com/vi/L4B0ZrvBQNs/maxresdefault.jpg)
There may be a time where we do not require applied table formatting. Excel provides a variety of built-in table styles with various formatting options of fonts, background colors, borders, banded rows to manage and improve the look of data.