Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Result Before Accepting, Possible?
With Excel 2007 can you customize the formula bar to give you the result of
what you type before you hit enter? This was a nice feature in Excel 2000 with the equal ( = ) button. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula Result Before Accepting, Possible?
With Excel 2007 can you customize the formula bar to give you the result
of what you type before you hit enter? This was a nice feature in Excel 2000 with the equal ( = ) button. I'm not familiar with Excel 2000, so I don't know how the Equal Button worked. However, if you want see the result of your formula before hitting Enter, you can press F9... BUT to actually use (or further edit) the formula, you MUST press Ctrl+Z (or click Undo in the Edit menu), otherwise the calculated value will be placed in the cell, not the formula that produced it. Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Accepting changes in word document | Excel Discussion (Misc queries) | |||
MORE THAN 8 IF CONDITION IN A FORMULA IS NOT ACCEPTING | Excel Worksheet Functions | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
Accepting Blank Cells | New Users to Excel |