{"id":2342,"date":"2023-07-22T16:56:23","date_gmt":"2023-07-22T16:56:23","guid":{"rendered":"https:\/\/statorials.org\/id\/kenaikan-otomatis-google-sheet\/"},"modified":"2023-07-22T16:56:23","modified_gmt":"2023-07-22T16:56:23","slug":"kenaikan-otomatis-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/kenaikan-otomatis-google-sheet\/","title":{"rendered":"Cara menambah nilai secara otomatis di google sheets (dengan contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin menambah nilai secara otomatis di Google Spreadsheet.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Untungnya, hal ini mudah dilakukan berkat fungsionalitas seret dan isi bawaan Google Sheets, dan contoh berikut menunjukkan cara melakukan hal ini dalam skenario yang berbeda.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Secara otomatis menambah nilai satu per satu<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin membuat daftar nilai dari 0 hingga 20.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, masukkan nilai 0 dan 1 di sel yang berurutan:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21236 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/auto1.png\" alt=\"\" width=\"467\" height=\"414\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot kedua sel. Kemudian arahkan kursor ke pojok kanan bawah sel yang berisi nilai 1:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21237 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/auto2.png\" alt=\"\" width=\"466\" height=\"410\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Saat Anda melihat simbol &#8221; <strong>+<\/strong> &#8221; kecil muncul, cukup klik dan seret ke bawah untuk menyalin pola ke sel lainnya di kolom:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21238 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/auto3.png\" alt=\"\" width=\"456\" height=\"503\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hasilnya adalah daftar nilai mulai dari 0 hingga 20, otomatis bertambah satu.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Kenaikan nilai secara otomatis sebanyak kelipatan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin membuat daftar nilai mulai dari 0 hingga 20, yang secara otomatis bertambah empat.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, masukkan nilai 0 dan 4 di sel berturut-turut:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21239 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/auto4.png\" alt=\"\" width=\"467\" height=\"402\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, sorot kedua sel. Kemudian arahkan kursor ke pojok kanan bawah sel yang berisi nilai 4:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21240 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/auto5.png\" alt=\"\" width=\"468\" height=\"396\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Saat Anda melihat simbol &#8221; <strong>+<\/strong> &#8221; kecil muncul, cukup klik dan seret ke bawah untuk menyalin pola ke sel lainnya di kolom:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21241 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/auto6.png\" alt=\"\" width=\"468\" height=\"378\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hasilnya adalah daftar nilai mulai dari 0 hingga 20, otomatis bertambah empat.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: Menambah pola secara otomatis<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Katakanlah kita ingin membuat daftar minggu yang disebut &#8220;Minggu 1, Minggu 2, Minggu 3&#8221;, dan seterusnya.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Pertama, ketik \u201cMinggu 1\u201d di dalam sel:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21242 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/auto7.png\" alt=\"\" width=\"451\" height=\"386\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Selanjutnya, pilih sel, lalu arahkan kursor ke sudut kanan bawah sel.<\/span> <span style=\"color: #000000;\">Saat Anda melihat simbol &#8221; <strong>+<\/strong> &#8221; kecil muncul, cukup klik dan seret ke bawah untuk menyalin pola ke sel lainnya di kolom:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21243 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/auto8.png\" alt=\"\" width=\"461\" height=\"387\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Hasilnya adalah daftar nama minggu mulai dari minggu 1 hingga minggu 10.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Sumber daya tambahan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Tutorial berikut menjelaskan cara melakukan hal umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/angka-penting-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara membulatkan ke angka penting di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-mengganti-sel-kosong-dengan-nol\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara mengganti sel kosong dengan nol di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/google-sheet-menemukan-nilai-dalam-jangkauan\/\" target=\"_blank\" rel=\"noopener\">Bagaimana cara memeriksa apakah nilainya dalam jangkauan di Google Sheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin menambah nilai secara otomatis di Google Spreadsheet. Untungnya, hal ini mudah dilakukan berkat fungsionalitas seret dan isi bawaan Google Sheets, dan contoh berikut menunjukkan cara melakukan hal ini dalam skenario yang berbeda. Contoh 1: Secara otomatis menambah nilai satu per satu Katakanlah kita ingin membuat daftar nilai dari 0 hingga 20. [&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>Cara Menambah Nilai Secara Otomatis di Google Spreadsheet (dengan Contoh) - Statologi<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara menambah nilai secara otomatis di Google Sheets, dengan beberapa contoh.\" \/>\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\/kenaikan-otomatis-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara Menambah Nilai Secara Otomatis di Google Spreadsheet (dengan Contoh) - Statologi\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara menambah nilai secara otomatis di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/kenaikan-otomatis-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T16:56:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/auto1.png\" \/>\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\/kenaikan-otomatis-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/kenaikan-otomatis-google-sheet\/\",\"name\":\"Cara Menambah Nilai Secara Otomatis di Google Spreadsheet (dengan Contoh) - Statologi\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-22T16:56:23+00:00\",\"dateModified\":\"2023-07-22T16:56:23+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara menambah nilai secara otomatis di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/kenaikan-otomatis-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/kenaikan-otomatis-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/kenaikan-otomatis-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara menambah nilai secara otomatis di google sheets (dengan contoh)\"}]},{\"@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":"Cara Menambah Nilai Secara Otomatis di Google Spreadsheet (dengan Contoh) - Statologi","description":"Tutorial ini menjelaskan cara menambah nilai secara otomatis di Google Sheets, dengan beberapa contoh.","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\/kenaikan-otomatis-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara Menambah Nilai Secara Otomatis di Google Spreadsheet (dengan Contoh) - Statologi","og_description":"Tutorial ini menjelaskan cara menambah nilai secara otomatis di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/kenaikan-otomatis-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-22T16:56:23+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/auto1.png"}],"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\/kenaikan-otomatis-google-sheet\/","url":"https:\/\/statorials.org\/id\/kenaikan-otomatis-google-sheet\/","name":"Cara Menambah Nilai Secara Otomatis di Google Spreadsheet (dengan Contoh) - Statologi","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-22T16:56:23+00:00","dateModified":"2023-07-22T16:56:23+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara menambah nilai secara otomatis di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/kenaikan-otomatis-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/kenaikan-otomatis-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/kenaikan-otomatis-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara menambah nilai secara otomatis di google sheets (dengan contoh)"}]},{"@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\/2342"}],"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=2342"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2342\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}