{"id":2096,"date":"2023-10-18T03:07:27","date_gmt":"2023-10-18T03:07:27","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/pintasan-keyboard-1\/"},"modified":"2023-12-06T06:20:42","modified_gmt":"2023-12-06T06:20:42","slug":"pintasan-keyboard-1","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/pintasan-keyboard-1\/","title":{"rendered":"Pintasan keyboard tabel pivot di excel"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-2140326041\"><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>Kita semua menyukai pintasan keyboard. BENAR? Di sini saya telah membuat daftar beberapa pintasan keyboard <a href=\"https:\/\/exceladvisor.org\/id\/pintasan-keyboard\/\">yang umum namun berguna<\/a> yang dapat Anda gunakan untuk mempercepat pekerjaan tabel pivot Anda.<\/p><h2 class=\"wp-block-heading\"> 1. Buat tabel pivot<\/h2><p> <strong>Alt+N+V<\/strong><\/p><p> Untuk menggunakan tombol pintas ini, pastikan Anda telah memilih data sumber atau sel yang aktif berasal dari data sumber. Dan jika Anda menggunakan Excel versi 2007, Anda bisa menggunakan Alt+N+V+T.<\/p><h2 class=\"wp-block-heading\"> 2. Mengelompokkan\/membatalkan pengelompokan item tabel pivot yang dipilih<\/h2><p> <strong>Alt + Shift + Panah Kanan<\/strong><\/p><p> Katakanlah Anda memiliki tabel pivot dengan bulan dan Anda ingin mengelompokkan enam bulan pertama atau enam bulan terakhir. Yang harus Anda lakukan adalah memilih enam sel ini dan cukup gunakan tombol pintas ini.<\/p><p> <strong>Alt + Shift + Panah Kiri<\/strong><\/p><p> Sama seperti Anda dapat membuat grup item, pintasan ini membantu Anda memisahkan item tersebut dari grup.<\/p><h2 class=\"wp-block-heading\"> 3. Sembunyikan item atau kolom yang dipilih<\/h2><p> <strong>Ctrl + \u2013<\/strong><\/p><p> Tombol pintas ini hanya akan menyembunyikan sel yang dipilih. Ini sebenarnya tidak menyembunyikan sel tetapi memfilternya, yang kemudian dapat Anda hapus dari opsi filter.<\/p><h2 class=\"wp-block-heading\"> 4. Buka jendela Bidang Terhitung<\/h2><p> <strong>Alt + D dan P<\/strong><\/p><p> Dalam pintasan keyboard ini, Anda harus menekan tombol setelahnya.<\/p><h2 class=\"wp-block-heading\"> 5. Buka daftar kolom untuk sel aktif<\/h2><p> <strong>Alt + panah bawah<\/strong><\/p><p> Kunci ini membuka daftar bidang.<\/p><h2 class=\"wp-block-heading\"> (Bonus) Sisipkan PivotChart dari PivotTable<\/h2><p> <strong>Alt+F1<\/strong><\/p><p> Untuk menggunakan pintasan keyboard ini, Anda harus memilih sel di tabel pivot. Kunci ini menyisipkan tabel pivot ke dalam lembar yang ada. <\/p><div class=\"wp-block-group main-page-bottom is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Pelajari lebih lanjut tentang tabel pivot<\/h2><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/hapus-tabel-pivot\/\">Hapus PivotTable di Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/memindahkan-tabel-pivot\/\">Pindahkan tabel pivot<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/pivot-dari-beberapa-lembar-kerja\/\" data-wpil=\"url\">Tabel pivot dari beberapa lembar kerja<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/tabel-pivot-2\/\" data-wpil=\"url\">Tabel Pivot di Excel<\/a><\/li><\/ul><\/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-2096","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>Pintasan Keyboard Tabel Pivot di Excel<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda bisa mempelajari pintasan keyboard yang bisa Anda gunakan dengan tabel pivot.\" \/>\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\/pintasan-keyboard-1\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Pintasan Keyboard Tabel Pivot di Excel\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda bisa mempelajari pintasan keyboard yang bisa Anda gunakan dengan tabel pivot.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/pintasan-keyboard-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:20:42+00:00\" \/>\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\/pintasan-keyboard-1\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/pintasan-keyboard-1\/\",\"name\":\"Pintasan Keyboard Tabel Pivot di Excel\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"datePublished\":\"2023-10-18T03:07:27+00:00\",\"dateModified\":\"2023-12-06T06:20:42+00:00\",\"description\":\"Dalam tutorial ini, Anda bisa mempelajari pintasan keyboard yang bisa Anda gunakan dengan tabel pivot.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/pintasan-keyboard-1\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/pintasan-keyboard-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/pintasan-keyboard-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Pintasan keyboard tabel pivot 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":"Pintasan Keyboard Tabel Pivot di Excel","description":"Dalam tutorial ini, Anda bisa mempelajari pintasan keyboard yang bisa Anda gunakan dengan tabel pivot.","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\/pintasan-keyboard-1\/","og_locale":"id_ID","og_type":"article","og_title":"Pintasan Keyboard Tabel Pivot di Excel","og_description":"Dalam tutorial ini, Anda bisa mempelajari pintasan keyboard yang bisa Anda gunakan dengan tabel pivot.","og_url":"https:\/\/exceladvisor.org\/id\/pintasan-keyboard-1\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:20:42+00:00","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\/pintasan-keyboard-1\/","url":"https:\/\/exceladvisor.org\/id\/pintasan-keyboard-1\/","name":"Pintasan Keyboard Tabel Pivot di Excel","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"datePublished":"2023-10-18T03:07:27+00:00","dateModified":"2023-12-06T06:20:42+00:00","description":"Dalam tutorial ini, Anda bisa mempelajari pintasan keyboard yang bisa Anda gunakan dengan tabel pivot.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/pintasan-keyboard-1\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/pintasan-keyboard-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/pintasan-keyboard-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Pintasan keyboard tabel pivot 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\/2096","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=2096"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2096\/revisions"}],"predecessor-version":[{"id":2935,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/2096\/revisions\/2935"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=2096"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}