{"id":1904,"date":"2023-10-29T06:40:28","date_gmt":"2023-10-29T06:40:28","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/hapus-pemformatan\/"},"modified":"2023-12-06T06:19:24","modified_gmt":"2023-12-06T06:19:24","slug":"hapus-pemformatan","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/hapus-pemformatan\/","title":{"rendered":"Bagaimana cara menghapus pemformatan di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3232149390\"><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>Di Excel, pemformatan digunakan untuk menyorot sel atau rentang sel agar data yang relevan mudah terlihat. Hal ini dapat dilakukan dengan menerapkan warna sel atau font, batas, perataan, gaya font, dan format lainnya.<\/p><p> Dan, terkadang Anda perlu menghapus pemformatan dari beberapa rentang sel tertentu atau seluruh lembar kerja, dan melakukannya secara manual adalah tugas yang membosankan dan ada kemungkinan kehilangan beberapa pemformatan untuk menghapus jika data Anda besar.<\/p><p> Tapi tenang saja, Excel punya beberapa cara untuk menghapus format dengan cepat dan mudah dan beberapa di antaranya dijelaskan di bawah ini untuk Anda.<\/p><h2 class=\"wp-block-heading\"> Langkah-langkah untuk Menghapus Pemformatan Menggunakan Opsi Clear Formats<\/h2><ol><li> Pertama, pilih sel atau rentang sel yang ingin Anda hapus pemformatannya, atau seluruh lembar jika Anda ingin menghapus pemformatan dari seluruh lembar.<\/li><li> Setelah itu, buka tab \u201cBeranda\u201d dan di grup Pengeditan, klik ikon tarik-turun Hapus. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-tab-beranda-ikon-hapus\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-deffacement-de-longlet-daccueil.png\" sizes=\"auto, \" srcset=\"\" alt=\"home-tab-clear-icon\" width=\"495\" height=\"395\"><\/li><li> Sekarang, pilih opsi Hapus Format dari daftar drop-down. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-pilih-hapus-format\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-selectionnez-des-formats-clairs.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-clear-formats\" width=\"196\" height=\"259\"><\/li><li> Saat Anda mengklik Hapus Format, semua jenis pemformatan yang diterapkan, termasuk warna sel, warna font, perataan batas, pemformatan bersyarat, dll., akan dihapus. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-format-dihapus\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-formatage-efface.png\" sizes=\"auto, \" srcset=\"\" alt=\"formatting-cleared\" width=\"302\" height=\"294\"><\/li><\/ol><div class=\"wp-block-group more-box is-layout-constrained\"><div class=\"wp-block-group__inner-container\"><ul id=\"ub_styled_list-fc5e0c8e-1a81-4ae0-81ad-53d21f6fae54\" class=\"ub_styled_list\"><li class=\"ub_styled_list_item\"> Jika Anda hanya memiliki beberapa kata atau karakter berwarna di sel, Excel tidak bisa menghapus pemformatan warna ini menggunakan salah satu langkah yang dijelaskan di atas. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77424\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-quelques-caracteres-colores-en-valeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"beberapa karakter berwarna dalam nilai\" width=\"177\" height=\"188\"><\/figure><\/div><\/div><\/div><h2 class=\"wp-block-heading\"> Hapus pemformatan menggunakan Format Painter<\/h2><ol><li> Pertama, navigasikan ke sel mana pun yang belum diformat.<\/li><li> Setelah itu, buka tab \u201cBeranda\u201d dan di bawah grup Clipboard, klik Format Painter.<\/li><li> Sekarang pilih sel atau rentang sel yang ingin Anda hapus pemformatannya. <br><img loading=\"lazy\" decoding=\"async\" title=\"pelukis-format-4-penggunaan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-utiliser-format-peintre.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-format-painter\" width=\"430\" height=\"425\"><\/li><li> Pada titik ini, semua pemformatan yang diterapkan akan dihapus. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-semua-format-dihapus\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-tout-formatage-efface.png\" sizes=\"auto, \" srcset=\"\" alt=\"all-formatting-cleared\" width=\"287\" height=\"279\"><\/li><\/ol><h2 class=\"wp-block-heading\"> Hapus pemformatan menggunakan pintasan keyboard<\/h2><p> Excel juga memiliki pintasan keyboard untuk menghapus pemformatan dan untuk itu Anda hanya perlu mengikuti dua langkah yang disebutkan di bawah ini.<\/p><ul><li> Pertama, pilih sel atau rentang sel yang ingin Anda hapus pemformatannya, atau seluruh lembar jika Anda ingin menghapus pemformatan dari seluruh lembar.<\/li><li> Setelah itu, cukup tekan <kbd>Alt<\/kbd> \u2192 <kbd>H<\/kbd> \u2192 <kbd>E<\/kbd> \u2192 <kbd>F<\/kbd> secara berurutan dan pemformatan akan terhapus.<\/li><\/ul><h2 class=\"wp-block-heading\"> Hapus pemformatan menggunakan kode VBA<\/h2><p> Anda juga dapat menggunakan kode VBA untuk menghapus pemformatan.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Range(\u201cA1\u201d).ClearFormats<\/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\/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\/format-angka-akuntansi\/\">Terapkan format angka akuntansi di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menambahkan-nomor-halaman\/\">Tambahkan nomor halaman di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/terapkan-gaya-koma\/\">Terapkan gaya koma di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tongkat\/\">Terapkan coretan di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sorot-sel-kosong\/\">Sorot sel kosong di Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-1904","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 menghapus pemformatan di Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menghapus pemformatan di Excel. Excel memiliki beberapa cara untuk menghapus pemformatan dengan cepat...\" \/>\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\/hapus-pemformatan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menghapus pemformatan di Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menghapus pemformatan di Excel. Excel memiliki beberapa cara untuk menghapus pemformatan dengan cepat...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/hapus-pemformatan\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-deffacement-de-longlet-daccueil.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\/hapus-pemformatan\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/hapus-pemformatan\/\",\"name\":\"Bagaimana cara menghapus pemformatan di Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-pemformatan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-pemformatan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-deffacement-de-longlet-daccueil.png\",\"datePublished\":\"2023-10-29T06:40:28+00:00\",\"dateModified\":\"2023-12-06T06:19:24+00:00\",\"description\":\"Dalam tutorial ini, kita akan mempelajari cara menghapus pemformatan di Excel. Excel memiliki beberapa cara untuk menghapus pemformatan dengan cepat...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-pemformatan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/hapus-pemformatan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-pemformatan\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-deffacement-de-longlet-daccueil.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-deffacement-de-longlet-daccueil.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/hapus-pemformatan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghapus pemformatan 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 menghapus pemformatan di Excel? (Tutorial 2023)","description":"Dalam tutorial ini, kita akan mempelajari cara menghapus pemformatan di Excel. Excel memiliki beberapa cara untuk menghapus pemformatan dengan cepat...","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\/hapus-pemformatan\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menghapus pemformatan di Excel? (Tutorial 2023)","og_description":"Dalam tutorial ini, kita akan mempelajari cara menghapus pemformatan di Excel. Excel memiliki beberapa cara untuk menghapus pemformatan dengan cepat...","og_url":"https:\/\/exceladvisor.org\/id\/hapus-pemformatan\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:24+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-deffacement-de-longlet-daccueil.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\/hapus-pemformatan\/","url":"https:\/\/exceladvisor.org\/id\/hapus-pemformatan\/","name":"Bagaimana cara menghapus pemformatan di Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/hapus-pemformatan\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/hapus-pemformatan\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-deffacement-de-longlet-daccueil.png","datePublished":"2023-10-29T06:40:28+00:00","dateModified":"2023-12-06T06:19:24+00:00","description":"Dalam tutorial ini, kita akan mempelajari cara menghapus pemformatan di Excel. Excel memiliki beberapa cara untuk menghapus pemformatan dengan cepat...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/hapus-pemformatan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/hapus-pemformatan\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/hapus-pemformatan\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-deffacement-de-longlet-daccueil.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-icone-deffacement-de-longlet-daccueil.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/hapus-pemformatan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghapus pemformatan 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\/1904","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=1904"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1904\/revisions"}],"predecessor-version":[{"id":2848,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1904\/revisions\/2848"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1904"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}