Formula Bar contents missing

  • Thread starter Thread starter Griffen
  • Start date Start date
G

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?
 
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
 
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?
 
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
 
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?
Click to expand...
 
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
 
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.
 
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?
Click to expand...

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.
 
Back
Top