{"id":1584,"date":"2023-11-16T09:04:35","date_gmt":"2023-11-16T09:04:35","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/autosom-2\/"},"modified":"2023-12-06T05:52:09","modified_gmt":"2023-12-06T05:52:09","slug":"autosom-2","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/autosom-2\/","title":{"rendered":"Hoe voer ik een automatische som uit in excel?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-256635645\"><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>Om in Excel een automatische som uit te voeren voor de waarden die je hebt in de cellen boven de actieve cel of de waarden in de cellen aan de linkerkant, kun je de sneltoets <kbd>Alt<\/kbd> + <kbd>=<\/kbd> gebruiken. Wanneer u op deze sneltoets drukt, wordt de somfunctie in de actieve cel ingevoegd door te verwijzen naar het bereik hierboven of aan de linkerkant. <\/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=\"automatische som\" 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=\"snelkoppeling automatisch\" width=\"896\" height=\"207\"><\/figure><\/div><p> Nu kunt u, zoals ik al zei, ook een autosom invoegen voor de waarden die we aan de linkerkant hebben. <\/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=\"invoeg- en autosum-waarden\" width=\"614\" height=\"128\"><\/figure><\/div><p> Maar als u zowel aan de linkerkant als boven de actieve cel waarden heeft, wordt er automatisch een som verder op de waarden ingevoegd. Er is nog iets dat u kunt doen als u op de sneltoets drukt: de functie wordt ingevoegd, maar u moet op Enter drukken om het resultaat te krijgen. <\/p><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Meer snelkoppelingen <\/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\/nl\/filteren-1\/\">Filter toepassen en verwijderen<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/duidelijke-inhoud\/\">Duidelijke inhoud<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/formules-weergeven\/\">Formules weergeven<\/a><\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/naar-beneden-glijden\/\">Naar beneden swipen<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/verwijderen\/\">VERWIJDEREN<\/a><\/li><\/ul><\/div><\/div><p> \u21e0 Terug naar <a href=\"https:\/\/exceladvisor.org\/nl\/toetsenbord-sneltoetsen\/\">Excel-snelkoppelingen (PDF-spiekbriefje)<\/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>Hoe voer ik een automatische som uit in Excel?<\/title>\n<meta name=\"description\" content=\"In deze tutorial leert u de sneltoets op het toetsenbord om autosum toe te passen om de somwaarden binnen te krijgen\" \/>\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\/nl\/autosom-2\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe voer ik een automatische som uit in Excel?\" \/>\n<meta property=\"og:description\" content=\"In deze tutorial leert u de sneltoets op het toetsenbord om autosum toe te passen om de somwaarden binnen te krijgen\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/autosom-2\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:52:09+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=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/autosom-2\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/autosom-2\/\",\"name\":\"Hoe voer ik een automatische som uit in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/autosom-2\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/autosom-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-06T05:52:09+00:00\",\"description\":\"In deze tutorial leert u de sneltoets op het toetsenbord om autosum toe te passen om de somwaarden binnen te krijgen\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/autosom-2\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/autosom-2\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/autosom-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\/nl\/autosom-2\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe voer ik een automatische som uit in excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hoe voer ik een automatische som uit in Excel?","description":"In deze tutorial leert u de sneltoets op het toetsenbord om autosum toe te passen om de somwaarden binnen te krijgen","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\/nl\/autosom-2\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe voer ik een automatische som uit in Excel?","og_description":"In deze tutorial leert u de sneltoets op het toetsenbord om autosum toe te passen om de somwaarden binnen te krijgen","og_url":"https:\/\/exceladvisor.org\/nl\/autosom-2\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:52:09+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":{"Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/autosom-2\/","url":"https:\/\/exceladvisor.org\/nl\/autosom-2\/","name":"Hoe voer ik een automatische som uit in Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/autosom-2\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/autosom-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-06T05:52:09+00:00","description":"In deze tutorial leert u de sneltoets op het toetsenbord om autosum toe te passen om de somwaarden binnen te krijgen","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/autosom-2\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/autosom-2\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/autosom-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\/nl\/autosom-2\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe voer ik een automatische som uit in excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1584","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1584"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1584\/revisions"}],"predecessor-version":[{"id":2882,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1584\/revisions\/2882"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}