When text exceeds a column width, it is possible to manually or automatically wrap the text.
To manually wrap text, use Alt-Enter to enter the break point.
Automatically wrapping text should be straightforward, but the results sometimes seem to depend on the order of operations. I find that the best approach is to first select Format > Row > Autofit and then Format > Cells > Wrap Text. Any page setup should be done last.
When I do not follow this sequence, it seems that text of a few lines will often not display, instead only showing "#" signs where the text should go.
If anyone has a better understanding of how this problem occurs, please contact me at matthews@wfu.edu.