Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
forgotten menu function
I used to be able to check a formulas by going through it step by step using
a function of the menu. I can not debug formulas that way anymore. where can I find that function again. Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
forgotten menu function
What version of Excel are you using?
In Excel 2002 and 2003: ToolsFormula AuditingEvaluate Formula Biff "Masood Alikhail" wrote in message ... I used to be able to check a formulas by going through it step by step using a function of the menu. I can not debug formulas that way anymore. where can I find that function again. Thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
forgotten menu function
I am using excel 2000 now
"T. Valko" wrote: What version of Excel are you using? In Excel 2002 and 2003: ToolsFormula AuditingEvaluate Formula Biff "Masood Alikhail" wrote in message ... I used to be able to check a formulas by going through it step by step using a function of the menu. I can not debug formulas that way anymore. where can I find that function again. Thank you |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
forgotten menu function
Sorry, I don't know about Excel 2000.
Biff "Masood Alikhail" wrote in message ... I am using excel 2000 now "T. Valko" wrote: What version of Excel are you using? In Excel 2002 and 2003: ToolsFormula AuditingEvaluate Formula Biff "Masood Alikhail" wrote in message ... I used to be able to check a formulas by going through it step by step using a function of the menu. I can not debug formulas that way anymore. where can I find that function again. Thank you |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
forgotten menu function
An alternative that should work in all versions of Excel (but is not quite
the same as Evaluate Formula): With the formula cell selected, highlight the portion of the formula you want to evaluate in the formula bar and then press F9. Press ESC to return the formula back to its original state. This works but is limited in its scope. Biff "T. Valko" wrote in message ... Sorry, I don't know about Excel 2000. Biff "Masood Alikhail" wrote in message ... I am using excel 2000 now "T. Valko" wrote: What version of Excel are you using? In Excel 2002 and 2003: ToolsFormula AuditingEvaluate Formula Biff "Masood Alikhail" wrote in message ... I used to be able to check a formulas by going through it step by step using a function of the menu. I can not debug formulas that way anymore. where can I find that function again. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
forgotten password | Excel Discussion (Misc queries) | |||
forgotten passwor | Excel Discussion (Misc queries) | |||
forgotten password | Excel Discussion (Misc queries) | |||
HELP, I'VE FORGOTTEN | Excel Worksheet Functions | |||
Please help, forgotten password | Excel Discussion (Misc queries) |