{"id":2164,"date":"2023-09-27T15:00:46","date_gmt":"2023-09-27T15:00:46","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/waarden-plakken\/"},"modified":"2023-12-06T05:55:27","modified_gmt":"2023-12-06T05:55:27","slug":"waarden-plakken","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/waarden-plakken\/","title":{"rendered":"De beste excel-snelkoppeling voor het plakken van waarden"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-1448220803\"><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 is kopi\u00ebren en plakken een veel voorkomende taak die iedereen uitvoert, en telkens wanneer een gebruiker de gegevens kopieert en plakt, plakt Excel niet alleen de waarden, maar ook de opmaak en formule.<\/p><p> Maar Excel heeft ook de mogelijkheid om de gegevens alleen als waarden te plakken, wat betekent dat bij deze optie alleen de waarde wordt geplakt en de opmaak en formule worden ge\u00eblimineerd.<\/p><p> Er zijn verschillende snelkoppelingen en toetscombinaties om de gegevens alleen als waarde in Excel te plakken, maar in deze zelfstudie hebben we u de snelste en gemakkelijkste snelkoppelingen verteld.<\/p><h2 class=\"wp-block-heading\"> Sneltoets voor het plakken van waarden in Excel<\/h2><p> In Excel worden hieronder de snelste en gemakkelijkste snelkoppelingen vermeld om waarden te plakken:<\/p><p> <kbd>Alt<\/kbd> \u2192 <kbd>H<\/kbd> \u2192 <kbd>V<\/kbd> \u2192 <kbd>V<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69464\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-coller-les-touches-de-raccourci-des-valeurs.png\" sizes=\"auto, \" srcset=\"\" alt=\"plak-waarden-toets-snelkoppelingen\" width=\"787\" height=\"309\"><\/figure><\/div><p> <kbd>Ctrl<\/kbd> + <kbd>Alt<\/kbd> + V en vervolgens <kbd>V<\/kbd> \u2192 <kbd>Enter<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69465\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-coller-le-raccourci-de-la-valeur.png\" sizes=\"auto, \" srcset=\"\" alt=\"plak-waarde-snelkoppeling\" width=\"781\" height=\"306\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Stappen om waarden te plakken met behulp van een sneltoets<\/h2><ul><li> Kopieer eerst de gegevens die u elders in Excel wilt plakken.<\/li><li> Ga daarna naar de cel waarin u de gegevens wilt plakken.<\/li><li> Druk nu gewoon op Alt \u2192 H \u2192 V \u2192 V in de juiste volgorde en uw gegevens worden alleen als waarden geplakt.<\/li><li> Of houd \u201cCtrl + Alt + V\u201d ingedrukt en u opent het dialoogvenster \u201cPlakken speciaal\u201d.<\/li><li> Laat nu de toetsen los en druk eenvoudig op &#8220;V&#8221; om het keuzerondje naar &#8220;Waarden&#8221; te verplaatsen en druk op Enter. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69466\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-coller-la-boite-de-dialogue-speciale.png\" sizes=\"auto, \" srcset=\"\" alt=\"plak-speciaal-dialoogvenster\" width=\"463\" height=\"349\"><\/figure><\/div><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-59\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/absolute-referentie\/\">Absolute referentie<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/\">Knippen en plakken<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/knip-en-plak\/\">Knip en plak<\/a><\/li><li> Cellen vergrendelen<\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/selecteer-een-lijn\/\">Selecteer een lijn<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/transponeren-2\/\">Transponeren<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/ga-naar\/\">Open de optie Ga naar<\/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-2164","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 Excel-snelkoppeling om waarden te plakken (nieuwste 2023)<\/title>\n<meta name=\"description\" content=\"In deze tutorial leert u hoe u een sneltoets gebruikt om waarden in Excel te plakken. Nu deze sneltoets\" \/>\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\/waarden-plakken\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Excel-snelkoppeling om waarden te plakken (nieuwste 2023)\" \/>\n<meta property=\"og:description\" content=\"In deze tutorial leert u hoe u een sneltoets gebruikt om waarden in Excel te plakken. Nu deze sneltoets\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/waarden-plakken\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:55:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-coller-les-touches-de-raccourci-des-valeurs.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\/waarden-plakken\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/waarden-plakken\/\",\"name\":\"\u25b7 Excel-snelkoppeling om waarden te plakken (nieuwste 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/waarden-plakken\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/waarden-plakken\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-coller-les-touches-de-raccourci-des-valeurs.png\",\"datePublished\":\"2023-09-27T15:00:46+00:00\",\"dateModified\":\"2023-12-06T05:55:27+00:00\",\"description\":\"In deze tutorial leert u hoe u een sneltoets gebruikt om waarden in Excel te plakken. Nu deze sneltoets\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/waarden-plakken\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/waarden-plakken\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/waarden-plakken\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-coller-les-touches-de-raccourci-des-valeurs.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-coller-les-touches-de-raccourci-des-valeurs.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/waarden-plakken\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"De beste excel-snelkoppeling voor het plakken van waarden\"}]},{\"@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 Excel-snelkoppeling om waarden te plakken (nieuwste 2023)","description":"In deze tutorial leert u hoe u een sneltoets gebruikt om waarden in Excel te plakken. Nu deze sneltoets","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\/waarden-plakken\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Excel-snelkoppeling om waarden te plakken (nieuwste 2023)","og_description":"In deze tutorial leert u hoe u een sneltoets gebruikt om waarden in Excel te plakken. Nu deze sneltoets","og_url":"https:\/\/exceladvisor.org\/nl\/waarden-plakken\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:55:27+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-coller-les-touches-de-raccourci-des-valeurs.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\/waarden-plakken\/","url":"https:\/\/exceladvisor.org\/nl\/waarden-plakken\/","name":"\u25b7 Excel-snelkoppeling om waarden te plakken (nieuwste 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/waarden-plakken\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/waarden-plakken\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-coller-les-touches-de-raccourci-des-valeurs.png","datePublished":"2023-09-27T15:00:46+00:00","dateModified":"2023-12-06T05:55:27+00:00","description":"In deze tutorial leert u hoe u een sneltoets gebruikt om waarden in Excel te plakken. Nu deze sneltoets","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/waarden-plakken\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/waarden-plakken\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/waarden-plakken\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-coller-les-touches-de-raccourci-des-valeurs.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-coller-les-touches-de-raccourci-des-valeurs.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/waarden-plakken\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"De beste excel-snelkoppeling voor het plakken van waarden"}]},{"@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\/2164","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=2164"}],"version-history":[{"count":2,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2164\/revisions"}],"predecessor-version":[{"id":2992,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2164\/revisions\/2992"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=2164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}