{"id":2450,"date":"2022-11-30T05:38:02","date_gmt":"2022-11-30T05:38:02","guid":{"rendered":"https:\/\/www.bjorn-meijer.nl\/?p=2450"},"modified":"2022-11-30T05:38:07","modified_gmt":"2022-11-30T05:38:07","slug":"snel-aanvullen-gebruiken-in-excel","status":"publish","type":"post","link":"https:\/\/www.bjorn-meijer.nl\/en\/2022\/11\/30\/using-quick-fill-in-excel\/","title":{"rendered":"Using Quick Fill in Excel"},"content":{"rendered":"

Since Excel 2013, Microsoft has added a new useful feature, QuickFill. As soon as Excel recognizes a pattern, the data is automatically completed. Sometimes Excel does this automatically, but you can also call the function with the keyboard shortcut CTRL+E<\/strong>.<\/p>\n\n\n\n

You can download the sample file at the bottom of this page to download<\/a> so that you can follow everything step by step.<\/p>\n\n\n\n

Split data<\/h2>\n\n\n\n

Suppose we have a list of personal names where the first and last name are in the same cell (column A). We want to split this into two columns. In the first column we want the first name and in the second column the last name.<\/p>\n\n\n\n

Create two new columns. Name the first column (column B). First Name<\/strong>, you name the second column (column C). Last name<\/strong>.<\/p>\n\n\n\n

Fill in cell B2<\/strong> the first name from cell A2<\/strong> in. Fill in cell C2<\/strong> the last name from cell A2<\/strong> in.<\/p>\n\n\n\n

Select cell B3<\/strong> and press the key combination Ctrl+E<\/strong> in. Excel automatically fills in all first names in column A. Repeat this step for the surnames in cell C3<\/strong> the key combination Ctrl+E<\/strong> applying.<\/p>\n\n\n\n

\"Split
Split data<\/figcaption><\/figure>\n\n\n\n

Merge data<\/h2>\n\n\n\n

In addition to splitting data, it is also possible to merge data. If we also have telephone numbers in addition to the personal names, we can paste the last four digits of the telephone number after the first name to create a (for example) login name.<\/p>\n\n\n\n

The first column (column A) is called First and last name<\/strong>. The second column (column B) is called First Name<\/strong>, the third column (column C) is called Last name<\/strong>.<\/p>\n\n\n\n

Name the fourth column (column D). phone number<\/strong>.<\/p>\n\n\n\n

Fill in cell E2<\/strong> the first name from cell A2<\/strong> in followed by the last four digits of the phone number in cell D2<\/strong>.<\/p>\n\n\n\n

Select cell E3<\/strong> and press the key combination Ctrl+E<\/strong> in. Excel automatically fills in all first names listed in column A, followed by the last four digits of the telephone number from column D.<\/p>\n\n\n\n

\"Merge
Merge data<\/figcaption><\/figure>\n\n\n\n

Format data<\/h2>\n\n\n\n

Next to it divide<\/a> and to merge<\/a> of data, we can also adjust the formatting of data quickly and easily.<\/p>\n\n\n\n

If we have a list of telephone numbers without any formatting, this is difficult to read. Placing spaces or a character between a series of numbers improves readability and reduces the chance of reading errors.<\/p>\n\n\n\n

Suppose I have a list of telephone numbers in column D without formatting. Now I want -character or a space between the third and fourth and seventh and eighth digits to increase readability.<\/p>\n\n\n\n

Fill in cell E2<\/strong> enter the phone number and place spaces or characters at the desired positions.<\/p>\n\n\n\n

Select cell E3<\/strong> and press the key combination Ctrl+E<\/strong> in. Excel automatically takes over the formatting of the phone number you enter in cell E2<\/strong> entered.<\/p>\n\n\n\n

\"Format
Format data<\/figcaption><\/figure>\n\n\n\n

<\/i> Downloads <\/h2>\n\n\n\n

If you can't figure it out with the above guide alone, download the sample file or ask a question by leaving a message.<\/p>\n\n\n\n

excel-quick-fill<\/a><\/i> Download<\/a><\/div>","protected":false},"excerpt":{"rendered":"

Since Excel 2013, Microsoft has added a new useful feature, QuickFill. As soon as Excel recognizes a pattern, the\u2026 Continue reading<\/a><\/p>","protected":false},"author":1,"featured_media":265,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[7],"tags":[104,106,17,21,110,111,109,107],"class_list":["post-2450","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","tag-data","tag-data-bewerken","tag-excel","tag-excel-functies","tag-gegevens-opmaken","tag-gegevens-samenvoegen","tag-gegevens-splitsen","tag-sneltoets"],"yoast_head":"\nSnel aanvullen gebruiken in Excel - Bj\u00f6rn Meijer<\/title>\n<meta name=\"description\" content=\"Snel gegevens splitsen, aanvullen of opmaken met snel aanvullen (CTRL+E) in Excel. Gegevens worden aangevuld zodra een patroon wordt herkent.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.bjorn-meijer.nl\/en\/2022\/11\/30\/using-quick-fill-in-excel\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Snel aanvullen gebruiken in Excel\" \/>\n<meta property=\"og:description\" content=\"Sinds Excel 2013 heeft Microsoft een nieuwe handige functie toegevoegd, Snel aanvullen. Zodra Excel een patroon herkent worden automatisch de gegevens\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bjorn-meijer.nl\/en\/2022\/11\/30\/using-quick-fill-in-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Bj\u00f6rn Meijer\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-30T05:38:02+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-30T05:38:07+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bj\u00f6rn Meijer\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bj\u00f6rn Meijer\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/\"},\"author\":{\"name\":\"Bj\u00f6rn Meijer\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"headline\":\"Snel aanvullen gebruiken in Excel\",\"datePublished\":\"2022-11-30T05:38:02+00:00\",\"dateModified\":\"2022-11-30T05:38:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/\"},\"wordCount\":490,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"image\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"keywords\":[\"data\",\"data bewerken\",\"excel\",\"excel functies\",\"gegevens opmaken\",\"gegevens samenvoegen\",\"gegevens splitsen\",\"sneltoets\"],\"articleSection\":[\"Excel\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/\",\"name\":\"Snel aanvullen gebruiken in Excel - Bj\u00f6rn Meijer\",\"isPartOf\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"datePublished\":\"2022-11-30T05:38:02+00:00\",\"dateModified\":\"2022-11-30T05:38:07+00:00\",\"description\":\"Snel gegevens splitsen, aanvullen of opmaken met snel aanvullen (CTRL+E) in Excel. Gegevens worden aangevuld zodra een patroon wordt herkent.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/#primaryimage\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"contentUrl\":\"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png\",\"width\":300,\"height\":300,\"caption\":\"Microsoft Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.bjorn-meijer.nl\/de\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Snel aanvullen gebruiken in Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#website\",\"url\":\"https:\/\/www.bjorn-meijer.nl\/de\/\",\"name\":\"Bj\u00f6rn Meijer\",\"description\":\"At My Playground\",\"publisher\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.bjorn-meijer.nl\/de\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615\",\"name\":\"Bj\u00f6rn Meijer\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1\",\"width\":165,\"height\":165,\"caption\":\"Bj\u00f6rn Meijer\"},\"logo\":{\"@id\":\"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/\"},\"sameAs\":[\"https:\/\/www.bjorn-meijer.nl\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Snel aanvullen gebruiken in Excel - Bj\u00f6rn Meijer","description":"Snel gegevens splitsen, aanvullen of opmaken met snel aanvullen (CTRL+E) in Excel. Gegevens worden aangevuld zodra een patroon wordt herkent.","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:\/\/www.bjorn-meijer.nl\/en\/2022\/11\/30\/using-quick-fill-in-excel\/","og_locale":"en_US","og_type":"article","og_title":"Snel aanvullen gebruiken in Excel","og_description":"Sinds Excel 2013 heeft Microsoft een nieuwe handige functie toegevoegd, Snel aanvullen. Zodra Excel een patroon herkent worden automatisch de gegevens","og_url":"https:\/\/www.bjorn-meijer.nl\/en\/2022\/11\/30\/using-quick-fill-in-excel\/","og_site_name":"Bj\u00f6rn Meijer","article_published_time":"2022-11-30T05:38:02+00:00","article_modified_time":"2022-11-30T05:38:07+00:00","og_image":[{"width":300,"height":300,"url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","type":"image\/png"}],"author":"Bj\u00f6rn Meijer","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Bj\u00f6rn Meijer","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/#article","isPartOf":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/"},"author":{"name":"Bj\u00f6rn Meijer","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"headline":"Snel aanvullen gebruiken in Excel","datePublished":"2022-11-30T05:38:02+00:00","dateModified":"2022-11-30T05:38:07+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/"},"wordCount":490,"commentCount":0,"publisher":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"image":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","keywords":["data","data bewerken","excel","excel functies","gegevens opmaken","gegevens samenvoegen","gegevens splitsen","sneltoets"],"articleSection":["Excel"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/","url":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/","name":"Snel aanvullen gebruiken in Excel - Bj\u00f6rn Meijer","isPartOf":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/#primaryimage"},"image":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","datePublished":"2022-11-30T05:38:02+00:00","dateModified":"2022-11-30T05:38:07+00:00","description":"Snel gegevens splitsen, aanvullen of opmaken met snel aanvullen (CTRL+E) in Excel. Gegevens worden aangevuld zodra een patroon wordt herkent.","breadcrumb":{"@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/#primaryimage","url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","contentUrl":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","width":300,"height":300,"caption":"Microsoft Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/www.bjorn-meijer.nl\/2022\/11\/30\/snel-aanvullen-gebruiken-in-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.bjorn-meijer.nl\/de\/"},{"@type":"ListItem","position":2,"name":"Snel aanvullen gebruiken in Excel"}]},{"@type":"WebSite","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#website","url":"https:\/\/www.bjorn-meijer.nl\/de\/","name":"Bj\u00f6rn Meijer","description":"At My Playground","publisher":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bjorn-meijer.nl\/de\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/3621be5a6ce9a9884a7b8b200cd52615","name":"Bj\u00f6rn Meijer","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/","url":"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/11\/logo-orange.png?fit=165%2C165&ssl=1","width":165,"height":165,"caption":"Bj\u00f6rn Meijer"},"logo":{"@id":"https:\/\/www.bjorn-meijer.nl\/de\/#\/schema\/person\/image\/"},"sameAs":["https:\/\/www.bjorn-meijer.nl"]}]}},"jetpack_featured_media_url":"https:\/\/www.bjorn-meijer.nl\/wp-content\/uploads\/2021\/05\/Excel.png","jetpack_sharing_enabled":true,"jetpack-related-posts":[],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/2450","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/comments?post=2450"}],"version-history":[{"count":5,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/2450\/revisions"}],"predecessor-version":[{"id":2477,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/posts\/2450\/revisions\/2477"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/media\/265"}],"wp:attachment":[{"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/media?parent=2450"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/categories?post=2450"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bjorn-meijer.nl\/en\/wp-json\/wp\/v2\/tags?post=2450"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}