The data form allows you to add, edit, and delete records (rows), as well as display only the information that meets certain criteria. The form is especially useful when the lines in the document are very wide and you want to avoid constantly scrolling the sheet to the right and left.
- Open the Excel file.
- Choose a team Form (Form) on the Quick Access Toolbar.
- Use buttons Back (Find Prev) and Next (Find Next) to easily switch from one record (line) to another.
Note: Use buttons Add (New) or Remove (Delete) to add or delete entries. When you start editing data, you can use the button Return (Restore) to undo any changes.
- Нажмите кнопку Criteria (Criteria) to display only records that meet certain criteria.
- Enter the criteria and click on the button Correction (Form).
- Now by pressing Back (Find Prev) and Next (Find Next), you will only see data that meets those criteria. In our example, this is entry 13.
Note: To edit the criteria, click the button Criteria (criteria) again. To close the form, click on Close (Close).