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

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Remove Blank Rows in Excel

March 22, 2021 by Andrew Childress
Remove blank rows in Microsoft Excel

Blank rows take up space in a spreadsheet. Fortunately, they’re easy to remove. Let’s learn how to remove blank rows in Microsoft Excel.

Blank rows take up space in a spreadsheet. Fortunately, they’re easy to remove. Let’s learn how to remove blank rows in Microsoft Excel.

How to Remove Blank Rows in Excel

Consider a spreadsheet with multiple rows of data. As you work, you may end up with blank rows. But if you have a long list of data, it can be time-consuming to find each blank row manually.

As you can see, this data has two blank rows in it. No matter how many rows you have, Excel has an easy way to automatically select only blank rows.

Remove blank rows in Excel

On the Home tab, locate the Find & Select option on the right side. Click on the dropdown arrow, and you’ll see a list of options. These include Find, Replace, Go To, and so forth.

Remove empty rows in Excel

The feature you need is Go To Special, the fourth option on the list. Go ahead and click it. The Go To Special menu appears, giving you a wide assortment of options. In essence, this is a filtering feature where you can ask Excel to find all data that matches the parameters you select.

Remove blank rows in Microsoft Excel

Here, you’ll want to select Blanks from the left-hand column. Click the bubble, then click OK. Excel will highlight every blank cell in the empty rows found within your data.

Now, it’s time to actually delete these blanks. Do that on the Home tab again, by clicking the Delete button.

How to remove blank rows in Excel

The empty rows will disappear, and your data will shift to fill the voids left behind.

Performing quick cleanup activities like this works to help your spreadsheets look better. By delivering a clear, concise layout with no blanks, users of your spreadsheet will be able to quickly focus on what they need to see. It only takes a few seconds, but goes a long way towards making a great impression.

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

About Andrew Childress

Previous Post:Delete blank rows in ExcelDelete Blank Rows in Excel
Next Post:Mean in ExcelExcel find mean autosum results

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows 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
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top