Go Back

How to Delete Rows in Excel

Deleting rows in Excel can be done in a number of ways without the use of any function or formula.  This step by step tutorial will assist all levels of Excel users in deleting rows in Excel by using three different methods.  

Figure 1.  Final result:  How to delete rows in Excel

Setting up our Data

Our table contains three columns: Name (column B), Department (column C) and Rating (column D).  We want to delete rows 4 and 6 to remove the Marketing employees from our list.

Figure 2.  Sample data to delete rows in Excel

Delete rows 4 and 6 using Menu options  

In order to delete rows 4 and 6 using Menu options, let us follow these steps:  

Step 1.  Select the rows we want to delete, row 4 and row 6.  To select multiple rows, we first select row “4” by clicking the row number at the left side of the worksheet.  Then we press the Control key “Ctrl” on the keyboard, and select row “6”.  

Figure 3.  Selecting the rows to delete in Excel

Step 2.  Click the Home tab

Step 3.  Select Delete cells or Delete Sheet Rows

Figure 4.  Deleting rows using Menu options

Figure 5.  Rows 4 and 6 deleted using Menu options

Delete rows 4 and 6 using mouse options

In order to delete rows 4 and 6 using mouse options, let us follow these steps:  

Step 1.  Select the rows we want to delete, row 4 and row 6.  To select multiple rows, we first select row “4” by clicking the row number at the left side of the worksheet.  Then we press the Control key “Ctrl” on the keyboard, and select row “6”.  

Figure 6.  Selecting the rows to delete in Excel

Step 2.  Right click, then select Delete

Figure 7.  Deleting rows using mouse options

Figure 8.  Rows 4 and 6 deleted using mouse options

Delete rows 4 and 6 using keyboard shortcut

Excel has a keyboard shortcut for deleting cells.  To delete rows 4 and 6 using keyboard shortcut, let us follow these steps:

Step 1.  Select the rows we want to delete, row 4 and row 6.  To select multiple rows, we first select row “4” by clicking the row number at the left side of the worksheet.  Then we press the Control key “Ctrl” on the keyboard, and select row “6”.  

Figure 9.  Selecting the rows to delete in Excel

Step 2.  Press the Control key “Ctrl” and the minus key “-” simultaneously on the keyboard.  The keyboard shortcut to delete cells is  Ctrl + – .  

Figure 10.  Rows 4 and 6 deleted using keyboard shortcut “ Ctrl + – ”

Delete rows 4 and 6 without selecting entire rows

We can also delete entire rows even if we select only a few cells in the rows we want to delete.  Let us follow these steps:

Step 1.  Select cells C4 and C6.   To select multiple cells, we first select one cell, C4, then we press the Control key “Ctrl” on the keyboard, and select cell C6.    

Figure 11.  Selecting cells in the rows we want to delete

Step 2.  Press the keyboard shortcut to delete cells in Excel :  Ctrl + – .   This will show the Delete dialog box.

Figure 12.  Delete dialog box preview

Step 3.  Tick Entire Row to delete the entire rows 4 and 6

Figure 13.  Selecting the Delete Entire Row option

Figure 14.  Rows 4 and 6 deleted without selecting entire rows

In the same manner, we can also use the Menu options or the mouse options to delete entire rows by clicking only selected cells in the rows we want to delete.   

Most of the time, the problem you will need to solve will be more complex than a simple application of a formula or function. If you want to save hours of research and frustration, try our live Excelchat service! Our Excel Experts are available 24/7 to answer any Excel question you may have. We guarantee a connection within 30 seconds and a customized solution within 20 minutes.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:
Here are some problems that our users have asked and received explanations on

I want to delete certain rows in excel, the rows which I have to delete comprises of few values
Solved by A. J. in 25 mins
How to delete blank rows
Solved by I. B. in 20 mins
Delete many repeated rows autoamatically
Solved by Z. D. in 27 mins

Leave a Comment

avatar