By Ramakrishnan , 18 June, 2014 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? Forums DTP It's simply done using Go To It's simply done using Go To Special command. Steps: 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. That's all. Add new comment
It's simply done using Go To It's simply done using Go To Special command. Steps: 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. That's all.
It's simply done using Go To
It's simply done using Go To Special command.
Steps:
That's all.