Forum Discussion
Cell Text expanding and not expanding
Riny_van_Eekelen One line stays exactly as you type it. On the next line, once you hit enter, the text spreads out to the right, out of the bound of the cell if there's enough text. The sentence "expands" beyond what was originally typed.
SergeiBaklan No, it's different. I have attempted to attach a file which shows a sheet illustrating the problem. The first line is exactly how I saw it when I typed it. The second and third lines show how the line "expanded". And I can't find any difference in the formatting of the 3 lines, yet lines 2+3 added space between letters.
I don't see extra spaces. Like SergeiBaklan suggested it's a different font. In this case a monospaced font (each character has the same width).
If you get the length of each cell it should be same.
=LEN(A1)
=LEN(A2)
=LEN(A3)
Why didn't you upload the xlsx-file?
Detlef_Lewin Actually, I uploaded that file because I don't know how to do a screenshot and I needed to show an example of the problem. Everything I saw in the spreadsheet was saying each line had the same font but it seems that it was spreading the letters on the 2nd and 3rd line after I hit enter.
SergeiBaklan Thank you Sergei! I tried format painter and was able to make all of the cells do the way I wanted. I still wish I knew why it had changed. I never wanted the "expanded" version and I wouldn't know how to change it if that first line hadn't changed to "what you see is what you get" format. Anyway, thank you again for your help.
