Please and Thank you!

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

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?

You're a life saver! Thanks for taking the time to respond!!


"Peo Sjoblom" wrote:

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?

Angelica wrote:
Please and Thank you!

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

I assume that you have a data row followed by a blank row followed by a
data row, etc.

To remove the blank rows, sort your rows such that the blank rows are
grouped together, then delete them.

Texas Handly