Skip to main content

Creating a drop down list in MS Excel

                                         Creating a drop down list in MS Excel


  1. Enter the following data into cells:
    A1 - Gingerbread
    A2 - Lemon
    A3 - Oatmeal Raisin
    A4 - Chocolate Chip
    D2 - Cookie Type:

  2. Click on cell E2 - the location where the results will be displayed.

  3. Click on the Data tab.

  4. Click on the Data Validation option from the ribbon to open the menu.

  5. Click on the Data Validation in the menu to bring up the dialog box.

  6. Click on Settings tab in the dialog box.

  7. From the Allow menu choose List.

  8. Click on the Source line in the dialog box.

  9. Drag to select cells A1 - A4 in the spreadsheet.

  10. Click OK in the dialog box.

  11. A down arrow should appear next to cell E2.

  12. When you click on the arrow the drop down list should open to display the four cookie names.                                                                                                                                                                          --- Collected from Internet.

Comments

Popular posts from this blog

ORA-01033 Oracle initialization or shutdown in progress

ORA-01033 Oracle initialization or shutdown in progress When you connect oracle 12c plug gable database, Thus time you have get oracle initialization or shutdown in progress error. This error occurred because pluggable database are not initialized. To fix this error connect as sysdba and run  ALTER PLUGGABLE DATABASE ALL OPEN    command. ALTER PLUGGABLE DATABASE ALL OPEN Thanks.

AFTER LOGON Trigger not perfectly working

AFTER LOGON not perfectly working.  I have tried it on single instance oracle 12c database it's perfectly work but it's not perfectly working on multi instance Oracle 12c database. I have submitted this matter in oracle forum but not found any perfect answer. Do you know why  it's not working ???

Oracle forms 11g default configuration file formsweb.cfg

#formsweb.cfg defines parameter values used by the FormsServlet # formsweb.cfg defines parameter values used by the FormsServlet (frmservlet) # This section defines the Default settings. Any of them may be overridden in the # following Named Configuration sections. If they are not overridden, then the # values here will be used. # The default settings comprise two types of parameters: System parameters, # which cannot be overridden in the URL, and User Parameters, which can. # Parameters which are not marked as System parameters are User parameters. # SYSTEM PARAMETERS