I have created an Excel Form that has two different columns of "blanks" and I
am trying to set it up for the user to go down one column and then down the
second column. I would prefer the cursor to not go 'left - to right'.
Any suggestions?

Tools | Options | [Edit] tab - check out the option labeled "Move Selection
After Enter ... Direction" - it has options, one of which is Down!

"Teresa" wrote:

I have created an Excel Form that has two different columns of "blanks" and I
am trying to set it up for the user to go down one column and then down the
second column. I would prefer the cursor to not go 'left - to right'.
Any suggestions?

Thanks JL. I already tried that and it does in fact go to the line below. The
problem is that There is a space(s) between each 'answer' field and I would
like to jump a line or so to go directly to the next field for data entry.
Any suggestions for that?

"JLatham" wrote:

Tools | Options | [Edit] tab - check out the option labeled "Move Selection
After Enter ... Direction" - it has options, one of which is Down!

"Teresa" wrote:

I have created an Excel Form that has two different columns of "blanks" and I
am trying to set it up for the user to go down one column and then down the
second column. I would prefer the cursor to not go 'left - to right'.
Any suggestions?

Can you live with sheet protection?

Select the range for users to enter data.......say A1:B20

FormatCellsProtectionUncheck "locked" options.

ToolsProtectionProtect SheetUncheck "select locked cells" and OK

With ENTER key set to move down start entering in A1.

Alternative is to use a named range.

Again with range to A1:B20, select A2 then CTRL and select A20 then B1:B20 then
A1 last

InsertNameDefine. Give your range a name like MyRange

In Nmaebox select MyRange and start typing and ENTERing


Gord Dibben MS Excel MVP


On Mon, 5 Mar 2007 09:32:11 -0800, Teresa
wrote:

I have created an Excel Form that has two different columns of "blanks" and I
am trying to set it up for the user to go down one column and then down the
second column. I would prefer the cursor to not go 'left - to right'.
Any suggestions?

I do have the sheet protection on. I will try the rest of it and let you
know. Thanks

"Gord Dibben" wrote:

Can you live with sheet protection?

Select the range for users to enter data.......say A1:B20

FormatCellsProtectionUncheck "locked" options.

ToolsProtectionProtect SheetUncheck "select locked cells" and OK

With ENTER key set to move down start entering in A1.

Alternative is to use a named range.

Again with range to A1:B20, select A2 then CTRL and select A20 then B1:B20 then
A1 last

InsertNameDefine. Give your range a name like MyRange

In Nmaebox select MyRange and start typing and ENTERing


Gord Dibben MS Excel MVP


On Mon, 5 Mar 2007 09:32:11 -0800, Teresa
wrote:

I have created an Excel Form that has two different columns of "blanks" and I
am trying to set it up for the user to go down one column and then down the
second column. I would prefer the cursor to not go 'left - to right'.
Any suggestions?

It should work if set up the way Gord Dibben has instructed. That's about
the only way I know to skip cells without resorting to VB code (or clicking
with a mouse or entering directly into the Name Box - I mention those to keep
others from reminding me that those options exist).

"Teresa" wrote:

I do have the sheet protection on. I will try the rest of it and let you
know. Thanks

"Gord Dibben" wrote:

Can you live with sheet protection?

Select the range for users to enter data.......say A1:B20

FormatCellsProtectionUncheck "locked" options.

ToolsProtectionProtect SheetUncheck "select locked cells" and OK

With ENTER key set to move down start entering in A1.

Alternative is to use a named range.

Again with range to A1:B20, select A2 then CTRL and select A20 then B1:B20 then
A1 last

InsertNameDefine. Give your range a name like MyRange

In Nmaebox select MyRange and start typing and ENTERing


Gord Dibben MS Excel MVP


On Mon, 5 Mar 2007 09:32:11 -0800, Teresa
wrote:

I have created an Excel Form that has two different columns of "blanks" and I
am trying to set it up for the user to go down one column and then down the
second column. I would prefer the cursor to not go 'left - to right'.
Any suggestions?

