{"id":1597,"date":"2023-11-15T18:44:47","date_gmt":"2023-11-15T18:44:47","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/"},"modified":"2023-12-06T06:14:41","modified_gmt":"2023-12-06T06:14:41","slug":"potong-dan-tempel","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/","title":{"rendered":"Bagaimana cara memotong dan menempel di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-4197941552\"><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, dengan fungsi copy paste, pengguna hanya bisa menyalin data dari satu tempat dan menempelkannya di tempat lain, artinya data setelah ditempel akan tersedia di kedua tempat tersebut.<\/p><p> Namun fungsi potong digunakan untuk memotong data dari tempatnya untuk dipindahkan ke tempat lain, yang berarti ketika Anda menggunakan opsi potong untuk memindahkan data, sel tempat Anda memotong data akan menjadi kosong setelah Anda menempelkannya. data ini di tempat lain.<\/p><p> Dalam tutorial ini, kami telah menjelaskan cara menggunakan pintasan keyboard untuk memotong dan menempelkan data dari satu tempat ke tempat lain.<\/p><h2 class=\"wp-block-heading\"> Pintasan keyboard untuk memotong dan menempel di Excel<\/h2><p> <kbd>Ctrl<\/kbd> + <kbd>X<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69429\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-couper-le-raccourci-clavier.png\" sizes=\"auto, \" srcset=\"\" alt=\"potong-pintasan-keyboard\" width=\"812\" height=\"318\"><\/figure><\/div><p> <kbd>Ctrl<\/kbd> + <kbd>V<\/kbd> atau <kbd>Enter<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69430\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-coller-le-raccourci-clavier.png\" sizes=\"auto, \" srcset=\"\" alt=\"tempel keyboard pintasan\" width=\"810\" height=\"318\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Langkah-langkah Memotong dan Menempel Menggunakan Pintasan Keyboard<\/h2><ul><li> Pertama, masuk ke sel atau pilih rentang sel yang datanya ingin Anda potong, lalu tekan tombol \u201cCtrl + X\u201d. <br><img decoding=\"async\" title=\"3-potong-sel-menggunakan-pintasan-keyboard\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-cellules-coupees-a-laide-dun-raccourci-clavier.png\" sizes=\"\" srcset=\"\" alt=\"cut-cells-using-keyboard-shortcut\"><\/li><li> Setelah itu, masuk ke sel tempat Anda ingin memindahkan data ini dan tekan tombol \u201cEnter\u201d atau tombol \u201cCtrl + V\u201d dan data Anda akan dipindahkan ke sana. <br><img decoding=\"async\" title=\"4-tempel data yang dipotong\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-coller-les-donnees-coupees.png\" sizes=\"\" srcset=\"\" alt=\"paste-the-cut-data\"><\/li><\/ul><p> Pada gambar di atas terlihat kita menekan &#8220;Enter&#8221; atau &#8220;Ctrl + V&#8221; di sel &#8220;F2&#8221;, dan data dipindahkan ke sana dan sel yang telah kita salin dari data menjadi kosong, yang menunjukkan bahwa data tersebut sudah ada. dipindahkan dari satu lokasi ke lokasi lain. <\/p><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Tutorial lainnya <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-15\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/referensi-mutlak\/\">Referensi mutlak<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/salin-tempel\/\">Salin dan tempel<\/a><\/li><li> Kunci sel<\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/tempel-nilai\/\">Tempelkan nilai<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pilih-satu-baris\/\">Pilih satu baris<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengubah-posisi-2\/\">Mengubah urutan<\/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-1597","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>\u25b7Bagaimana cara memotong dan menempel di Excel? (Pintasan Excel)<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menerapkan salin dan tempel di Excel. Sekarang jalan pintas ini\" \/>\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\/potong-dan-tempel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7Bagaimana cara memotong dan menempel di Excel? (Pintasan Excel)\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menerapkan salin dan tempel di Excel. Sekarang jalan pintas ini\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-couper-le-raccourci-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\/potong-dan-tempel\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/\",\"name\":\"\u25b7Bagaimana cara memotong dan menempel di Excel? (Pintasan Excel)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-couper-le-raccourci-clavier.png\",\"datePublished\":\"2023-11-15T18:44:47+00:00\",\"dateModified\":\"2023-12-06T06:14:41+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menerapkan salin dan tempel di Excel. Sekarang jalan pintas ini\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-couper-le-raccourci-clavier.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-couper-le-raccourci-clavier.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara memotong dan menempel 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":"\u25b7Bagaimana cara memotong dan menempel di Excel? (Pintasan Excel)","description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menerapkan salin dan tempel di Excel. Sekarang jalan pintas ini","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\/potong-dan-tempel\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7Bagaimana cara memotong dan menempel di Excel? (Pintasan Excel)","og_description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menerapkan salin dan tempel di Excel. Sekarang jalan pintas ini","og_url":"https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:41+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-couper-le-raccourci-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\/potong-dan-tempel\/","url":"https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/","name":"\u25b7Bagaimana cara memotong dan menempel di Excel? (Pintasan Excel)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-couper-le-raccourci-clavier.png","datePublished":"2023-11-15T18:44:47+00:00","dateModified":"2023-12-06T06:14:41+00:00","description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menerapkan salin dan tempel di Excel. Sekarang jalan pintas ini","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-couper-le-raccourci-clavier.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-couper-le-raccourci-clavier.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/potong-dan-tempel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara memotong dan menempel 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\/1597","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=1597"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1597\/revisions"}],"predecessor-version":[{"id":2364,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1597\/revisions\/2364"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1597"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}