I have set up a list in SharePoint with about ten columns. All of the columns except one can be answered with one to four words. Therefore, they take up little room in the list.
One of the columns, which asks for upgraded information, can take, say, 280 characters. When you save it, the comment just goes out to the right in one long paragraph. If you open in Excel or another program, it shows up in a wraparound format, which means I can see everything to the right of it on one page. Now, you have to scroll over. I suppose I could move it to the end.
I realize if it saved with the comments in four lines, for example, entries would take up four lines.
This seems like a huge limitation in SharePoint. As an FYI, I will be switching to O365 with SP in the cloud soon. Thanks for any help.