{"id":2683,"date":"2023-07-21T04:49:11","date_gmt":"2023-07-21T04:49:11","guid":{"rendered":"https:\/\/statorials.org\/id\/seri-pengisian-google-sheet\/"},"modified":"2023-07-21T04:49:11","modified_gmt":"2023-07-21T04:49:11","slug":"seri-pengisian-google-sheet","status":"publish","type":"post","link":"https:\/\/statorials.org\/id\/seri-pengisian-google-sheet\/","title":{"rendered":"Cara mengisi rangkaian di google sheets (4 contoh)"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">Seringkali Anda mungkin ingin mengisi serangkaian nilai di Google Spreadsheet. Untungnya, hal ini mudah dilakukan dengan fitur seret dan isi sederhana yang ada di Google Spreadsheet.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Tutorial ini menjelaskan cara menyelesaikan rangkaian dalam empat skenario berbeda:<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>1.<\/strong> Isi rangkaian angka<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>2.<\/strong> Lengkapi rangkaian huruf<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>3.<\/strong> Selesaikan rangkaian hari<\/span><\/p>\n<p> <span style=\"color: #000000;\"><strong>4.<\/strong> Selesaikan rangkaian bulan<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 1: Mengisi rangkaian angka<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk mengisi rangkaian angka di Google Sheets, cukup masukkan nilai dua angka pertama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23622 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplirgoogle1.jpg\" alt=\"\" width=\"475\" height=\"372\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian arahkan kursor ke pojok kanan bawah sel hingga muncul tanda \u201c <strong>+<\/strong> \u201d kecil. Kemudian klik dan seret ke jumlah sel yang Anda inginkan di kolom yang sama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-23623\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplirgoogle2.jpg\" alt=\"isi rangkaian angka di Google Sheets\" width=\"472\" height=\"401\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Google Sheets akan secara otomatis mendeteksi pola antara dua angka pertama (misalnya menambahkan nilai) dan cukup mengulangi pola tersebut untuk nilai sebanyak yang Anda inginkan.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 2: Mengisi rangkaian huruf<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk mengisi rangkaian huruf di Google Spreadsheet, ketikkan huruf pertama dalam sel, lalu gunakan rumus berikut untuk menambah satu huruf:<\/span> <\/p>\n<pre style=\"background-color: #ececec; font-size: 17px;\"> <strong><span class=\" default-formula-text-color\" dir=\"auto\">=CHAR(CODE( <span dir=\"auto\" style=\"color: #ff6600;\">A2<\/span> ) <span class=\"  default-formula-text-color\" dir=\"auto\">+<\/span> <span class=\"number\" dir=\"auto\" style=\"color: #3366ff;\">1<\/span> )\n<\/span><\/strong><\/pre>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-23624\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplirgoogle3.jpg\" alt=\"mengisi serangkaian surat di Google Sheets\" width=\"461\" height=\"373\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian arahkan kursor ke pojok kanan bawah sel hingga muncul tanda \u201c <strong>+<\/strong> \u201d kecil. Kemudian klik dan seret ke jumlah sel yang Anda inginkan di kolom yang sama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23625 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplirgoogle4.jpg\" alt=\"\" width=\"454\" height=\"391\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Serangkaian surat akan terisi secara otomatis.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 3: Mengisi rangkaian hari<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk mengisi rangkaian hari di Google Spreadsheet, cukup masukkan tanggal hari pertama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23626 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplirgoogle5.jpg\" alt=\"\" width=\"487\" height=\"394\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian arahkan kursor ke pojok kanan bawah sel hingga muncul tanda \u201c <strong>+<\/strong> \u201d kecil. Kemudian klik dan seret ke jumlah sel yang Anda inginkan di kolom yang sama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23627 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplirgoogle6.jpg\" alt=\"\" width=\"471\" height=\"400\" srcset=\"\" sizes=\"\"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Contoh 4. Mengisi rangkaian bulan<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Untuk mengisi rangkaian bulan di Google Spreadsheet, cukup masukkan nama bulan pertama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23629 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplirgoogle7.jpg\" alt=\"\" width=\"459\" height=\"356\" srcset=\"\" sizes=\"\"><\/p>\n<p> <span style=\"color: #000000;\">Kemudian arahkan kursor ke pojok kanan bawah sel hingga muncul tanda \u201c <strong>+<\/strong> \u201d kecil. Kemudian klik dan seret ke jumlah sel yang Anda inginkan di kolom yang sama:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-23628 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplirgoogle8.jpg\" alt=\"\" width=\"479\" height=\"363\" srcset=\"\" sizes=\"\"><\/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 tugas umum lainnya di Google Spreadsheet:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/id\/google-meninggalkan-rantai\/\" target=\"_blank\" rel=\"noopener\">Cara mengekstrak substring di Google Sheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/rentang-tanggal-filter-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara memfilter berdasarkan rentang tanggal di Google Spreadsheet<\/a><br \/> <a href=\"https:\/\/statorials.org\/id\/tanggal-pengisian-otomatis-google-sheet\/\" target=\"_blank\" rel=\"noopener\">Cara Mengisi Tanggal Secara Otomatis di Google Spreadsheet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Seringkali Anda mungkin ingin mengisi serangkaian nilai di Google Spreadsheet. Untungnya, hal ini mudah dilakukan dengan fitur seret dan isi sederhana yang ada di Google Spreadsheet. Tutorial ini menjelaskan cara menyelesaikan rangkaian dalam empat skenario berbeda: 1. Isi rangkaian angka 2. Lengkapi rangkaian huruf 3. Selesaikan rangkaian hari 4. Selesaikan rangkaian bulan Contoh 1: Mengisi [&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 mengisi seri di Google Sheets (4 contoh) - Statorials<\/title>\n<meta name=\"description\" content=\"Tutorial ini menjelaskan cara mengisi rangkaian 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\/seri-pengisian-google-sheet\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cara mengisi seri di Google Sheets (4 contoh) - Statorials\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini menjelaskan cara mengisi rangkaian di Google Sheets, dengan beberapa contoh.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/id\/seri-pengisian-google-sheet\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-21T04:49:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplirgoogle1.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\/seri-pengisian-google-sheet\/\",\"url\":\"https:\/\/statorials.org\/id\/seri-pengisian-google-sheet\/\",\"name\":\"Cara mengisi seri di Google Sheets (4 contoh) - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/id\/#website\"},\"datePublished\":\"2023-07-21T04:49:11+00:00\",\"dateModified\":\"2023-07-21T04:49:11+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81\"},\"description\":\"Tutorial ini menjelaskan cara mengisi rangkaian di Google Sheets, dengan beberapa contoh.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/id\/seri-pengisian-google-sheet\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/id\/seri-pengisian-google-sheet\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/id\/seri-pengisian-google-sheet\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/statorials.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cara mengisi rangkaian di google sheets (4 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 mengisi seri di Google Sheets (4 contoh) - Statorials","description":"Tutorial ini menjelaskan cara mengisi rangkaian 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\/seri-pengisian-google-sheet\/","og_locale":"id_ID","og_type":"article","og_title":"Cara mengisi seri di Google Sheets (4 contoh) - Statorials","og_description":"Tutorial ini menjelaskan cara mengisi rangkaian di Google Sheets, dengan beberapa contoh.","og_url":"https:\/\/statorials.org\/id\/seri-pengisian-google-sheet\/","og_site_name":"Statorials","article_published_time":"2023-07-21T04:49:11+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplirgoogle1.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\/seri-pengisian-google-sheet\/","url":"https:\/\/statorials.org\/id\/seri-pengisian-google-sheet\/","name":"Cara mengisi seri di Google Sheets (4 contoh) - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/id\/#website"},"datePublished":"2023-07-21T04:49:11+00:00","dateModified":"2023-07-21T04:49:11+00:00","author":{"@id":"https:\/\/statorials.org\/id\/#\/schema\/person\/3d17a1160dd2d052b7c78e502cb9ec81"},"description":"Tutorial ini menjelaskan cara mengisi rangkaian di Google Sheets, dengan beberapa contoh.","breadcrumb":{"@id":"https:\/\/statorials.org\/id\/seri-pengisian-google-sheet\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/id\/seri-pengisian-google-sheet\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/id\/seri-pengisian-google-sheet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/statorials.org\/id\/"},{"@type":"ListItem","position":2,"name":"Cara mengisi rangkaian di google sheets (4 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\/2683"}],"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=2683"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/posts\/2683\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/media?parent=2683"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/categories?post=2683"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/id\/wp-json\/wp\/v2\/tags?post=2683"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}