Microsoft Office Tutorials and References
In Depth Information
Adding and Editing Records
Table 1-3
Entering Data with Keystrokes
Data It Enters
Ctrl+’ (apostrophe)
Repeats the entry for the field from the previous record
Ctrl+; (semicolon)
Inserts the current date
Ctrl+Shift+: (colon)
Inserts the current time
Inserts the default value for a field
You can also use the Windows cut-and-paste shortcut keys. Press Ctrl+C to
copy the selected information to the clipboard, Ctrl+X to cut the selected
information and move it to the clipboard, and Ctrl+V to paste the information
from the clipboard at the current cursor location. (See Chapter 4 of this
minibook for more information on using the clipboard.)
Editing the data you have
Editing data is pretty straightforward. The only trick is noticing whether
you’re in overwrite mode (the entire contents are selected) or in edit mode
(a cursor is displayed). To get into edit mode, click where you want to place
the cursor, or press F2 to insert the cursor at the end of the data.
To edit data, place your cursor in the cell containing the data you want to
change, press the Backspace or Delete key to get rid of unwanted stuff, and
then type your replacement stuff.
Use these tricks when selecting text:
To replace the entire value, move the pointer to the left of the field until
it changes into a big plus sign and then click to select the whole cell.
Double-click to select a word or value.
Click at the beginning of what you want to select, press the Shift key,
and then click at the end of what you want to select.
If you have lots of text in a cell and want to see it all at once, select the cell
and press Shift+F2 to see the data in the Zoom dialog box (see Figure 1-8).
You can make any changes and then press Enter or click OK to return to the
datasheet. Click the Font button in the Zoom dialog box to change the font
and the font size. Any changes you make to the font in this dialog box are
retained, so the next time you display the Zoom dialog box, you see the data
with the new font settings. These settings don’t affect how the data is
displayed in the datasheet, however.
Search JabSto ::

Custom Search