Excel compares<\/a> your input to the cells located above.<\/p>\n\n\n\nWhen you type the first letter “J”, Excel won\u2019t give you any hints, because it doesn\u2019t know whether you mean “John Smith” or “John Collins” or maybe a completely different name.<\/p>\n\n\n\n
But when you type “John C” Excel will “know” that there is a good chance that you meant “John Collins”, because there is no other \u201cJohn\u201d, whose last name begins with the letter \u201cC\u201d.<\/p>\n\n\n\n
If the text suggested by Excel is the one you want, you can go to the next cell, but if you meant a different one, then continue typing until Excel guesses what you are looking for.<\/p>\n\n\n\n
The AutoComplete<\/strong> feature has several limitations:<\/p>\n\n\n\n\nIt only works with text. It doesn’t work with numbers and dates.<\/li>\n\n\n\n It doesn’t check the data in other columns than those located above.<\/li>\n\n\n\n If there is a break in the form of an empty field between typed text and the values above, then Excel will treat it as another list, even though it is in the same column.<\/li>\n<\/ul>\n\n\n\nIf you want to disable AutoComplete, you can do it in FILE >> Options >> Advanced >> Editing Options >> Enable AutoComplete for cell values<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"When you work with worksheets, sometimes you will need to enter the same text multiple times. To automate this task, Microsoft introduced the AutoComplete feature….<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[14],"tags":[],"yoast_head":"\n
AutoComplete<\/title>\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n\t \n\t \n\t \n