Click the Design tab (this is a contextual tab and only appears when you click any cell in the table).Remove Formatting from the Excel Tableīelow are the steps to remove the Excel table formatting: I can now remove the formatting from the table completely or I can modify it to look the way I want. In most cases, I don’t like the formatting Excel automatically applies and I need to change this. You can see that Excel has gone ahead and applied some formatting to the table (apart from adding filters). When I covert this data into an Excel table (keyboard shortcut Control + T), I get something as shown below. Suppose I have the dataset as shown below. How to Remove Excel Table Formatting (while keeping the Table) Remove Excel Table (Convert to Range) & the Formatting.Change the Formatting of the Excel Table.
