Lesson 218: Sample data in Excel

This article will guide you to create data templates in Excel.

Data form

The Data Form in Excel allows you to add, edit and delete records and only display the records that match the criteria you have requested.

1. Download Data Form here Link

2. Add the Form command to the Quick Access ToolBar.

3. Click the Form . command

4.. Use the Find Prev and Find next buttons to change the record.

4. To display the records that match the Criteria, click the Criteria button

5. Enter your criteria and press the button Form

And now if you use the Find Prev and Find Next buttons, you will see the records that match the criteria you have given.

Note: to edit the criteria , click the Criteria button again. To close the Data Form, click the Close button.

In addition, you can also view many other excel articles here.