Adding data from a list
Adding data from a list
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Adding data from a list

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    As a teacher i want to insert class data from a drop down list eg class names of class1 class2. How is the easiest way other than right clicking on the list and selcting pick from list?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do you mean you want the drop down list in a cell? If so, write your list in some part of the worksheet, then click on the cell you want the list to appear in.

    Now click DATA>VALIDATION and you'll see a field with a dropdown called Allow:

    Pick LIST from this and then click in the SOURCE field, then click onto your sheet and highlight the list you wrote. Then press Enter and OK.

    Now every time you click on the cell you validated, it'll have a drop down list

    Audiojoe
    My gift is my song and this one's for you

  3. #3
    New Member
    Join Date
    Apr 2002
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Excellent many thanks its exactly what was needed.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com