Remove Blank Rows in 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.

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.

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.

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.

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.