How to undo table formatting in excel

This article wish explain how to remove two types of table formatting in Excel. You'll learn how to remove formatting disseminate Excel tables and manually formatted information ranges.

Remove Formatting from Excel Tables

Automatic board formatting in Excel is applied in the way that you create a table by jiffy 'Table' on the Insert tab purchase 'Format as Table' on the Hint tab.

This formatting includes color schemes, banded rows, and other style elements.

To fast remove this table formatting, follow these steps.

1. Click on any cell favourable the table to activate the Slab Design tab.

2. Next, on the Board Design tab, in the Table Styles group, click the first style (None).

This removes the automatic table formatting nevertheless retains the table functionality!

If you entail to remove the table functionality altogether and revert to a normal facts range, stay on the Table Plan tab.

3. In the Tools group, clicking Convert to Range.

4. Confirm the elicit to convert the table back show to advantage a regular range, which removes nomadic table-specific features.

Note: the headings in how to undo table formatting in excel
how to remove table formatting in excel but keep data
how to remove table formatting in excel without losing data
how to remove table formatting in excel mac
how to remove table formatting in excel online
how to remove table formatting in excel 365
how to cancel table formatting in excel
how to remove table formatting in excel youtube
how to remove table formatting in excel office 365
how to remove table format in excel shortcut
how to remove table format in excel sharepoint
how to remove table format in excel 2021
how to remove table format in excel 2019