Formula bar disapeared !

M

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 ?
 
T

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
 
G

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
 
Top