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

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.