Microsoft Office Tutorials and References
In Depth Information
Adding and Editing Records
✦ Press the spacebar to change a check-box setting from selected to
deselected, or vice versa.
✦ Press F4 to open a drop-down menu, press the ↓ key to make your
choice, and then press Enter.
If you change your mind about your entry, press the Esc key to cancel it. If
you’ve already pressed Enter, you can undo the last entry by clicking the
Undo button (a small button on the toolbar above the Ribbon) or pressing
Ctrl+Z (a shortcut for Undo in many applications). Another useful keystroke
to know is Ctrl+’ (apostrophe), which repeats the value in the record
immediately above the cursor.
Table 1-2 lists all the keystrokes you’ll ever need to enter and edit data.
Keystrokes in Datasheet View
What It Does
Ctrl++ (plus sign)
Moves the cursor to a new record
Enter or Tab
Enters the data and moves to the next cell to the right or to
the first field of the next record
Cancels the current entry
Undo or Ctrl+Z
Undoes the last entry
Displays a drop-down menu (if one is present) in the current
Copies the selected data
Cuts the selected data
Pastes data from the clipboard
Deletes the selected data
Enters a line break within an entry
Deletes the current record
Switches between the values in a check box or option button
Chapter 4 of this minibook covers cutting, copying, and pasting in detail.
Using keystrokes to enter data automatically
Access has a few extremely convenient keystrokes that enter data for you
automatically, and they’re listed in Table 1-3.