Unformat as a table in Excel

Page updated :

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.