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?
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?
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
=================================
"E-QUIP" <[email protected]> wrote in message
news:[email protected]...
>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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks