Row height

[Confused from Hertford]

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]

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