Formula bar height in XL2K3 w/XP

[Guest]

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?

 

[RagDyer]

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!
==============================================

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?

 

[RagDyer]

AFAIK,

Can't be done!
--


Regards,

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

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 ;-}

 

[Guest]

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 ;-}

 

[Guest]

Oh well.

BTW, been around a while, but what is AFAIK?

 

[RagDyer]

As far as I know.
--


Regards,

RD

 

[Gord Dibben]

Jon

Have not heard of any setting that would prevent this.

Work-around could be to enter a Window>Split 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

 

[Dave Peterson]

If this bothers you mostly when you're selecting whole columns, maybe just
inserting a new row 1 (and delete it when you're done).

 

[Guest]

Looks like I'm stuck.

Your idea, Gord, helped in some cases.

The specific anoyance is that the column-context menu can't activate when
that area is obscured.

I can get it to work if I remember NOT to select the column first.