Assignment of Dropdown list (UNIT 2)

 Steps to create dropdown list

1. Prepare Your List:

   • First, create a list of items you want to appear in the drop-down list. Enter these items in a single column or row in your worksheet. For example, you can enter them in cells c7 to c18.
   • Output:-
     
     
     
     

2. Select the Cell for the Drop-Down:

   • Click on the cell where you want the drop-down list to appear.
   • Output:-
     
     
     
     
     
     

3. Open Data Validation:

   • Go to the Data tab on the Ribbon.
   • Click on Data Validation in the Data Tools group.
   • Output:-
     
     
     
     

4. Set Up Data Validation:

   • In the Data Validation dialog box, go to the Settings tab.
   • In the Allow box, select List.
   • Output:-
     
     
     
     
     
     

5. Enter the Source:

   • In the Source box, enter the range of cells that contain your list items. For example, if your list is in cells  C8 to C18enter =$C$8:$C$18
   • Alternatively, you can click the small button to the right of the Source box and then select the range directly on the worksheet.
   • Output:- 
     
     
     

6. Complete the Setup:

   • Click OK to close the Data Validation dialog box.

7. Test Your Drop-Down List:

   • Click on the cell with the drop-down list to see if it displays the items you specified.
   • Output:-