Pressing Enter to skip rows:drop-down list

[DoctorWard]

We have a pro-forma in Excel for clients. Anyway, the cells where they enter information from a drop-down list are three rows apart, going down the page.

Is there anyway for the client to press Enter just once and go three rows down rather than pressing enter three times?

I am aware that if the sheet is locked with the particular input cells unlocked then Tab will take you to the next box however, we need Enter to do the same.

I imagine a macro could achieve this.

Thanks in advance

DW

[Gord Dibben]

DW

You can give the range a name and ENTER your way through the cells in the order
you wish.

See Bob Phillips's site for methods of naming a range.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

Don't be put off by the title "Tab to selected cells". There is a method of
using the ENTER key.


Gord Dibben MS Excel MVP
On Tue, 6 Jun 2006 22:57:43 -0500, DoctorWard
<[email protected]> wrote:

>
>We have a pro-forma in Excel for clients. Anyway, the cells where they
>enter information from a drop-down list are three rows apart, going
>down the page.
>
>Is there anyway for the client to press Enter just once and go three
>rows down rather than pressing enter three times?
>
>I am aware that if the sheet is locked with the particular input cells
>unlocked then Tab will take you to the next box however, we need Enter
>to do the same.
>
>I imagine a macro could achieve this.
>
>Thanks in advance
>
>DW