Assuming you have data in between those blank rows:

Select a column. Press Ctrl+G to bring up the goto dialogue. Click
'Special', then select blanks. Ok out.

Now, with those cells selected, press Ctrl+minus sybol. Select the option to
delete entire row. Ok out.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Desperate" wrote:

How to delete alternating BLANK rows in .xls file all at one time? Is there a
formula, find and replace, etc.?