DROP DOWN LIST

Home Forums Excel Utility DROP DOWN LIST

  • This topic is empty.
Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • #68517
    Anonymous
    Inactive

    DEBBRATA DA,
    I, HAVE FACED A MINOR PROBLEM TO EDIT STAFF INFO COLM. DESIGNATION COL LIKE AS NAME, designation, head master, my question beside the head master show a symbol like as down arrow so pls informed me how to make a drop down list in exls 2007 on another topic/name.

    #77009
    Anonymous
    Inactive

    In Excel 2010 (May be same in excel 2007) first select a cell where you want to drop down list.
    Choice data ribbon—>Data Validation—>Data Validation–>settings tab—>allow—>list…
    just select some cells (column wise) and ok.
    you can put the criteria like HM, AT, Peon etc. in this selected cells you will find those in the drop down list.

    #77010
    Anonymous
    Inactive

    I just learnt this tips in Excel 2007. Thanks @ chanchal.

    #77017
    Anonymous
    Inactive

    For Excel 2007
    Select at top bar menu:
    Data-> Data Validation-> Data Validation-> Settings->
    In validation criteria:
    Allow: List
    Source: HM, AHM, AT (Just write the name separate by a comma)

    #77018
    Anonymous
    Inactive

    Dear Mr.Nemo, Mr.Chanchal Torkona,
    Thanks for your post . You have informed others data validation formula for drop down list. I think this will help them to modify School Management Utility. Besides I will up load the modified file after a few days. Till then please wait.
    Debabrata Paul.

    #77019
    Anonymous
    Inactive

    Dear Mr. Chanchal babu,
    The problem you faced is not in the Staff info.The School info contains a number of Drop down Lists.Please look at the bottom of that page. You will find some columns with specific headings. Choose the column(s) and modify the rows where some letters are written. You may modify those and add some new designations.You may create drop down list according to your will. First create a Column entitled as Designation any where in the sheet of your choice. Then Write the designations such as Headmaster
    Asst.Teacher
    Clerk
    Peon
    Matron
    After that select any cell of your choice on that sheet where you like the drop down list. Write ‘Cookie’ in that cell , then go to Data Tool , then go to Data validation, go to settings, then choose List,Click Source, you will find data validation. Then select the entire List which you have previously created( other than heading)-After noting select symbol go to the source again, ClIck OK, THE DROP DOWN LIST will be noticed in’ the cookie’ cell. This is easy.
    Debabrata Paul

    #77020
    Anonymous
    Inactive

    Dear Mr.Sajmal ,
    Please find a sample Drop down List creation file.I think it will help you to do the task.
    Debabrata Paul.

    #77025
    Anonymous
    Inactive

    THANK YOU DEB DA ,AND FRIEND.

    #77028
    Anonymous
    Inactive

    Sir, can’t unprotect some pages applying password 123. please help me.

    #77041
    Anonymous
    Inactive

    you have type dp

Viewing 10 posts - 1 through 10 (of 10 total)
  • You must be logged in to reply to this topic.