A
Angelica
Please and Thank you!
Can I make my spreadsheet single spaced with out deleting each row
individually?
Can I make my spreadsheet single spaced with out deleting each row
individually?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
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
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
B
Brian Handly
AngelicaAngelica said:Please and Thank you!
Can I make my spreadsheet single spaced with out deleting each row
individually?
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
A
Angelica
You're a life saver! Thanks for taking the time to respond!!