Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Drop Down/Manual Entry

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Columbia, SC
    Posts
    81
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have created drop down list using the Data/Validation feature throughout my spreadsheet. When I try to input data manually into one of the cells, even if it is one of the valid data values, I get the "Invalid Data" Message. Can't this be fixed?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Massachusetts, USA
    Posts
    255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can only enter data by selecting one of the items in the drop down list - when the cell is selected, the arrow appears in the right part of the cell. From here, select your choice.

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Location
    Wivenhoe, England
    Posts
    912
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    nancyo, not sure that is right - you can input valid data manually. hbendillo, are you using the same case, upper or lower?

  4. #4
    New Member
    Join Date
    Apr 2002
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-02 13:00, hbendillo wrote:
    I have created drop down list using the Data/Validation feature throughout my spreadsheet. When I try to input data manually into one of the cells, even if it is one of the valid data values, I get the "Invalid Data" Message. Can't this be fixed?
    I'm not sure if you're validating numbers or text. One thing I've noticed with data validation of text is that, if you list the valid items in the Source box in the data validation window, the valid entries are case sensitive. If you use a cell or range reference in the box, the valid entries are not case sensitive.

  5. #5
    New Member
    Join Date
    May 2002
    Posts
    18
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    can we create a custom drop down list in cell?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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