Enter x TAB

[Juran]

I have a form in Excel, which is protected. After I
entered a data and press TAB the cursor jumps to cell I
want. When I entered a data and press ENTER the cursor
jumps to an adjacent cell.

Exemple:

TAB - I enter a data on A1 press TAB goes to D1 (what I want)
ENTER - I enter a data on A1 press ENTER goes to B1 (what
I do not want)

Any Suggestion?

Thank You.

Juran

 

[Gord Dibben]

Don't press ENTER key.

Which version of Excel are you running?

It is helpful to post this information because not versions have the same
features.

If using Excel 2002 or 2003 there are options available when protecting a
sheet.

If you set the option to "select unlocked cells" and de-select "select locked
cells", the ENTER key will move to unlocked cells only.

If necessary, you can set the direction of move after enter under
Tools>Options>Edit.

Gord Dibben Excel MVP