We recently discussed this in another forum.

This behavior is a trade-off between versions. In Excel 2003 and earlier the
formula bar automatically expands *but* it also will expand to cover the
grid which is not good. In Excel 2007 they made it so that when the formula
bar is expanded it doesn't cover the grid *but* the formula bar doesn't
automatically expand. The reason for this seems to be that a constantly
expanding/retracting formula bar is not very aesthetically pleasing.

One of the MVPs wrote some code to automatically resize the formula bar but
their conclusion was that it is a horrible computing experience and strongly
recommended not trying to do this.

--
Biff
Microsoft Excel MVP


"Gary''s Student" wrote in message
...
I am entering text in a cell. I insert some ALT-ENTERs to force hard
returns
within the cell.

In Excel 2003, the formula bar height would automatically adjust to show
the
full text.

In Excel 2007, I have to manually adjust the height of the formula bar.

Is there any way, in Excel 2007, to configure the formula bar to adjust
automatically??
--
Gary''s Student - gsnu200902