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