1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Delete Rows in Excel Worksheets


As with all things Microsoft, there is more than one way to delete rows from an Excel worksheet. These instructions show you how to delete rows by right clicking on the row header.

The row header is the gray bar along the left edge of the worksheet containing the row numbers.

Delete Rows in an Excel Worksheet

Note: if you delete rows containing data, the data is deleted as well. If you make a mistake use the Undo feature under the Edit menu to get your data back.

To delete more than one row from a worksheet, select more than one row in the column header. For example, if you want to delete two rows, select two rows in the row header.

To delete a single row

  1. Right click on the row header of the row you want to delete.
  2. Choose Delete from the menu.
  3. The row will be deleted.

To delete multiple rows

  1. In the row header, select the number of rows you want to delete from the worksheet.
  2. Right click on the selected rows .
  3. Choose Delete from the menu.
  4. The rows will be deleted.

©2014 About.com. All rights reserved.