For the life of me, I can not figure this out.
I have attached a example workbook to illustrate my problem.
I have mutiple cells with my workbook that contain long lines of text. This excel document is more like a word
document, but is pre-populated with other cells located on various worksheets located within the same workbook. Due to the
fact that is like a word document, the end of text line within the cell is "wrapped" down to the next line and
continues one. Very simple - just like writing in a word doc.
But I want to auto resize the height of that cell -
and when you do - it resizes it to one line (row height = 16.5) and hides all the text within that cell and therefore doesnt
show when printed.
Now I know I can manually drag the height to show what I want - but with 500+ lines of text
within my worksheet, I do not want to do that each time the "report" is generated.
I have tried various
types of combinatious of merged cells, unmerged cells, center across selection....and I cant seem to get it.