how to see cell-data in formula bar ?

T

theSefirah

Good day
I have tried searching for an answer to this question but didnt fin
anything relevant. Here it goes:
In MS Excel when I "drag down" a formula I want to see in the formul
bar Not the new formula for the respective new cell but the cel
contense (the actual data/text in the cell).

Its probably not a big deel but I cant find this Option anywhere ..

Thank you in advance
 
G

Gord Dibben

I am not sure what the real question is.

You will never see the data in the formula bar if you have a formula in a cell.

The formula results will be seen in the cells.

Seeing the formula and not the result indicates that the cell you typed it in
was formatted as text before you typed.

Select the cell and hit F2 then ENTER

OR.....on that sheet you have "View Formulas" enabled.

Hit CTRL + `(backquote above Tab key) to toggle off.


Gord Dibben MS Excel MVP



n Mon, 31 Jul 2006 08:55:26 -0400, theSefirah
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell shows the last typed text, no matter where it is typed 0
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Data visible in formula bar, but not in cells 1
Cell Reference & formula 5
Zeros in Formula Bar 3
Displaying results in formula bar when cell is hidden 1
view all text in formula bar 1
Cell contents in formula bar 9

Top