Ans :
➯ There are various ways we can delete Blank Rows:
1) Go to each blank row and delete it manually (too tedious and time-consuming).
2) Sort the entire data set so that all the blank rows are at the bottom (works but alters the data set).
3) Use Go To special technique (or a macro) to select all the blank cells at once and delete the rows.
➯ Now we will learn how quickly we can delete blank rows
A) Using the Go To Special dialogue box.
B) Using a VBA Macro.
For Example : See below dataset
➯ The above data has three blank rows in it.
➯ Here are the steps to quickly delete blank rows (empty rows) from this dataset.
1) Select the entire dataset (A1:C13 ).
➯ Press the F5 key Or press Ctrl + G . It will open the Go To dialog box.
2) You can get this dialog box from
Home ➯ Editing ➯ Find and Select ➯ Go To.
3) In the Go To dialog box, click on the Special button. This will open the Go To Special dialog box.
4) In the Go To Special dialog box, select Blanks.
7) Now you can right click on any selected cell and click on delete.Delete Entire Row
8) It will delete entire blank rows from data
➯ Now we will learn how to Delete Blank rows using VBA
'Delete Blank Rows From Column A
Sub RemoveBlankRows()
Sheet1.Range("A1:A100").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub
➯ Here we have learned how to delete Blank rows using Go To Special dialogue box and VBA Macro 😎