Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mixed cell displays--values and formulas showing on same works
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. "מיכאל (מיקי) אבידן" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mixed cell displays--values and formulas showing on same works
Select the "funny" range 'DATA' 'TEXT TO COLUMNS...' 'FINISH'
Micky "Compu Geek" wrote: 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. "מיכאל (מיקי) אבידן" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mixed cell displays--values and formulas showing on same works
In which case those cells are presumably formatted as text. Format as
General, then re-enter the formula. -- David Biddulph Compu Geek wrote: 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. "????? (????) ?????" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you print a worksheet that displays the formulas? | Excel Discussion (Misc queries) | |||
values not showing for copied formulas | Excel Worksheet Functions | |||
Formulas showing on worksheet | Excel Discussion (Misc queries) | |||
Formulas showing as text rather than values | Excel Discussion (Misc queries) | |||
Spreadsheet is only showing formulas not the actual values | Excel Worksheet Functions |