Controlling Cell/Cursor Placement
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! |
All times are GMT +1. The time now is 04:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com