ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HOW DO I GET THE ANSWER TO A FORMULA BY PRESSING ENTER IN CELL? (https://www.excelbanter.com/excel-discussion-misc-queries/91459-how-do-i-get-answer-formula-pressing-enter-cell.html)

E-QUIP

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?

Daniel CHEN

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?





All times are GMT +1. The time now is 04:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com