+ Reply to Thread
Results 1 to 3 of 3

drop dpwn tables in excel

  1. #1
    Registered User
    Join Date
    01-24-2006
    Posts
    11

    drop dpwn tables in excel

    hi, i working on a little spreadsheet and would like to insert a drop down table, tht allows some pre-written answers to be inserted into a cell, for example : under the heading 'type of order', the correct answerss would be 'model', 'tool' , 'base'. how do you insert drop down tables.
    thanks
    john

  2. #2
    Forum Contributor
    Join Date
    08-23-2004
    Posts
    210
    Have a look here: http://www.meadinkent.co.uk/xldropdown.htm

  3. #3
    Pete_UK
    Guest

    Re: drop dpwn tables in excel

    One way is to use Data Validation - here you can define a list of
    acceptable responses and specify that you want the entries in the cell
    where you have DV to choose from this list.

    Hope this helps.

    Pete


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1