| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I GET THE ANSWER TO A FORMULA BY PRESSING ENTER IN CELL?
I WOULD LIKE TO KNOW HOW TO GET THE ANSWER TO A FORMULA IN A CELL BY JUST
PRESSING ENTER IT SEEMS I HAVE TO PUT THE CURSOR AT THE END AND PRESS ENTER IS THERE A WAY TO JUST PRESS ENTER AND GET RESULT? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO I GET THE ANSWER TO A FORMULA BY PRESSING ENTER IN CELL?
Normally the results of formulas are automatically updated when the input
changes - you do not need to press enter key. Try this: Menu - ToolsOptionsCalculation TabMake Sure "Automatic" is checked. -- Best regards, --- Yongjun CHEN ================================= XLDataSoft - Data Analysis Expert, Excel/VBA Specialist - - - - www.XLDataSoft.com - - - - Free Excel-Based Data Processing Tool is Available for Download Free Excel / VBA Training Materials is Available for Download ================================= "E-QUIP" wrote in message ... I WOULD LIKE TO KNOW HOW TO GET THE ANSWER TO A FORMULA IN A CELL BY JUST PRESSING ENTER IT SEEMS I HAVE TO PUT THE CURSOR AT THE END AND PRESS ENTER IS THERE A WAY TO JUST PRESS ENTER AND GET RESULT? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is it possible? | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| how do i enter a formula in excel that will change a cell value | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula window displays correct answer while cell displays incorre | Excel Worksheet Functions | |||
Linear Mode
