Looking For The Best Vancouver and Fraser Valley IT Services?

Direct:(604) 864-_0992 | Toll Free: (877) 864-_0992

How to delete an Excel table without losing data or formatting


Let’s say you’ve created a table in Microsoft Excel. You don’t want the table, but you 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. You can also watch the video version.

1. Click anywhere on the table. This displays the Design tab under Table Tools. A cell in the table must be selected for the Design tab to be visible.

2. On the Design tab, in the Tools group, click Convert to Range.

3. Click Yes. Now you have a date range without table options.