{"id":2120,"date":"2023-10-14T20:26:54","date_gmt":"2023-10-14T20:26:54","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/"},"modified":"2023-12-06T06:13:11","modified_gmt":"2023-12-06T06:13:11","slug":"batalkan-pilihan-sel","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/","title":{"rendered":"Bagaimana cara membatalkan pilihan sel di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1806963883\"><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>Hingga saat ini, Excel tidak memiliki kemampuan untuk membatalkan pilihan sel atau rentang dari rentang sel yang dipilih. Jadi tidak ada yang bisa membatalkan pilihan sel atau rentang sel dari pilihannya.<\/p><p> Namun sekarang Excel telah memperkenalkan fitur untuk membatalkan pilihan sel atau rentang sel yang dipilih dari pilihan Anda saat ini. Pada saat blog ini ditulis, fitur baru ini hanya tersedia untuk pelanggan PC dan Mac Office 365 dan Excel 2019.<\/p><p> Di bawah ini kami telah menangkap beberapa langkah cepat dan mudah bagi Anda untuk membatalkan pilihan dan memilih sel di Excel<\/p><h2 id=\"deselect-cells-in-excel\" class=\"wp-block-heading\"> Batalkan pilihan sel di Excel<\/h2><p> Setelah menambahkan fitur Batalkan Pilihan Sel di Excel, Anda dapat dengan mudah membatalkan pilihan sel yang tidak Anda perlukan dari pilihan Anda saat ini.<\/p><ul><li> Pertama, tahan tombol \u201cKontrol\u201d pada keyboard.<\/li><li> Setelah itu, klik sel dalam pilihan Anda saat ini yang ingin Anda batalkan pilihannya. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64054\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"batalkan pilihan sel\" width=\"580\" height=\"284\"><\/figure><\/div><p> Pada contoh gambar di atas, kita menahan tombol Control dan mengklik sel B1, B3, dan B7 untuk membatalkan pilihan kolom tersebut dari pilihan saat ini (A1-I15). Anda dapat melihat setelah pemilihan bahwa kolom yang dipilih tidak dipilih.<\/p><h2 id=\"deselect-the-entire-columns-in-excel\" class=\"wp-block-heading\"> Batalkan pilihan seluruh kolom di Excel<\/h2><ul><li> Pertama, tahan tombol \u201cKontrol\u201d pada keyboard.<\/li><li> Setelah itu, klik pada tajuk kolom dan seret ke seluruh kolom untuk membatalkan pilihan kolom tersebut dari pilihan Anda saat ini. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64055\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-deselectionner-la-colonne-entiere.png\" sizes=\"auto, \" srcset=\"\" alt=\"batalkan pilihan-seluruh-kolom\" width=\"654\" height=\"303\"><\/figure><\/div><p> Pada contoh gambar di atas, kita menahan tombol Control dan mengklik header kolom (Kategori), dan menyeret seluruh kolom ke D15 dan melakukan hal yang sama -header kolom (Zona) untuk membatalkan pilihan kedua kolom keseluruhan (D &amp; F) dari pilihan saat ini (A1-I15).<\/p><h2 id=\"select-cells-or-ranges-in-excel\" class=\"wp-block-heading\"> Pilih sel atau rentang di Excel<\/h2><p> Tidak ada perubahan dalam pemilihan sel atau rentang sel di Excel. Proses pemilihan selnya sama dan ditunjukkan di bawah ini:<\/p><ul><li> Untuk sel yang bersebelahan, pilih sel tempat Anda ingin membuat pilihan dan<\/li><li> Setelah itu, tahan tombol \u201cShift\u201d pada keyboard lalu klik sel lain yang ingin Anda buat pilihannya<\/li><li> Atau pilih sel tempat Anda ingin membuat pilihan, lalu seret ke sel tempat Anda ingin membuat pilihan. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64056\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-selectionner-des-cellules-contigues.png\" sizes=\"auto, \" srcset=\"\" alt=\"pilih sel yang berdekatan\" width=\"589\" height=\"295\"><\/figure><\/div><p> Pada contoh gambar di atas, pertama kita klik dan tahan Shift pada sel A1, lalu langsung klik pada sel I15 untuk membuat seleksi dari (A1-I15).<\/p><ul><li> Untuk sel yang tidak bersebelahan, tahan tombol Kontrol, lalu pilih sel atau rentang yang diinginkan sebagai pilihan Anda. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64057\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-selectionner-des-cellules-non-contigues.png\" sizes=\"auto, \" srcset=\"\" alt=\"pilih sel yang tidak bersebelahan\" width=\"646\" height=\"266\"><\/figure><\/div><p> Pada contoh gambar di atas, kita menahan tombol Control dan memilih rentang sel yang tidak bersebelahan.<\/p><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\/dasar-dasar-excel\/\">Dasar-Dasar Microsoft Excel (Komponen, Bagian dan Catatan Pengetahuan)<\/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\/tambahkan-hapus-hyperlink\/\">Tambahkan dan hapus hyperlink di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-tanda-air\/\">Tambahkan tanda air di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/\">Hapus baris tersembunyi di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menambahkan-kolom\/\">Tambahkan kolom di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pilih-sel-yang-tidak-bersebelahan\/\">Pilih sel yang tidak bersebelahan 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-2120","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>Bagaimana cara membatalkan pilihan sel di Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara membatalkan pilihan sel di Excel. Dan Anda juga akan belajar cara membatalkan pilihan a\" \/>\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\/batalkan-pilihan-sel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara membatalkan pilihan sel di Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara membatalkan pilihan sel di Excel. Dan Anda juga akan belajar cara membatalkan pilihan a\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:13:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.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\/batalkan-pilihan-sel\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/\",\"name\":\"Bagaimana cara membatalkan pilihan sel di Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png\",\"datePublished\":\"2023-10-14T20:26:54+00:00\",\"dateModified\":\"2023-12-06T06:13:11+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari cara membatalkan pilihan sel di Excel. Dan Anda juga akan belajar cara membatalkan pilihan a\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membatalkan pilihan sel 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":"Bagaimana cara membatalkan pilihan sel di Excel? (Tutorial 2023)","description":"Dalam tutorial ini, Anda akan mempelajari cara membatalkan pilihan sel di Excel. Dan Anda juga akan belajar cara membatalkan pilihan a","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\/batalkan-pilihan-sel\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara membatalkan pilihan sel di Excel? (Tutorial 2023)","og_description":"Dalam tutorial ini, Anda akan mempelajari cara membatalkan pilihan sel di Excel. Dan Anda juga akan belajar cara membatalkan pilihan a","og_url":"https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:13:11+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.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\/batalkan-pilihan-sel\/","url":"https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/","name":"Bagaimana cara membatalkan pilihan sel di Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png","datePublished":"2023-10-14T20:26:54+00:00","dateModified":"2023-12-06T06:13:11+00:00","description":"Dalam tutorial ini, Anda akan mempelajari cara membatalkan pilihan sel di Excel. Dan Anda juga akan belajar cara membatalkan pilihan a","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membatalkan pilihan sel 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\/2120","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=2120"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2120\/revisions"}],"predecessor-version":[{"id":2272,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2120\/revisions\/2272"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2120"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}