ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Row height (https://www.excelbanter.com/excel-worksheet-functions/249732-row-height.html)

Confused from Hertford[_2_]

Row height
 
Hi Guys, Thank you very much for your assistance yesterday - great help. Need
to pick you brains on the following;

Worksheet now has alternate blank rows inserted but I now need to adjust the
height of these blank rows on block - know how to to this individually but
can't get it to work on mass.

Thanks.

Ashish Mathur[_2_]

Row height
 
Hi,

Select the range and then press Ctrl+G Special Blanks. This will select
all the blank cells. Now go to Format Row Height and input the desired
number. All the blank cells will now calibrate to the row height

Hope this helps.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Confused from Hertford"
wrote in message ...
Hi Guys, Thank you very much for your assistance yesterday - great help.
Need
to pick you brains on the following;

Worksheet now has alternate blank rows inserted but I now need to adjust
the
height of these blank rows on block - know how to to this individually but
can't get it to work on mass.

Thanks.




All times are GMT +1. The time now is 12:27 PM.

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