How to Delete Rows in Excel

Sometimes, while working on an Excel sheet, you may want to add or delete some rows. For such operations, there are options available in the editing menus. Moreover, shortcuts are also supported for this purpose.

Delete rows in Excel

Deleting rows is a simple task in Excel, and there is no special formula for this purpose. The steps that must be followed in this case are listed below

How to Delete Rows using the options in the Menu bar

  • Select the rows that you want to delete. You can do this by clicking on the row number in the left side of the Excel workspace.
  • For selecting multiple rows hold the Ctrl key on your keyboard and select the rows by clicking on the row number.
  • After selecting the rows, go to the menu bar and press the Home button.
  • In the menu for Home, click on the delete option or the arrow with delete option to see the full menu.
  • Click on the Delete Sheet Rows option and the selected rows will be deleted.

How to Delete Rows using the keyboard shortcut

  • Select the rows that you want to delete. You can do this by clicking on the row number in the left side of the Excel workspace.
  • For selecting multiple rows hold the Ctrl key on your keyboard and select the rows by clicking on the row number.
  • After selecting the rows, press the Ctrl and buttons simultaneously if you are running Windows of your system.
  • If you are using Linux or for Mac use the shortcut ^ +

Example

An example sheet has been presented for explaining the deletion of rows process.

Figure 1. Example Sheet

Select the rows by clicking on the row number given on the left side of the workspace.

Figure 2. Selection of rows to be deleted

Go to the Delete option in the drop-down menu of Home option (in the Menu bar) and press Delete Sheet Rows button.

Figure 3. Getting to the Delete Sheet Rows option in the drop-down menu of Home button

After pressing the Delete Sheet Rows button, the selected rows will be deleted.

Figure 4. Resulted in sheet after deleting selected rows

The results are same even if the shortcut is used to delete the rows.

Still need some help with Excel formatting or have other questions about Excel? Connect with a live Excel expert here for some 1 on 1 help. Your first session is always free. 

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar