Highlight the row or the column then click on "Format". Choose "Row" or "Column" and click "autofit".
If you just want the rows tall enough to fit the type but not too wide for the page, click "format", "cells", "alignment", and check the "wrap text" box.
If you are worried about changing it and losing data you already have, click save it under a new name.
The formula parts are a bit confusing at first, but if you go through the steps, you'll get it.
Hope this helps. If you need more, PM me.
