Can you tell me whether it's possible to enter information in a Google Spreadsheet and format it so that the cell expands downwards as I keep entering text, rather than the text keeps entering beyond the visible right boundary of the cell? I love using Google Sheets for tracking and sharing student achievement data, and if I could just do this, they would become more useful/convenient to me.
OOOH! I'm happy to help with anything that makes people love Sheets even more!! The good news is that you can easily do that!
When you click on it, you'll get the option to wrap the text in three different ways: overflow (what you're probably seeing in your Sheet now), wrap (what it sounds like you want), or clip.
Just highlight the rows, columns, cells or whatever you want to be different, then click that Wrap button and choose the style you want. Here is how the different options look: