how do i create lists in excel 2002?

i don't have 2003

2 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    Well, it depends what kind of list you are trying to create. Can you be more specific? Some lists are self contained in Excel like Monthas and day, you can also use the Auto fill feature.

    Are you trying to Creat mailing list? Be more specific

  • piquet
    Lv 7
    1 decade ago

    if you just mean you want a drop down list in a cell which people can choose from, then it's really easy.

    so anyways:

    · create a column of words/numbers/whatever you want in the list

    · go to data > validation > change 'allow' drop down box to 'list'

    · click the button to the right of 'source', select the range/list of entries you made

    · ok it

    that's all there is to it, but you could also reference a 'named range' in the source box instead if you need to reference a list on another worksheet.

    don't forget to 'accept' this answer if it helped.

Still have questions? Get your answers by asking now.