{"id":700,"date":"2018-06-28T14:07:54","date_gmt":"2018-06-28T14:07:54","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=700"},"modified":"2024-02-19T14:55:28","modified_gmt":"2024-02-19T14:55:28","slug":"autocomplete","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/training\/autocomplete\/","title":{"rendered":"AutoComplete"},"content":{"rendered":"\n

When you work with worksheets, sometimes you will need to enter the same text multiple times. To automate this task, Microsoft introduced the AutoComplete<\/strong> feature.<\/p>\n\n\n\n

To better illustrate how this tool works, take a look at the following example:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Here, you can see that name “John Smith” appears in cell B2<\/strong>. The Name “John Collins” in cell B3<\/strong> and the name “Sophie Richardson” in cell B4.<\/strong> As soon as you start typing, Excel compares<\/a> your input to the cells located above.<\/p>\n\n\n\n

When 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

Limitations of AutoComplete<\/h2>\n\n\n\n

The AutoComplete<\/strong> feature has several limitations:<\/p>\n\n\n\n

    \n
  • It 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\n

    AutoComplete Options<\/h2>\n\n\n\n

    If 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":"\nAutoComplete<\/title>\n<meta name=\"description\" content=\"Learn about Microsoft Excel's AutoComplete feature for text entry, how it works, and its limitations. Disable it in File > Options > Advanced > Editing Options.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/training\/autocomplete\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"AutoComplete\" \/>\n<meta property=\"og:description\" content=\"Learn about Microsoft Excel's AutoComplete feature for text entry, how it works, and its limitations. Disable it in File > Options > Advanced > Editing Options.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/training\/autocomplete\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-06-28T14:07:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-19T14:55:28+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/autocomplete.png\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/autocomplete\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/autocomplete\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"AutoComplete\",\"datePublished\":\"2018-06-28T14:07:54+00:00\",\"dateModified\":\"2024-02-19T14:55:28+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/autocomplete\/\"},\"wordCount\":299,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/autocomplete\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/autocomplete.png\",\"articleSection\":[\"training\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/autocomplete\/\",\"url\":\"https:\/\/officetuts.net\/excel\/training\/autocomplete\/\",\"name\":\"AutoComplete\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/autocomplete\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/autocomplete\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/autocomplete.png\",\"datePublished\":\"2018-06-28T14:07:54+00:00\",\"dateModified\":\"2024-02-19T14:55:28+00:00\",\"description\":\"Learn about Microsoft Excel's AutoComplete feature for text entry, how it works, and its limitations. Disable it in File > Options > Advanced > Editing Options.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/training\/autocomplete\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/training\/autocomplete\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/autocomplete\/#primaryimage\",\"url\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/autocomplete.png\",\"contentUrl\":\"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/autocomplete.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/training\/autocomplete\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"AutoComplete\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"AutoComplete","description":"Learn about Microsoft Excel's AutoComplete feature for text entry, how it works, and its limitations. Disable it in File > Options > Advanced > Editing Options.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/officetuts.net\/excel\/training\/autocomplete\/","og_locale":"en_US","og_type":"article","og_title":"AutoComplete","og_description":"Learn about Microsoft Excel's AutoComplete feature for text entry, how it works, and its limitations. Disable it in File > Options > Advanced > Editing Options.","og_url":"https:\/\/officetuts.net\/excel\/training\/autocomplete\/","article_published_time":"2018-06-28T14:07:54+00:00","article_modified_time":"2024-02-19T14:55:28+00:00","og_image":[{"url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/autocomplete.png"}],"author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/training\/autocomplete\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/training\/autocomplete\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"AutoComplete","datePublished":"2018-06-28T14:07:54+00:00","dateModified":"2024-02-19T14:55:28+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/autocomplete\/"},"wordCount":299,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/autocomplete\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/autocomplete.png","articleSection":["training"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/training\/autocomplete\/","url":"https:\/\/officetuts.net\/excel\/training\/autocomplete\/","name":"AutoComplete","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/training\/autocomplete\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/training\/autocomplete\/#primaryimage"},"thumbnailUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/autocomplete.png","datePublished":"2018-06-28T14:07:54+00:00","dateModified":"2024-02-19T14:55:28+00:00","description":"Learn about Microsoft Excel's AutoComplete feature for text entry, how it works, and its limitations. Disable it in File > Options > Advanced > Editing Options.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/training\/autocomplete\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/training\/autocomplete\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/training\/autocomplete\/#primaryimage","url":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/autocomplete.png","contentUrl":"http:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2018\/06\/autocomplete.png"},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/training\/autocomplete\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"AutoComplete"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/700"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=700"}],"version-history":[{"count":4,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/700\/revisions"}],"predecessor-version":[{"id":13811,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/700\/revisions\/13811"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=700"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=700"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=700"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}