{"id":1596,"date":"2023-11-15T20:03:44","date_gmt":"2023-11-15T20:03:44","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/menghapus\/"},"modified":"2023-12-06T06:19:22","modified_gmt":"2023-12-06T06:19:22","slug":"menghapus","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/menghapus\/","title":{"rendered":"Bagaimana cara menghapus nilai sel di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-1722991745\"><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>Cara tercepat untuk menghapus nilai sel adalah dengan menggunakan tombol \u201cHapus\u201d pada keyboard. Pengguna dapat sepenuhnya menghapus nilai yang dimasukkan ke dalam sel menggunakan tombol pintasan keyboard \u201cHapus\u201d dan mengosongkan sel.<\/p><p> Atau terkadang pengguna menemukan bahwa nilai yang dimasukkan ke dalam sel salah eja atau dimasukkan dengan nilai tambahan dan untuk menghapus karakter atau nilai tambahan tersebut, mereka dapat menggunakan tombol pintasan keyboard \u201cHapus\u201d untuk memperbaiki nilainya.<\/p><h2 class=\"wp-block-heading\"> Pintasan keyboard untuk dihapus di Excel<\/h2><p> Pintasan keyboard untuk menghapus nilai disebutkan di bawah ini:<\/p><p> <kbd>MENGHAPUS<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-74576\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touche-de-suppression-du-clavier.png\" sizes=\"auto, \" srcset=\"\" alt=\"hapus-keyboard\" width=\"839\" height=\"329\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Langkah-langkah untuk menghapus nilai menggunakan pintasan keyboard<\/h2><ol><li> Pertama pilih sel yang nilainya ingin Anda hapus. <br><img decoding=\"async\" title=\"seleksi 2 sel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-selection-de-cellules.png\" sizes=\"\" srcset=\"\" alt=\"selection-of-cells\"><\/li><li> Setelah dipilih, cukup tekan tombol \u201cHapus\u201d pada keyboard, dan nilainya akan terhapus dan sel akan menjadi kosong. <br><img decoding=\"async\" title=\"3-nilai-hapus-sel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-valeurs-supprimees-des-cellules.png\" sizes=\"\" srcset=\"\" alt=\"values-delete-from-cells\"><\/li><li> Atau pilih sel dalam mode edit menggunakan tombol \u201cFn + F2\u201d dan gerakkan kursor ke kiri karakter yang ingin Anda hapus. <br><img loading=\"lazy\" decoding=\"async\" title=\"4 sel dalam mode edit\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-cellules-en-mode-edition.png\" sizes=\"auto, \" srcset=\"\" alt=\"cell-in-edit-mode\" width=\"539\" height=\"229\"><\/li><li> Setelah selesai, tekan tombol \u201cHapus\u201d dan ini akan menghapus satu karakter yang diketik di sebelah kanan kursor.<\/li><li> Tekan tombol \u201cHapus\u201d beberapa kali untuk menghapus beberapa karakter. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-hapus-nilai-karakter\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-supprimer-le-caractere-de-la-valeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"delete-character-from-value\" width=\"547\" height=\"234\"><\/li><\/ol><p> Pada gambar di atas, Anda dapat melihat bahwa ketika kita menekan tombol \u201cHapus\u201d, Excel menghapus karakter \u201ct\u201d yang ditempatkan di sebelah kanan kursor. <\/p><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Lebih banyak jalan pintas <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-122\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/menyaring-1\/\">Terapkan dan hapus filter<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-2\/\">Jumlah otomatis<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/konten-yang-jelas\/\">Hapus konten<\/a><\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/meluncur-ke-bawah\/\">Geser ke bawah<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menunjukkan-rumus\/\">Tampilkan rumus<\/a><\/li><\/ul><\/div><\/div><p> \u21e0 Kembali ke <a href=\"https:\/\/exceladvisor.org\/id\/pintasan-keyboard\/\">pintasan Excel (lembar contekan PDF)<\/a><\/p><\/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-1596","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>\u25b7 Bagaimana cara menghapus nilai sel di Excel?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menggunakan pintasan keyboard untuk menghapus nilai dari sebuah sel atau beberapa rentang\" \/>\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\/menghapus\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara menghapus nilai sel di Excel?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, kita akan mempelajari cara menggunakan pintasan keyboard untuk menghapus nilai dari sebuah sel atau beberapa rentang\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/menghapus\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:22+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touche-de-suppression-du-clavier.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/menghapus\/\",\"name\":\"\u25b7 Bagaimana cara menghapus nilai sel di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touche-de-suppression-du-clavier.png\",\"datePublished\":\"2023-11-15T20:03:44+00:00\",\"dateModified\":\"2023-12-06T06:19:22+00:00\",\"description\":\"Dalam tutorial ini, kita akan mempelajari cara menggunakan pintasan keyboard untuk menghapus nilai dari sebuah sel atau beberapa rentang\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/menghapus\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touche-de-suppression-du-clavier.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touche-de-suppression-du-clavier.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/menghapus\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menghapus nilai 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":"\u25b7 Bagaimana cara menghapus nilai sel di Excel?","description":"Dalam tutorial ini, kita akan mempelajari cara menggunakan pintasan keyboard untuk menghapus nilai dari sebuah sel atau beberapa rentang","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\/menghapus\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara menghapus nilai sel di Excel?","og_description":"Dalam tutorial ini, kita akan mempelajari cara menggunakan pintasan keyboard untuk menghapus nilai dari sebuah sel atau beberapa rentang","og_url":"https:\/\/exceladvisor.org\/id\/menghapus\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:22+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touche-de-suppression-du-clavier.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/menghapus\/","url":"https:\/\/exceladvisor.org\/id\/menghapus\/","name":"\u25b7 Bagaimana cara menghapus nilai sel di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/menghapus\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/menghapus\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touche-de-suppression-du-clavier.png","datePublished":"2023-11-15T20:03:44+00:00","dateModified":"2023-12-06T06:19:22+00:00","description":"Dalam tutorial ini, kita akan mempelajari cara menggunakan pintasan keyboard untuk menghapus nilai dari sebuah sel atau beberapa rentang","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/menghapus\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/menghapus\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/menghapus\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touche-de-suppression-du-clavier.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-touche-de-suppression-du-clavier.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/menghapus\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menghapus nilai 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\/1596","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=1596"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1596\/revisions"}],"predecessor-version":[{"id":2843,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1596\/revisions\/2843"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1596"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}