Controlling Cell/Cursor Placement

M

MarkT

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!
 
R

RagDyeR

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!
=====================================================

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!
 
F

FSt1

hi.
on the xl toolbar Tools>options>edit tab > Move Selection after Enter.
take your pick.

regards
FSt1
 
S

Stefi

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


„MarkT†ezt írta:
 
Top