{"id":2172,"date":"2023-09-26T07:28:02","date_gmt":"2023-09-26T07:28:02","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/tampilkan-kolom\/"},"modified":"2023-12-06T06:20:38","modified_gmt":"2023-12-06T06:20:38","slug":"tampilkan-kolom","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/tampilkan-kolom\/","title":{"rendered":"Pintasan excel untuk menampilkan kolom"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2644162347\"><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, pengguna terkadang menyembunyikan kolom tertentu saat bekerja dengan data dan lupa menampilkan kolom tersebut sebelum membagikan file atau menyembunyikan kolom yang mereka anggap tidak relevan bagi penerima dan membagikan file dengan kolom tersembunyi dan penerima mendapatkan file dengan kolom tersembunyi .<\/p><p> Namun seringkali Anda ingin meninjau tampilan kolom dan untuk itu Anda tidak perlu khawatir karena Excel memiliki beberapa cara untuk menampilkan kolom secara manual atau menggunakan pintasan keyboard.<\/p><p> Dalam tutorial ini, kami telah menjelaskan tombol pintas untuk menampilkan kolom.<\/p><h2 class=\"wp-block-heading\"> Pintasan keyboard untuk memperlihatkan kolom di Excel<\/h2><p> Ada beberapa pintasan keyboard untuk menampilkan kolom, namun beberapa pintasan untuk menampilkan kolom tidak berfungsi untuk semua orang dan kita harus mengubah pengaturan Excel agar berfungsi, namun di sini kami hanya menangkap pintasan yang dapat digunakan untuk semua orang.<\/p><p> <kbd>Lainnya<\/kbd> \u2192 <kbd>O<\/kbd> \u2192 <kbd>C<\/kbd> \u2192 <kbd>U<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69491\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-la-colonne-a-laide-du-raccourci-clavier.png\" sizes=\"auto, \" srcset=\"\" alt=\"tampilkan-kolom-menggunakan-pintasan-keyboard\" width=\"837\" height=\"328\"><\/figure><\/div><p> <kbd>Alt<\/kbd> \u2192 <kbd>H<\/kbd> \u2192 <kbd>O<\/kbd> \u2192 <kbd>U<\/kbd> \u2192 <kbd>L<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69492\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-raccourci-clavier-pour-afficher-les-colonnes.png\" sizes=\"auto, \" srcset=\"\" alt=\"pintasan keyboard untuk menampilkan kolom\" width=\"837\" height=\"328\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Langkah-langkah Menampilkan Kolom Menggunakan Pintasan Keyboard<\/h2><ol><li> Pertama, tekan <kbd>Ctrl<\/kbd> + <kbd>A<\/kbd> + <kbd>A<\/kbd> untuk memilih seluruh lembar guna menampilkan semua kolom tersembunyi di seluruh lembar.<\/li><li> Atau pilih hanya rentang kolom tertentu menggunakan tombol panah Ctrl + Spasi dan Shift + &lt; atau &gt; jika Anda ingin menampilkan kolom hanya dari rentang kolom tertentu dan bukan seluruh lembar.<\/li><li> Setelah seluruh lembar atau rentang kolom tertentu dipilih, cukup tekan tombol pintas Alt \u2192 O \u2192 C \u2192 U atau Alt \u2192 H \u2192 O \u2192 U \u2192 L, dan kolom tersembunyi akan terlihat. <\/li><\/ol><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Tutorial lainnya <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-43\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/tambahkan-kolom-1\/\">Tambahkan kolom<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hapus-sel\/\">Hapus sel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/hapus-baris\/\">Hapus baris<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/mengedit-sel\/\">Sunting sel<\/a><\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/masukkan-sel\/\">Masukkan sel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/masukkan-garis\/\">Sisipkan \u2013 Tambahkan baris<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menggabungkan-sel-sel-yang-terdisosiasi-1\/\">Gabungkan-lepaskan sel<\/a><\/li><\/ul><\/div><\/div><p> \u21e0 Kembali ke <a href=\"https:\/\/exceladvisor.org\/id\/pintasan-keyboard\/\">pintasan Excel (lembar contekan PDF)<\/a><\/p><\/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-2172","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>Shortcut Excel untuk Menampilkan Kolom (Terbaru 2023)<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk melihat kolom di Excel. Sekarang jalan pintas ini\" \/>\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\/tampilkan-kolom\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Shortcut Excel untuk Menampilkan Kolom (Terbaru 2023)\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk melihat kolom di Excel. Sekarang jalan pintas ini\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/tampilkan-kolom\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:20:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-la-colonne-a-laide-du-raccourci-clavier.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\/tampilkan-kolom\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/tampilkan-kolom\/\",\"name\":\"Shortcut Excel untuk Menampilkan Kolom (Terbaru 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tampilkan-kolom\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tampilkan-kolom\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-la-colonne-a-laide-du-raccourci-clavier.png\",\"datePublished\":\"2023-09-26T07:28:02+00:00\",\"dateModified\":\"2023-12-06T06:20:38+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk melihat kolom di Excel. Sekarang jalan pintas ini\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/tampilkan-kolom\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/tampilkan-kolom\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tampilkan-kolom\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-la-colonne-a-laide-du-raccourci-clavier.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-la-colonne-a-laide-du-raccourci-clavier.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/tampilkan-kolom\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pintasan excel untuk menampilkan kolom\"}]},{\"@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":"Shortcut Excel untuk Menampilkan Kolom (Terbaru 2023)","description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk melihat kolom di Excel. Sekarang jalan pintas ini","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\/tampilkan-kolom\/","og_locale":"id_ID","og_type":"article","og_title":"Shortcut Excel untuk Menampilkan Kolom (Terbaru 2023)","og_description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk melihat kolom di Excel. Sekarang jalan pintas ini","og_url":"https:\/\/exceladvisor.org\/id\/tampilkan-kolom\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:20:38+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-la-colonne-a-laide-du-raccourci-clavier.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\/tampilkan-kolom\/","url":"https:\/\/exceladvisor.org\/id\/tampilkan-kolom\/","name":"Shortcut Excel untuk Menampilkan Kolom (Terbaru 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/tampilkan-kolom\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/tampilkan-kolom\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-la-colonne-a-laide-du-raccourci-clavier.png","datePublished":"2023-09-26T07:28:02+00:00","dateModified":"2023-12-06T06:20:38+00:00","description":"Dalam tutorial ini, Anda akan mempelajari cara menggunakan pintasan keyboard untuk melihat kolom di Excel. Sekarang jalan pintas ini","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/tampilkan-kolom\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/tampilkan-kolom\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/tampilkan-kolom\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-la-colonne-a-laide-du-raccourci-clavier.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-afficher-la-colonne-a-laide-du-raccourci-clavier.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/tampilkan-kolom\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pintasan excel untuk menampilkan kolom"}]},{"@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\/2172","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=2172"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2172\/revisions"}],"predecessor-version":[{"id":2931,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2172\/revisions\/2931"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}