Ok guys. I did work...BUT, now it has decided to skip over one of the cells.
It is a 'drop list' created through the validation. I have others in the form
and they are woking fine. It just skips right over it. I can tab to it, but
not enter. Help? Any further suggestions? (other than 'give it up')

"JLatham" wrote:

It should work if set up the way Gord Dibben has instructed. That's about
the only way I know to skip cells without resorting to VB code (or clicking
with a mouse or entering directly into the Name Box - I mention those to keep
others from reminding me that those options exist).

"Teresa" wrote:

I do have the sheet protection on. I will try the rest of it and let you
know. Thanks

"Gord Dibben" wrote:

Can you live with sheet protection?

Select the range for users to enter data.......say A1:B20

FormatCellsProtectionUncheck "locked" options.

ToolsProtectionProtect SheetUncheck "select locked cells" and OK

With ENTER key set to move down start entering in A1.

Alternative is to use a named range.

Again with range to A1:B20, select A2 then CTRL and select A20 then B1:B20 then
A1 last

InsertNameDefine. Give your range a name like MyRange

In Nmaebox select MyRange and start typing and ENTERing


Gord Dibben MS Excel MVP


On Mon, 5 Mar 2007 09:32:11 -0800, Teresa
wrote:

I have created an Excel Form that has two different columns of "blanks" and I
am trying to set it up for the user to go down one column and then down the
second column. I would prefer the cursor to not go 'left - to right'.
Any suggestions?

A contradiction here in my mind.............

"skips right over it" and "I can Tab to it but not enter".

Which is it?

What happens when you try to enter? A DV drop-down list should throw an error
if you try to enter something not on the list.


Gord


On Tue, 6 Mar 2007 06:26:40 -0800, Teresa
wrote:

Ok guys. I did work...BUT, now it has decided to skip over one of the cells.
It is a 'drop list' created through the validation. I have others in the form
and they are woking fine. It just skips right over it. I can tab to it, but
not enter. Help? Any further suggestions? (other than 'give it up')

"JLatham" wrote:

It should work if set up the way Gord Dibben has instructed. That's about
the only way I know to skip cells without resorting to VB code (or clicking
with a mouse or entering directly into the Name Box - I mention those to keep
others from reminding me that those options exist).

"Teresa" wrote:

I do have the sheet protection on. I will try the rest of it and let you
know. Thanks

"Gord Dibben" wrote:

Can you live with sheet protection?

Select the range for users to enter data.......say A1:B20

FormatCellsProtectionUncheck "locked" options.

ToolsProtectionProtect SheetUncheck "select locked cells" and OK

With ENTER key set to move down start entering in A1.

Alternative is to use a named range.

Again with range to A1:B20, select A2 then CTRL and select A20 then B1:B20 then
A1 last

InsertNameDefine. Give your range a name like MyRange

In Nmaebox select MyRange and start typing and ENTERing


Gord Dibben MS Excel MVP


On Mon, 5 Mar 2007 09:32:11 -0800, Teresa
wrote:

I have created an Excel Form that has two different columns of "blanks" and I
am trying to set it up for the user to go down one column and then down the
second column. I would prefer the cursor to not go 'left - to right'.
Any suggestions?

If I try and use the enter key it goes from A1 to A3. If I use the tab button
it will go to A1, A2, and A3 etc. The enter key will go past the A2 field.
There is a list I created (with the validation option) that is in the A2
field. I can select it manually, tab to it, but not enter to that field. I
have other fields further down the form that are set up the exact same way
and they are fine. I can enter to those. Could this be and "I-D-10-T" error.
Am I missing something? Sorry for my frustration and incomplete descriptions.

"Gord Dibben" wrote:

A contradiction here in my mind.............

"skips right over it" and "I can Tab to it but not enter".

Which is it?

What happens when you try to enter? A DV drop-down list should throw an error
if you try to enter something not on the list.


Gord


On Tue, 6 Mar 2007 06:26:40 -0800, Teresa
wrote:

