If your layout is like this

row with data
empty row

and so on where the empty rows are truly empty there is an easy fix
select the column, press F5, click special, select blanks and click OK,
press Ctrl and - (ctrl and minus/hyphen), select entire row and press enter
of click OK, done


--

Regards,

Peo Sjoblom


"Angelica" wrote in message
...
Please and Thank you!

Can I make my spreadsheet single spaced with out deleting each row
individually?