Remove Blanks Rows in Excel

1. First of all backup the Existing Excel file ( Due to Accidental Loss of Data )


2. Now, select the cells in one column from the top of your list to the bottom.


3. Now Click on Edit and Find the Go To Section ( or Press F5 )


4. Click the Special Button


5. Now Select the Blank Option in Options Box ( it will select all the Blank Rows )


6. Final Step is to Delete the Rows ( Now Go To Edit and Delete , Select Delete Entire Row )