Change height of the Formula Bar in Excel?

[Guest]

When I have a cell that contains multiple lines of text (usually forced with
Alt + Enter), the text covers the top few rows of cells on the worksheet when
it is displayed in the formula bar. Is there a way to change the height of
the Formula Bar (in Excel 2003) in order to allow all cells of the worksheet
to be selected, even when viewing a cell that has multiple lines of text?

Thanks for your help.

 

[Nick Hodge]

Michael

No it is not possible to re-size the formula bar

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)

 

[Gord Dibben]

The formula bar height cannot be changed.

Resize the Window so you're not working in a maximized window.

Alternative..........................

A kludgy work-around............

Window>New Window>Arrange>Horizontal.

Arrange top window so's it covers 4 or 5 rows.

Work in the bottom window. Your long formulas will drop down into the top
window when you select a cell in lower window.


Gord Dibben Excel MVP

When I have a cell that contains multiple lines of text (usually forced with
Alt + Enter), the text covers the top few rows of cells on the worksheet when
it is displayed in the formula bar. Is there a way to change the height of
the Formula Bar (in Excel 2003) in order to allow all cells of the worksheet
to be selected, even when viewing a cell that has multiple lines of text?

Thanks for your help.

Gord Dibben MS Excel MVP

 

[Guest]

Thanks for the work-around idea - that could be really helpful in certain
instances!

Cheers