Mixed cell displays--values and formulas showing on same worksheet

  • Thread starter Thread starter Compu Geek
  • Start date Start date
C

Compu Geek

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
 
Try pressing ONCE the keys combination: CTRL + TILDE
[TILDE is the ~ key]
Micky
 
This let's me toggle between displaying values and formulas for the cells
that were showing values. The cells that were showing formulas continue to
show formulas throughout.

מיכ×ל (מיקי) ×בידן said:
Try pressing ONCE the keys combination: CTRL + TILDE
[TILDE is the ~ key]
Micky


Compu Geek said:
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
Click to expand...
Click to expand...
 
Select the "funny" range > 'DATA' > 'TEXT TO COLUMNS...' > 'FINISH'
Micky


Compu Geek said:
This let's me toggle between displaying values and formulas for the cells
that were showing values. The cells that were showing formulas continue to
show formulas throughout.

מיכ×ל (מיקי) ×בידן said:
Try pressing ONCE the keys combination: CTRL + TILDE
[TILDE is the ~ key]
Micky


Compu Geek said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top