How to Remove the Table Formatting in Microsoft Excel

Updated on:

May 12, 2026

By:

Use this interactive demo to learn how to strip table formatting from an Excel worksheet in seconds.

Quick summary

To remove table formatting in Microsoft Excel, select the formatted cells, open the Table Design tab, and use Convert To Range to instantly revert the table back to a normal cell range.

Steps

Select the cells you wish to edit inside your Microsoft Excel worksheet.
Navigate to the top menu bar and click Table Design.
Find and select the Convert To Range option.
The table formatting of the selected cells will be removed instantly.

📌 Why this matters

Knowing how to remove table formatting in Microsoft Excel is an essential skill for anyone who needs to clean up spreadsheet data, restore normal cell ranges, or prepare data for use in other tools. Excel's built-in Convert To Range feature lets users strip structured table styles in seconds without losing any underlying data. This makes it easier to reformat, sort, or export your spreadsheet content with full flexibility. Mastering this simple workflow saves time and prevents common formatting conflicts in shared or imported Excel files.

Your product deserves an interactive demo

Start free

How to Organize Dates by Week in Excel

How to Make Cells Fit Text Microsoft Excel

How to Make a Bar Graph in Microsoft Excel