Excel remove blank rows

If you have a blank row on every other row in excel, there is an easy way of getting rid of it.

select the entitre column or the range of cells,

hist f5, select special, select blanks and hit okay

now the every blank row will be highlighted.

From the edit menu, select delete. You are all set