{"id":1917,"date":"2023-10-28T02:58:16","date_gmt":"2023-10-28T02:58:16","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/"},"modified":"2023-12-06T05:50:10","modified_gmt":"2023-12-06T05:50:10","slug":"samengevoegde-cellen-zoeken","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/","title":{"rendered":"Hoe samengevoegde cellen in excel vinden?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-3735859444\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Vaak krijgt u gegevens die samengevoegde cellen bevatten, waardoor u bepaalde activiteiten niet kunt uitvoeren, zoals het sorteren van gegevens, het gebruik van verwijzingen naar samengevoegde cellen in formules en het correct gebruiken van filterselectie.<\/p><p> In dit geval moet u de samengevoegde cellen vinden om ze te degroeperen en aan te passen. Het kan enige tijd duren om de samengevoegde cellen \u00e9\u00e9n voor \u00e9\u00e9n te vinden.<\/p><p> Maar leun achterover en ontspan, Excel heeft de functionaliteit om alle samengevoegde cellen in \u00e9\u00e9n keer te vinden en te markeren om ze snel te bekijken voordat ze worden gedegroepeerd en we hebben deze functionaliteit voor u beschreven.<\/p><h2 class=\"wp-block-heading\"> Stappen om samengevoegde cellen te vinden met Zoeken en vervangen<\/h2><ol><li> Selecteer eerst het celbereik of het hele blad waaruit u de samengevoegde cellen wilt vinden.<\/li><li> Zodra het bereik is geselecteerd, gaat u naar het tabblad &#8220;Home&#8221; en klikt u onder de groep &#8220;Bewerken&#8221; op het pictogram &#8220;Zoeken en vervangen&#8221; en selecteert u de optie Vervangen om het dialoogvenster Vervangen te openen.<\/li><li> Of druk gewoon op de sneltoets &#8220;Ctrl + H&#8221; om het dialoogvenster &#8220;Vervangen&#8221; te openen. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-gebruik-vind-en-vervang\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-rechercher-et-remplacer.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-find-and-replace\" width=\"664\" height=\"363\"><\/li><li> Klik daarna op de optie &#8220;Formaat&#8221; in het dialoogvenster &#8220;Zoeken en vervangen&#8221; en het dialoogvenster &#8220;Formaat zoeken&#8221; wordt geopend. <br><img loading=\"lazy\" decoding=\"async\" title=\"Opmaakoptie met 2 klikken\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-cliquez-sur-loption-de-format.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-on-format-option\" width=\"468\" height=\"223\"><\/li><li> Ga in het dialoogvenster &#8220;Formaat zoeken&#8221; naar het tabblad &#8220;Uitlijning&#8221;, vink de optie &#8220;Cellen samenvoegen&#8221; aan en schakel de opties &#8220;Tekst omwikkelen&#8221; en &#8220;Verkleinen om passend te maken&#8221; uit, zoals weergegeven in de afbeelding, en klik vervolgens op OK. <br><img loading=\"lazy\" decoding=\"async\" title=\"Samengevoegde cellen met slechts drie vinkjes\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-coches-uniquement-pour-les-cellules-fusionnees.png\" sizes=\"auto, \" srcset=\"\" alt=\"tickmark-only-merged-cells\" width=\"475\" height=\"335\"><\/li><li> Klik nu op &#8220;Alles zoeken&#8221; in het dialoogvenster &#8220;Zoeken en vervangen&#8221; en u krijgt alle samengevoegde cellen die hieronder in het dialoogvenster worden vermeld. <br><img loading=\"lazy\" decoding=\"async\" title=\"Vind alles in 4 klikken\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-clics-pour-tout-trouver.png\" sizes=\"auto, \" srcset=\"\" alt=\"click-find-all\" width=\"468\" height=\"306\"><\/li><li> Klik nu op een cel in het dialoogvenster &#8220;Zoeken en vervangen&#8221; en selecteer alle cellen in de lijst met de toetsen &#8220;Ctrl+A&#8221;. Uw samengevoegde cellen in de gegevens worden geselecteerd. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-selecteer-alle-cellen-vermeld\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-selectionner-toutes-les-cellules-repertoriees.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-all-listed-cells\" width=\"697\" height=\"386\"><\/li><li> Om de geselecteerde samengevoegde cellen te markeren, gaat u naar het tabblad &#8220;Start&#8221; en klikt u onder de groep &#8220;Lettertype&#8221; op het pictogram &#8220;Opvulkleur&#8221; en selecteert u de kleur. Uw samengevoegde cellen worden gemarkeerd en u kunt ze snel bekijken voordat u ze dissocieert.<\/li><li> Om ze te degroeperen, klikt u op het einde op het pictogram &#8220;Samenvoegen en centreren&#8221; onder de groep &#8220;Uitlijning&#8221;. Alle samengevoegde cellen worden dan gedegroepeerd. <br><img loading=\"lazy\" decoding=\"async\" title=\"6 samengevoegde cellen gemarkeerd\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-cellules-fusionnees-en-surbrillance.png\" sizes=\"auto, \" srcset=\"\" alt=\"highlight-merged-cells\" width=\"775\" height=\"429\"><\/li><\/ol><h2 class=\"wp-block-heading\"> Zoek samengevoegde cellen met behulp van VBA-code<\/h2><p> Gebruikers kunnen ook VBA-code gebruiken om samengevoegde cellen te vinden en te markeren.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub find_merged_cells() Dim Cel As Range, Msg As String, Addr As String For Each Cel In ActiveSheet.UsedRange If Cel.MergeCells Then Cel.Interior.Color = 65535 End If Next End Sub<\/code><\/pre><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/nl\/excel-vooruitgang\/\">Geavanceerde Excel-zelfstudies<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Gerelateerde tutorials <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/snelle-analysetool\/\">Snelle analysetool in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/meerdere-filters-toepassen\/\">Pas meerdere filters toe op kolommen<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/markeer-de-bovenste-en-onderste-waarden\/\">Markeer de bovenste en onderste N-waarden in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/selectievakje\/\">Voeg een selectievakje in Excel in<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/cellen-samenvoegen-zonder-gegevensverlies\/\">Voeg cellen samen zonder gegevens te verliezen in Excel<\/a><\/li><\/ul><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1917","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>2 manieren om samengevoegde cellen in Excel te vinden<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leren we op twee verschillende manieren hoe u samengevoegde cellen in Excel kunt vinden.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"2 manieren om samengevoegde cellen in Excel te vinden\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leren we op twee verschillende manieren hoe u samengevoegde cellen in Excel kunt vinden.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:50:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-rechercher-et-remplacer.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/\",\"name\":\"2 manieren om samengevoegde cellen in Excel te vinden\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-rechercher-et-remplacer.png\",\"datePublished\":\"2023-10-28T02:58:16+00:00\",\"dateModified\":\"2023-12-06T05:50:10+00:00\",\"description\":\"In deze zelfstudie leren we op twee verschillende manieren hoe u samengevoegde cellen in Excel kunt vinden.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-rechercher-et-remplacer.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-rechercher-et-remplacer.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe samengevoegde cellen in excel vinden?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"2 manieren om samengevoegde cellen in Excel te vinden","description":"In deze zelfstudie leren we op twee verschillende manieren hoe u samengevoegde cellen in Excel kunt vinden.","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:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/","og_locale":"nl_NL","og_type":"article","og_title":"2 manieren om samengevoegde cellen in Excel te vinden","og_description":"In deze zelfstudie leren we op twee verschillende manieren hoe u samengevoegde cellen in Excel kunt vinden.","og_url":"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:50:10+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-rechercher-et-remplacer.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"2 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/","url":"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/","name":"2 manieren om samengevoegde cellen in Excel te vinden","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-rechercher-et-remplacer.png","datePublished":"2023-10-28T02:58:16+00:00","dateModified":"2023-12-06T05:50:10+00:00","description":"In deze zelfstudie leren we op twee verschillende manieren hoe u samengevoegde cellen in Excel kunt vinden.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-rechercher-et-remplacer.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-rechercher-et-remplacer.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/samengevoegde-cellen-zoeken\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe samengevoegde cellen in excel vinden?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1917","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1917"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1917\/revisions"}],"predecessor-version":[{"id":2683,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1917\/revisions\/2683"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1917"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}