{"id":1840,"date":"2023-10-31T21:14:17","date_gmt":"2023-10-31T21:14:17","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/salinan-1\/"},"modified":"2023-12-06T06:18:59","modified_gmt":"2023-12-06T06:18:59","slug":"salinan-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/salinan-1\/","title":{"rendered":"Bagaimana cara menyalin\/memindahkan spreadsheet di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-547670253\"><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, Anda bisa menyalin atau memindahkan lembar ke buku kerja baru atau buku kerja yang sudah terbuka. Dan dalam tutorial ini, kita akan mempelajarinya secara detail.<\/p><ul><li> Salin \u2013 Ini membuat salinan baru dan memindahkannya ke buku kerja lain.<\/li><li> Pindahkan \u2013 Ini memindahkan lembar asli.<\/li><\/ul><p> Mari kita pelajari ini.<\/p><h2 id=\"h-copy-a-sheet-to-an-existing-sheet\" class=\"wp-block-heading\"> Salin lembar ke lembar yang sudah ada<\/h2><ol><li> Klik kanan pada tab Lembar dan klik \u201cSalin atau Pindahkan\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"1 salinan per lembar\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copier-une-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"1-copy-a-sheet\" width=\"415\" height=\"451\"><\/li><li> Di kotak dialog, gunakan menu drop-down \u201cUntuk Memesan\u201d untuk memilih buku kerja. Dan di \u201cBefore Sheet\u201d, pilih sheet yang ingin Anda salin.<\/li><li> Selanjutnya, centang kotak \u201cBuat salinan\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"2 tanda centang-buat-salinan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-coche-creer-une-copie.png\" sizes=\"auto, \" srcset=\"\" alt=\"2-tickmark-create-a-copy\" width=\"320\" height=\"326\"><\/li><li> Pada akhirnya, klik OK.<\/li><\/ol><p> Dalam contoh ini, kami telah menyalin lembar \u201cPuneet\u201d dari Buku2 ke Buku1. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92247\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-feuilles-copiees-dans-un-autre-classeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"lembar disalin ke buku kerja lain\" width=\"576\" height=\"371\"><\/figure><\/div><p class=\"qt-tip\"> <strong>Catatan<\/strong> : Jika Anda ingin memindahkan lembar alih-alih menyalinnya, lanjutkan dengan mencentang kotak \u201cBuat salinan\u201d.<\/p><h2 id=\"h-copy-a-sheet-to-a-new-sheet\" class=\"wp-block-heading\"> Salin lembar ke lembar baru<\/h2><p> Dengan cara yang sama, Anda bisa membuat buku kerja baru dengan opsi yang sama dan menyalin atau memindahkan lembar ke buku kerja ini. Saat membuka kotak dialog \u201cPindahkan atau Salin\u201d, dari \u201cUntuk memesan; \u00bb daftar drop-down, pilih (buku baru), lalu klik OK. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92248\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-copier-une-feuille-vers-une-nouvelle-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"salin-lembar-ke-lembar-baru\" width=\"287\" height=\"266\"><\/figure><\/div><p> Dan ketika Anda mengklik OK, Excel langsung membuka buku kerja baru dan menyalin lembar tersebut ke buku kerja baru ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92249\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-feuilles-copiees-dans-un-nouveau-classeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"lembar disalin ke buku kerja baru\" width=\"227\" height=\"286\"><\/figure><\/div><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Jika Anda tidak ingin membuat salinan lembar dan ingin memindahkan lembar ke buku kerja baru, alihkan ke tanda centang &#8220;Buat salinan&#8221;. <\/p><div class=\"gb-container gb-container-3044ba66 gb-container-mt\"><p class=\"gb-headline gb-headline-b5bb6270 gb-headline-text\"> <strong><a href=\"https:\/\/exceladvisor.org\/id\/dasar-dasar-excel\/\">Dasar-Dasar Excel<\/a><\/strong> \/ <strong><a href=\"https:\/\/exceladvisor.org\/id\/lembar-kerja\/\" data-wpil=\"url\">Lembar Bentang Excel<\/a><\/strong><\/p><h2 class=\"gb-headline gb-headline-819d540d gb-headline-text gb-headline-mt-heading\"> Tutorial lainnya <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-7f3d805a gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-530ab33a\"><div class=\"gb-container gb-container-530ab33a\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/menampilkan\/\">Melihat lembar Excel atau semua lembar (spreadsheet)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hapus-1\/\">Hapus lembar (lembar kerja) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/duplikat\/\">Gandakan lembar atau spreadsheet di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tautan-ke-lembar-lain\/\">Buat hyperlink (tautan) ke spreadsheet lain<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kunci\/\">Kunci lembar (lembar kerja) 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-1840","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\/memindahkan spreadsheet di Excel?<\/title>\n<meta name=\"description\" content=\"Tutorial ini membantu Anda mempelajari 2 metode berbeda untuk menyalin atau memindahkan lembar ke buku kerja baru.\" \/>\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\/salinan-1\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara menyalin\/memindahkan spreadsheet di Excel?\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini membantu Anda mempelajari 2 metode berbeda untuk menyalin atau memindahkan lembar ke buku kerja baru.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/salinan-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:59+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copier-une-feuille.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\/salinan-1\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/salinan-1\/\",\"name\":\"Bagaimana cara menyalin\/memindahkan spreadsheet di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/salinan-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/salinan-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copier-une-feuille.png\",\"datePublished\":\"2023-10-31T21:14:17+00:00\",\"dateModified\":\"2023-12-06T06:18:59+00:00\",\"description\":\"Tutorial ini membantu Anda mempelajari 2 metode berbeda untuk menyalin atau memindahkan lembar ke buku kerja baru.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/salinan-1\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/salinan-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/salinan-1\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copier-une-feuille.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copier-une-feuille.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/salinan-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara menyalin\/memindahkan spreadsheet 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 menyalin\/memindahkan spreadsheet di Excel?","description":"Tutorial ini membantu Anda mempelajari 2 metode berbeda untuk menyalin atau memindahkan lembar ke buku kerja baru.","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\/salinan-1\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara menyalin\/memindahkan spreadsheet di Excel?","og_description":"Tutorial ini membantu Anda mempelajari 2 metode berbeda untuk menyalin atau memindahkan lembar ke buku kerja baru.","og_url":"https:\/\/exceladvisor.org\/id\/salinan-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:59+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copier-une-feuille.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\/salinan-1\/","url":"https:\/\/exceladvisor.org\/id\/salinan-1\/","name":"Bagaimana cara menyalin\/memindahkan spreadsheet di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/salinan-1\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/salinan-1\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copier-une-feuille.png","datePublished":"2023-10-31T21:14:17+00:00","dateModified":"2023-12-06T06:18:59+00:00","description":"Tutorial ini membantu Anda mempelajari 2 metode berbeda untuk menyalin atau memindahkan lembar ke buku kerja baru.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/salinan-1\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/salinan-1\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/salinan-1\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copier-une-feuille.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copier-une-feuille.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/salinan-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara menyalin\/memindahkan spreadsheet 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\/1840","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=1840"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1840\/revisions"}],"predecessor-version":[{"id":2794,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1840\/revisions\/2794"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}