ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can I make my spreadsheet single spaced (https://www.excelbanter.com/excel-discussion-misc-queries/61730-can-i-make-my-spreadsheet-single-spaced.html)

Angelica

Can I make my spreadsheet single spaced
 
Please and Thank you!

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

Peo Sjoblom

Can I make my spreadsheet single spaced
 
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?




Brian Handly

Can I make my spreadsheet single spaced
 
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

Angelica

Can I make my spreadsheet single spaced
 
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?






All times are GMT +1. The time now is 05:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com