.The following table lists mouse techniques for selecting data or records in Datasheet view.
| To select | Click |
|---|---|
| Data in a field | Where you want to start selecting and drag across the data. |
| An entire field | The left edge of the field in a datasheet, where the pointer changes into . |
| Adjacent fields | The left edge of a field and drag to extend the selection. |
| A column | The field selector. |
| Adjacent columns | The field name at the top of the column and then, without releasing the mouse, drag to extend the selection. |
| A record | The record selector. |
| Multiple records | The record selector of the first record, and then drag to extend the selection. |
| All records | Select All Records on the Edit menu. |
The following table lists keyboard techniques for selecting data or records in Datasheet view.
| To select | Do this |
|---|---|
| Data in a field | Move the insertion point to the start of the text you want to select, and then hold down SHIFT and press the arrow keys to move to the end of the selection. |
| An entire field | Move the insertion point to the field, and press F2. |
| Adjacent fields | With a field selected, hold down SHIFT and press the appropriate arrow key. |
| The current column | Press CTRL+SPACEBAR. |
| The current record | Press SHIFT+SPACEBAR. |
| Multiple records | Press SHIFT+SPACEBAR, and then SHIFT+UP ARROW or SHIFT+DOWN ARROW. |