Jon

Have not heard of any setting that would prevent this.

Work-around could be to enter a WindowSplit at say A5. Select your cell
with the long formula in the lower part of the split window. The text in the
formula bar would cover just the top part of the split window.

Alternative.........reduce the size of the sheet window and move it down far
enough to be below the extent of the formula bar.

I know it's clunky but what else?


Gord Dibben Excel MVP


On Tue, 22 Feb 2005 18:29:07 -0800, "Jon Bouy"
wrote:

Thanks for the quick response RD!

This would work, but I was looking more for a height adjustment so I can
have my cake & eat it too ;-}


"RagDyer" wrote:

Controlled ... like toggle off and on?

<Alt + <V<F
OR
<View and check - uncheck <FormulaBar.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"Jon Bouy" <Jon wrote in message
...
With multi-line text (Alt-Enter) in the Formula Bar, it automagically
extends
the height of the bar. This interferes with column actions since the bar now
obscures the column headings (A through ...). Painful when the 1st cell in a
column is multi-line.

Can this 'feature' be controlled?