Pressing Enter to skip rows



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




Gord Dibben


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.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question