Ok guys. I did work...BUT, now it has decided to skip over one of the cells.
It is a 'drop list' created through the validation. I have others in the form
and they are woking fine. It just skips right over it. I can tab to it, but
not enter. Help? Any further suggestions? (other than 'give it up')

"JLatham" wrote:

It should work if set up the way Gord Dibben has instructed. That's about
the only way I know to skip cells without resorting to VB code (or clicking
with a mouse or entering directly into the Name Box - I mention those to keep
others from reminding me that those options exist).

"Teresa" wrote:

I do have the sheet protection on. I will try the rest of it and let you
know. Thanks

"Gord Dibben" wrote:

Can you live with sheet protection?

Select the range for users to enter data.......say A1:B20

FormatCellsProtectionUncheck "locked" options.

ToolsProtectionProtect SheetUncheck "select locked cells" and OK

With ENTER key set to move down start entering in A1.

Alternative is to use a named range.

Again with range to A1:B20, select A2 then CTRL and select A20 then B1:B20 then
A1 last

InsertNameDefine. Give your range a name like MyRange

In Nmaebox select MyRange and start typing and ENTERing


Gord Dibben MS Excel MVP


On Mon, 5 Mar 2007 09:32:11 -0800, Teresa
wrote:

I have created an Excel Form that has two different columns of "blanks" and I
am trying to set it up for the user to go down one column and then down the
second column. I would prefer the cursor to not go 'left - to right'.
Any suggestions?

What is the exact range you are concerned about and what order do you want to
have for that range?

Which method from my first post are you attempting to employ?

The "protection" method or the "named range" method?

Re-read the original post and try again with either method.

If using the protection method don't forget, when protecting the sheet, to
uncheck "select locked cells" so you can Tab or ENTER to locked cells only.


Gord

On Tue, 6 Mar 2007 11:09:35 -0800, Teresa
wrote:

If I try and use the enter key it goes from A1 to A3. If I use the tab button
it will go to A1, A2, and A3 etc. The enter key will go past the A2 field.
There is a list I created (with the validation option) that is in the A2
field. I can select it manually, tab to it, but not enter to that field. I
have other fields further down the form that are set up the exact same way
and they are fine. I can enter to those. Could this be and "I-D-10-T" error.
Am I missing something? Sorry for my frustration and incomplete descriptions.

"Gord Dibben" wrote:

A contradiction here in my mind.............

"skips right over it" and "I can Tab to it but not enter".

Which is it?

What happens when you try to enter? A DV drop-down list should throw an error
if you try to enter something not on the list.


Gord


On Tue, 6 Mar 2007 06:26:40 -0800, Teresa
wrote:

Ok guys. I did work...BUT, now it has decided to skip over one of the cells.
It is a 'drop list' created through the validation. I have others in the form
and they are woking fine. It just skips right over it. I can tab to it, but
not enter. Help? Any further suggestions? (other than 'give it up')

"JLatham" wrote:

It should work if set up the way Gord Dibben has instructed. That's about
the only way I know to skip cells without resorting to VB code (or clicking
with a mouse or entering directly into the Name Box - I mention those to keep
others from reminding me that those options exist).

"Teresa" wrote:

I do have the sheet protection on. I will try the rest of it and let you
know. Thanks

"Gord Dibben" wrote:

Can you live with sheet protection?

Select the range for users to enter data.......say A1:B20

FormatCellsProtectionUncheck "locked" options.

ToolsProtectionProtect SheetUncheck "select locked cells" and OK

With ENTER key set to move down start entering in A1.

Alternative is to use a named range.

Again with range to A1:B20, select A2 then CTRL and select A20 then B1:B20 then
A1 last

InsertNameDefine. Give your range a name like MyRange

In Nmaebox select MyRange and start typing and ENTERing


Gord Dibben MS Excel MVP


On Mon, 5 Mar 2007 09:32:11 -0800, Teresa
wrote:

I have created an Excel Form that has two different columns of "blanks" and I
am trying to set it up for the user to go down one column and then down the
second column. I would prefer the cursor to not go 'left - to right'.
Any suggestions?