View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Compu Geek Compu Geek is offline
external usenet poster
 
Posts: 8
Default Mixed cell displays--values and formulas showing on same worksheet

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