Expanding Formula Bar

[Domingo]

Hi,

Wonder if anybody can tell me how to expand the formula bar to accomodate large formulas without blockink the vew of column headers...

[Chip Pearson]

Unfortunately, this cannot be done.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Domingo" <[email protected]>
wrote in message
news:[email protected]...
>
> Hi,
>
> Wonder if anybody can tell me how to expand the formula bar to
> accomodate large formulas without blockink the vew of column
> headers...
>
>
> --
> Domingo
> ------------------------------------------------------------------------
> Domingo's Profile:
> http://www.excelforum.com/member.php...o&userid=29891
> View this thread:
> http://www.excelforum.com/showthread...hreadid=495992
>

[Ragdyer]

BUT ... to easily toggle the formula bar off and on,
Think - View Formula -
<Alt> <V> <F>

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Chip Pearson" <[email protected]> wrote in message
news:[email protected]...
> Unfortunately, this cannot be done.
>
>
> --
> Cordially,
> Chip Pearson
> Microsoft MVP - Excel
> Pearson Software Consulting, LLC
> www.cpearson.com
>
>
> "Domingo" <[email protected]>
> wrote in message
> news:[email protected]...
> >
> > Hi,
> >
> > Wonder if anybody can tell me how to expand the formula bar to
> > accomodate large formulas without blockink the vew of column
> > headers...
> >
> >
> > --
> > Domingo
> > ------------------------------------------------------------------------
> > Domingo's Profile:
> > http://www.excelforum.com/member.php...o&userid=29891
> > View this thread:
> > http://www.excelforum.com/showthread...hreadid=495992
> >
>
>

[Gord Dibben]

Domingo

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



On Sun, 25 Dec 2005 16:33:39 -0600, Domingo
<[email protected]> wrote:

>
>Hi,
>
>Wonder if anybody can tell me how to expand the formula bar to
>accomodate large formulas without blockink the vew of column headers...

[Domingo]

Thank you all