Auto cursor advancement in Excell after numerical entries - acros
 

I am trying to enter data from a survey. I would like the cursor to advance
to the next cell upon numerical entry. Also, I would like for the cursor to
return to the next set of 7 questions upon the last entry (7th). Thank you
Diana

Auto cursor advancement in Excell after numerical entries - acros
 

If you need the cursor to move to the right after entering data, go to the
menu bar and select Tools Options, and go to the Edit tab. Make sure that
'Move Selection after Enter' is checked and choose 'Right'.
If you want to advance back to the first column and down a row after every
7th entry, you've got two reasonable choices. The first is just to have the
user highlight the 7 columns and a bunch of rows and start entering data.
You'll continue to column 7, then wrap back and down. Just be careful when
you reach the end of the selected block.
A bit more complicated to set up, but easier to use is cell protection.
Select the 7 columns where data is to be input (highlight the complete
columns). Then Format Cells, select the Protection tab and uncheck
'Locked'; click OK. Then Tools Protection Protect Sheet. Uncheck
'Select Locked Cells' and click OK. Now the user will always wrap to the
next row after entering data in the final column. You can always turn
protection off (Tools Protection Unprotect Sheet) when you need to add
formulas and such.
HTH. --Bruce


" wrote:

I am trying to enter data from a survey. I would like the cursor to advance
to the next cell upon numerical entry. Also, I would like for the cursor to
return to the next set of 7 questions upon the last entry (7th). Thank you
Diana