View of Normal Range of Cells Instant Connection to an Expert through our Excelchat Service
Table converts into a normal range of cells, keeping the formatting styles without additional features of table formatting.įigure 8. Click Yes button on the dialog box to convert Table into a range of cells.įigure 7. 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 
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
IN WORD 2010 FOR A MAC WHAT DOES BANDED ROWS MEAN 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.
0 kommentar(er)
