Unformat as a table in Excel

Using "Format as Table" for the selected range of cells can be used as a special table-style cell, which makes it look cleaner, filters are easier, and it's easier to aggregate.

It's easy to format by selecting a range of cells, but we'll talk about unsetting them here.

First, select the table you want to unformat. It can be a single cell instead of a range.

Select Design because it is added to the menu tab.

Select Convert to Range from the Tools group in the menu.

A confirmation dialog appears, and select Yes.

Unformatting is detifyed as a table. The design tab does not appear when you select a cell.

Because it is only unformatted as a table, you need to manually reset the text color and background color.