I have a huge number of data rows in Excel with lot of blank rows between them.
How to remove the blank rows easily?
Is there any shortcut for this?
It's simply done using Go To Special command.
- Select the range of cells that contains data with blank rows.
- In the Home Tab Click on Find & Select (binocular icon), and chose the Go To Special menu option
- Choose 'Blanks' option then click Ok.
- Now, select Delete Sheet Rows option in the drop down menu by clicking the Delete icon under Home tab.