|remove format table excel 2010||0.68||0.7||9330||37|
If you want to keep all features of an Excel table and remove only the formatting such as banded rows, shading and borders, you can clear the table format in this way: Select any cell in the table. On the Design tab, in the Table Styles group, click the More button. Underneath the table style templates, click Clear.How do you clear format table in Excel?
Under Table Elements, select the element you want to format and click the Format button. The Format Cells dialog will open, and you select the desired formatting options on the Font, Border, and Fill tabs. To remove existing formatting, click the element, and then click the Clear button.How do I remove data from a table in Excel?
If you want to remove the formatting, use "Clear all" in the Clear menu on the home ribbon. Another easy way remove data in a worksheet is to delete entire columns or rows. Just select the columns or rows that contain the data you'd like to remove, and delete, using one of the methods covered in an earlier lesson.