{"id":1918,"date":"2023-10-28T02:58:16","date_gmt":"2023-10-28T02:58:16","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/temukan-sel-yang-digabungkan\/"},"modified":"2023-12-06T06:19:39","modified_gmt":"2023-12-06T06:19:39","slug":"temukan-sel-yang-digabungkan","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/temukan-sel-yang-digabungkan\/","title":{"rendered":"Bagaimana menemukan sel yang digabungkan di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1834092171\"><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>Seringkali Anda mendapatkan data yang berisi sel yang digabungkan, sehingga menghalangi Anda melakukan aktivitas tertentu seperti mengurutkan data, menggunakan referensi ke sel yang digabungkan dalam rumus, dan menggunakan pemilihan filter dengan benar.<\/p><p> Dalam hal ini, Anda perlu menemukan sel yang digabungkan untuk dipisahkan dan disesuaikan, dan menemukan sel yang digabungkan satu per satu mungkin memerlukan waktu.<\/p><p> Namun, duduk dan bersantailah, Excel memiliki fungsi untuk menemukan dan menyorot semua sel yang digabungkan sekaligus untuk melihatnya dengan cepat sebelum memisahkannya dan kami telah menjelaskan fungsi ini untuk Anda.<\/p><h2 class=\"wp-block-heading\"> Langkah-langkah Menemukan Sel yang Digabung Menggunakan Temukan dan Ganti<\/h2><ol><li> Pertama, pilih rentang sel atau seluruh lembar tempat Anda ingin menemukan sel gabungannya.<\/li><li> Setelah rentang dipilih, buka tab \u201cBeranda\u201d dan di bawah grup \u201cEdit\u201d, klik ikon \u201cTemukan dan Ganti\u201d dan pilih opsi Ganti untuk membuka kotak dialog Ganti.<\/li><li> Atau cukup tekan tombol pintas \u201cCtrl + H\u201d untuk membuka kotak dialog \u201cGanti\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-gunakan-temukan-dan-ganti\" 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> Setelah itu, klik opsi \u201cFormat\u201d di kotak dialog \u201cTemukan dan Ganti\u201d dan kotak dialog \u201cTemukan Format\u201d akan terbuka. <br><img loading=\"lazy\" decoding=\"async\" title=\"Opsi pemformatan 2-klik\" 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> Pada kotak dialog \u201cFind Format\u201d, buka tab \u201cAlignment\u201d, centang opsi \u201cMerge Cells\u201d dan hapus centang opsi \u201cWrap Text\u201d dan \u201cShrink to Fit\u201d dengan benar seperti yang ditunjukkan pada gambar, lalu klik OK. <br><img loading=\"lazy\" decoding=\"async\" title=\"Sel yang digabungkan hanya dengan 3 tanda centang\" 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> Sekarang klik &#8220;Temukan Semua&#8221; di kotak dialog &#8220;Temukan dan Ganti&#8221; dan Anda akan mendapatkan semua sel gabungan yang tercantum di bawah dalam kotak dialog. <br><img loading=\"lazy\" decoding=\"async\" title=\"Temukan semuanya dalam 4 klik\" 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> Sekarang klik sel mana pun yang terdaftar di kotak dialog &#8220;Temukan dan Ganti&#8221; dan pilih semua sel yang terdaftar menggunakan tombol &#8220;Ctrl+A&#8221; dan sel gabungan Anda dalam data akan dipilih. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-pilih-semua-sel-terdaftar\" 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> Untuk menyorot sel gabungan yang dipilih, buka tab &#8220;Beranda&#8221; dan di bawah grup &#8220;Font&#8221;, klik ikon &#8220;Isi Warna&#8221; dan pilih warnanya, dan sel gabungan Anda akan disorot dan Anda akan dapat melihatnya dengan cepat sebelum memisahkan mereka.<\/li><li> Pada akhirnya, untuk memisahkan grupnya, cukup klik ikon &#8220;Gabungkan dan Pusatkan&#8221; di bawah grup &#8220;Penyelarasan&#8221; dan semua sel yang digabungkan akan dipisahkan dari grupnya. <br><img loading=\"lazy\" decoding=\"async\" title=\"6 sel gabungan disorot\" 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\"> Temukan sel yang digabungkan menggunakan kode VBA<\/h2><p> Pengguna juga dapat menggunakan kode VBA untuk menemukan dan menyorot sel yang digabungkan.<\/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\/id\/unggul-terlebih-dahulu\/\">Tutorial Excel Tingkat Lanjut<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/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\/id\/alat-analisis-cepat\/\">Alat Analisis Cepat di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/\">Terapkan beberapa filter ke kolom<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/\">Sorot nilai N atas dan bawah di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kotak-centang\/\">Sisipkan kotak centang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-sel-tanpa-kehilangan-data\/\">Gabungkan sel tanpa kehilangan data di 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-1918","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 Cara Menemukan Sel yang Digabung di Excel<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menemukan sel yang digabungkan di Excel dengan dua cara berbeda.\" \/>\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\/id\/temukan-sel-yang-digabungkan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"2 Cara Menemukan Sel yang Digabung di Excel\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menemukan sel yang digabungkan di Excel dengan dua cara berbeda.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/temukan-sel-yang-digabungkan\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:39+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=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/temukan-sel-yang-digabungkan\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/temukan-sel-yang-digabungkan\/\",\"name\":\"2 Cara Menemukan Sel yang Digabung di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/temukan-sel-yang-digabungkan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/temukan-sel-yang-digabungkan\/#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-06T06:19:39+00:00\",\"description\":\"Dalam tutorial ini, kita akan mempelajari cara menemukan sel yang digabungkan di Excel dengan dua cara berbeda.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/temukan-sel-yang-digabungkan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/temukan-sel-yang-digabungkan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/temukan-sel-yang-digabungkan\/#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\/id\/temukan-sel-yang-digabungkan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana menemukan sel yang digabungkan di excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"name\":\"Excel Advisor\",\"description\":\"Panduan utama Anda untuk mendominasi data!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/id\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"id\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/id\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"2 Cara Menemukan Sel yang Digabung di Excel","description":"Dalam tutorial ini, kita akan mempelajari cara menemukan sel yang digabungkan di Excel dengan dua cara berbeda.","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\/id\/temukan-sel-yang-digabungkan\/","og_locale":"id_ID","og_type":"article","og_title":"2 Cara Menemukan Sel yang Digabung di Excel","og_description":"Dalam tutorial ini, kita akan mempelajari cara menemukan sel yang digabungkan di Excel dengan dua cara berbeda.","og_url":"https:\/\/exceladvisor.org\/id\/temukan-sel-yang-digabungkan\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:39+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":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/temukan-sel-yang-digabungkan\/","url":"https:\/\/exceladvisor.org\/id\/temukan-sel-yang-digabungkan\/","name":"2 Cara Menemukan Sel yang Digabung di Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/temukan-sel-yang-digabungkan\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/temukan-sel-yang-digabungkan\/#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-06T06:19:39+00:00","description":"Dalam tutorial ini, kita akan mempelajari cara menemukan sel yang digabungkan di Excel dengan dua cara berbeda.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/temukan-sel-yang-digabungkan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/temukan-sel-yang-digabungkan\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/temukan-sel-yang-digabungkan\/#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\/id\/temukan-sel-yang-digabungkan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana menemukan sel yang digabungkan di excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/id\/#website","url":"https:\/\/exceladvisor.org\/id\/","name":"Excel Advisor","description":"Panduan utama Anda untuk mendominasi data!","publisher":{"@id":"https:\/\/exceladvisor.org\/id\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/id\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"id"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/id\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/id\/","logo":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/id\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1918","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/comments?post=1918"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1918\/revisions"}],"predecessor-version":[{"id":2870,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1918\/revisions\/2870"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1918"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}