Remove a table style
- Select any cell in the table from which you want to remove the current table style.
- On the Home tab, click Format as Table, or expand the Table Styles gallery from the Table Tools > Design tab (the Table tab on a Mac).
- Click Clear. The table will be displayed in the default table format.
How do I remove table formatting in Excel 2016?
How to remove table formatting
- 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 change the format of a table in Excel?
To change the table style:
- Select any cell in your table. The Design tab will appear.
- Locate the Table Styles group. Click the More drop-down arrow to see all of the table styles. ...
- Hover the mouse over the various styles to see a live preview.
- Select the desired style. The table style will appear in your worksheet.
