Formula Bar contents missing

[Griffen]

The contents of my worksheet cells don't show up in my formula bars. I have
to use F2 to see and change the contents of my cells. The cells are not
locked or hidden, but nothing shows up in the Formula bar. It happens in new
or older worksheets alike. I'm in ver 2007. Ideas?

 

[Bernard Liengme]

Say you have two numbers in A1 and A2, and =A1+A2 in cell A3
If you click A3, are you saying you see nothing in the Formula Bar?
How about if you click A1?
Tell use more, please
best wishes

 

[Griffen]

In your example, if I click on A1, A2 or A3, the formula bar remains blank.
I have to use F2 to edit the cell. Nothing appears in the Form Bar. If I
click on the Formula bar, only the contents of A3 will appear. A1 and A2
show nothing in the Form bar. Does this help?

 

[Bernard Liengme]

Very odd. I would be tempted to do a repair to Office
I cannot think of any option that hides things from Formula Bar
best wishes

 

[Dave Peterson]

Do you use multiple monitors?

The contents of my worksheet cells don't show up in my formula bars. I have
to use F2 to see and change the contents of my cells. The cells are not
locked or hidden, but nothing shows up in the Formula bar. It happens in new
or older worksheets alike. I'm in ver 2007. Ideas?

 

[Grant Nordwall]

Hello, thanks Dave - that is exactly the issue. I have the same problem and if I switch to the other monitor, it behaves fine. Incidentally, on my machine, it's not the entire excel formula bar that is blank, only the first 8 characters. And if I hit F2 to edit, I loose the first 12 characters. But if I put it on the secondary monitor, everything is fine. (this may be why it seems like an intermittent problem).



Dave Peterson wrote:

Re: Formula Bar contents missing
29-May-09

Do you use multiple monitors?

Griffen wrote:

--

Dave Peterson

Previous Posts In This Thread:

Formula Bar contents missing
The contents of my worksheet cells do not show up in my formula bars. I have
to use F2 to see and change the contents of my cells. The cells are not
locked or hidden, but nothing shows up in the For

Say you have two numbers in A1 and A2, and =A1+A2 in cell A3If you click A3,
Say you have two numbers in A1 and A2, and =A1+A2 in cell A3
If you click A3, are you saying you see nothing in the Formula Bar?
How about if you click A1?
Tell use more, please
best wishes
--
Bernard

In your example, if I click on A1, A2 or A3, the formula bar remains blank.
In your example, if I click on A1, A2 or A3, the formula bar remains blank.
I have to use F2 to edit the cell. Nothing appears in the Form Bar. If I
click on the Formula bar, only the contents of A3

Very odd.
Very odd. I would be tempted to do a repair to Office
I cannot think of any option that hides things from Formula Bar
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengm

Re: Formula Bar contents missing
Do you use multiple monitors?

Griffen wrote:

--

Dave Peterson

EggHeadCafe - Software Developer Portal of Choice
TreeView - JavaScript IE / FireFox IFRAME Combination
http://www.eggheadcafe.com/tutorial...d6c-264bc38d08ee/treeview--javascript-ie.aspx

 

[Dave Peterson]

There have been some people who complained that the text would appear in the
formula bar, but not in the cell in the worksheet.

http://groups.google.co.uk/group/mi...isplay+group:*excel*&rnum=16#7109488256478b2d

or

http://snipurl.com/1crbf

Mike Brambley posts a link to a suggestion that worked for him.

 

[CV]

I had this issue as well. No cell protection of any kind, yet formulas were
not appearing in my formula bar. The cursor would appear at the end of the
invisible text, and if I hit "space" earlier in the formula bar, the whole
string appeared, temporarily.

Anyway, all I had to do was move my excel window from my secondary monitor
to my primary monitor, and it worked. If I select a cell, its contents appear
in the formula bar. It still worked after I moved the window back to my
external monitor.

 

[trbrooks]

The contents of my worksheet cells don't show up in my formula bars. I have
to use F2 to see and change the contents of my cells. The cells are not
locked or hidden, but nothing shows up in the Formula bar. It happens in new
or older worksheets alike. I'm in ver 2007. Ideas?

I had this same problem just now, and the fix was incredibly easy.

Simply hide your formula bar by going to View > Fomula Bar (uncheck). Then "unhide" it by checking "Formula Bar" again.

Hope that helps.