Formula bar disapeared !

[Matteo]

Hello

My formula bar (the case above the sheet which display the content of the
cell) disapeared with no reason... I reinstalled Excel, but didn't came back
! Any idea how to display it again ?

[dominicb]

Good morning Matteo

Have you tried Tools > Options, View Tab and under Show, make sure that the Formula Bar box is ticked...

HTH

[Jerry W. Lewis]

View|Formula Bar

Jerry

Matteo wrote:

> Hello
>
> My formula bar (the case above the sheet which display the content of the
> cell) disapeared with no reason... I reinstalled Excel, but didn't came back
> ! Any idea how to display it again ?

[TH35]

Hey....looking for the same help here...but I've tried the view/formula
bar...i've tried chaning the preferences...nothing seems to work...my formula
bar is gone.

Thanks for your time!

TH

"Jerry W. Lewis" wrote:

> View|Formula Bar
>
> Jerry
>
> Matteo wrote:
>
> > Hello
> >
> > My formula bar (the case above the sheet which display the content of the
> > cell) disapeared with no reason... I reinstalled Excel, but didn't came back
> > ! Any idea how to display it again ?
>
>

[Gord Dibben]

Try this method

Application.DisplayFormulaBar = True

Copy the above line of code.

With Excel open, ALT + F11 to open VBE.

View>Immediate Window.

Paste the line in there and hit <ENTER>

ALT + Q to return to Excel screen.

Formula Bar is visible?


Gord Dibben MS Excel MVP

On Wed, 28 Jun 2006 15:36:02 -0700, TH35 <[email protected]> wrote:

>Hey....looking for the same help here...but I've tried the view/formula
>bar...i've tried chaning the preferences...nothing seems to work...my formula
>bar is gone.
>
>Thanks for your time!
>
>TH
>
>"Jerry W. Lewis" wrote:
>
>> View|Formula Bar
>>
>> Jerry
>>
>> Matteo wrote:
>>
>> > Hello
>> >
>> > My formula bar (the case above the sheet which display the content of the
>> > cell) disapeared with no reason... I reinstalled Excel, but didn't came back
>> > ! Any idea how to display it again ?
>>
>>