{"id":2745,"date":"2023-07-20T21:59:06","date_gmt":"2023-07-20T21:59:06","guid":{"rendered":"https:\/\/statorials.org\/id\/isi-otomatis-lembar-google-dari-lembar-lain\/"},"modified":"2023-07-20T21:59:06","modified_gmt":"2023-07-20T21:59:06","slug":"isi-otomatis-lembar-google-dari-lembar-lain","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/isi-otomatis-lembar-google-dari-lembar-lain\/","title":{"rendered":"Google sheets: cara mengisi otomatis nilai dari sheet lain"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Contoh langkah demi langkah berikut menunjukkan cara mengisi otomatis nilai dari sheet lain di Google Spreadsheet.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 1: Masukkan data di lembar pertama<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Pertama, mari kita masukkan data berikut ke dalam <strong>Sheet1<\/strong> di Google Sheets:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24163 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/un-autre1-1.jpg\" alt=\"\" width=\"502\" height=\"450\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Langkah 2: Isi otomatis data di lembar kedua<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Sekarang misalkan kita mempunyai sheet lain bernama <strong>Sheet2<\/strong> yang berisi data berikut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24164 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/un-autre2-1.jpg\" alt=\"\" width=\"483\" height=\"440\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin secara otomatis mengisi nilai dari kolom Points di <strong>Sheet1<\/strong> ke dalam kolom Points di <strong>Sheet2<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untuk melakukannya, kita bisa mengetikkan rumus berikut di sel <strong>C2<\/strong> pada <strong>Sheet2<\/strong> :<\/span><\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong>= <span style=\"color: #ff6600;\">Sheet1!B2<\/span><\/strong><\/pre>\n<p> <span style=\"color: #000000;\">Ini secara otomatis akan mengisi sel <strong>C2<\/strong> dari <strong>Sheet2<\/strong> dengan nilai sel <strong>B2<\/strong> dari <strong>Sheet1<\/strong> :<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24165 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/un-autre4-1.jpg\" alt=\"\" width=\"481\" height=\"458\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Untuk mengisi sisa nilai di kolom C secara otomatis, kita dapat mengarahkan kursor ke pojok kanan bawah sel <strong>C2<\/strong> hingga muncul tanda \u201c+\u201d kecil.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Kemudian klik dan seret ke bawah ke semua sel yang tersisa di kolom C:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-24166 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/un-autre3-1.jpg\" alt=\"\" width=\"461\" height=\"442\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Perhatikan bahwa semua nilai di kolom Poin dari <strong>Sheet1<\/strong> secara otomatis diisi di <strong>Sheet2<\/strong> .<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> Tutorial berikut menjelaskan cara melakukan tugas umum lainnya di Google Spreadsheet:<\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/filter-lembar-google-dari-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara memfilter dari sheet lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sumif-daun-dari-daun-lain\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Cara menggunakan SUMIF dari sheet lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/countif-dari-spreadsheet-google-sheets-lainnya\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: Cara menggunakan COUNTIF dari sheet lain<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/lembar-google-menanyakan-lembar-lain\/\" target=\"_blank\" rel=\"noopener\">Google Spreadsheet: cara melakukan kueri dari sheet lain<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Contoh langkah demi langkah berikut menunjukkan cara mengisi otomatis nilai dari sheet lain di Google Spreadsheet. Langkah 1: Masukkan data di lembar pertama Pertama, mari kita masukkan data berikut ke dalam Sheet1 di Google Sheets: Langkah 2: Isi otomatis data di lembar kedua Sekarang misalkan kita mempunyai sheet lain bernama Sheet2 yang berisi data berikut: [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Google Spreadsheet: Cara mengisi otomatis nilai dari sheet lain - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengisi otomatis nilai dari sheet lain di Google Sheets, dengan contoh langkah demi langkah.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/id\/isi-otomatis-lembar-google-dari-lembar-lain\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Google Spreadsheet: Cara mengisi otomatis nilai dari sheet lain - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengisi otomatis nilai dari sheet lain di Google Sheets, dengan contoh langkah demi langkah.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/isi-otomatis-lembar-google-dari-lembar-lain\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-20T21:59:06+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/un-autre1-1.jpg\" \/>\n<meta name=\"author\" content=\"Benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Ditulis oleh\" \/>\n\t<meta name=\"twitter:data1\" content=\"Benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimasi waktu membaca\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/id\/isi-otomatis-lembar-google-dari-lembar-lain\/\",\"url\":\"https:\/\/statorials.org\/id\/isi-otomatis-lembar-google-dari-lembar-lain\/\",\"name\":\"Google Spreadsheet: Cara mengisi otomatis nilai dari sheet lain - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-20T21:59:06+00:00\",\"dateModified\":\"2023-07-20T21:59:06+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengisi otomatis nilai dari sheet lain di Google Sheets, dengan contoh langkah demi langkah.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/isi-otomatis-lembar-google-dari-lembar-lain\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/isi-otomatis-lembar-google-dari-lembar-lain\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/isi-otomatis-lembar-google-dari-lembar-lain\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Google sheets: cara mengisi otomatis nilai dari sheet lain\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/id\/#website\",\"url\":\"https:\/\/statorials.org\/id\/\",\"name\":\"Statorials\",\"description\":\"Panduan anda untuk kompetensi statistik!\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/id\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"id\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\",\"name\":\"Benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Benjamin anderson\"},\"description\":\"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya\",\"sameAs\":[\"http:\/\/statorials.org\/id\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Google Spreadsheet: Cara mengisi otomatis nilai dari sheet lain - Statorials","description":"Tutorial ini menjelaskan cara mengisi otomatis nilai dari sheet lain di Google Sheets, dengan contoh langkah demi langkah.","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:\/\/statorials.org\/id\/isi-otomatis-lembar-google-dari-lembar-lain\/","og_locale":"id_ID","og_type":"article","og_title":"Google Spreadsheet: Cara mengisi otomatis nilai dari sheet lain - Statorials","og_description":"Tutorial ini menjelaskan cara mengisi otomatis nilai dari sheet lain di Google Sheets, dengan contoh langkah demi langkah.","og_url":"https:\/\/statorials.org\/id\/isi-otomatis-lembar-google-dari-lembar-lain\/","og_site_name":"Statorials","article_published_time":"2023-07-20T21:59:06+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/un-autre1-1.jpg"}],"author":"Benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Ditulis oleh":"Benjamin anderson","Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/id\/isi-otomatis-lembar-google-dari-lembar-lain\/","url":"https:\/\/statorials.org\/id\/isi-otomatis-lembar-google-dari-lembar-lain\/","name":"Google Spreadsheet: Cara mengisi otomatis nilai dari sheet lain - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-20T21:59:06+00:00","dateModified":"2023-07-20T21:59:06+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengisi otomatis nilai dari sheet lain di Google Sheets, dengan contoh langkah demi langkah.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/isi-otomatis-lembar-google-dari-lembar-lain\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/isi-otomatis-lembar-google-dari-lembar-lain\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/isi-otomatis-lembar-google-dari-lembar-lain\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Google sheets: cara mengisi otomatis nilai dari sheet lain"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/id\/#website","url":"https:\/\/statorials.org\/id\/","name":"Statorials","description":"Panduan anda untuk kompetensi statistik!","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/id\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"id"},{"@type":"Person","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81","name":"Benjamin anderson","image":{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/id\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Benjamin anderson"},"description":"Halo, saya Benjamin, pensiunan profesor statistika yang menjadi guru Statorial yang berdedikasi. Dengan pengalaman dan keahlian yang luas di bidang statistika, saya ingin berbagi ilmu untuk memberdayakan mahasiswa melalui Statorials. Baca selengkapnya","sameAs":["http:\/\/statorials.org\/id"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2745"}],"collection":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/comments?post=2745"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2745\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2745"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}