Change height of the Formula Bar in Excel?
 

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.
--
Michael Stewart

Change height of the Formula Bar in Excel?
 

Michael

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"csustew" wrote in message
...
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.
--
Michael Stewart

Change height of the Formula Bar in Excel?
 

The formula bar height cannot be changed.

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

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

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

WindowNew WindowArrangeHorizontal.

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

On Mon, 19 Jun 2006 15:12:01 -0700, csustew
wrote:

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

Change height of the Formula Bar in Excel?
 

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

Cheers

--
Michael Stewart


"Gord Dibben" wrote:

The formula bar height cannot be changed.

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

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

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

WindowNew WindowArrangeHorizontal.

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

On Mon, 19 Jun 2006 15:12:01 -0700, csustew
wrote:

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