How to Delete a Data Table in Excel (4 Methods)

Dataset Overview

We’ll use the below dataset to demonstrate the steps to be taken to delete a data table.

Method 1 – Using a Peripheral Device to Remove a Table from the Data Model in Excel

• Select the data table (from B4 to E13 in our dataset).

• Right-click your mouse.
• Choose Table Columns under the Delete option.

• This will delete the data table.

Method 2 – Using Design Tab to Delete a Data Table Without Deleting Data in Excel

• Select the range B4:E13 of the data table.
• Go to Table Design → Tools → Convert to Range.

• Confirm the conversion when the Microsoft Excel warning box appears.

• This will delete the table while preserving formatting and data.

Method 3 – Applying Clear Command to Delete a Data Table in Excel

• Select the range B4:E13.
• Go to Home → Editing → Clear All.

• This will delete the data table, including data and formatting.

Method 4 – Running an Excel VBA Code to Delete a Data Table

• Open a module.
• Go to the Developer tab → Visual Basic.

• Insert a module (go to Insert → Module).

• Enter the following VBA code in the module:

Sub delete_data_table()
Cells.Range("B4:E13").Delete
End Sub

• Run the VBA code (go to Run → Run Sub/UserForm).

• This will remove the data table.

Download Practice Workbook

You can download the practice workbook from here:

Related Articles

• How to Create One Variable Data Table in Excel
• How to Create One Variable Data Table Using What-If Analysis
• How to Create a Two-Variable Data Table in Excel
• How to Create a Data Table with 3 Variables
• How to Create a 4-Variable Data Table in Excel

<< Go Back to Data Table in Excel | What-If Analysis in Excel | Learn Excel