Forum Discussion
multiple line of text hidden
danielea990 Set the cells containing the line feeds to "wrap text"?
- danielea990Nov 24, 2021Copper Contributor
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.
- Riny_van_EekelenNov 24, 2021Platinum Contributor
danielea990 Merged cells are "evil" and should be avoided at all cost. Got that you will get rid of them.