{"id":2103,"date":"2023-10-17T00:17:04","date_gmt":"2023-10-17T00:17:04","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jangkauan\/"},"modified":"2023-12-06T06:12:44","modified_gmt":"2023-12-06T06:12:44","slug":"jangkauan","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jangkauan\/","title":{"rendered":"Apa itu rentang excel dan fitur-fiturnya?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-406563351\"><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> <h2 class=\"wp-block-heading\">Apa itu rentang di Excel<\/h2><p> Rentang adalah sekelompok beberapa sel di Excel. Ada rentang yang kontinu dan tidak kontinu. Sama seperti sel tunggal, setiap rentang memiliki alamat yang dapat Anda gunakan untuk merujuk ke rentang tersebut. Kolom dan baris juga merupakan bentuk rentang kontinu karena merupakan sekelompok sel.<\/p><h2 class=\"wp-block-heading\"> Pilih rentang sel<\/h2><p> Saat bekerja dengan data di Excel, Anda perlu memilih rentang yang memungkinkan Anda menyalin-menempel, memindahkan, dan menghapusnya (banyak hal lainnya juga).<\/p><p> Untuk memilih seluruh rentang, pilih sel tempat Anda ingin memulai pemilihan (C1). Sambil menahan tombol kiri mouse, pilih sel tempat Anda ingin memperluas pilihan rentang Anda. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-78750\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/image-gif.gif\" sizes=\"auto, \" srcset=\"\" alt=\"\" width=\"480\" height=\"321\"><\/figure><\/div><p> Cara lain untuk memilih rentang adalah dengan menekan tombol Shift dan menggunakan tombol navigasi. Seperti yang Anda lihat pada cuplikan di atas, kami memilih rentang dari C1 hingga C10.<\/p><p class=\"tips\"> Saat Anda memilih rentang, Excel menampilkan jumlah baris dan kolom di kotak Nama di sebelah kiri bilah rumus.<\/p><p class=\"tips\"> Setelah Anda menyelesaikan pemilihan, kotak nama menampilkan alamat sel aktif yang tidak disorot. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-78744\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-case-nom-dans-la-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"nama-bidang-dalam-lembar\" width=\"500\" height=\"216\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Mengacu pada rentang yang berdekatan<\/h2><p> Untuk mereferensikan rentang dalam fungsi atau rumus, Anda memiliki dua metode berbeda:<\/p><ul><li> <strong>Mouse:<\/strong> Anda dapat memilih rentang menggunakan mouse sambil memasukkan fungsi atau rumus.<\/li><li> <strong>Tipe:<\/strong> Anda juga dapat mengetikkan alamat rentang dengan keyboard Anda saat memasukkan fungsi atau rumus. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-78745\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-plage-continue-de-reference.png\" sizes=\"auto, \" srcset=\"\" alt=\"rentang referensi-berlanjut\" width=\"721\" height=\"196\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Referensi ke rentang yang tidak bersebelahan<\/h2><p> Untuk merujuk pada rentang tidak kontinu, ikuti langkah-langkah berikut:<\/p><ol><li> Pertama, pilih sel atau rentang pertama dan ketik perintah.<\/li><li> Setelah itu, tahan tombol Ctrl dan pilih baris kedua di lembar kerja Anda, lalu ketikkan koma lagi.<\/li><li> Pada akhirnya, pilih baris sel ketiga.<\/li><\/ol><p> Di bawah ini kami telah memilih B3:B5, C2:C6 dan D3:D5. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-78746\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-gamme-non-continue-de-reference.png\" sizes=\"auto, \" srcset=\"\" alt=\"referensi-lingkup-non-kontinyu\" width=\"646\" height=\"332\"><\/figure><\/div><p> Cara lain masukkan alamat rentang pertama, lalu gunakan koma dan ketik rentang kedua, dan sekarang gunakan koma lagi dan ketikkan rentang sel ketiga pada rumus atau fungsinya.<\/p><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/id\/dasar-dasar-excel\/\">Dasar-Dasar Microsoft Excel (Komponen, Bagian dan Catatan Pengetahuan)<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Tutorial terkait <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-hapus-hyperlink\/\">Tambahkan dan hapus hyperlink di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-tanda-air\/\">Tambahkan tanda air di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hapus-kolom-baris-tersembunyi\/\">Hapus baris tersembunyi di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/batalkan-pilihan-sel\/\">Batalkan pilihan sel di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menambahkan-kolom\/\">Tambahkan kolom di Excel<\/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-2103","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 Apa yang dimaksud dengan rentang Excel dan fitur-fiturnya?<\/title>\n<meta name=\"description\" content=\"Ini adalah tutorial dasar Microsoft Excel untuk mengetahui rentang sel. Pelajari juga cara mereferensikan rentang...\" \/>\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\/jangkauan\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Apa yang dimaksud dengan rentang Excel dan fitur-fiturnya?\" \/>\n<meta property=\"og:description\" content=\"Ini adalah tutorial dasar Microsoft Excel untuk mengetahui rentang sel. Pelajari juga cara mereferensikan rentang...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jangkauan\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:12:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/image-gif.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=\"2 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jangkauan\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jangkauan\/\",\"name\":\"\u25b7 Apa yang dimaksud dengan rentang Excel dan fitur-fiturnya?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jangkauan\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jangkauan\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/image-gif.gif\",\"datePublished\":\"2023-10-17T00:17:04+00:00\",\"dateModified\":\"2023-12-06T06:12:44+00:00\",\"description\":\"Ini adalah tutorial dasar Microsoft Excel untuk mengetahui rentang sel. Pelajari juga cara mereferensikan rentang...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jangkauan\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jangkauan\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jangkauan\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/image-gif.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/image-gif.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jangkauan\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Apa itu rentang excel dan fitur-fiturnya?\"}]},{\"@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 Apa yang dimaksud dengan rentang Excel dan fitur-fiturnya?","description":"Ini adalah tutorial dasar Microsoft Excel untuk mengetahui rentang sel. Pelajari juga cara mereferensikan rentang...","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\/jangkauan\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Apa yang dimaksud dengan rentang Excel dan fitur-fiturnya?","og_description":"Ini adalah tutorial dasar Microsoft Excel untuk mengetahui rentang sel. Pelajari juga cara mereferensikan rentang...","og_url":"https:\/\/exceladvisor.org\/id\/jangkauan\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:12:44+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/image-gif.gif","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\/jangkauan\/","url":"https:\/\/exceladvisor.org\/id\/jangkauan\/","name":"\u25b7 Apa yang dimaksud dengan rentang Excel dan fitur-fiturnya?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jangkauan\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jangkauan\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/image-gif.gif","datePublished":"2023-10-17T00:17:04+00:00","dateModified":"2023-12-06T06:12:44+00:00","description":"Ini adalah tutorial dasar Microsoft Excel untuk mengetahui rentang sel. Pelajari juga cara mereferensikan rentang...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jangkauan\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jangkauan\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jangkauan\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/image-gif.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/image-gif.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jangkauan\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Apa itu rentang excel dan fitur-fiturnya?"}]},{"@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\/2103","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=2103"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2103\/revisions"}],"predecessor-version":[{"id":2243,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2103\/revisions\/2243"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}