{"id":2172,"date":"2023-09-26T07:18:38","date_gmt":"2023-09-26T07:18:38","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/formules-weergeven\/"},"modified":"2023-12-06T05:58:10","modified_gmt":"2023-12-06T05:58:10","slug":"formules-weergeven","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/formules-weergeven\/","title":{"rendered":"Hoe formules weergeven in excel?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-144906653\"><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>In Excel zijn er zoveel formules om te gebruiken en telkens wanneer de gebruiker de formule in een cel invoert, geeft Excel de resulterende waarden van die formule weer.<\/p><p> Maar in sommige gevallen willen gebruikers de cellen zien die formules bevatten om de formule weer te geven en te valideren en soms de gegevens met de formules af te drukken in plaats van de resulterende waarden en hiervoor heeft Excel de opties om de bestaande formules weer te geven.<\/p><h2 class=\"wp-block-heading\"> Sneltoets om formules weer te geven<\/h2><p> Net als veel andere kenmerken en functies van Excel heeft Excel ook een sneltoets ingesteld om bestaande formules in het werkblad weer te geven. De sneltoets om formules weer te geven is: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67542\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-afficher-les-formules.png\" sizes=\"auto, \" srcset=\"\" alt=\"snelkoppeling om formules weer te geven\" width=\"813\" height=\"319\"><\/figure><\/div><p> Ctrl+`<\/p><p> In het onderstaande voorbeeld drukten we op de toetsen &#8220;Ctrl + `&#8221; en Excel gaf alle bestaande formules weer in plaats van de resulterende waarden. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67543\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-formules-affichees.png\" sizes=\"auto, \" srcset=\"\" alt=\"weergegeven formules\" width=\"738\" height=\"168\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Stappen om formules te bekijken en formules te gebruiken met behulp van een sneltoets<\/h2><ol><li> Klik op een cel in het werkblad.<\/li><li> Druk daarna gewoon op de sneltoetsen \u00bbCtrl + ` \u00bb en u krijgt alle formules weergegeven in plaats van de resulterende waarden.<\/li><li> Om terug te gaan en de resulterende waarden te bekijken, drukt u nogmaals op de toetsen &#8220;Ctrl + `&#8221;. <\/li><\/ol><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-87\"><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\/autosom-2\/\">Automatische som<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/duidelijke-inhoud\/\">Duidelijke inhoud<\/a><\/li><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 class=\"wp-block-column is-layout-flow\"><\/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-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>\u25b7 Hoe formules weergeven? (Excel 2023-snelkoppeling)<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leren we hoe u een sneltoets kunt gebruiken om formules in een spreadsheet in Excel te bekijken.\" \/>\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\/formules-weergeven\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hoe formules weergeven? (Excel 2023-snelkoppeling)\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leren we hoe u een sneltoets kunt gebruiken om formules in een spreadsheet in Excel te bekijken.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/formules-weergeven\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:58:10+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-afficher-les-formules.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\/formules-weergeven\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/formules-weergeven\/\",\"name\":\"\u25b7 Hoe formules weergeven? (Excel 2023-snelkoppeling)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/formules-weergeven\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/formules-weergeven\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-afficher-les-formules.png\",\"datePublished\":\"2023-09-26T07:18:38+00:00\",\"dateModified\":\"2023-12-06T05:58:10+00:00\",\"description\":\"In deze zelfstudie leren we hoe u een sneltoets kunt gebruiken om formules in een spreadsheet in Excel te bekijken.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/formules-weergeven\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/formules-weergeven\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/formules-weergeven\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-afficher-les-formules.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-afficher-les-formules.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/formules-weergeven\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe formules weergeven 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":"\u25b7 Hoe formules weergeven? (Excel 2023-snelkoppeling)","description":"In deze zelfstudie leren we hoe u een sneltoets kunt gebruiken om formules in een spreadsheet in Excel te bekijken.","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\/formules-weergeven\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe formules weergeven? (Excel 2023-snelkoppeling)","og_description":"In deze zelfstudie leren we hoe u een sneltoets kunt gebruiken om formules in een spreadsheet in Excel te bekijken.","og_url":"https:\/\/exceladvisor.org\/nl\/formules-weergeven\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:58:10+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-afficher-les-formules.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\/formules-weergeven\/","url":"https:\/\/exceladvisor.org\/nl\/formules-weergeven\/","name":"\u25b7 Hoe formules weergeven? (Excel 2023-snelkoppeling)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/formules-weergeven\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/formules-weergeven\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-afficher-les-formules.png","datePublished":"2023-09-26T07:18:38+00:00","dateModified":"2023-12-06T05:58:10+00:00","description":"In deze zelfstudie leren we hoe u een sneltoets kunt gebruiken om formules in een spreadsheet in Excel te bekijken.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/formules-weergeven\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/formules-weergeven\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/formules-weergeven\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-afficher-les-formules.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-afficher-les-formules.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/formules-weergeven\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe formules weergeven 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\/2172","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=2172"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2172\/revisions"}],"predecessor-version":[{"id":2426,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2172\/revisions\/2426"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=2172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}