Delete Blank Rows in Excel

Using Go To Special Technique to Delete Blank Rows in Excel

Suppose you have a dataset as shown below:

The above data has three blank rows in it.Here are the steps to quickly delete blank rows from this dataset.

•  Select the entire dataset (A1:C13 in this case).Press the F5 key

• It will open the Go To dialog box.

• You can get this dialog box from Home –> Editing –> Find and Select –> Go To.

• In the Go To dialog box, click on the Special button. This will open the Go To Special dialog box.

• In the Go To Special dialog box, select Blanks.
  
• Click Ok.
  
  

  
  
  This would select all the blank cells in the dataset.
  
  
   Now that you have all the blank rows selected, here are the steps to delete these rows:

• Right-click on any of the selected cells and select Delete.

• In the Delete dialog box, select ‘Entire row’. 

•  Click OK.

This would instantly delete all the blank rows in the dataset.

Note that this technique would delete the entire row, which means that if you have any data to the left/right of your dataset, it will get deleted too. If you don’t want this to happen, select Shift cells up option. This would only delete the cells/rows in the data set, and all the other cells around it would remain intact.