{"id":1584,"date":"2023-11-16T09:04:35","date_gmt":"2023-11-16T09:04:35","guid":{"rendered":"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-2\/"},"modified":"2023-12-06T06:12:56","modified_gmt":"2023-12-06T06:12:56","slug":"jumlah-otomatis-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-2\/","title":{"rendered":"Bagaimana cara melakukan penjumlahan otomatis di excel?"},"content":{"rendered":"<div class=\"excel-before-content\" id=\"excel-3281755318\"><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>Untuk melakukan penjumlahan otomatis di Excel untuk nilai yang Anda miliki di sel di atas sel aktif atau nilai di sel kiri, Anda dapat menggunakan tombol pintas <kbd>Alt<\/kbd> + <kbd>=<\/kbd> . Saat Anda menekan tombol pintasan ini, fungsi penjumlahan akan dimasukkan ke dalam sel aktif dengan mengacu pada rentang di atas atau di kiri. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62308\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-automatique.png\" sizes=\"auto, \" srcset=\"\" alt=\"jumlah otomatis\" width=\"302\" height=\"460\"><\/figure><\/div><p> <kbd>alternatif<\/kbd> + <kbd>=<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62315\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-raccourcis-de-somme-automatique.png\" sizes=\"auto, \" srcset=\"\" alt=\"pintasan autosum\" width=\"896\" height=\"207\"><\/figure><\/div><p> Sekarang, seperti yang saya katakan, Anda juga dapat memasukkan autosum untuk nilai-nilai yang kita miliki di sisi kiri. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-62322\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-valeurs-dinsertion-et-de-somme-automatique.png\" sizes=\"auto, \" srcset=\"\" alt=\"masukkan dan nilai autosum\" width=\"614\" height=\"128\"><\/figure><\/div><p> Tetapi jika Anda memiliki nilai di sisi kiri dan di atas sel aktif, maka penjumlahan otomatis akan dimasukkan lebih jauh pada nilai tersebut. Ada satu hal lagi ketika Anda menekan hotkey, itu akan memasukkan fungsinya, tetapi Anda harus menekan enter untuk mendapatkan hasilnya. <\/p><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Lebih banyak jalan pintas <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-29\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/menyaring-1\/\">Terapkan dan hapus filter<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/konten-yang-jelas\/\">Hapus konten<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menunjukkan-rumus\/\">Tampilkan rumus<\/a><\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/id\/meluncur-ke-bawah\/\">Geser ke bawah<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/id\/menghapus\/\">MENGHAPUS<\/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-1584","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>Bagaimana cara melakukan penjumlahan otomatis di Excel?<\/title>\n<meta name=\"description\" content=\"Dalam tutorial ini, Anda akan mempelajari tombol pintasan keyboard untuk menerapkan autosum guna mendapatkan nilai penjumlahan\" \/>\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\/jumlah-otomatis-2\/\" \/>\n<meta property=\"og:locale\" content=\"id_ID\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Bagaimana cara melakukan penjumlahan otomatis di Excel?\" \/>\n<meta property=\"og:description\" content=\"Dalam tutorial ini, Anda akan mempelajari tombol pintasan keyboard untuk menerapkan autosum guna mendapatkan nilai penjumlahan\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T06:12:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-automatique.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\/jumlah-otomatis-2\/\",\"url\":\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-2\/\",\"name\":\"Bagaimana cara melakukan penjumlahan otomatis di Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-2\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-automatique.png\",\"datePublished\":\"2023-11-16T09:04:35+00:00\",\"dateModified\":\"2023-12-06T06:12:56+00:00\",\"description\":\"Dalam tutorial ini, Anda akan mempelajari tombol pintasan keyboard untuk menerapkan autosum guna mendapatkan nilai penjumlahan\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-2\/#breadcrumb\"},\"inLanguage\":\"id\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"id\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-2\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-automatique.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-automatique.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Rumah\",\"item\":\"https:\/\/exceladvisor.org\/id\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Bagaimana cara melakukan penjumlahan otomatis 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":"Bagaimana cara melakukan penjumlahan otomatis di Excel?","description":"Dalam tutorial ini, Anda akan mempelajari tombol pintasan keyboard untuk menerapkan autosum guna mendapatkan nilai penjumlahan","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\/jumlah-otomatis-2\/","og_locale":"id_ID","og_type":"article","og_title":"Bagaimana cara melakukan penjumlahan otomatis di Excel?","og_description":"Dalam tutorial ini, Anda akan mempelajari tombol pintasan keyboard untuk menerapkan autosum guna mendapatkan nilai penjumlahan","og_url":"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T06:12:56+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-automatique.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\/jumlah-otomatis-2\/","url":"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-2\/","name":"Bagaimana cara melakukan penjumlahan otomatis di Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/id\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-2\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-automatique.png","datePublished":"2023-11-16T09:04:35+00:00","dateModified":"2023-12-06T06:12:56+00:00","description":"Dalam tutorial ini, Anda akan mempelajari tombol pintasan keyboard untuk menerapkan autosum guna mendapatkan nilai penjumlahan","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-2\/#breadcrumb"},"inLanguage":"id","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/id\/jumlah-otomatis-2\/"]}]},{"@type":"ImageObject","inLanguage":"id","@id":"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-2\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-automatique.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-somme-automatique.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/id\/jumlah-otomatis-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Rumah","item":"https:\/\/exceladvisor.org\/id\/"},{"@type":"ListItem","position":2,"name":"Bagaimana cara melakukan penjumlahan otomatis 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\/1584","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=1584"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1584\/revisions"}],"predecessor-version":[{"id":2256,"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/pages\/1584\/revisions\/2256"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/id\/wp-json\/wp\/v2\/media?parent=1584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}