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.
That complicates things enormously. I'd either unmerge the cells, or resize the rows manually.
- HansVogelaar
Not to worry, appreciate you trying to help. I will just stick with 1st option of manually doing it. That is probably not an attractive option.
- HansVogelaar
In that instance, would you propose just making cell a1 a page width then and tall enough to accomodate wrap?
If so, within the same excel I am adding many tables, so I am using several columns. Sorry about that. In the future, try to avoid merged cells, especially if you want to wrap text.
- HansVogelaar
I have around 10,000 merged cells, so to unmerge, then re merge will take hours. I will have to take the first route you mentioned then and just complete the tasks manually. Again: I'd unmerge the cells.
- HansVogelaar
It can vary, but 95% of it are cells B - AJ are always merged.
30% of the time, 1 row, 20% 2 rows merged as well, 20% 3 rows merged 20% 4 rows, 10% more than 4 rows, all as well as horizontally B-AJ. Where are the merged cells? All in the same columns (for example B/C)? Or does it vary from row to row? And are there multiple merged cells in the same row?
- 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