Hello!

I'm just making the transition to the new Excel.

When the formula is too long, in the old Excel, the formula bar
auromatically "grows" more lines in order to let you see all the formula at
once.

In Excel 2007, when this happens, i still only have one line in the formula
bar, and a scroll down bar appears to the right so I can scroll down. This is
quite inconvenient. I can also drag the lower part of the formula bar and
make it as many rows long as I want, but then it stays with that size until I
manually make it smaller again. This is quite manual intensive, so
inconvenient also.

Any way to make it work as in the old excel? (I know, I sound like a grumpy
grandma reluctant to change, but it's driving me mad!!!)

Thanks!