Friday, June 17, 2005
If you're entering data that is arranged in rows, you may find it helpful to use Excel's built-in data form for data entry. To enter data using a data entry form, follow these steps.
If your data entry range does not have descriptive headings in the first row, enter some headings.
You can always erase these headings later if you don't need them.
Select any cell in the header row.
Choose the Data, Form command.
Excel asks if you want to use that row for headers (click OK). It then displays a dialog box with edit boxes and several buttons.
Enter data into the edit boxes, using Tab to move between the boxes. When you complete entering the data for a row, click the New button. Click Close when finished.
Excel dumps the data into the worksheet and clears the dialog box for the next row.
If your data entry range does not have descriptive headings in the first row, enter some headings.
You can always erase these headings later if you don't need them.
Select any cell in the header row.
Choose the Data, Form command.
Excel asks if you want to use that row for headers (click OK). It then displays a dialog box with edit boxes and several buttons.
Enter data into the edit boxes, using Tab to move between the boxes. When you complete entering the data for a row, click the New button. Click Close when finished.
Excel dumps the data into the worksheet and clears the dialog box for the next row.
