3 Simple Ways on How to Delete Rows in Excel

Deleting rows is one of the most common tasks a user will undertake in Excel which therefore means you need to learn how to master this. You may need to delete rows because it contains old data and is no longer needed. Another reason could be because you may have combined different datasets together and want to delete duplicate rows. This post will teach you how to delete rows in Excel by using three simple methods. These are by using the:

  1. Excel ribbon
  2. Mouse
  3. Keyboard shortcut

Before I dive straight in and show you the three different ways of how to delete rows in Excel, it is important to understand the rule of how Excel deletes rows. The rule is:

  • When you delete a row, all the cells below the deleted row shifts up one row

1. How to Delete Rows in Excel using the Ribbon

To learn how to delete a row in Excel using the ribbon, then follow these steps.

  1. Select the entire row where you want to delete a row by clicking on the row header number. In this example, I want to delete row 5 so I select the row header 5.
To show how to delete rows in excel, the entire row 5 is selected and the range A1:A10 contains numbers 1 to 10.
Click the row header to select the entire row
  1. Go to the Home tab and under the Cells group click on Delete. You can also select the arrow next to the Delete button and select Delete Sheet Rows from the menu.
To show how to delete rows in Excel, row 5 is selected and the Home tab, the Delete button and the Delete Sheet Rows button is highlighted in a red border.
Click on the Delete button in the ribbon which is located in the Home tab under the Cells group
  1. Row 5 has been deleted. Consequently, the cells below the deleted row have shifted up one row.
Row 5 has been deleted in Excel. Range A1:A9 contains numbers.
Row 5 has been deleted. All the cells below have shifted up by one row

2. Deleting Rows in Excel using the Mouse

To delete a row using the mouse, then follow these steps.

  1. Select the entire row where you want to delete a row by clicking on the row header number. In this example, I want to delete row 5 so I select the row header 5.
The entire row 5 is selected and the range A1:A10 contains numbers 1 to 10.
Row 5 has been selected by clicking the row 5 header
  1. Right-click your mouse and select Delete from the shortcut menu.
The Excel shortcut menu is showing and the Delete button is highlighted in a red border to show how to delete rows in Excel
Select Delete from the shortcut menu
  1. Row 5 has been deleted and therefore all the contents below have shifted up one row.
Row 5 has been deleted in Excel. The range A1:A9 contains numbers.
Row 5 has been deleted

3. Using a Keyboard Shortcut

To delete a row using keyboard shortcut keys then select the entire row by clicking on the row header number. Then press Ctrl + Shift + the minus sign (-).

How to Delete Multiple Rows in Excel

If you want to delete multiple rows, then simply select the row header numbers first and choose one of the three methods mentioned above. For example, I want to delete four rows from row 4 so I select row headers 4 to 7.

To show how to delete rows in Excel, rows 4 to 7 were selected and then deleted in Excel using the ribbon. Range A1:A6 contains numbers.
Rows 4 to 7 have been deleted and the rows above have shifted up four rows

Rows 4 to 7 have been deleted. Notice that the rows below have now shifted up by four rows because four rows were deleted.

Do you want to take your Excel Skills to the Next Level?

If you are a beginner in Excel and want to take your Excel skills to the next level then please read my book Excel Bible for Beginners: The Essential Step by Step Guide to Learn Excel for Beginners. This Excel book will teach you all the fundamentals of Excel which will therefore enable you to become an advanced user.

Excel Bible for Beginners: The Essential Step by Step Guide to Learn Excel for Beginners by Harjit Suman
Excel Bible for Beginners: The Essential Step by Step Guide to Learn Excel for Beginners

Some of the things you will learn from this book includes how to:

  • Use the Quick Access Toolbar
  • Change font styles
  • Wrap and merge text
  • Format numbers
  • Apply borders
  • Apply cell styles
  • Use the Format Painter tool
  • Freeze rows and columns
  • Hide/unhide columns and rows
  • Copy, paste and cut
  • Use the Excel Find and Replace tool
  • Use the Excel Text to Speech function
  • Create charts and format them
  • Create formulas
  • Print

And much much more!

Below are some reviews from people who have purchased this book.

Excel Bible for Beginners: The Essential Step by Step Guide to Learn Excel for Beginners by Harjit Suman 5 star review in Amazon.
Excel Bible for Beginners: The Essential Step by Step Guide to Learn Excel for Beginners by Harjit Suman 5 star review in Amazon.
Excel Bible for Beginners: The Essential Step by Step Guide to Learn Excel for Beginners by Harjit Suman 5 star review in Amazon.
Excel Bible for Beginners: The Essential Step by Step Guide to Learn Excel for Beginners by Harjit Suman 5 star review in Amazon.
Excel Bible for Beginners: The Essential Step by Step Guide to Learn Excel for Beginners by Harjit Suman 5 star review in Amazon.

To learn more about this Excel book and to purchase it from Amazon, then please click either of the buttons below.

I hope you enjoyed this post on how to delete rows in Excel. Moreover, I hope you have learnt something new. If you have any questions or feedback then please write a comment below and I will get back to you.

Spread the love
         
  
        
 
        
 
    

Leave a Comment

Your email address will not be published.