Delete blank rows - HOW?

S

SteveL

Have a spreadsheet that contains blank rows every other
row. How can I stip them ouyt automatically?

--Steve
 
K

Ken Wright

If you don't want a VBA solution, simply highlight any column where you can
reliably say that you will happily delete every row where the cell in that
column is blank, then do Edit / Go To Special / Blanks, and then do Edit /
Delete / Entire Row.
 
Top