Note: As you can see, in this procedure all the rows which have blank cells were deleted. Now delete the cells just the way I did in the previous example.This will select all the blank cells at once.In the GO TO Special box click on the Blanks and press OK.Then in the Home tab under the Find & Select option click on to Go to Special.1 st select the area where you want to perform your task.So, let’s choose a way faster way to do this. If you have a spreadsheet containing a handful of blank rows deleting them manually will take so much time. Deleting Blank Rows by finding Blank cells So, the process can be used in a variety of situations. This process also works for the rows which aren’t blank. By clicking it you will delete all the blank rows in your spreadsheet. Then in the Home tab under Delete option, press Delete Sheet Rows. By this, you select the whole blank row, continuing this process for other blank rows will eventually select all the blank rows. In this process, select the blank row by just putting the mouse cursor on the leftmost side of a row and clicking the right button of the mouse. This may take a long time in big spreadsheets, as you have to target them manually. The simplest way to delete/eliminate blank rows is to select the blank rows manually.

Related Articles Eliminating Blank Rows Manually

Delete blank columns in excel 2016