2.4 Criteria-based Navigating
Criteria is an option in data form that enables you to quickly navigate through all the records based on a given criteria. This feature is a very useful when you have a huge Excel table and you want to quickly go through those records that meet a given set of criteria.
By the time you complete this lesson, you should be able to:
- Navigate through table records based on a given criteria
- Navigate through table records based on multiple criteria
Using Criteria to Navigate
If you want to go through all the entries where the status is regular, you can do that by doing the following steps:
1. Activate your Excel table by clicking any cell in it.
2. Click Form icon in the Quick Access Toolbar
3. Click the Criteria button in the data form dialog box (figure 1).
4. Type Regular in the Status field (figure 2).
Remember regular or similar values that you type and use criteria activities are not case-sensitive. It does not matter whether you enter REGULAR or tegular.
5. Use the Find Prev or Find Next buttons to navigate through the records where the status is regular.
Using Multiple Criteria to Navigate
You can use multiple criteria fields to navigate through records of your table. For example, if you want to go through all the records of all Regular students who were given admission after 20 Jan 2019, do the following tasks:
1. Repeat the process discussed in steps 1-4 under Using Criteria to Navigate.
2. Type >20 Jan 2019 in the textbox for Admission Date field (figure 4).
3. Use Find Prev/Find Next buttons to display records after 20 Jan 2019 where the status is regular (figure 5).