Submitted by Ramakrishnan on Jun 18, 2014 - 12:11 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 Submitted by Karthik on Jun 18, 2014 - 13:15 Permalink 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. Log in or register to post comments Add new comment
Submitted by Karthik on Jun 18, 2014 - 13:15 Permalink 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. Log in or register to post comments
It's simply done using Go To
It's simply done using Go To Special command.
Steps:
That's all.