user-friendly data-entry

Corticus · May 16th, 2002, 06:58 AM

is there a way to have Excel go to a specified cell(or direction) after you populate a cell and hit enter,
like skip a line going down, or go across?

Lisa · May 16th, 2002, 07:03 AM

For simple direction: ie 1 cell up,down, right or left you can go to Tools - Options - Edit - "move selection after enter" and Use the drop down box to check your choice.

I'm not sure about going down 2 lines.....

Lisa

sen_edp · May 16th, 2002, 07:03 AM

hello

yes there is

go to the options menu
edit
move selection after enter
down,up,left,right

_________________
Best Regards,
Andreas
using Excel 2000 - Windows 2000 prof.

[ This Message was edited by: sen_edp on 2002-05-16 06:05 ]

Corticus · May 16th, 2002, 07:08 AM

More specifically, I would to skip lines, or specify a new cell to go to, so the data entry person doesn't have to move around finding the right cells if they're entering a whole lot of data

Audiojoe · May 16th, 2002, 07:09 AM

How about locking the cells you dont want to use and tabbing between the unlocked ones?

Corticus · May 16th, 2002, 07:18 AM

I tried the Tab thing,
but the data is entered down columns, with a formula between each entry

X
=F(x)
Y
=F(y)
Z
=F(z)

Thanks,
Corticus

Audiojoe · May 16th, 2002, 07:30 AM

Try highlighting the cells you want the user to be able to fill in by holding down CTRL and clicking on them all. Then right click and go to FORMAT CELLS>PROTECTION and unchecking the Locked box. Now click OK and Protect the sheet

Now when you tab, the only cells you can move to are the unlocked ones

[ This Message was edited by: Audiojoe on 2002-05-16 06:31 ]

Corticus · May 16th, 2002, 07:37 AM

I have the cells locked appropriately,
I can tab across the fields,
I guess what I want to do is tab down-
I know it sounds strange,
a lot of our data is entered down columns, and tab goes across

kinkyparamour · May 16th, 2002, 07:46 AM

As others have stated, once you lock the cells and protect the worksheet your tab key will move you down to as many lines as needed........

Denny

Corticus · May 16th, 2002, 07:52 AM

there is an unlocked cell to the right as well,
I don't want it to go to that cell,
I want it to go down

thanks
Corticus

[ This Message was edited by: Corticus on 2002-05-16 06:53 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 06:58 AM	#1
Corticus Board Regular Join Date: Apr 2002 Location: Sarasota, FL Posts: 1,539	is there a way to have Excel go to a specified cell(or direction) after you populate a cell and hit enter, like skip a line going down, or go across?

May 16th, 2002, 07:03 AM	#2
Lisa Board Regular Join Date: Apr 2002 Location: Indianapolis Posts: 80	For simple direction: ie 1 cell up,down, right or left you can go to Tools - Options - Edit - "move selection after enter" and Use the drop down box to check your choice. I'm not sure about going down 2 lines..... Lisa

May 16th, 2002, 07:03 AM	#3
sen_edp Board Regular Join Date: Mar 2002 Location: Hellas Posts: 553	hello yes there is go to the options menu edit move selection after enter down,up,left,right _________________ Best Regards, Andreas using Excel 2000 - Windows 2000 prof. [ This Message was edited by: sen_edp on 2002-05-16 06:05 ]

May 16th, 2002, 07:08 AM	#4
Corticus Board Regular Join Date: Apr 2002 Location: Sarasota, FL Posts: 1,539	More specifically, I would to skip lines, or specify a new cell to go to, so the data entry person doesn't have to move around finding the right cells if they're entering a whole lot of data

May 16th, 2002, 07:09 AM	#5
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	How about locking the cells you dont want to use and tabbing between the unlocked ones?

May 16th, 2002, 07:18 AM	#6
Corticus Board Regular Join Date: Apr 2002 Location: Sarasota, FL Posts: 1,539	I tried the Tab thing, but the data is entered down columns, with a formula between each entry X =F(x) Y =F(y) Z =F(z) Thanks, Corticus

May 16th, 2002, 07:30 AM	#7
Audiojoe Board Regular Join Date: Feb 2002 Location: Where the wild roses grow Posts: 285	Try highlighting the cells you want the user to be able to fill in by holding down CTRL and clicking on them all. Then right click and go to FORMAT CELLS>PROTECTION and unchecking the Locked box. Now click OK and Protect the sheet Now when you tab, the only cells you can move to are the unlocked ones [ This Message was edited by: Audiojoe on 2002-05-16 06:31 ]

May 16th, 2002, 07:37 AM	#8
Corticus Board Regular Join Date: Apr 2002 Location: Sarasota, FL Posts: 1,539	I have the cells locked appropriately, I can tab across the fields, I guess what I want to do is tab down- I know it sounds strange, a lot of our data is entered down columns, and tab goes across

May 16th, 2002, 07:46 AM	#9
kinkyparamour Board Regular Join Date: Feb 2002 Location: Florida Posts: 82	As others have stated, once you lock the cells and protect the worksheet your tab key will move you down to as many lines as needed........ Denny

May 16th, 2002, 07:52 AM	#10
Corticus Board Regular Join Date: Apr 2002 Location: Sarasota, FL Posts: 1,539	there is an unlocked cell to the right as well, I don't want it to go to that cell, I want it to go down thanks Corticus [ This Message was edited by: Corticus on 2002-05-16 06:53 ]