• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Delete Blank Rows in Excel

March 22, 2021 by Andrew Childress
Delete blank rows in Excel

Deleting blank rows in Excel is a quick and easy way to tidy up worksheets. Let’s learn how to delete blank rows in Microsoft Excel.

Deleting blank rows in Excel is a quick and easy way to tidy up worksheets. It only takes a few seconds. Let’s learn how to delete blank rows in Microsoft Excel.

How to Delete Adjacent Blank Rows in Excel

When you work on your spreadsheets, you may find yourself with blank rows. These can be distracting, and make your data appear somewhat cluttered.

There are two different ways to delete blank rows in Excel. The first instance happens if you have several blank rows grouped together. Consider an example like this: rows 2, 3, and 4 are blank, and need to be deleted.

To get started, click on the row number of the topmost row. In this case, that’s 2. Next, hold down Shift on your keyboard. Click on the lowermost row number, which is 4 in this example.

Delete blank rows in Excel

Excel will instantly select all three rows: the two you clicked on, and any rows in between. This works no matter whether you have 2 or 2,000 blank rows. The process is identical.

Now, to delete the rows, be sure you’re working on Excel’s Home tab on the ribbon. Then, click Delete.

How to delete blank rows in Excel

The blank rows will delete, and your other data will shift to fill the gaps.

How to Delete Non-Adjacent Blank Rows in Excel

Imagine you have blank rows that you want to delete, but they aren’t grouped together. For example, rows 1 and 3 are blank, while row 2 has data in it. Holding Shift and deleting will result in deleting the data from row 2.

To delete non-adjacent blank rows, begin by clicking on the uppermost row number to select it. Here, that’s row 1. Now, instead of holding Shift, hold Control (or Command on Mac) and click on the other blank row(s), in this case, 3.

Deleting blank rows in Excel

As you can see, Excel will select only the rows you’ve clicked on. Anything in between is left untouched. From here, the process is identical to before. Simply click Delete on the Home tab. The blanks will be deleted, and data will move to fill the gaps. If you would like to Insert Multiple Rows in Excel we have a quick tutorial to help out.

How to delete the blank rows Excel

This is a great example of a quick cleanup task you can perform to make your spreadsheets look neater.

Category: Excel TutorialsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « How to alphabetize in Excel Alphabetize in Excel
Next Post: Remove Blank Rows in Excel Remove blank rows in Microsoft Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2022 · Excelypedia · All Rights Reserved

Back to top