Excel4Business - Our Blog

Excel Tips and Tricks from our Experts

Excel Help - How to Remove Blank Cells in Excel 2013

In this video you’ll learn how to remove blank rows in Excel. If there are blank rows in your list or table, Excel can’t perform functions such as sorting and removing duplicates. If you have a lot of entries in your worksheet and want to delete any blank rows you may have added by mistake, removing each one separately might take you a long time, so this video will walk you through a quicker way to remove blank cells.

To begin with, find a column that you are certain contains blank rows. Now select all cells in the column, you can do this by clicking the column header.
Go to the Home tab and find the Editing group. Click on Find & Select, Click Go to special, check Blanks and click OK.
You have now selected all the blank cells in the column you chose.

Right-click one of the selected cells.
Select Delete.
Choose Entire Row.
Click OK.