I've had a look around but can't find someone with a similar query/answer.
I'm looking to resize the height of some cells based on the data inside them. The data is a formula and comes from other worksheets - the length of the text string can vary.
Action Plan.xlsx
I've heard that any AutoFit method has trouble when working with merged cells, so columns DP,DQ and DR have the contents of the main section only in single cells.
Rows 21-24 (and any similar rows going down the page - i.e 31-34, 41-44, etc) are the rows that will need to be resized (height only).
The rows have 'wrap text' active.
The data within columns B:DE would come from another worksheet, but in the attached example i've just used 'Action', 'Question', 'Observations' and 'Comments'. These 4 rows will have varying lengths of data - sometimes just "N/A" other times full sentences. The user will never see this page until the document is complete and printed so cannot manually adjust the height of any rows. I need these 4 rows to automatically adjust depending on how long the text entry from the formula is.
The width of any and all cells cannot be changed.
Bookmarks