Inputting data is seldom anybody's favorite chore but controlling the way the cursor moves certainly eases the task. Data entry can be a thankless job and if Excel doesn’t cooperate, it can be a ...

Of course, if you want to enter, say, 50 into a cell, you now have to type either 5000 or 50. (but if this setting makes sense to you, no doubt you’re already aware of that).

Lay out your data entry form. Start by typing and formatting a title and some labels for the data entry form, like the ones shown in Figure A. Notice that we “colorized” and adjusted the ...