Monday, October 20, 2014

Google Spreadsheet Word Wrap - Solved

I was working in a Google Docs Spreadsheet and could not get the "Wrap Text" option to work in one of my cells. I made sure the format was selected properly, and tried the format painter from a different cell where the word wrap was working.

I noticed that the wrapping worked when I entered a fresh block of text in the cell. This is when I discovered that the reason it wasn't wrapping was because my original block of text didn't have any spaces in it. The sheet won't wrap the text unless it has spaces to break the text on. I inserted spaces and then it started wrapping as expected.