Results 1 to 2 of 2
  1. #1
    dr_d_2k
    Guest

    List Select in XL 97 (Excel 97)

    I know this is a basic question, but How do you offer selections (select employee) from a list like the expense report example in XL 97.

    Thanks

    David

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: List Select in XL 97 (Excel 97)

    David,

    I haven't seen the example but I believe what you're after is found under Data/Validation.

    On the settings tab select list in the allow box and then select the area of your list using the refedit box - this can only be on the same sheet in the workbook, unless you use a named range (insert/name/define and then type "=MyRangeName" or similar in the refedit box.) If you use a list on the page where you are using the validation, you can always hide the column/row the data is in if you don't want it on display.

    HTH

    Brooke

Posting Permissions

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