Remove an Excel Table but Keep Its Data

To remove Format as Table while keeping the data, click inside the table and choose Table Design > Convert to Range, then confirm the conversion. Excel changes the table into ordinary cells but retains its current colors, borders and number formats. To make those cells visually plain as well, select the converted range and choose Home > Clear > Clear Formats.

Choose what should remain; the decision tool shows the correct Excel command.

Choose the Result You Need

The correct command depends on whether you want to remove the table itself, its visual style, or all cell formatting. These operations are not interchangeable.

Desired result	Action	What remains
Normal cells with the same appearance	Convert to Range	Data, formulas and current formatting
A table without the selected color scheme	Clear the table style	Table behavior and default table format
Normal, unformatted cells	Convert, then Clear Formats	Data and formulas, but not formatting

Make a copy of the workbook first if formulas, filters or downstream sheets depend on the table. Conversion changes more than its appearance: it removes the Excel table object and changes structured references to ordinary cell references.

If you merely dislike the table’s colors, do not convert it. Clear or adjust the table style instead. If you need plain cells for export or publishing, convert the table and then clear its formats.

Convert the Table to a Normal Range

Use Convert to Range when you want to keep the values and formulas but no longer need the Excel table object. The cells remain in place, and the existing appearance remains until you clear or replace it.

Excel for Windows

1. Click any cell inside the table.
2. Open Table Design on the ribbon.
3. In the Tools group, select Convert to Range.
4. Confirm the conversion if prompted.

You can also right-click a cell in the table and choose Table > Convert to Range.

Excel for Mac

1. Click any cell inside the table.
2. Open the Table tab.
3. Select Convert to Range.
4. Select Yes to confirm.

Excel for the Web

Right-click a cell inside the table, then choose Table > Convert to Range.

These routes are documented in Microsoft’s instructions for converting an Excel table to a range. The conversion preserves the applied table-style formatting. A colored header, borders or alternating row colors can therefore remain visible even though the cells are no longer part of a table.

That retained appearance sometimes makes the conversion seem unsuccessful. Click a cell in the converted area and look at the ribbon. If the contextual Table Design or Table tab no longer appears, the table object has been removed. The remaining colors are cell formatting, not proof that the table still exists.

Conversion Removes Table Behavior

Converting a table to a range removes the features attached to the table object. Sort and filter arrows disappear, and Table Design is no longer available for that range. Features such as automatic table expansion, table style options and a table total row no longer operate as table features.

Structured references in formulas also become ordinary cell references. Microsoft defines structured references as formulas that use table and column names, such as =SUM(DeptSales[Sales Amount]), instead of coordinates such as =SUM(C2:C7) (Microsoft Support).

For example, a formula that refers to a named table column may be rewritten to refer to a specific range of cells. The formula can continue calculating, but it no longer has the same table-aware reference. If more rows are added later, an ordinary range reference may not behave like the former structured reference.

Check formulas and totals after conversion, especially when other worksheets refer to the table by name. Also review any workflow that expects the table to expand when new records are typed beneath it. Converting is appropriate only when those table behaviors are no longer needed.

A conversion does not delete the underlying cell values. It also does not, by itself, make the cells visually plain. Those are separate decisions, which is why Convert to Range and Clear Formats may both be necessary.

Remove the Table Style but Keep the Table

Use this approach when you still want table behavior—such as automatic expansion, structured references, filter controls or a total row—but do not want the selected color scheme.

1. Click any cell inside the table.
2. Open Table Design. On a Mac, use the Table tab.
3. Expand the Table Styles gallery.
4. Select Clear.

Clearing the style does not convert the table into normal cells. Microsoft says the table is then displayed in its default table format (Microsoft Support). The table can therefore continue to show table-related visual treatment even after the selected style has been cleared.

This is the safer choice when formulas use the table name or named columns. It changes the presentation without deliberately removing the structure on which those formulas rely.

