Forum Discussion
Solved
Excel change row height based on font size
Hi, Is there a way of making excel change the row height, dependant on the font size in the cells, e.g. if font size is 12, then make row height 18... Thanks Rob
That complicates things enormously. I'd either unmerge the cells, or resize the rows manually.
HansVogelaar
Thanks, I have ran this on my workbook, I am still getting the bottom of text being cut off in places. Is this because of the range used? Also, can you also write code that will increase a merged cell if not all of the wrapped text has fit into the cell intially?
Rob
Thanks, I have ran this on my workbook, I am still getting the bottom of text being cut off in places. Is this because of the range used? Also, can you also write code that will increase a merged cell if not all of the wrapped text has fit into the cell intially?
Rob
Do you have horizontally merged cells (for example A1 and B1), or vertically merged cells (for example A1 and A2), or both?
That complicates things enormously. I'd either unmerge the cells, or resize the rows manually.
- HansVogelaar
Ok, so probably need to be manual then. Most of them are 1 size which means I can just apply to all rows. code can be written to just work on a row which has only been merged horzontally that would still help alot. Is this possible without it being too complicated?
Rob