Delete Rows in Excel

In this blog post we will see how we can delete the rows in an excel sheet. There are various methods available in excel to delete the rows. Let’s learn them one by one:

1. Using Mouse Right Click
2. Using Delete Command
3. Using Keyboard Shortcut

To learn these multiple methods to delete the rows in excel we will use the below dummy data which contains five rows “Row 1”, Row 2”, Row 3”, Row 4” and Row 5”. There are random numbers listed in each row. We will delete the “Row 3” from this data by using each of the above mentioned methods.

Method 1: Using Mouse Right Click

This is the first method which we will learn to delete the row.

1. Select the entire row which we wish to delete (in our case we have selected “Row 3”).

2. Press Mouse Right Click which will show several options on screen. Please select “Delete” option from this.

3. With this we can see that the data from “Row 3” is now deleted.

Method 2: Using Delete Command

This is the second method which we will learn to delete the column.

1. Select the entire row which we wish to delete (in our case we have selected “Row 3”).

2. Go to Home tab and then from cells group we have to select “Delete” command. This will open 04 further options on screen. Out of these we have to click on option “Delete Sheet Rows”.

3. With this we can see that the data from “Row 3” is now deleted.

Method 3: Using Keyboard Shortcut

This is the third method which we will learn to delete the column.

1. Select the entire row which we wish to delete (in our case we have selected “Row 3”).

2. Press and hold “Ctrl” key and then press “-“ on your keyboard.

3. With this we can see that the data from “Column C” is now deleted.

These are the various methods to delete the rows from excel sheet. Please mention your favorite method in comments section below.