HOW DO I GET THE ANSWER TO A FORMULA BY PRESSING ENTER IN CELL?

[Guest]

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?

 

[Daniel CHEN]

Normally the results of formulas are automatically updated when the input
changes - you do not need to press enter key.

Try this:

Menu - Tools>Options>Calculation Tab>Make 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
=================================