{"id":1525,"date":"2023-11-17T23:12:54","date_gmt":"2023-11-17T23:12:54","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/pilih-rentangnya\/"},"modified":"2023-12-06T06:14:33","modified_gmt":"2023-12-06T06:14:33","slug":"pilih-rentangnya","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/pilih-rentangnya\/","title":{"rendered":"Bagaimana cara memilih rentang di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3208590779\"><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>Saat Anda mulai mempelajari Excel, penting untuk mengetahui cara memilih rentang. Dalam tutorial ini, kita akan mempelajari berbagai metode untuk memilih rentang (sel tunggal, sel kontinu, dan sel non-kontinu) menggunakan mouse dan keyboard.<\/p><h2 class=\"wp-block-heading\"> Pilih satu sel<\/h2><p> Untuk memilih satu sel, Anda perlu mengklik sel yang ingin Anda pilih. Dan saat Anda memilih sel, alamat sel yang sama ditampilkan di kotak Nama. Mari kita lihat pada snapshot di bawah ini, kita pilih sel A2. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80034\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/gif-selectionner-une-seule-cellule.gif\" sizes=\"auto, \" srcset=\"\" alt=\"pilih satu sel\" width=\"548\" height=\"386\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Pilih rentang sel yang berdekatan<\/h2><p> Setelah memilih satu sel di Excel, mari lakukan langkah cepat untuk memilih beberapa sel. Misalkan Anda ingin memilih A1:B5:<\/p><ul><li> Pertama, tempatkan kursor Anda pada sel (A1).<\/li><li> Kemudian pilih dengan menekan tombol kiri mouse.<\/li><li> Dan sekarang seret kursor sambil menahan tombol mouse dari A1 ke B5. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80035\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/gif-plage-de-cellules-adjacentes.gif\" sizes=\"auto, \" srcset=\"\" alt=\"rentang sel yang berdekatan\" width=\"600\" height=\"361\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Pilih rentang sel yang tidak berdekatan<\/h2><p> Terkadang, saat Anda sedang bekerja, Anda perlu memilih beberapa sel non-kontinu di lembar kerja (seperti A4 hingga A7, B3 hingga B8, dan C2 hingga C5.)<\/p><ul><li> Klik pada sel pertama (A4) dan seret kursor ke A7.<\/li><li> Setelah itu, tahan tombol Kontrol dan pilih rentang berikutnya yang tidak berdekatan satu per satu.<\/li><li> Pada akhirnya, seluruh rentang sel yang dipilih akan disorot.<\/li><\/ul><p class=\"grey-note\"> Anda dapat menahan <kbd>tombol Ctrl<\/kbd> untuk memilih baris atau kolom yang tidak kontinu. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80036\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/gif-plage-de-cellules-non-adjacentes.gif\" sizes=\"auto, \" srcset=\"\" alt=\"rentang sel yang tidak berdekatan\" width=\"600\" height=\"358\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Pilih rentang sel dalam baris<\/h2><p> Untuk memilih rentang sel dalam satu baris, ikuti langkah-langkah di bawah ini:<\/p><ul><li> Pertama pilih baris di mana Anda ingin memilih beberapa sel.<\/li><li> Sekarang klik salah satu sel di baris ini.<\/li><li> Kemudian tempatkan kursor pada sel itu dan seret ke sel terakhir yang akan dipilih.<\/li><\/ul><p> Seperti pada contoh di bawah, kita telah memilih empat sel pertama dari baris 3. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80037\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/gif-plage-de-cellules-daffilee.gif\" sizes=\"auto, \" srcset=\"\" alt=\"rentang sel dalam satu baris\" width=\"568\" height=\"332\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Pilih rentang sel di kolom<\/h2><p> Anda juga dapat memilih grup sel dalam satu kolom untuk menerapkan fungsi apa pun dengan melakukan hal berikut:<\/p><ul><li> Pertama, pilih kolom di mana Anda ingin memilih rentang selnya.<\/li><li> Kemudian klik sel mana saja dan seret kursor ke sel terakhir.<\/li><\/ul><p> Mari kita ambil contoh kolom C, di mana kita telah memilih sel C3 hingga C10. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80038\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/gif-plage-de-cellules-dans-une-colonne.gif\" sizes=\"auto, \" srcset=\"\" alt=\"rentang sel dalam satu kolom\" width=\"568\" height=\"390\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Pilih semua sel di lembar kerja<\/h2><p> Di sini tugas umum untuk semua pengguna Excel adalah memilih semua sel di lembar kerja. Anda perlu mengklik segitiga kecil terbalik di sudut kiri atas, dan Anda akan melihat bahwa seluruh lembar dipilih. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80039\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/gif-selectionner-une-feuille-entiere-a-partir-du-triangle-superieur.gif\" sizes=\"auto, \" srcset=\"\" alt=\"pilih-keseluruhan-daun-dari-segitiga-atas\" width=\"600\" height=\"308\"><\/figure><\/div><p> Kemudian Anda juga bisa menggunakan tombol pintas untuk memilih sel di lembar kerja.<\/p><ul><li> Jika Anda memilih sel kosong tanpa data pada lembar, tekan dan tahan Control + A. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80040\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/gif-selectionner-toutes-les-cellules-ayant-des-cellules-vides.gif\" sizes=\"auto, \" srcset=\"\" alt=\"pilih-semua-sel-dengan-sel kosong\" width=\"582\" height=\"348\"><\/figure><\/div><ul><li> Dan saat Anda memilih sel yang berisi data atau nilai, Anda perlu menekan dan menahan Control + A + A (dua kali A) untuk memilih seluruh lembar; jika tidak, ia hanya akan memilih sel dengan data. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-80041\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/gif-selectionner-une-feuille-avec-des-donnees-dans-une-cellule.gif\" sizes=\"auto, \" srcset=\"\" alt=\"pilih-lembar-dengan-data-dalam-sel\" width=\"453\" height=\"235\"><\/figure><\/div><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 class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-1525","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 Bagaimana cara memilih rentang di Excel? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"Tutorial ini berfokus pada pemilihan rentang. Ini adalah hal penting untuk dipelajari bagi pengguna baru Excel.\" \/>\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\/pilih-rentangnya\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara memilih rentang di Excel? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"Tutorial ini berfokus pada pemilihan rentang. Ini adalah hal penting untuk dipelajari bagi pengguna baru Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/pilih-rentangnya\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:14:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/gif-selectionner-une-seule-cellule.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\/pilih-rentangnya\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/pilih-rentangnya\/\",\"name\":\"\u25b7 Bagaimana cara memilih rentang di Excel? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/pilih-rentangnya\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/pilih-rentangnya\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/gif-selectionner-une-seule-cellule.gif\",\"datePublished\":\"2023-11-17T23:12:54+00:00\",\"dateModified\":\"2023-12-06T06:14:33+00:00\",\"description\":\"Tutorial ini berfokus pada pemilihan rentang. Ini adalah hal penting untuk dipelajari bagi pengguna baru Excel.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/pilih-rentangnya\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/pilih-rentangnya\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/pilih-rentangnya\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/gif-selectionner-une-seule-cellule.gif\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/gif-selectionner-une-seule-cellule.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/pilih-rentangnya\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara memilih rentang 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":"\u25b7 Bagaimana cara memilih rentang di Excel? (Tutorial 2023)","description":"Tutorial ini berfokus pada pemilihan rentang. Ini adalah hal penting untuk dipelajari bagi pengguna baru Excel.","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\/pilih-rentangnya\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara memilih rentang di Excel? (Tutorial 2023)","og_description":"Tutorial ini berfokus pada pemilihan rentang. Ini adalah hal penting untuk dipelajari bagi pengguna baru Excel.","og_url":"https:\/\/exceladvisor.org\/id\/pilih-rentangnya\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:14:33+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/gif-selectionner-une-seule-cellule.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\/pilih-rentangnya\/","url":"https:\/\/exceladvisor.org\/id\/pilih-rentangnya\/","name":"\u25b7 Bagaimana cara memilih rentang di Excel? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/pilih-rentangnya\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/pilih-rentangnya\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/gif-selectionner-une-seule-cellule.gif","datePublished":"2023-11-17T23:12:54+00:00","dateModified":"2023-12-06T06:14:33+00:00","description":"Tutorial ini berfokus pada pemilihan rentang. Ini adalah hal penting untuk dipelajari bagi pengguna baru Excel.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/pilih-rentangnya\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/pilih-rentangnya\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/pilih-rentangnya\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/gif-selectionner-une-seule-cellule.gif","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/gif-selectionner-une-seule-cellule.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/pilih-rentangnya\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara memilih rentang 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\/1525","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=1525"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1525\/revisions"}],"predecessor-version":[{"id":2356,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1525\/revisions\/2356"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1525"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}