Once you've selected the necessary cells, enter the first value -- that would be cell A11. Then, press Tab. Enter the appropriate value for Cell B11 and press Tab. Continue in this fashion until you reach cell E11. Enter the value for E11 and press Tab. Instead of selecting F11, the cell to the right, Excel cycles around to the next cell in the selection, which is A12. That's right where you need to be to start the next new record!
This selection method cycles through only the selected cells, so you must select the appropriate number of records, or more records than you need. If you press Tab while in the last cell in the selection (cell E13 in the above example), Excel will cycle around to the first cell (A11). Consequently, if you're not careful, you could overwrite existing data. The trick, when you don't know exactly how many rows to select, is to select more rows than you need.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.