...I can't see the entire contents of the formula bar
unless I manually resize it.

Just to mention if you are dragging the formula bar down...

Ctrl + Shift + "U"

to toggle the expansion of the formula bar in Excel 2007.

= = = = =
HTH
Dana DeLouis


T. Valko wrote:
I don't like either behavior!

I hate in earlier versions when the grid gets covered but I also don't like
in Excel 2007 that I can't see the entire contents of the formula bar unless
I manually resize it.

You could set it to a "default" size, say, like 5 rows high, but then
whatever's in the formula bar won't always take up all 5 of those rows so
there's wasted space and those 5 rows push 5 rows out of the grid.

Damned if you do, damned if you don't!