+ Reply to Thread
Results 1 to 3 of 3

Only Allowing Certain Codes In Column

  1. #1
    Buttercup
    Guest

    Only Allowing Certain Codes In Column

    In my spreadsheet, I would like to set a column so that it will only allow
    certain codes. For example: I would like only the following written exactly
    as is here to be allowed to be entered into a column:

    AUTO

    HOME

    DP-3

    DP-2

    How can I set the column to only allow these & can I make it so it will
    display the codes for the user.

    Thank you.

  2. #2
    Nick Hodge
    Guest

    Re: Only Allowing Certain Codes In Column

    Select your column and then Data>Data Validation. Take the list option and
    enter your list separated by commas and then enter any input or error
    message you want

    --
    HTH
    Nick Hodge
    Microsoft MVP - Excel
    Southampton, England
    nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


    "Buttercup" <Buttercup@discussions.microsoft.com> wrote in message
    news:3A97A571-8256-4DFE-9E5E-BFEE676C2DA3@microsoft.com...
    > In my spreadsheet, I would like to set a column so that it will only allow
    > certain codes. For example: I would like only the following written
    > exactly
    > as is here to be allowed to be entered into a column:
    >
    > AUTO
    >
    > HOME
    >
    > DP-3
    >
    > DP-2
    >
    > How can I set the column to only allow these & can I make it so it will
    > display the codes for the user.
    >
    > Thank you.




  3. #3
    Gord Dibben
    Guest

    Re: Only Allowing Certain Codes In Column

    Buttercup

    Data Validation is problay what you need.

    See here for instructions.

    http://www.contextures.on.ca/xlDataVal01.html


    Gord Dibben Excel MVP

    On Thu, 6 Jan 2005 11:25:03 -0800, Buttercup
    <Buttercup@discussions.microsoft.com> wrote:

    >In my spreadsheet, I would like to set a column so that it will only allow
    >certain codes. For example: I would like only the following written exactly
    >as is here to be allowed to be entered into a column:
    >
    >AUTO
    >
    >HOME
    >
    >DP-3
    >
    >DP-2
    >
    >How can I set the column to only allow these & can I make it so it will
    >display the codes for the user.
    >
    >Thank you.



+ 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