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?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Suhas

    Dropdown menus in Excel

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

    Help with menus

    Al, Jul 3, 2003, in forum: Microsoft Excel Worksheet Functions
    Replies:
    2
    Views:
    413
    Paul B
    Jul 3, 2003
  3. Marilyn Walsh

    Lost my menus

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

    New Menus - attaching but menus are reset

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

    Creating Drop-down menus with subset drop-down menus

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

Share This Page