{"id":1830,"date":"2023-10-31T23:27:44","date_gmt":"2023-10-31T23:27:44","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/"},"modified":"2023-12-06T06:19:45","modified_gmt":"2023-12-06T06:19:45","slug":"lihat-berdampingan","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/","title":{"rendered":"Cara melihat dua lembar berdampingan di excel"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3687754481\"><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>Excel memiliki fitur untuk membagi dan membandingkan dua lembar kerja dari buku kerja yang sama atau berbeda dan dengan bantuan ini, pengguna dapat dengan cepat membandingkan data dari lembar tersebut tanpa harus berpindah antar lembar lagi dan lagi.<\/p><p> Pengguna juga dapat menyinkronkan pengguliran di antara spreadsheet ini, membuat perbandingan menjadi sangat cepat dan mudah.<\/p><p> Kami telah menyebutkan beberapa langkah cepat dan mudah untuk memisahkan dua atau lebih lembar kerja dari buku kerja yang sama atau berbeda.<\/p><h2 id=\"h-split-and-view-two-sheets-side-by-side-of-the-same-workbook\" class=\"wp-block-heading\">Pisahkan dan tampilkan dua lembar berdampingan dari buku kerja yang sama<\/h2><ol><li> Pertama, buka tab \u201cTampilan\u201d dan klik ikon \u201cJendela Baru\u201d di bawah grup \u201cJendela\u201d pada pita. <br><img loading=\"lazy\" decoding=\"async\" title=\"ikon 1 jendela baru\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nouvelle-icone-de-fenetre.png\" sizes=\"auto, \" srcset=\"\" alt=\"new-window-icon\" width=\"495\" height=\"116\"><\/li><li> Berapa kali Anda mengklik &#8220;Jendela Baru&#8221;, Anda akan mendapatkan salinan buku kerja yang sedang terbuka.<\/li><li> Excel secara otomatis menambahkan angka seperti 1, 2, 3, dst. di akhir nama buku kerja yang disalin. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-salinan-pengikat\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-cahiers-copies.png\" sizes=\"auto, \" srcset=\"\" alt=\"copied-workbook\" width=\"783\" height=\"152\"><\/li><li> Setelah itu, klik ikon \u201cAtur Semua\u201d di bawah grup \u201cJendela\u201d pada pita.<\/li><li> Sekarang, pilih tampilan layar terpisah (Ubin, Horizontal, Vertikal, Air Terjun) dari daftar drop-down dan klik OK.<\/li><li> Opsi &#8220;Jendela buku kerja aktif&#8221; harus selalu dicentang saat memisahkan lembar di buku kerja yang sama. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-urutkan ulang-semua-ikon\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-organiser-toutes-les-icones.png\" sizes=\"auto, \" srcset=\"\" alt=\"arrange-all-icon\" width=\"330\" height=\"306\"><\/li><li> Pada titik ini, buku kerja Anda saat ini dibagi menjadi dua bagian.<\/li><li> Untuk mengganti sheet di antara keduanya, cukup klik pada tab sheet yang ingin Anda lihat untuk perbandingan. <br><img loading=\"lazy\" decoding=\"async\" title=\"4 Lembar Kerja Terbagi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-feuilles-de-travail-divisees.png\" sizes=\"auto, \" srcset=\"\" alt=\"worksheets-split\" width=\"1152\" height=\"332\"><\/li><\/ol><p> Pengguna dapat membagi lebih dari dua buku kerja secara bersamaan hanya dengan membuat lebih banyak salinan buku kerja dari ikon &#8220;Jendela Baru&#8221; di bawah grup &#8220;Jendela&#8221; pada pita. <\/p><h2 id=\"h-split-and-view-two-sheets-side-by-side-of-the-different-workbooks\" class=\"wp-block-heading\"> Pisahkan dan tampilkan dua lembar secara berdampingan dari buku kerja yang berbeda<\/h2><ol><li> Pertama, buka buku kerja yang ingin Anda pisahkan dan bandingkan.<\/li><li> Setelah itu, buka tab \u201cView\u201d, lalu klik ikon \u201cArrange All\u201d di bawah grup \u201cWindow\u201d pada pita.<\/li><li> Sekarang pilih tampilan layar terpisah (Ubin, Horizontal, Vertikal, Air Terjun) dari daftar drop-down.<\/li><li> Pada akhirnya, hapus centang opsi \u201cWindows di buku kerja aktif\u201d dan klik OK. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-atur-semua-dropdown\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-organiser-tous-les-menus-deroulants.png\" sizes=\"auto, \" srcset=\"\" alt=\"arrange-all-dropdown\" width=\"348\" height=\"324\"><\/li><li> Pada titik ini, buku kerja terbuka Anda dibagi menjadi dua bagian. <\/li><\/ol><h2 id=\"h-synchronous-scrolling-between-the-sheets-of-the-same-or-different-workbooks\" class=\"wp-block-heading\"> Pengguliran sinkron antar lembar dalam buku kerja yang sama atau berbeda<\/h2><p> Fitur pengguliran sinkron memungkinkan pengguna untuk menggulir lembar kerja antara dua buku kerja secara bersamaan menggunakan tampilan layar terpisah.<\/p><ol><li> Pertama, buka tab \u201cTampilan\u201d dan klik ikon \u201cTampilkan Berdampingan\u201d di bawah grup \u201cJendela\u201d pada pita.<\/li><li> Sekarang, pilih buku kerja dari daftar drop-down yang ingin Anda bandingkan dalam mode layar terpisah dan klik OK. <br><img loading=\"lazy\" decoding=\"async\" title=\"Opsi 6 tampilan berdampingan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Option-6-vues-cote-a-cote.png\" sizes=\"auto, \" srcset=\"\" alt=\"view-side-by-side-option\" width=\"470\" height=\"338\"><\/li><li> Setelah Anda mengklik OK, Anda akan mendapatkan buku kerja dalam mode meludah dan pengguliran sinkron akan diaktifkan secara default untuk lembar kerja dalam mode layar terbagi. <br><img loading=\"lazy\" decoding=\"async\" title=\"Opsi pengguliran 7-sinkron\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-option-de-defilement-synchrone.png\" sizes=\"auto, \" srcset=\"\" alt=\"synchronous-scrolling-option\" width=\"557\" height=\"119\"><\/li><\/ol><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-7495e031\"><div class=\"gb-container gb-container-7495e031\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengkonsolidasikan\/\">Konsolidasikan data dari beberapa spreadsheet<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/ganti-nama\/\">Ganti nama lembar di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/grup-1\/\">Kelompokkan Lembar Kerja di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menambahkan\/\">Tambahkan spreadsheet di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengubah-warna-tab\/\">Ubah Warna Tab di Excel (Tab Lembar Kerja)<\/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-1830","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>Cara melihat dua lembar berdampingan di Excel<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menampilkan dua lembar secara berdampingan dari satu buku kerja serta dari buku kerja yang berbeda.\" \/>\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\/lihat-berdampingan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara melihat dua lembar berdampingan di Excel\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menampilkan dua lembar secara berdampingan dari satu buku kerja serta dari buku kerja yang berbeda.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:19:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nouvelle-icone-de-fenetre.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/\",\"name\":\"Cara melihat dua lembar berdampingan di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nouvelle-icone-de-fenetre.png\",\"datePublished\":\"2023-10-31T23:27:44+00:00\",\"dateModified\":\"2023-12-06T06:19:45+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari cara menampilkan dua lembar secara berdampingan dari satu buku kerja serta dari buku kerja yang berbeda.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nouvelle-icone-de-fenetre.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nouvelle-icone-de-fenetre.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara melihat dua lembar berdampingan 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":"Cara melihat dua lembar berdampingan di Excel","description":"Dalam tutorial ini, Anda akan mempelajari cara menampilkan dua lembar secara berdampingan dari satu buku kerja serta dari buku kerja yang berbeda.","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\/lihat-berdampingan\/","og_locale":"id_ID","og_type":"article","og_title":"Cara melihat dua lembar berdampingan di Excel","og_description":"Dalam tutorial ini, Anda akan mempelajari cara menampilkan dua lembar secara berdampingan dari satu buku kerja serta dari buku kerja yang berbeda.","og_url":"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:19:45+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nouvelle-icone-de-fenetre.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"2 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/","url":"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/","name":"Cara melihat dua lembar berdampingan di Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nouvelle-icone-de-fenetre.png","datePublished":"2023-10-31T23:27:44+00:00","dateModified":"2023-12-06T06:19:45+00:00","description":"Dalam tutorial ini, Anda akan mempelajari cara menampilkan dua lembar secara berdampingan dari satu buku kerja serta dari buku kerja yang berbeda.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nouvelle-icone-de-fenetre.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-nouvelle-icone-de-fenetre.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/lihat-berdampingan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara melihat dua lembar berdampingan 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\/1830","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=1830"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1830\/revisions"}],"predecessor-version":[{"id":2876,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1830\/revisions\/2876"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1830"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}