{"id":1911,"date":"2023-10-29T04:55:26","date_gmt":"2023-10-29T04:55:26","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/nomor-kolom\/"},"modified":"2023-12-06T06:18:12","modified_gmt":"2023-12-06T06:18:12","slug":"nomor-kolom","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/nomor-kolom\/","title":{"rendered":"Bagaimana cara mengubah huruf kolom menjadi angka?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3967146247\"><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>Di Excel, kolom memiliki huruf sebagai identitasnya, namun Anda bisa menggantinya dengan angka. Artinya untuk kolom A, Anda bisa menggunakan kolom 1. Dalam tutorial ini, kita akan mempelajari dua cara berbeda yang bisa Anda gunakan.<\/p><ul><li> Buat baris header dengan nomor kolom<\/li><li> Ubah referensi sel ke R1C1 untuk meminta nomor kolom <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-74845\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-les-numeros-de-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"gunakan-nomor-kolom\" width=\"531\" height=\"306\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Ubah Abjad Kolom menjadi Angka (R1C1)<\/h2><ol><li> Pertama, klik pada tab File. <br><img loading=\"lazy\" decoding=\"async\" title=\"file tab 2\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-onglet-fichier.png\" sizes=\"auto, \" srcset=\"\" alt=\"file-tab\" width=\"486\" height=\"235\"><\/li><li> Setelah itu, buka \u201cOpsi\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"3 pilihan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-allez-dans-les-options.png\" sizes=\"auto, \" srcset=\"\" alt=\"go-to-options\" width=\"266\" height=\"236\"><\/li><li> Selanjutnya, klik \u201cFormula\u201d dan dari sana centang \u201cGaya Referensi R1C1\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-centang-r1c1-gaya referensi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-cochez-le-style-de-reference-r1c1.png\" sizes=\"auto, \" srcset=\"\" alt=\"tick-r1c1-reference-style\" width=\"500\" height=\"315\"><\/li><li> Pada akhirnya, klik OK untuk menerapkan pengaturan. <br><img loading=\"lazy\" decoding=\"async\" title=\"5 pengaturan aplikasi\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-appliquer-les-parametres.png\" sizes=\"auto, \" srcset=\"\" alt=\"apply-settings\" width=\"378\" height=\"213\"><\/li><\/ol><p> Saat Anda melakukan ini, ini akan mengubah gaya referensi untuk seluruh aplikasi Excel. Artinya, Anda sekarang harus merujuk ke kolom menggunakan angka, bukan alfabet. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-74850\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-styles-de-reference-pour-toute-lapplication-Excel.png\" sizes=\"auto, \" srcset=\"\" alt=\"gaya-referensi-untuk-seluruh-aplikasi-excel\" width=\"456\" height=\"134\"><\/figure><\/div><p> Anda lihat pada contoh di atas di mana saya mengacu pada sel A1, ini menunjukkan R[-1]C[-2] bukan A1. Artinya, yang Anda maksud adalah baris dan dua kolom di belakangnya.<\/p><p> <em>Anda dapat mempelajarinya lebih lanjut dengan panduan komprehensif tentang <a href=\"https:\/\/exceladvisor.org\/id\/r1c1\/\">gaya referensi R1C1<\/a> ini.<\/em><\/p><h2 class=\"wp-block-heading\"> Buat header dengan nomor kolom<\/h2><p> Metode ini dapat digunakan dalam situasi yang berbeda, namun sama efektifnya dengan yang pertama.<\/p><ol><li> Pertama, <a href=\"https:\/\/exceladvisor.org\/id\/mengedit-sel\/\">edit sel<\/a> A1 dan masukkan \u201c=COLUMN()\u201d di dalamnya. <br><img loading=\"lazy\" decoding=\"async\" title=\"7-header-dengan-nomor-kolom\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-en-tete-avec-numeros-de-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"header-with-column-numbers\" width=\"544\" height=\"114\"><\/li><li> Setelah itu tekan Enter untuk mendapatkan nomor kolom saat ini. <br><img loading=\"lazy\" decoding=\"async\" title=\"8-dapatkan-nomor-kolom-saat ini\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-obtenir-le-numero-de-la-colonne-en-cours.png\" sizes=\"auto, \" srcset=\"\" alt=\"get-the-number-of-current-column\" width=\"544\" height=\"114\"><\/li><li> Sekarang gunakan gagang isian dan <a href=\"https:\/\/exceladvisor.org\/id\/meluncur-ke-bawah\/\">perluas rumus ke kolom di<\/a> mana Anda ingin memiliki nomor kolom. <br><img loading=\"lazy\" decoding=\"async\" title=\"Pengisi Formula 9 Pegangan untuk Memperluas\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-poignee-de-remplissage-pour-etendre-la-formule.png\" sizes=\"auto, \" srcset=\"\" alt=\"fill-handle-to-extend-formula\" width=\"545\" height=\"144\"><\/li><li> Pada akhirnya, Anda dapat mengubah semua rumus ini menjadi nilai menggunakan pintasan keyboard ( <a href=\"https:\/\/exceladvisor.org\/id\/salin-tempel\/\">Ctrl + C untuk menyalin<\/a> lalu tekan Alt \u2192 H \u2192 V \u2192 V untuk <a href=\"https:\/\/exceladvisor.org\/id\/tempel-nilai\/\">menempelkan nilainya<\/a> ).<\/li><\/ol><p> Metode ini bekerja paling baik ketika Anda tidak ingin mengubah referensi sel, tetapi hanya nomor kolomnya saja.<\/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\/unggul-terlebih-dahulu\/\">Tutorial Excel Tingkat Lanjut<\/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\/alat-analisis-cepat\/\">Alat Analisis Cepat di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menerapkan-beberapa-filter\/\">Terapkan beberapa filter ke kolom<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/sorot-nilai-atas-bawah\/\">Sorot nilai N atas dan bawah di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/kotak-centang\/\">Sisipkan kotak centang di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-sel-tanpa-kehilangan-data\/\">Gabungkan sel tanpa kehilangan data 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-1911","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 mengubah huruf kolom menjadi angka?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, kita akan mempelajari dua cara berbeda untuk mengubah huruf kolom menjadi angka sebagai header.\" \/>\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\/nomor-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Bagaimana cara mengubah huruf kolom menjadi angka?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, kita akan mempelajari dua cara berbeda untuk mengubah huruf kolom menjadi angka sebagai header.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/nomor-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:18:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-les-numeros-de-colonne.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=\"1 menit\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/id\/nomor-kolom\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/nomor-kolom\/\",\"name\":\"\u25b7 Bagaimana cara mengubah huruf kolom menjadi angka?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/nomor-kolom\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/nomor-kolom\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-les-numeros-de-colonne.png\",\"datePublished\":\"2023-10-29T04:55:26+00:00\",\"dateModified\":\"2023-12-06T06:18:12+00:00\",\"description\":\"Dalam tutorial ini, kita akan mempelajari dua cara berbeda untuk mengubah huruf kolom menjadi angka sebagai header.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/nomor-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/nomor-kolom\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/nomor-kolom\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-les-numeros-de-colonne.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-les-numeros-de-colonne.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/nomor-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara mengubah huruf kolom menjadi angka?\"}]},{\"@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 mengubah huruf kolom menjadi angka?","description":"Dalam tutorial ini, kita akan mempelajari dua cara berbeda untuk mengubah huruf kolom menjadi angka sebagai header.","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\/nomor-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"\u25b7 Bagaimana cara mengubah huruf kolom menjadi angka?","og_description":"Dalam tutorial ini, kita akan mempelajari dua cara berbeda untuk mengubah huruf kolom menjadi angka sebagai header.","og_url":"https:\/\/exceladvisor.org\/id\/nomor-kolom\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:18:12+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-les-numeros-de-colonne.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Estimasi waktu membaca":"1 menit"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/id\/nomor-kolom\/","url":"https:\/\/exceladvisor.org\/id\/nomor-kolom\/","name":"\u25b7 Bagaimana cara mengubah huruf kolom menjadi angka?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/nomor-kolom\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/nomor-kolom\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-les-numeros-de-colonne.png","datePublished":"2023-10-29T04:55:26+00:00","dateModified":"2023-12-06T06:18:12+00:00","description":"Dalam tutorial ini, kita akan mempelajari dua cara berbeda untuk mengubah huruf kolom menjadi angka sebagai header.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/nomor-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/nomor-kolom\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/nomor-kolom\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-les-numeros-de-colonne.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-utiliser-les-numeros-de-colonne.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/nomor-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara mengubah huruf kolom menjadi angka?"}]},{"@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\/1911","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=1911"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1911\/revisions"}],"predecessor-version":[{"id":2695,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1911\/revisions\/2695"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1911"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}