View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
מיכאל (מיקי) אבידן מיכאל (מיקי) אבידן is offline
external usenet poster
 
Posts: 561
Default Mixed cell displays--values and formulas showing on same worksheet

Try pressing ONCE the keys combination: CTRL + TILDE
[TILDE is the ~ key]
Micky


"Compu Geek" wrote:

I the same sheet of the same workbook, some of my cells are displaying the
value (for calculated values), whilst others are displaying the formula.
Originally, only the values were displaying.

I don't know what I did to get this...I think the green indicator appeared
on one of my cells, and when I clicked on it I chose one of the options it
displayed.

How do I get all my cells to appear consistently again?

This is Excel 2007