how to see cell-data in formula bar ?

  • Thread starter Thread starter theSefirah
  • Start date Start date
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
 
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
 
Back
Top