Once a list created, you can add, find, edit, or delete records by using a data form. A data form is a dialogue box that displays one complete record at a time.
· Select the list and then Choose Data | Form. 

(Figure 5.2)

· Choose the New button to fill in the new records. You can use the Tab key to move between fields. When you finish press.
Elements of Data Form

(Figure 5.3)

Data Form Title
The Title Bar at the top of dialogue box displays the name of worksheet that contains the list.
Data Form Fields
The Fields that make up a record are stored as a single row in a list.
Field Names field Names are created from the column labels as they appear in the list.
Scroll Bar 
The Record Number Indicator displays the current record number and total number of records in the data list.
Command Buttons
· Add new records
· Delete a displayed record
· Undo changes
· Move between adjacent records
· Find records based on criteria.
Changing data in the form
· Activate Data | Form…..
· Excel always lists the first record. Go to the record which requires editing using scroll bar.
· Click on the field that needs to be changed and do the necessary modifications.
Deleting Data
· If a selected record in the data form is to be deleted permanently, use the Delete button.
Searching for Data
· To enter a search criteria into the form, activate data form and click the Criteria button.

(Figure 5.4)

· Enter the criteria for the field name and press Find Next.
· Excel will change back to normal view to display the next record which satisfies the condition 
· To see other records click the Find Next Find.
Sorting Data
Data can be entered in a list in any order you want to but it can be rearranged using Excel. When you sort a list, Excel rearranges rows according to the contents of column you choose. You can choose an ascending or descending sort order. Sorting in ascending order means numbers are sorted from 1 to 9, text is sorted from A to Z and dates sorted from earliest to latest. Descending order sorting means numbers are sorted from 9 to 1, text is sorted from Z to A and dates from latest to the earliest.
The following methods can be used to sort a list:
Method 1 :
· Select a single cell and choose Data | Sort from menu. The Sort dialog box will appear.

(Figure 5.5)

Method 2 :
· Move the pointer in a cell of the column to sort.
· To sort in ascending order click on sort ascending toolbutton on tool bar. or to sort on descending order click on sort desceding on tool bar.