Delete a Table

Delete a table from an existing Excel worksheet.

Overview

This procedure deletes a table from an existing Excel worksheet by clearing the contents of cells within the specified table dimensions.

Syntax

Below is a line-by-line overview of the automation syntax. Expand each line to learn more.

delete the table in the worksheet

What does it do?

Begins table deletion from the current worksheet.

Where does it go?

This phrase should be written on a new line.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — A reference to the worksheet must be defined in the automation.

the location is "A1"

What does it do?

Specifies the top-left corner of the table to delete.

Where does it go?

Indented under delete the table in the worksheet where.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — Replace A1 with a cell reference (e.g., "A1", "B2").

Example

the location is "B2"
the height is h

What does it do?

Specifies the number of rows in the table.

Where does it go?

Indented under delete the table in the worksheet where.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — Replace h with a numeric value representing table height.

Example

the height is 5
the width is w

What does it do?

Specifies the number of columns in the table.

Where does it go?

Indented under delete the table in the worksheet where.

Is it required?

✅ Yes — This phrase is required.

Does it require data?

✅ Yes — Replace w with a numeric value representing table width.

Example

the width is 4

Examples

1. Delete a Table from an Excel Worksheet

delete the table in the worksheet where
    the location is "B2"
    the height is 5
    the width is 4

Last updated

Was this helpful?