Adding Data Entry Form Option

Simple Tricks For Adding Data Entry Form Option

How To Adding Data Entry Form Option in Excel















Simple Tricks For Adding Data Entry Form Option

How to Adding Data Entry Form Option in ms Office Excel

Steps For Adding Data Entry Form Option

1. Right-click on any of the existing icons in the Quick Access Toolbar

2. Click on ‘Customize Quick Access Toolbar’.

3. select the ‘All Commands’ option from the drop-down.

4. select ‘Form’.

5. Click on the ‘Add’ button.

6. Click OK.

7. The above steps would add the Form icon to the Quick Access Toolbar

The above snapshot shows basic navigation where you are going through all the records one after the other. But you can also quickly navigate through all the records based on criteria.

1. New: This will clear any existing data in the form and allows you to create a new record.

2. Delete: This will allow you to delete an existing record. For example, if I hit the Delete key in the above example, it will delete the record for Mike Banes.

3. Restore: If you’re editing an existing entry, you can restore the previous data in the form (if you haven’t clicked New or hit Enter).

4. Find Prev: This will find the previous entry.

5. Find Next: This will find the next entry.

8. Criteria: This allows you to find specific records. For example, if I am looking for all the records, where the candidate was Hired, I need to click the Criteria button, enter ‘Hired’ in the Status field and then use the find buttons. Example of this is covered later in this tutorial.

9. Close: This will close the form.

10. Scroll Bar: You can use the scroll bar to go through the records.