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 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. |
Select fields and records in a data access page
The following table lists mouse techniques for selecting data or records in Page view.
To select | Click |
---|---|
Data in a field | Where you want to start selecting and drag across the data |
An entire field | Three times within the field |
A record | A field that belongs to the record |
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 anywhere in the field, press HOME, and then press SHIFT+END. |
A record | Press TAB until a field that belongs to the record gets focus. |
Note Your data access page might have a Microsoft Office PivotTable Component, Spreadsheet Component, or Chart Component, which have their own methods of selection. To display Help for one of these components, click Help on its toolbar.