HOW TO UNFORMAT AS TABLE IN EXCEL HOW TO

We can achieve this by converting the table into a normal range of cells in the following way 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.

At the end of the Table Styles window, select the Clear buttonДЄfter selecting the Clear button, remove table formatting only but other features remain available with the table having the following view ДЇigure 4.

Go to Design tab > In Table Styles section click on the More drop-down arrowДЇigure 2.

In this case, we need to perform unformat table by clearing the table formatting in the following steps Sometimes, we only need to delete only the formatting style of the table such as background color, shade, border, banded rows but we want to keep the additional features of integrated filtering and sorting and table referencing intact for data manipulation. There are the following two methods to perform this task Clear Table Format However, in some cases, we may need to remove table formatting to manipulate the data as per own requirement.

Table formatting is applied to get available benefits of creating catchy view along with additional features like integrated sorting and filtering of the data, dynamic table referencing required in data handling. Remove Table Formatting Removing Table Formatting

HOW TO UNFORMAT AS TABLE IN EXCEL HOW TO

Therefore, we need to learn how to remove table formatting. 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.

How to unformat as table in excel