Forum Discussion
multiple line of text hidden
Riny_van_Eekelen wrap text doesn't work in this case, I'm thinking it has something to do with how this spread sheet was created. The text is split between rows using alt+enter. If I add text to a blank cell using alt+enter, the cell expands as normal. But nothing I've tried thus far to expand the existing cells will work. I'm left with manually identifying each cell with multiple rows and manually dragging the row height to fit.
. . .
I may have just discovered why it won't work. The cells with multiple rows of text are made up of 2 merged cells, wrap text and expand won't work for these merged cells. I think I have my answer - I've got to do this manually.
Thanks.
danielea990 Merged cells are "evil" and should be avoided at all cost. Got that you will get rid of them.