Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas Displaying-Excel 2007
My formulas are showing up in some of my cells (not all cells though). I have
gone into Excel Options/Advanced/unchecked show formulas, etc. Any ideas? -- Thanks in advance for your time! denilynn |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas Displaying-Excel 2007
Have you tried going into the cells you want to hid the formulas in and
choosing format cellsProtectionhidden? After doing this you have to either protect teh sheet or the workbook before the formulas are hidden. Hope that helps "denilynn" wrote: My formulas are showing up in some of my cells (not all cells though). I have gone into Excel Options/Advanced/unchecked show formulas, etc. Any ideas? -- Thanks in advance for your time! denilynn |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas Displaying-Excel 2007
The cells MAY be formatted as text. Ctrl/1, Number tab will tell you. if
that's so, reformat (General?) and re-enter the formula (F2/Enter) "denilynn" wrote: My formulas are showing up in some of my cells (not all cells though). I have gone into Excel Options/Advanced/unchecked show formulas, etc. Any ideas? -- Thanks in advance for your time! denilynn |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Currency format for Excel 2007 not displaying actual number | Excel Discussion (Misc queries) | |||
Displaying linked data in excel 2007 when linked file is not avail | Excel Discussion (Misc queries) | |||
not displaying pie chart in excel 2007 | Charts and Charting in Excel | |||
Displaying formulas | Excel Worksheet Functions | |||
displaying formulas | Excel Discussion (Misc queries) |