Discard Table Form For Free

To delete a row, column, or table, place the insertion point inside the table, or select text in the table, and then choose Table > Delete > Row, Column, or Table. To delete rows and columns by using the Table Options dialog box, choose Table > Table Options > Table Setup.

Using the Clear Formatting Option to Unformat an Excel Table Select the table cells that you want to unformat. Click on the 'Clear' button on the 'Home' tab of the ribbon, and then select 'Clear Formatting'

Select any cell in the table from which you want to remove the current table style. On the Home tab, click Format as Table, or expand the Table Styles gallery from the Table Tools > Design tab (the Table tab on a Mac). Click Clear. The table will be displayed in the default table format.

Select any cell in the table from which you want to remove the current table style. On the Home tab, click Format as Table, or expand the Table Styles gallery from the Table Tools > Design tab (the Table tab on a Mac). Click Clear. The table will be displayed in the default table format.

Tip. 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.

It's easy to convert tabular data into an Excel table, and it's equally easy to convert an Excel table back to the regular range....Below are the steps to convert this Excel table to a range: Right-click on any cell in the Excel table. Go to the Table option. Click on '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. For example, the row headers no longer include the sort and filter arrows and the Table Design tab disappears.

Select any cell in the table from which you want to remove the current table style. On the Home tab, click Format as Table, or expand the Table Styles gallery from the Table Tools > Design tab (the Table tab on a Mac). Click Clear. The table will be displayed in the default table format.

Select any cell in the table from which you want to remove the current table style. On the Home tab, click Format as Table, or expand the Table Styles gallery from the Table Tools > Design tab (the Table tab on a Mac). Click Clear. The table will be displayed in the default table format.

If your Excel worksheet has data in a table format and you no longer want the data and its formatting, here's how you can remove the entire table. Select all the cells in the table, click Clear and pick Clear All. Tip: You can also select the table and press Delete.