Formula bar disapeared !

[Guest]

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 ?

 

[Jerry W. Lewis]

View|Formula Bar

Jerry

 

[Guest]

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

 

[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