Forum

How to remove blank rows in a selection?  

  RSS

0

How can i remove the blank rows in the middle of the given image:-

Use filter, select blank and delete rows

Or use sort

Select entire range

Press F5

Click special

Select blank or press Alt K

Click OK

All blank cells will be selected

Then press shift space

And Ctrl -

Share:
 
  
Working

Please Login or Register