Pressing Enter to skip rows


D

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
 
Ad

Advertisements

G

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
 

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

Top