Lost in Menus

Discussion in 'Microsoft Excel Worksheet Functions' started by jan, Jul 30, 2004.

  1. jan

    jan Guest

    I am creating a spreadsheet for users to verify and if
    applicable, add information. In the blank cells, is there
    a way to have a drop down menu for the user from which to
    select? If this is possible, how is it created?

    thanks in advance,

    jan
     
    jan, Jul 30, 2004
    #1
    1. Advertisements

  2. jan

    Frank Kabel Guest

    Hi
    use 'Data - validation - List'. See:
    http://www.contextures.com/xlDataVal01.html

    --
    Regards
    Frank Kabel
    Frankfurt, Germany


    jan wrote:
    > I am creating a spreadsheet for users to verify and if
    > applicable, add information. In the blank cells, is there
    > a way to have a drop down menu for the user from which to
    > select? If this is possible, how is it created?
    >
    > thanks in advance,
    >
    > jan
     
    Frank Kabel, Jul 30, 2004
    #2
    1. Advertisements

  3. jan

    Govind Guest

    Hi,

    Check Data -> validation menu

    Govind.

    jan wrote:
    > I am creating a spreadsheet for users to verify and if
    > applicable, add information. In the blank cells, is there
    > a way to have a drop down menu for the user from which to
    > select? If this is possible, how is it created?
    >
    > thanks in advance,
    >
    > jan
    >
     
    Govind, Jul 30, 2004
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Suhas

    Dropdown menus in Excel

    Suhas, Jun 25, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    1,515
    Jason Morin
    Jun 25, 2003
  2. Al

    Help with menus

    Al, Jul 3, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    518
    Paul B
    Jul 3, 2003
  3. Matt

    Drop-down menus

    Matt, Aug 12, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    3
    Views:
    170
    EZ Money
    Aug 21, 2003
  4. PJ

    Dropdown Menus

    PJ, Aug 19, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    255
    Paul Corrado
    Aug 19, 2003
  5. Wayne Burritt

    Pull down menus

    Wayne Burritt, Aug 21, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    210
    StarTrek
    Aug 23, 2003
  6. Marilyn Walsh

    Lost my menus

    Marilyn Walsh, Mar 23, 2004, in forum: Microsoft Excel Worksheet Functions
    Replies:
    1
    Views:
    272
    Guest
    Mar 23, 2004
  7. Greegan

    New Menus - attaching but menus are reset

    Greegan, Nov 5, 2005, in forum: Microsoft Excel Worksheet Functions
    Replies:
    0
    Views:
    217
    Greegan
    Nov 5, 2005
  8. Benjamin

    Creating Drop-down menus with subset drop-down menus

    Benjamin, Jun 4, 2009, in forum: Microsoft Excel Worksheet Functions
    Replies:
    4
    Views:
    1,516
    Benjamin
    Jun 8, 2009
Loading...