Excel also gives you another way to look at list data, using a data form window. A data form is a separate window that shows the information from your list one record at a time. To try it, click in any row in your list and select Data → Form. An unusual looking window opens (see Figure 13-6), where you can edit each row using neatly organized textboxes.
The data form lets you navigate your list in many different ways:
Press the down arrow key (↓) to move down one record. You can also click the down arrow at the bottom of the scroll bar, or the Find Next button.
Press the up arrow key (↑) to move up one record. You can also click the up arrow at the top of the scroll bar, or the Find Prev button.
To move down 10 records at once, press the Page Down key.
To move up 10 records at once, press the Page Up key.
To move to the first record in the list, press Ctrl+↑ or drag the scroll box to the top of the scroll bar.
To move to the first record in the list, press Ctrl+↓ or drag the scroll box to the bottom of the scroll bar.
To move from one field to the next, press Tab. To move backward to the previous field, press Shift+Tab.
You can close the data form at any time by clicking the Close button.
Figure 13-6. The data form window lets you move through your data one record at a time. You can edit, insert, and delete records—all from one convenient location. You can move from record to ...