Table formatting can be a difficult task to remove in Microsoft Excel. Here are some tips to help:
- Open the Microsoft Excel window and click on the Table Tools button. This will open the Table Formatting dialog box.
- In the Table Formatting dialog box, select the Remove Formatting check box and then click on OK.
- Click on the table you want to format and then click on the Format button. The table will be formatted according to your selection in step 2.
When you insert a table in your spreadsheet, Microsoft Excel automatically applies certain formatting to your table. If you’d rather keep your table plain and simple, you can remove its formatting. We’ll show you how.
You can use this method even if you have applied your own custom formatting to your table.
RELATED: How to Create and Use a Table in Microsoft Excel
Clear a Table’s Formatting in Excel
To begin the table format removal process, open your spreadsheet with Microsoft Excel.
In your spreadsheet, click any cell of your table.
At the top, in Excel’s ribbon, click the “Table Design” tab.
On the “Table Design” tab, in the “Table Styles” section, click the “More” option (a down-arrow icon with a line at the top of it).
In the “More” menu that opens, click “Clear.”
You’ve successfully removed your table’s formatting.
And that’s how you turn your stylized tables into plain regular tables in Microsoft Excel!
Similarly, you can also clear formatting in your Microsoft Word documents.
RELATED: How to Clear Formatting in a Microsoft Word Document
