Change Tools>Options>Edit>Move selection after enter, and use Enter to
complete entry rather than Tab. This prevents the selection from moving to
Note that calculation can never be done while the cell is being edited.
"Sisilla" <firstname.lastname@example.org> wrote in message
> When a user enters data into a cell, he has to tab out of
> it before he can push the "calculate" button. Is there any
> way to change this so that the calculation can be
> performed while the cell is still selected? I appreciate
> any help.