Discard Table Form For Free

3 Ways to Remove Table Functionality in Excel Method 1: Use Excel Convert to Range Command to Remove Table Functionality. Method 2: Use Clear Command from the Table Design Tab to Delete Table Style. Method 3: Apply Clear Command from the Home Tab to Erase Table Format.

Here's how to do that. Click on the table you want to remove. This action also will trigger an exclusive menu for managing the table. Go to the Table Tools > Layout menu. Click Convert to Text. Select the separator type between text, then click OK.The table is now removed and the text still there.

Remove Formatting from Selected Cells ? Then, go to Home > Editing > clear and select Clear Formats. Now, you will see the formatting of your selected cells has been removed but the contents are still there.

To remove a table but keep data and formatting, go to the Design tab Tools group, and click Convert to Range. Or, right-click anywhere within the table, and select Table > Convert to Range.

Click anywhere in the table and then go to Table Tools > Design on the Ribbon. In the Tools group, click Convert to Range. Right-click the table, then in the shortcut menu, click Table > Convert to Range. Note: Table features are no longer available after you convert the table back to a range.

Right-click the table, then in the shortcut menu, click Table > Convert to Range. Note: Table features are no longer available after you convert the table back to a range. For example, the row headers no longer include the sort and filter arrows and the Table Design tab disappears.

To remove a table but keep data and formatting, go to the Design tab Tools group, and click Convert to Range. Or, right-click anywhere within the table, and select Table > Convert to Range.