In this video How to data entry form Design in Microsoft excel. ............................................................................................................................. To design a data entry form in Excel, To activate the forms in excel, go to Option in the File menu, then select Forms from the Customize Ribbon menu list. The form is available under Commands Not In Ribbon drop-down. Once activated, on selecting the Form from the menu tab, we will be getting the custom form which will pick all the headers from the sheet as its fields. 1.) Go to File menu and choose option. 2.)We will get the below dialogue box as show. Next choose the customize ribbon. 3.)We will get the customize ribbon dialogue box where we can add or remove the ribbon. 4.)Search for the FORM button, create a new group in the HOME menu. and your Choice. 5.)After creating New Group click on Add 6.)So that form will be added under Main Tabs in New Group as shown below. 7.)And Select form option left side click add and close customize ribbon From Option Definition .............................................................................................................................. New - Which will add new records to the database. Delete - Delete the specific records of the employee. Restore - Restore the old record. Find Next - Finds the next record. Find Previous - Find the Previous record. Criteria - Displays the records based on the employee criteria.