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 ???

Error Initializing Opera: module 15

Solutions: You should manually remove directories name as "Opera" from  %PROGRAMFILES% ,%APPDATA% and %USERPROFILE% . RUN(Windows Logo Key + R)-> Enter '%PROGRAMFILES%' -> Then press OK Button. Open a new window, There find Opera folder and delete it. Same as %APPDATA%  and %USERPROFILE%. What programming languages should I learn to make a website How do i transfer music from my mac to my iPhone using the iTunes HOW TO FIX ICE CREAM SANDWICH UPDATE ERRORS !!! Fix an app that isn't working properly in Nexus how to reset Google nexus 7 Screen flicker problem in iPhone 5 DATE AND TIME PROBLEM IN IPHONE5 Another way: IF it's install in C drive you can delete opera folder from below location : c: \ Program Files \ Opera \ c: \ Documents and Settings \ Username \ Application Data \ Opera \ c: \ Documents and Settings \ Username \ Local Settings \ Application Data \ Opera \ Any you getting any problem give a comments. You can also see...