{"id":1862,"date":"2023-10-30T19:52:35","date_gmt":"2023-10-30T19:52:35","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/duplikat\/"},"modified":"2023-12-06T06:13:42","modified_gmt":"2023-12-06T06:13:42","slug":"duplikat","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/duplikat\/","title":{"rendered":"Bagaimana cara membuat lembar kerja duplikat di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3663851419\"><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, jika Anda ingin membuat lembar duplikat, yaitu membuat salinan lembar di buku kerja yang sama, Anda bisa menggunakan dua metode berbeda.<\/p><ul><li> Seret dan lepas dengan mouse.<\/li><li> Buat salinan duplikat dengan menyalin dan memindahkan<\/li><\/ul><p> Dalam tutorial ini, kita akan melihat kedua metode tersebut.<\/p><h2 id=\"h-drag-and-drop-to-create-a-duplicate-sheet\" class=\"wp-block-heading\"> Seret dan lepas untuk membuat lembar duplikat<\/h2><ol type=\"1\"><li> Pertama, aktifkan lembar yang ingin Anda buat salinannya.<\/li><li> Sekarang tekan tombol Ctrl.<\/li><li> Setelah itu, tahan tombol Ctrl, klik pada tab lembar.<\/li><li> Pada akhirnya, seret dan lepas lembar ke lokasi baru di tab lembar. <\/li><\/ol><figure class=\"gb-block-image gb-block-image-b115ad26\"><img loading=\"lazy\" decoding=\"async\" class=\"gb-image gb-image-b115ad26\" title=\"duplikat-excel-sheet-drag-drop\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-en-double-excel-glisser-deposer.gif\" sizes=\"auto, \" srcset=\"\" alt=\"duplicate-sheet-excel-drag-drop\" width=\"890\" height=\"306\"><\/figure><p> Ini menciptakan duplikat lembar, yang meluncur dan jatuh. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92667\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-glisser-deposer-pour-creer-une-feuille-en-double.png\" sizes=\"auto, \" srcset=\"\" alt=\"seret dan lepas untuk membuat lembar duplikat\" width=\"546\" height=\"224\"><\/figure><\/div><p> Anda dapat melihat pada contoh di atas; Anda memiliki lembar duplikat baru &#8220;Sheet3&#8221; dengan (2) dengan nama aslinya.<\/p><h2 id=\"h-use-copy-and-move-to-create-a-duplicate-copy-of-the-sheet\" class=\"wp-block-heading\"> Gunakan Salin dan Pindahkan untuk membuat salinan duplikat lembar<\/h2><p> Saat Anda mengklik kanan pada tab lembar, Anda dapat melihat opsi \u201cPindahkan atau Salin\u201d di sana. Opsi ini memungkinkan Anda menyalin lembar ke buku kerja baru atau ke buku kerja yang sudah ada dan terbuka. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92668\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-copier-et-deplacer-vers-la-feuille-dupliquee.png\" sizes=\"auto, \" srcset=\"\" alt=\"salin dan pindahkan ke lembar duplikat\" width=\"483\" height=\"390\"><\/figure><\/div><p> Namun dengan opsi yang sama Anda bisa membuat salinan lembar duplikat di buku kerja yang sama. Saat Anda mengklik opsi tersebut, kotak dialog akan muncul untuk memilih tujuan penyalinan lembar. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92669\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-copies-dans-le-meme-classeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"salin ke buku kerja yang sama\" width=\"548\" height=\"391\"><\/figure><\/div><p> Di kotak dialog Pindahkan atau Salin, centang kotak &#8220;Buat salinan&#8221; dan pastikan Anda memiliki nama buku kerja yang sama di &#8220;Untuk memesan:&#8221;. Pada akhirnya, klik OK untuk membuat salinan duplikat. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92670\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-coche-creer-une-copie.png\" sizes=\"auto, \" srcset=\"\" alt=\"tanda centang-buat-salinan\" width=\"652\" height=\"212\"><\/figure><\/div><p> Anda dapat memilih posisi untuk menambahkan lembar duplikat di kotak dialog ini. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92671\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-choisissez-la-position-pour-ajouter-une-feuille-en-double.png\" sizes=\"auto, \" srcset=\"\" alt=\"pilih-posisi-untuk-menambahkan-lembar-duplikat\" width=\"348\" height=\"323\"><\/figure><\/div><p class=\"qt-tip\"> <strong>Catatan:<\/strong> Dari kedua cara tersebut, cara pertama adalah cara yang cepat dan mudah. Tapi Anda dapat menggunakan salah satu dari mereka sesuai dengan preferensi Anda. <\/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\/hapus-1\/\">Hapus lembar (lembar kerja) 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><li> <a href=\"https:\/\/exceladvisor.org\/id\/menyegarkan\/\">Refresh lembar (spreadsheet) di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/membuka\/\">Buka kunci lembar dengan kata sandi (tanpa kata sandi)<\/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-1862","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 membuat lembar kerja duplikat di Excel?<\/title>\n<meta name=\"description\" content=\"Di Excel, jika Anda ingin membuat lembar duplikat, yaitu membuat salinan lembar di buku kerja yang sama, Anda bisa\" \/>\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\/duplikat\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara membuat lembar kerja duplikat di Excel?\" \/>\n<meta property=\"og:description\" content=\"Di Excel, jika Anda ingin membuat lembar duplikat, yaitu membuat salinan lembar di buku kerja yang sama, Anda bisa\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/duplikat\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:13:42+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-en-double-excel-glisser-deposer.gif\" \/>\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\/duplikat\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/duplikat\/\",\"name\":\"\u25b7 Bagaimana cara membuat lembar kerja duplikat di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/duplikat\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/duplikat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-en-double-excel-glisser-deposer.gif\",\"datePublished\":\"2023-10-30T19:52:35+00:00\",\"dateModified\":\"2023-12-06T06:13:42+00:00\",\"description\":\"Di Excel, jika Anda ingin membuat lembar duplikat, yaitu membuat salinan lembar di buku kerja yang sama, Anda bisa\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/duplikat\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/duplikat\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/duplikat\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-en-double-excel-glisser-deposer.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-en-double-excel-glisser-deposer.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/duplikat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara membuat lembar kerja duplikat 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 membuat lembar kerja duplikat di Excel?","description":"Di Excel, jika Anda ingin membuat lembar duplikat, yaitu membuat salinan lembar di buku kerja yang sama, Anda bisa","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\/duplikat\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara membuat lembar kerja duplikat di Excel?","og_description":"Di Excel, jika Anda ingin membuat lembar duplikat, yaitu membuat salinan lembar di buku kerja yang sama, Anda bisa","og_url":"https:\/\/exceladvisor.org\/id\/duplikat\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:13:42+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-en-double-excel-glisser-deposer.gif","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\/duplikat\/","url":"https:\/\/exceladvisor.org\/id\/duplikat\/","name":"\u25b7 Bagaimana cara membuat lembar kerja duplikat di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/duplikat\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/duplikat\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-en-double-excel-glisser-deposer.gif","datePublished":"2023-10-30T19:52:35+00:00","dateModified":"2023-12-06T06:13:42+00:00","description":"Di Excel, jika Anda ingin membuat lembar duplikat, yaitu membuat salinan lembar di buku kerja yang sama, Anda bisa","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/duplikat\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/duplikat\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/duplikat\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-en-double-excel-glisser-deposer.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/feuille-en-double-excel-glisser-deposer.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/duplikat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara membuat lembar kerja duplikat 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\/1862","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=1862"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1862\/revisions"}],"predecessor-version":[{"id":2306,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1862\/revisions\/2306"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1862"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}