You must also have Wrap Text enabled on those cells with formulas.


Gord Dibben MS Excel MVP

On Wed, 20 Jun 2007 07:31:05 -0700, Rob E <Rob
wrote:

I am trying to configure a worksheet to automatically adjust it's row heights
after the values have changed. Some of the formulas on the page are simply
pulling text off other cells in other tabs. When the text in those other tabs
is changed to a larger or smaller size, the row height on the original tab
changes, but not the row height on the sheet that has the formula, even
though both tabs have Automatic Row Height selectd.