Excel: Finding a Record Using the Data Form

• Microsoft Excel for the Macintosh, versions 2.2, 3.0, 4.0

SUMMARY

To find a record in a data form in Microsoft Excel version 2.20 or 3.00, do the following (these steps assume you have correctly defined a database range):

1. From the Data menu, choose Form and drag the scroll bar up to the top if it isn't there already. Record 1 should be displayed in the Form window.

2. Click the Criteria button.

3. Type the criteria you want to search on in the appropriate fields. You can have only one criteria per field in the data form.

4. Click Form to toggle back to the Form window. Record 1 will be displayed.

5. Click Find Next. The next record that fits the criteria described earlier will be displayed.

MORE INFORMATION

Using the data form, you cannot find records based on computed criteria or criteria consisting of ANDs and/or ORs. To find records based on this type of criteria, the criteria range must be created using the method described on pages 327-337 in the "Microsoft Excel User's Guide 1," version 4.0 manual. If you are using version 3.0, refer to pages 369-378 of the "Microsoft Excel User's Guide" version 3.0 manual. If you are using Excel 2.20, see pages 166-173 of the "Microsoft Excel Reference" version 2.2 manual.