Pressing Enter to skip rows

[DoctorWard]

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

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

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

I imagine a macro could achieve this.

Thanks in advance

D

 

[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