In this tutorial you will learn how to use data form in excel. Data form is the way by which you make the interface of excel worksheet convenient. You can use data form when you have large spread sheet and you need to scroll to see data in the worksheet of excel. By data form you can insert, delete, Find next and previous record of excel sheet.
use data form in excel example:-
You have sheet which has data of employees of an organization. Fields of sheet are employee_ID, employee_Name, employee_Designation, employee_Salary and employee_Bonus.
So on the above sheet you need to scroll the sheet for finding the data of employee in the worksheet. You can use here the data form for this data. For insert the data click on file menu and some options are like as following sheet.
Now take move pointer on the Options like as following sheet.
After click on options the Excel Options dialog box appear as like following sheet.
Now select the quick access toolbar option and then click on drop down menu named as choose command from. Take cursor on the option Commands not in the ribbon like as following.
Scroll down and find the option Form and select it like as following.
For add the Form in the quick access tool bar click on Add>> button and then Form added to the toolbar like as following.
Click on the OK button of the Excel Option dialog box same as like following sheet.
So you can see the form icon on the left side of the title bar in microsoft excel.
By clicking on form button the form name as sheet1 appear on the screen like as following.
You can find the previous or next record by clicking on Find Prev or Find Next buttons. Now click on Find Next button and you can see the record of employee having id 2.
For add new record through the form click on button having caption New. Insert the data of new employee like as this sheet.
Press enter button to insert the record in the excel work sheet. So you have learn how to use data form in excel and how to find and insert new record in excel worksheet. You also can delete data by clicking on delete button.