Home Excel 2002 Forms Form Tool In Excel's Data Menu
Search MS Office A-Z | Search Web Pages/ Design A-Z
Form Tool In Excel's Data Menu
- Open the excel spreadsheet.
- Go to Data | Form.
- The data-entry boxes are labeled with the column headings.
- To create a new record, click on the "New" button.
- Press Tab to move to the next field.
- Press Enter to finish the record.
- Type Ctrl/' to enter the info that appeared in that field in a previous record.
- To search for a record, click the "Criterion" button and fill in one of the fields with the information that takes you to the record.