![]() |
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. |
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