{"id":2095,"date":"2023-10-18T04:39:54","date_gmt":"2023-10-18T04:39:54","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/kolom-2\/"},"modified":"2023-12-06T06:12:41","modified_gmt":"2023-12-06T06:12:41","slug":"kolom-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/kolom-2\/","title":{"rendered":"Apa itu kolom di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-4154360491\"><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>Kolom di Excel adalah perataan sel secara vertikal. Setiap kolom memiliki alamat uniknya sendiri, yang diberi label seperti alfabet (dari A hingga XFD). Dan ada lebih dari satu juta sel dalam satu kolom dan total ada 16384 kolom yang Anda miliki dalam satu lembar kerja. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77894\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-faisant-reference-a-la-communaute.png\" sizes=\"auto, \" srcset=\"\" alt=\"referensi ke kolom\" width=\"641\" height=\"469\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Pilih kolom<\/h2><p> Untuk memilih kolom, Anda hanya perlu mengklik header kolom tempat Anda memiliki alfabet kolom, dan itu akan memilih seluruh kolom dari sel pertama hingga terakhir. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77895\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-se-referant-a-une-seule-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"mengacu pada satu kolom\" width=\"478\" height=\"296\"><\/figure><\/div><p> Cara lain untuk memilih seluruh kolom adalah dengan menggunakan pintasan keyboard. Setelah Anda memilih salah satu sel di kolom yang ingin Anda pilih, tekan dan tahan tombol kontrol, lalu tekan bilah spasi. Ini akan memilih seluruh kolom.<\/p><p> <em><strong>Terkait:<\/strong><\/em><mark class=\"has-inline-color\" style=\"background-color: #eafaeb;\"> <strong><em><a href=\"https:\/\/exceladvisor.org\/id\/pintasan-keyboard\/\">Pintasan keyboard untuk Excel (lembar contekan PDF)<\/a><\/em><\/strong><\/mark><\/p><h2 class=\"wp-block-heading\"> Referensi kolom di Excel<\/h2><p> Seperti yang saya katakan dan Anda juga dapat melihat pada cuplikan di atas bahwa setiap kolom memiliki nama uniknya sendiri, yang terdiri dari alfabet. Sekarang, untuk merujuk ke suatu kolom, Anda harus menggunakan namanya. Jika Anda ingin merujuk ke kolom A, Anda harus menggunakan alamatnya sebagai A:A. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77896\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-se-referant-a-une-colonne-en-utilisant-ladresse.png\" sizes=\"auto, \" srcset=\"\" alt=\"referensi-ke-kolom-menggunakan-alamat\" width=\"502\" height=\"480\"><\/figure><\/div><p> Pada contoh di atas, Anda dapat melihat bahwa kita merujuk ke kolom A menggunakan alamatnya di fungsi penjumlahan. Sekarang, jika Anda ingin mereferensikan beberapa kolom, Anda bisa menggunakan alamat yang mereferensikan beberapa kolom. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77897\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-faisant-reference-a-plusieurs-colonnes-adjacentes.png\" sizes=\"auto, \" srcset=\"\" alt=\"mengacu pada beberapa kolom yang berdekatan\" width=\"517\" height=\"501\"><\/figure><\/div><p> Sekarang pada contoh di atas kita mengacu pada empat kolom dari A ke D dan pada alamatnya kita menggunakan A:D yang artinya dari kolom A ke kolom D. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77898\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-se-referant-a-deux-colonnes-non-continues.png\" sizes=\"auto, \" srcset=\"\" alt=\"referensi dua kolom non-kontinyu\" width=\"642\" height=\"463\"><\/figure><\/div><p> Dan pada contoh di atas, kami mengacu pada dua kolom yang tidak bersambung dan kami menggunakannya menggunakan alamatnya secara terpisah menggunakan koma di antaranya.<\/p><h2 class=\"wp-block-heading\"> Apa kolom terakhir di Excel<\/h2><p> Kolom terakhir di Excel adalah kolom XFD. Dalam satu spreadsheet, ada 16384 kolom. Jumlah ini tetap, Anda tidak dapat menambahkan lebih banyak kolom ke satu lembar kerja dan jika Anda ingin menambahkan lebih banyak data, Anda perlu <a href=\"https:\/\/exceladvisor.org\/id\/menambahkan\/\" data-wpil=\"url\">memasukkan lembar kerja baru<\/a> yang juga memiliki 16384 kolom. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77899\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-total-16384-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"total-16384-kolom\" width=\"359\" height=\"209\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Bisakah saya menjadikan nama kolom sebagai nomor?<\/h2><p> Ya, Anda dapat memiliki nama kolom sebagai angka, bukan alfabet. Untuk melakukan ini, Anda perlu mengubah gaya referensi ke R1C1. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77900\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-nom-de-colonne-sous-forme-de-nombre.png\" sizes=\"auto, \" srcset=\"\" alt=\"kolom-nama-sebagai-nomor\" width=\"451\" height=\"266\"><\/figure><\/div><p> Dengan R1C1, Anda dapat mengubah referensi kolom, memungkinkan Anda merujuk ke kolom menggunakan nomor. Untuk melakukan ini, buka tab File \u279c <a href=\"https:\/\/exceladvisor.org\/id\/pilihan\/\">Opsi<\/a> \u279c Bekerja dengan rumus. Kemudian centang \u201cGaya referensi R1C1\u201d. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-77901\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-changer-la-reference-de-la-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"ubah-kolom-referensi\" width=\"580\" height=\"448\"><\/figure><\/div><p> Tapi sebelum melanjutkan ke yang satu ini <a href=\"https:\/\/exceladvisor.org\/id\/r1c1\/\">, pastikan untuk membaca tentang hal itu<\/a> .<\/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-50067b57\"><div class=\"gb-container gb-container-50067b57\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/baris-2\/\">Baris di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menunjukkan-garis\/\">Tampilkan baris di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/jangkauan\/\">Rentang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pilih-rentangnya\/\">Pilih rentang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sel-aktif\/\">Aktifkan sel 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-2095","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>Apa itu kolom di Excel? \u2013 Penasihat Excel<\/title>\n<meta name=\"description\" content=\"Jika Anda baru mulai belajar Excel, tutorial ini akan membantu Anda memahami beberapa hal penting tentang kolom...\" \/>\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\/kolom-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Apa itu kolom di Excel? \u2013 Penasihat Excel\" \/>\n<meta property=\"og:description\" content=\"Jika Anda baru mulai belajar Excel, tutorial ini akan membantu Anda memahami beberapa hal penting tentang kolom...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/kolom-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:12:41+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-faisant-reference-a-la-communaute.png\" \/>\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\/kolom-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/kolom-2\/\",\"name\":\"Apa itu kolom di Excel? \u2013 Penasihat Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kolom-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kolom-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-faisant-reference-a-la-communaute.png\",\"datePublished\":\"2023-10-18T04:39:54+00:00\",\"dateModified\":\"2023-12-06T06:12:41+00:00\",\"description\":\"Jika Anda baru mulai belajar Excel, tutorial ini akan membantu Anda memahami beberapa hal penting tentang kolom...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/kolom-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/kolom-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kolom-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-faisant-reference-a-la-communaute.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-faisant-reference-a-la-communaute.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/kolom-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Apa itu kolom 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":"Apa itu kolom di Excel? \u2013 Penasihat Excel","description":"Jika Anda baru mulai belajar Excel, tutorial ini akan membantu Anda memahami beberapa hal penting tentang kolom...","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\/kolom-2\/","og_locale":"id_ID","og_type":"article","og_title":"Apa itu kolom di Excel? \u2013 Penasihat Excel","og_description":"Jika Anda baru mulai belajar Excel, tutorial ini akan membantu Anda memahami beberapa hal penting tentang kolom...","og_url":"https:\/\/exceladvisor.org\/id\/kolom-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:12:41+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-faisant-reference-a-la-communaute.png","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\/kolom-2\/","url":"https:\/\/exceladvisor.org\/id\/kolom-2\/","name":"Apa itu kolom di Excel? \u2013 Penasihat Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/kolom-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/kolom-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-faisant-reference-a-la-communaute.png","datePublished":"2023-10-18T04:39:54+00:00","dateModified":"2023-12-06T06:12:41+00:00","description":"Jika Anda baru mulai belajar Excel, tutorial ini akan membantu Anda memahami beberapa hal penting tentang kolom...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/kolom-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/kolom-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/kolom-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-faisant-reference-a-la-communaute.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-faisant-reference-a-la-communaute.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/kolom-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Apa itu kolom 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\/2095","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=2095"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2095\/revisions"}],"predecessor-version":[{"id":2240,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2095\/revisions\/2240"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2095"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}