I'm not sure it this is doable but is it possible to set a cell so that it
automatically displays all the text that is in there, expanding where
necessary without manual changes.

i don't want shrink to fit as I need to text to be of a certain size