O'Reilly logo

Excel 2003: The Missing Manual by Matthew MacDonald

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Data Form

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.

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 record using the scrollbar, and you can insert and remove records with a single button click. In the top-right corner, you'll see the total number of records in your list and your current position. In this example, the data form is on record 1 of 41.

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required