I am trying to create an overview sheet for people who know even less about
Excel than I do. The original data is an extraction from an online tool and
I have created a "pretty" template to display some of this information using
very simple formulae. What I would like to know is as the results of the
formulae differ (i.e. different text block size ranging from 1 number to a
few lines of text) is there a way of auto-resizing the cell height?

I've tried auto-resize and double click, but as the true contents of the
cell is just a one line formula, that's what the row resizes to.

Any chance there is a simple command to solve this?

Thanks.