How about using Text boxes to hold text.
You can link the contents of a text box to a cell or cells.
Click on a text box frame and enter a cell reference in the formula bar.
e.g., Text in Cell A1
Formula for text box: =A1
Text boxes will wrap text for you and you shouldn't have to worry about hiding rows or adding Char(10) for new lines.
Text boxes can also be set to autosize. Right click text box and select Format Text Box, then alignment Tab.