+ Reply to Thread
Results 1 to 5 of 5

Data Validation question

Hybrid View

  1. #1
    Registered User
    Join Date
    12-26-2009
    Location
    Richmond, North Yorkshire
    MS-Off Ver
    2017
    Posts
    83

    Data Validation question

    I’ve created a drop-down data list in the following way.

    1) Selected a cell
    2) Clicked 'Data Validation'.
    3) Selected 'list' from the drop down 'Allow' menu.
    4) Typed my data in the 'Source' box, each separated with a comma.

    I now want to edit that list by adding more data, but I don't seem to be able to move along the list to insert data where I want to.
    When I press the arrow key to move left or right, it enters a cell ref. instead of moving the cursor along the list.

    How do I move along the list so that I can insert the new data where I want to?

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2503 (Windows 11 Home 24H2 64-bit)
    Posts
    90,313

    Re: Data Validation question

    Why not make it easy for yourself and refer to a cell range instead?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,047

    Re: Data Validation question

    Or, if you want to edit the range, press F2 (edit) 1st
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Registered User
    Join Date
    12-26-2009
    Location
    Richmond, North Yorkshire
    MS-Off Ver
    2017
    Posts
    83

    Re: Data Validation question

    Thanks for that, pressing Fn + F2 did the trick.

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,047

    Re: Data Validation question

    Good stuff, happy to help and thanks for the feedback

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Data Validation Question
    By bgrish3 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-16-2016, 09:59 AM
  2. Data Validation question
    By mgeorge in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-06-2008, 04:22 AM
  3. Data>Validation Question
    By Weave in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-12-2005, 04:10 PM
  4. Another Data Validation question
    By Nigel in forum Excel General
    Replies: 3
    Last Post: 10-14-2005, 06:05 PM
  5. Data Validation Question
    By cmk18 in forum Excel General
    Replies: 4
    Last Post: 10-07-2005, 03:05 PM
  6. [SOLVED] Data validation question
    By Ted Rogers in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 09-04-2005, 08:05 PM
  7. [SOLVED] Data Validation question
    By Jeff in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2005, 02:05 PM

Tags for this Thread

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