Delete an Excel Table without Losing Data or Formatting

By August 10, 2016 February 10th, 2020 Tech Tip

Let’s say you’ve created a table in Microsoft Excel. You don’t want the Excel table, but you do want to keep the data or formatting. The solution is simple: convert the table back to a data range.

Note: For this to work, you need to have an already completed table.

  1. Click anywhere on the table. This displays the Design tab under Table Tools on the Ribbon. A cell in the table must be selected for the Design tab to be visible.Image: Select a cell in the Excel table
  2. Then, on the Design tab, in the Tools group, click Convert to Range.
  3. Click Yes. Now you have a data range without table options.Image: Data range without table formatting

And that’s it!