Now delete these blank cells like we did before then remove the filter option.

Sometimes blank rows can be generated due to some glitch in your Excel software.

It can also occur while transferring the excel file, exporting data from the corporate database etc.

Table of Contents Eliminating Blank Rows Manually Deleting Blank Rows by finding Blank cells Remove Blank Rows by Using Excel Find Functionality Using Filter Functionality to Delete Blank Rows Using If Statement in Excel to Delete Blank Rows Removing Blank Rows using Excel VBA Conclusion Related Readings Eliminating Blank Rows Manually The simplest way to deleteeliminate blank rows is to select the blank rows manually.

This may take a long time in big spreadsheets, as you have to target them manually.

In this process, select the blank row by just putting the mouse cursor in the leftmost side of a row and clicking the right button of the mouse.

By this, you select the whole blank row, continuing this process for other blank rows will eventually select all the blank rows.

Then in the Home tab under Delete option, press Delete Sheet Rows.

By clicking it you will delete all the blank rows in your spreadsheet.

Read More: How to Highlight Every Other Row in Excel Deleting Blank Rows by finding Blank cells If you have a spreadsheet containing a handful of blank rows deleting them manually will take so much time.

So, lets choose a way faster way to do this.

Then in the Home tab under the Find Select option click on to Go to Special In the GO TO Special box click on the Blanks and press OK This will select all the blank cells at once Now delete the cells just the way I did in the previous example Note: As you can see, in this procedure all the rows which have blank cells were deleted.

There is another thing you should be careful about is that, if there are some missing values in any column they will be deleted as well so the data will displace and can cause inconsistency.

Read More: How to Multiply Columns, Cells, Rows, Numbers in Excel Remove Blank Rows by Using Excel Find Functionality In this example, we modify our table a little, so that you can have a proper result.

Because of too many blank cells in the previous examples, some rows which were not actually blank were deleted.

Home tab under Find Select option click on Find Then in the Find and Replace box put nothing on Find what option and select values in Look in option After pressing Find all an extension of that box will appear in below.

Press CTRLA to select them all then close the box You will see the blank boxes in the selected zone.

Delete them in the same way that we did in the previous examples Using Filter Functionality to Delete Blank Rows For this method, we need to put all our data in a table.

Follow the below steps to do this method.

In the Home tab under the Sort Filter option click on Filter After this select, a column and click the filter drop-down, uncheck all the values except Blanks then press OK This will select all the blank cells in the range Then in the Home tab under Delete option, press Delete Sheet Rows Finally, remove the filter and you will see unfilled rows are eliminated Note: Make sure to make a table before doing this process otherwise you will not find every name in the column as there are blanks in between the rows of the columns.

By making a table for the cells you are indicating a range to do the operation.

Using If Statement in Excel to Delete Blank Rows For this, we will make an extra column titled Test.

The difference is that you can see the blank rows of your spreadsheet easily.

On the Column of Title in cell D2 type this formula IF(AND(ISBLANK(A2), ISBLANK(B2), ISBLANK(C2)),Blanks, No-Blanks) After pressing enter you will see a result either Blanks or No-Blanks.

Dragging this formulated cell to downwards will copy this formula to every cell Just like the previous example execute the filter option for the Test column and uncheck the No-Blank box This will show the blank cells only.

Excel For Mac 16 Delete Row