How To Remove Table Format In Excel

Excel is a powerful tool, used by many to organize, analyze and store data. While using Excel, you might have stumbled upon one of its features – Tables, which provide numerous benefits like quick sorting, filtering, and formatting options. However, there might be times where you wish to remove the table format. This blog post will guide you through the steps on how to remove table format in Excel.

Step-by-Step Guide to Remove Table Format

Step 1: Select the Table

The first step is to select the table from which you want to remove the formatting. To do this, click on any cell within the table. This will enable Table Tools in Excel.

Step 2: Convert to Range

Next, navigate to the Design tab under Table Tools. Here, you’ll find the option ‘Convert to Range’. What this function does is it retains your data, but removes the table features, essentially converting your table back into a normal range of cells.

Step 3: Confirm the Action

Once you click on ‘Convert to Range’, a dialog box will appear asking you to confirm the action. Click ‘Yes’ to remove the table format.

Step 4: Remove Table Formatting

The final step is to remove the remaining table style formatting. You do this by selecting the range of cells, then go to Home > Clear > Clear Formats.


In just four simple steps, you can easily remove the table format in Excel. Keep in mind that this will not delete your data. It merely removes the features and functionalities of a table and reverts your data back to a range of cells. Excel is a very dynamic tool with various capabilities that can enhance your data analysis and presentation capabilities. Understanding how to manipulate your data, like removing table formats, can help you make the most out of this powerful tool.

Stay tuned for more tips and tricks on how to navigate Excel like a pro!