Working in Data Forms

To help you enter data in a database more easily, Excel offers data forms ”custom dialog boxes that Excel creates using the fields that make up the database. Excel provides keyboard shortcuts for navigating within and among data forms.

Shortcuts for Working in Data Forms

Insert a new, blank record in the database

[Ctrl] - [PageDown]

Move to the next record, first field

[Enter]

Move to the previous record, first field

[Shift] - [Enter]

Move to the next record, same field

[ “ ]

Excel selects the same field in the next record that was active in the current record.

Move to the previous record, same field

[ ‘ ]

Excel selects the same field in the previous record that was active in the current record.

Move ten records forward, same field

[PageDown]

Move ten records backward, same field

[PageUp]