Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Oct 2005
    Thanked 1 Time in 1 Post

    'Predictive' text in Excel; 'recognizing' previous data entries

    Hi all....I am not sure if this is the correct forum, but my question does apply to Excel usage. Often-times, I will be entering data manually and it will use some sort of 'predictive' text (after typing 2 or 3 letters) to anticipate the data being entered....this is a great feature (for the most part). However, there doesn't seem to be any consistency or rhythm to how or when it happens.......I don't want to use the Auto-Complete feature of OFFICE....I am content with this predictive text feature, but I am wondering if there is some way to have some control over it? Does how it works have anything to do with 'Iterations' in Excel? Is there some way to 'adjust' how quickly it 'turns on' or how many times you have to enter a word before Excel can predict its entry..??..??....does anyone have a link to more info about this feature? Thanks.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    Thanked 342 Times in 335 Posts
    What you are speaking about is autocomplete. the value has to be in the column and it does not kick in until you enter enough to be unique in the column (so it can occur with one letter or require a dozen or more). Blank cells within the column can interfere with this feature.

    File - options - advanced
    check "Allow autocomplete for cell values".


Posting Permissions

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