Greetings all:

I am wondering if there is a way to controll the way excel moves from one
cell to another cell after you hit the "enter" or "tab" keys? I created a
spreadsheet for my employees, they will start off in one specific cell, then
they must go in a sequence of other cells on the sheet entering in various
information. I would like the spreadsheet to automatically move to the next
cell where they need to go. Is this possilbe?

Thanks for your help!

One way is to use a "named range".

Check out this old post:

http://tinyurl.com/39vzv

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"MarkT" wrote in message
...
Greetings all:

I am wondering if there is a way to controll the way excel moves from one
cell to another cell after you hit the "enter" or "tab" keys? I created a
spreadsheet for my employees, they will start off in one specific cell, then
they must go in a sequence of other cells on the sheet entering in various
information. I would like the spreadsheet to automatically move to the next
cell where they need to go. Is this possilbe?

Thanks for your help!

hi.
on the xl toolbar Toolsoptionsedit tab Move Selection after Enter.
take your pick.

regards
FSt1

"MarkT" wrote:

Greetings all:

I am wondering if there is a way to controll the way excel moves from one
cell to another cell after you hit the "enter" or "tab" keys? I created a
spreadsheet for my employees, they will start off in one specific cell, then
they must go in a sequence of other cells on the sheet entering in various
information. I would like the spreadsheet to automatically move to the next
cell where they need to go. Is this possilbe?

Thanks for your help!

Unlock the cells to be used, protect the worksheet, then Tab moves to the
next unlocked cell.
Regards,
Stefi


€žMarkT€� ezt Ã*rta:

Greetings all:

I am wondering if there is a way to controll the way excel moves from one
cell to another cell after you hit the "enter" or "tab" keys? I created a
spreadsheet for my employees, they will start off in one specific cell, then
they must go in a sequence of other cells on the sheet entering in various
information. I would like the spreadsheet to automatically move to the next
cell where they need to go. Is this possilbe?

Thanks for your help!