How to: Delete a Row or Column from a Worksheet

Sep 19, 2023
3 minutes to read

Row

This example demonstrates how to remove rows from a worksheet.

Call the Row.Delete method to delete the current row.
Call the RowCollection.Remove method of the Worksheet.Rows collection to remove a row at the specified position or delete multiple rows at once.
To delete a row containing the specified cell or multiple rows containing the specified cell range, use the Worksheet.DeleteCells method with DeleteMode.EntireRow enumeration member passed as a parameter.

When you delete rows from a worksheet, other rows are automatically shifted up.

Enclose your code in the Workbook.BeginUpdate - Workbook.EndUpdate method calls to improve performance when you remove multiple rows from a document.

View Example

RowAndColumnActions.cs
RowAndColumnActions.vb

csharp

// Delete the 2nd row from the worksheet.
worksheet.Rows[1].Delete();

// Delete the 3rd row from the worksheet.
worksheet.Rows.Remove(2);

// Delete three rows from the worksheet starting from the 10th row.
worksheet.Rows.Remove(9, 3);

// Delete a row that contains the "B2"cell.
worksheet.DeleteCells(worksheet.Cells["B2"], DeleteMode.EntireRow);

' Delete the 2nd row from the worksheet.
worksheet.Rows(1).Delete()

' Delete the 3rd row from the worksheet.
worksheet.Rows.Remove(2)

' Delete three rows from the worksheet starting from the 10th row.
worksheet.Rows.Remove(9, 3)

' Delete a row that contains the "B2"cell.
worksheet.DeleteCells(worksheet.Cells("B2"), DeleteMode.EntireRow)

You can also hide worksheet rows. See the How to: Hide a Row or a Column topic for details.

Note

The number of rows in a worksheet is permanently fixed - 1048576.

Column

This example demonstrates how to remove columns from a worksheet.

Call the Column.Delete method to delete the current column.
Call the ColumnCollection.Remove method of the Worksheet.Columns collection to remove a column at the specified position or delete multiple columns at once.
To delete a column containing the specified cell or multiple columns containing the specified cell range, use the Worksheet.DeleteCells method with the DeleteMode.EntireColumn enumeration member passed as a parameter.

When you delete columns from a worksheet, other columns are automatically shifted to the left.

Enclose your code in the Workbook.BeginUpdate - Workbook.EndUpdate method calls to improve performance when you remove multiple columns from a document.

View Example

RowAndColumnActions.cs
RowAndColumnActions.vb

csharp

// Delete the 2nd column from the worksheet.
worksheet.Columns[1].Delete();

// Delete the 3rd column from the worksheet.
worksheet.Columns.Remove(2);

// Delete three columns from the worksheet starting from the 10th column.
worksheet.Columns.Remove(9, 3);

// Delete a column that contains the "B2"cell.
worksheet.DeleteCells(worksheet.Cells["B2"], DeleteMode.EntireColumn);

' Delete the 2nd column from the worksheet.
worksheet.Columns(1).Delete()

' Delete the 3rd column from the worksheet.
worksheet.Columns.Remove(2)

' Delete three columns from the worksheet starting from the 10th column.
worksheet.Columns.Remove(9, 3)

' Delete a column that contains the "B2"cell.
worksheet.DeleteCells(worksheet.Cells("B2"), DeleteMode.EntireColumn)

You can also hide worksheet columns. See the How to: Hide a Row or a Column topic for details.

Note

The number of columns in a worksheet is permanently fixed - 16384.