another question...

[Carmel]

Hi Everyone!
This is probably another one I really should know but here
goes...
In a form for data entry that I'm building for my
colleagues, I want people who complete the row and
press "Enter" to be sent to the first cell (eg A2, A3 etc)
of the row below. At present, if I do "Enter" I get sent
to the first cell on the screen (which in my example is
G2, G3 etc).

Help anyone???
Thanks in advance!

 

[Gord Dibben]

Carmel

Teach your users to use the TAB key while moving across the row until the last
entry, then hit Enter key.

This will move you back to start column down one row.

OR

Assume columns A through G to have data entered.

Select those columns then Format>Cells>Protection. "unlock" those cells.

Now Tools>Protection>Protect Sheet.

Using the TAB key only will move across A to G then back to A down one row.

If using Excel 2002 or 2003 when Protecting the sheet, you will have the
option of unchecking "allow users to select locked cells".

Then set your ENTER key to move right after entry. See Tools>Options>Edit for
settings.

Gord Dibben Excel MVP

 

[Carmel]

Thanks Gord!

-----Original Message-----
Carmel

Teach your users to use the TAB key while moving across the row until the last
entry, then hit Enter key.

This will move you back to start column down one row.

OR

Assume columns A through G to have data entered.

Select those columns then

Format>Cells>Protection. "unlock" those cells.