{"id":1590,"date":"2023-11-16T04:16:08","date_gmt":"2023-11-16T04:16:08","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/salin-tempel\/"},"modified":"2023-12-06T06:18:51","modified_gmt":"2023-12-06T06:18:51","slug":"salin-tempel","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/salin-tempel\/","title":{"rendered":"Bagaimana cara menyalin dan menempel melalui pintasan excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-499801933\"><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>Salin dan tempel adalah fitur Excel yang paling umum dan sering digunakan. Fitur ini digunakan untuk menyalin dan menempelkan data dari satu tempat ke tempat lain. Pengguna bisa membuat beberapa salinan data yang disalin di berbagai lokasi pada lembar yang sama, pada lembar berbeda, atau di beberapa buku kerja.<\/p><p> Seperti fitur excel lainnya, fitur ini juga memiliki shortcut keyboard dan jika anda pecinta shortcut keyboard pasti tahu tentang shortcut copy paste ini.<\/p><h2 class=\"wp-block-heading\"> Pintasan keyboard untuk menyalin dan menempel di Excel<\/h2><p> <kbd>Ctrl<\/kbd> + <kbd>C<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69421\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png\" sizes=\"auto, \" srcset=\"\" alt=\"salinan pintasan keyboard\" width=\"809\" height=\"317\"><\/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-69422\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-raccourci-clavier-coller.png\" sizes=\"auto, \" srcset=\"\" alt=\"tempel pintasan keyboard\" width=\"813\" height=\"319\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Langkah-langkah untuk menyalin dan menempel menggunakan pintasan keyboard<\/h2><ul><li> Pertama, buka sel atau pilih rentang sel tempat Anda ingin menyalin data, lalu tekan tombol \u201cCtrl + C\u201d. <br><img decoding=\"async\" title=\"3-salin-rentangnya\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-copier-la-plage.png\" sizes=\"\" srcset=\"\" alt=\"copy-the-range\"><\/li><li> Setelah itu, buka sel tempat Anda ingin menempelkan data yang disalin dan tekan tombol \u201cEnter\u201d atau tombol \u201cCtrl + V\u201d dan data Anda akan ditempel\/disalin di sana. <br><img decoding=\"async\" title=\"4-tempel-data\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-coller-les-donnees.png\" sizes=\"\" srcset=\"\" alt=\"paste-the-data\"><\/li><\/ul><p> Pada gambar di atas, Anda dapat melihat bahwa kita menekan &#8220;Ctrl + V&#8221; di sel &#8220;F1&#8221;, dan data yang disalin ditempel di sana.<\/p><h2 class=\"wp-block-heading\"> Kesimpulan<\/h2><ul><li> Untuk menempelkan data di satu lokasi, Anda dapat menggunakan tombol \u201cEnter\u201d untuk menempelkan data.<\/li><li> Untuk menempelkan data yang disalin ke beberapa lokasi, Anda perlu menggunakan tombol \u201cCtrl + V\u201d, jika tidak, Anda perlu menyalin data berulang kali untuk menempelkannya ke beberapa lokasi.<\/li><li> Untuk menempelkan data menggunakan opsi tempel khusus (hanya nilai, rumus, atau format), Anda perlu menggunakan tombol \u201cCtrl + Alt + V\u201d untuk menempelkan data yang disalin. <\/li><\/ul><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-51\"><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\/potong-dan-tempel\/\">Potong 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><\/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-1590","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 menyalin dan menempel melalui pintasan Excel? - Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menyalin dan menempel di Excel. Sekarang pintasan keyboard 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\/salin-tempel\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menyalin dan menempel melalui pintasan Excel? - Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menyalin dan menempel di Excel. Sekarang pintasan keyboard ini\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/salin-tempel\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:51+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-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\/salin-tempel\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/salin-tempel\/\",\"name\":\"Bagaimana cara menyalin dan menempel melalui pintasan Excel? - Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/salin-tempel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/salin-tempel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png\",\"datePublished\":\"2023-11-16T04:16:08+00:00\",\"dateModified\":\"2023-12-06T06:18:51+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menyalin dan menempel di Excel. Sekarang pintasan keyboard ini\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/salin-tempel\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/salin-tempel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/salin-tempel\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/salin-tempel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menyalin dan menempel melalui pintasan 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 menyalin dan menempel melalui pintasan Excel? - Penasihat Excel","description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menyalin dan menempel di Excel. Sekarang pintasan keyboard 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\/salin-tempel\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menyalin dan menempel melalui pintasan Excel? - Penasihat Excel","og_description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menyalin dan menempel di Excel. Sekarang pintasan keyboard ini","og_url":"https:\/\/exceladvisor.org\/id\/salin-tempel\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:51+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-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\/salin-tempel\/","url":"https:\/\/exceladvisor.org\/id\/salin-tempel\/","name":"Bagaimana cara menyalin dan menempel melalui pintasan Excel? - Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/salin-tempel\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/salin-tempel\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png","datePublished":"2023-11-16T04:16:08+00:00","dateModified":"2023-12-06T06:18:51+00:00","description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk menyalin dan menempel di Excel. Sekarang pintasan keyboard ini","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/salin-tempel\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/salin-tempel\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/salin-tempel\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/salin-tempel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menyalin dan menempel melalui pintasan 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\/1590","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=1590"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1590\/revisions"}],"predecessor-version":[{"id":2778,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1590\/revisions\/2778"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1590"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}