Assign Cell to move to
 

I have created a form for sales people to complete.

(a) Is there a way to lock all cells to the left and bottom of the
spreadsheet without manually locking them all? I am trying to prevent the
user from tabbing or entering to a space outside the form.

(2) When the person completing the form fills in the last box (cell) is
there a way to automatically go HOME when they hit the enter key? I know how
to do this manually, but I don't want to have each of them do that.
Thanks

Assign Cell to move to
 

joaniemic wrote:
I have created a form for sales people to complete.

(a) Is there a way to lock all cells to the left and bottom of the
spreadsheet without manually locking them all? I am trying to prevent the
user from tabbing or entering to a space outside the form.

(2) When the person completing the form fills in the last box (cell) is
there a way to automatically go HOME when they hit the enter key? I know how
to do this manually, but I don't want to have each of them do that.
Thanks

Maybe you could use a "user form" for inputing the data.