| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to move to next cell by entering data-not using Enter key.
I have posted this as a new user but hought I may get a better reponse here.I am using ms excel to enter data, 1 for Yes and 2 for No, for 300 items/questions listed successively in column A. The data is then tallied on another excel page. However, I would like to have the entry of 1 or 2 provide the jump to the next cell down ( each time1 or 2 is entered) rather than have to always press enter key to go to the next cell. Any ideas how to proceed? -- johnexcel ------------------------------------------------------------------------ johnexcel's Profile: http://www.excelforum.com/member.php...o&userid=26600 View this thread: http://www.excelforum.com/showthread...hreadid=398818 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| Macro entering data into a protected Cell?? | Excel Discussion (Misc queries) | |||
| Data Validation Cell - Move to UserForm | Excel Worksheet Functions | |||
| Must move mouse before entering data? | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Threaded Mode