If only one visual feature is distracting, keep the style and adjust Table Style Options instead. You can turn off Banded Rows, First Column or Last Column without changing the table’s underlying structure. This is more targeted than clearing the entire style.

Clearing a table style is also different from using Clear Formats on the cells. The former keeps the table and returns it to its default table format. The latter removes cell formatting and can affect number and conditional formats.

Make the Converted Range Visually Plain

If the goal is ordinary cells without table colors, borders or number formats, complete both operations in order:

1. Click inside the table and choose Convert to Range.
2. Select the entire converted range.
3. Choose Home > Clear > Clear Formats.

Do not choose Clear All. Microsoft states that Clear Formats removes formatting only, while Clear All also removes cell contents and comments (Microsoft Support). Pressing Delete or Backspace is also the wrong operation because it clears contents rather than formatting.

The distinction matters when the range contains formulas. Clear Formats keeps those formulas, although their displayed results may look different after the number formats are removed. Clear All can remove the formulas themselves along with the other cell contents.

Select only the former table range before clearing formats. If the selection extends into adjacent cells, their formatting will be cleared too. When the range has no obvious border after conversion, selecting it immediately before navigating elsewhere can make the intended area easier to retain.

Clear Formats Can Change How Values Look

Clear Formats includes number formats and conditional formats. Dates may display as serial numbers, percentages as decimals, and currency values without currency symbols even though the underlying values remain.

That change is visual rather than a deletion of the stored value. A cell that previously displayed a date can appear numeric because the date format no longer controls its presentation. Likewise, a percentage can look smaller when it is shown as its underlying decimal.

Reapply any number formats the data needs after clearing. This is especially relevant when the cleaned range is intended for readers rather than for a machine-processing step. A plain range can still use deliberate date, percentage or currency formats without becoming an Excel table again.

If you want to remove only the table’s colors while retaining date and currency displays, converting and clearing every format is unnecessarily broad. Convert the table, keep its existing formats, and then change only the unwanted fills, fonts or borders through the normal formatting controls.

Confirm That the Table Was Actually Removed

A table’s appearance is not a reliable test because Convert to Range preserves its applied formatting. Use its behavior and ribbon controls to distinguish a converted range from a styled table.

Click a cell in the affected area. If Table Design or the Mac Table tab appears, the cell is still in a table. If that contextual tab does not appear, the area is a normal range even if it still has a colored header or banded rows.

Filter arrows provide another practical clue, although a normal range can have filtering applied separately. The absence of the table-specific ribbon tab is the more direct indicator that the selected cell is no longer part of an Excel table.

If Convert to Range is unavailable, first make sure the active cell is inside the table rather than in a nearby blank cell. The contextual table tab appears only when Excel recognizes the current selection as part of a table.

Use the Least Destructive Command

The three commands solve different problems:

• Convert to Range removes the table object but preserves its current cell formatting.
• Clear in the Table Styles gallery keeps the table while removing the selected style.
• Clear Formats removes formatting from selected cells but keeps their contents.
• Clear All removes more than formatting and is not the command to use when the data must remain.

Start with the least destructive operation that produces the required result. If table behavior is still useful, adjust or clear the style. If table behavior is unwanted but the existing appearance is acceptable, convert to a range and stop. Use Clear Formats only when number formats, borders, fills and other formatting should also be removed.

Review the Range Before Publishing

Removing an Excel table or its formatting does not clean the underlying dataset. It does not correct mixed date formats, numbers stored as text, blank identifiers or inconsistent headers. Review those separately with a column data-type validation workflow.

For a public dataset, keep one header row and one observation per row. Verify formulas and totals after conversion, particularly when other sheets previously used structured references or the table name. Check whether dates, percentages and currency values still display as intended after clearing formats.

Publish only a sanitized copy of the workbook. Never upload confidential, personal or otherwise sensitive workbook content. If the destination accepts either format, decide whether workbook features are still required before choosing CSV or XLSX.