How to Remove Blank Rows in Excel

Looking to Delete Empty Rows on Microsoft Excel. Here is the Simple Guide to Remove Blank Rows in Excel.

If you are preparing data structures or a spreadsheet and want to remove the blank rows in Excel, then you’re in the right place. Microsoft Excel offers a versatile tool that allows individual users to delete the cell that contains no data.

If you are preparing a worksheet, that contains only empty` rows, don’t worry – you can remove the blank rows with a simple step. This guide will show you two effective ways to remove blank rows in Excel. So, without further ado, let’s begin!

Ways to Remove Empty Rows in Microsoft Excel

We have mentioned two ways to remove blank rows from the Excel worksheet. Let’s take a look at them.

1. Remove All Empty Rows in Excel

Does your database contain empty rows in Excel and want to delete them? If so, then you can remove all empty rows effortlessly. This means you don’t need to delete the rows manually. You can remove the rows with just a click. Here’s how to do it.

  1. Launch Microsoft Excel and open the spreadsheet for which you want to delete empty rows.
  2. Select the database by dragging the cursor. Then, click on the “Home” tab in the ribbon.
    Click on the Home tab in the ribbon
  3. In the “Editing” section, click on the Find & Select drop-down menu and choose “Go to Special.”
    Click on Find & Select and choose Go To Special
  4. In the Go To Special window, check the “Blanks” and click OK located at the bottom.
    Choose Blank option and click OK
  5. Here, you will see that all the empty rows are selected and highlighted.
  6. Click the “Delete” drop-down menu from the Cells section to delete the blank rows.
  7. Then, select Delete Sheet Rows.
    Click on the Delete Selected Rows to remove the empty rows
  8. Now you may see that Excel has removed your blank rows and your data is shifted to upward.

If you accidentally deleted a row containing data, you can bring it back by pressing the Ctrl + Z (Windows) or Command + Z key (Mac). This will recover the deleted cells and rows in the spreadsheet.

2. Remove a Few Blank Cells Manually

If your database is not larger and contains a few empty rows, you can also remove it. You can remove a few blank cells manually. Here’s how to do it.

  1. In the Excel spreadsheet, click on the row numbers located on the left side that contain only empty rows.
  2. If more rows are empty, select the row by pressing and holding the Ctrl key (for Windows) or Command (Mac). Then click the row numbers you want to select.
    Select the empty row by clicking on the row number
  3. Once you select the empty rows, then right-click on any blank row number and select the “Delete” button in the menu.
    Click on the Delete button to remove the empty rows
  4. Now you may notice that all your selected rows are removed from the spreadsheet.
    Removed empty rows in Excel


That’s it. This is how you can easily remove blank rows in Excel. It is essential to delete unnecessary and blank rows or cells in the worksheet to give a minimal look, especially when preparing the sheets for an organization or school. We have outlined two different ways to remove blank rows in a spreadsheet. I hope you have found this guide helpful.

If you've any thoughts on How to Remove Blank Rows in Excel, then feel free to drop in below comment box. Also, please subscribe to our DigitBin YouTube channel for videos tutorials. Cheers!

Ansar Ahmed
Ansar Ahmed is a tech content writer with almost 2 years of experience who has a strong passion for technology. He covered ever-green content in many niche websites. He specializes in covering topics related to Android, iOS, and Windows.

Leave a Reply

Your email address will not be published. Required fields are marked *