{"id":1582,"date":"2023-11-16T09:04:35","date_gmt":"2023-11-16T09:04:35","guid":{"rendered":"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-2\/"},"modified":"2023-12-10T06:01:58","modified_gmt":"2023-12-10T06:01:58","slug":"otomatik-toplam-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-2\/","title":{"rendered":"Excel&#39;de otomatik toplama nas\u0131l yap\u0131l\u0131r?"},"content":{"rendered":"<div class=\"excel-icerikten-once\" id=\"excel-2680607544\"><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>Aktif h\u00fccrenin \u00fcst\u00fcndeki h\u00fccrelerde bulunan de\u011ferler veya soldaki h\u00fccrelerde bulunan de\u011ferler i\u00e7in Excel&#8217;de otomatik toplama i\u015flemi ger\u00e7ekle\u015ftirmek i\u00e7in <kbd>Alt<\/kbd> + <kbd>=<\/kbd> k\u0131sayol tu\u015funu kullanabilirsiniz. Bu k\u0131sayol tu\u015funa bast\u0131\u011f\u0131n\u0131zda, yukar\u0131daki veya soldaki aral\u0131\u011fa ba\u015fvurarak toplam i\u015flevini aktif h\u00fccreye ekler. <\/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=\"otomatik toplam\" width=\"302\" height=\"460\"><\/figure><\/div><p> <kbd>Alt<\/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=\"otomatik toplama k\u0131sayolu\" width=\"896\" height=\"207\"><\/figure><\/div><p> Art\u0131k dedi\u011fim gibi sol tarafta sahip oldu\u011fumuz de\u011ferler i\u00e7in de otomatik toplam ekleyebilirsiniz. <\/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=\"de\u011ferleri ekleme ve otomatik toplama\" width=\"614\" height=\"128\"><\/figure><\/div><p> Ancak aktif h\u00fccrenin \u00fcst\u00fcnde ve solunda de\u011ferleriniz varsa de\u011ferlerin \u00fczerine otomatik bir toplam ekleyecektir. K\u0131sayol tu\u015funa bast\u0131\u011f\u0131n\u0131zda bir \u015fey daha var, i\u015flevi ekliyor, ancak sonucu almak i\u00e7in enter tu\u015funa basman\u0131z gerekiyor. <\/p><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Daha fazla k\u0131sayol <\/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\/tr\/filtre-1\/\">Filtreyi uygula ve kald\u0131r<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/icerigi-temizle\/\">\u0130\u00e7eri\u011fi temizle<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/formulleri-goster\/\">Form\u00fclleri g\u00f6ster<\/a><\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/tr\/kayip-dusmek\/\">A\u015fag\u0131 kayd\u0131r<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/tr\/silmek\/\">S\u0130LMEK<\/a><\/li><\/ul><\/div><\/div><p> \u21e0 <a href=\"https:\/\/exceladvisor.org\/tr\/klavye-kisayollari\/\">Excel k\u0131sayollar\u0131na geri d\u00f6n\u00fcn (PDF kopya sayfas\u0131)<\/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-1582","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>Excel&#039;de otomatik toplama nas\u0131l yap\u0131l\u0131r?<\/title>\n<meta name=\"description\" content=\"Bu e\u011fitimde, toplam de\u011ferlerini almak amac\u0131yla otomatik toplam\u0131 uygulamak i\u00e7in klavye k\u0131sayol tu\u015funu \u00f6\u011freneceksiniz.\" \/>\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\/tr\/otomatik-toplam-2\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel&#039;de otomatik toplama nas\u0131l yap\u0131l\u0131r?\" \/>\n<meta property=\"og:description\" content=\"Bu e\u011fitimde, toplam de\u011ferlerini almak amac\u0131yla otomatik toplam\u0131 uygulamak i\u00e7in klavye k\u0131sayol tu\u015funu \u00f6\u011freneceksiniz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-10T06:01:58+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=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-2\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-2\/\",\"name\":\"Excel&#39;de otomatik toplama nas\u0131l yap\u0131l\u0131r?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-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-10T06:01:58+00:00\",\"description\":\"Bu e\u011fitimde, toplam de\u011ferlerini almak amac\u0131yla otomatik toplam\u0131 uygulamak i\u00e7in klavye k\u0131sayol tu\u015funu \u00f6\u011freneceksiniz.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-2\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-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\/tr\/otomatik-toplam-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Ev\",\"item\":\"https:\/\/exceladvisor.org\/tr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel&#39;de otomatik toplama nas\u0131l yap\u0131l\u0131r?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#website\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"name\":\"Excel Advisor\",\"description\":\"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/tr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel&#39;de otomatik toplama nas\u0131l yap\u0131l\u0131r?","description":"Bu e\u011fitimde, toplam de\u011ferlerini almak amac\u0131yla otomatik toplam\u0131 uygulamak i\u00e7in klavye k\u0131sayol tu\u015funu \u00f6\u011freneceksiniz.","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\/tr\/otomatik-toplam-2\/","og_locale":"tr_TR","og_type":"article","og_title":"Excel&#39;de otomatik toplama nas\u0131l yap\u0131l\u0131r?","og_description":"Bu e\u011fitimde, toplam de\u011ferlerini almak amac\u0131yla otomatik toplam\u0131 uygulamak i\u00e7in klavye k\u0131sayol tu\u015funu \u00f6\u011freneceksiniz.","og_url":"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-10T06:01:58+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":{"Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-2\/","url":"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-2\/","name":"Excel&#39;de otomatik toplama nas\u0131l yap\u0131l\u0131r?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/tr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-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-10T06:01:58+00:00","description":"Bu e\u011fitimde, toplam de\u011ferlerini almak amac\u0131yla otomatik toplam\u0131 uygulamak i\u00e7in klavye k\u0131sayol tu\u015funu \u00f6\u011freneceksiniz.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-2\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/tr\/otomatik-toplam-2\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/otomatik-toplam-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\/tr\/otomatik-toplam-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Ev","item":"https:\/\/exceladvisor.org\/tr\/"},{"@type":"ListItem","position":2,"name":"Excel&#39;de otomatik toplama nas\u0131l yap\u0131l\u0131r?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/tr\/#website","url":"https:\/\/exceladvisor.org\/tr\/","name":"Excel Advisor","description":"Veri hakimiyetine y\u00f6nelik nihai rehberiniz!","publisher":{"@id":"https:\/\/exceladvisor.org\/tr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/tr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/tr\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/tr\/","logo":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/tr\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/tr\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1582","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/comments?post=1582"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1582\/revisions"}],"predecessor-version":[{"id":2569,"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/pages\/1582\/revisions\/2569"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/tr\/wp-json\/wp\/v2\/media?parent=1582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}