{"id":1590,"date":"2023-11-16T04:16:08","date_gmt":"2023-11-16T04:16:08","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/"},"modified":"2023-12-06T05:49:31","modified_gmt":"2023-12-06T05:49:31","slug":"kopieren-plakken","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/","title":{"rendered":"Hoe kopi\u00ebren en plakken via de excel-snelkoppeling?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-2969985757\"><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>Kopi\u00ebren en plakken is de meest gebruikte functie van Excel. Deze functie wordt gebruikt om gegevens van de ene plaats naar de andere te kopi\u00ebren en te plakken. Gebruikers kunnen meerdere kopie\u00ebn van gekopieerde gegevens maken op verschillende locaties op hetzelfde blad, op verschillende bladen of in meerdere werkmappen.<\/p><p> Net als andere Excel-functies heeft deze functie ook een sneltoets en als u een liefhebber bent van sneltoetsen, moet u op de hoogte zijn van deze sneltoets voor kopi\u00ebren en plakken.<\/p><h2 class=\"wp-block-heading\"> Sneltoets om te kopi\u00ebren en plakken in Excel<\/h2><p> <kbd>Ctrl<\/kbd> + <kbd>C<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69421\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png\" sizes=\"auto, \" srcset=\"\" alt=\"sneltoets kopi\u00ebren\" width=\"809\" height=\"317\"><\/figure><\/div><p> <kbd>Ctrl<\/kbd> + <kbd>V<\/kbd> of <kbd>Enter<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69422\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-raccourci-clavier-coller.png\" sizes=\"auto, \" srcset=\"\" alt=\"sneltoets plakken\" width=\"813\" height=\"319\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Stappen voor kopi\u00ebren en plakken met behulp van een sneltoets<\/h2><ul><li> Ga eerst naar de cel of selecteer het celbereik waaruit u de gegevens wilt kopi\u00ebren en druk vervolgens op de toetsen &#8220;Ctrl + C&#8221;. <br><img decoding=\"async\" title=\"3-kopieer het bereik\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-copier-la-plage.png\" sizes=\"\" srcset=\"\" alt=\"copy-the-range\"><\/li><li> Ga daarna naar de cel waar u de gekopieerde gegevens wilt plakken en druk op de toets \u201cEnter\u201d of \u201cCtrl + V\u201d en uw gegevens worden daar geplakt\/gekopieerd. <br><img decoding=\"async\" title=\"4-plak-de-gegevens\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-coller-les-donnees.png\" sizes=\"\" srcset=\"\" alt=\"paste-the-data\"><\/li><\/ul><p> In de afbeelding hierboven kun je zien dat we op &#8220;Ctrl + V&#8221; in cel &#8220;F1&#8221; hebben gedrukt en dat de gekopieerde gegevens daar zijn geplakt.<\/p><h2 class=\"wp-block-heading\"> Afhaalrestaurants<\/h2><ul><li> Om de gegevens op \u00e9\u00e9n locatie te plakken, kunt u de \u201cEnter\u201d-toets gebruiken om de gegevens te plakken.<\/li><li> Om de gekopieerde gegevens naar meerdere locaties te plakken, moet u de toetsen \u201cCtrl + V\u201d gebruiken, anders moet u de gegevens steeds opnieuw kopi\u00ebren om deze op meerdere locaties te plakken.<\/li><li> Om de gegevens te plakken met de speciale optie voor plakken (alleen waarde, formule of formaat), moet u de toetsen &#8220;Ctrl + Alt + V&#8221; gebruiken om de gekopieerde gegevens te plakken. <\/li><\/ul><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-51\"><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\/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\/waarden-plakken\/\">Waarden plakken<\/a><\/li><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><\/ul><\/div><\/div><\/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-1590","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 kopi\u00ebren en plakken via de Excel-snelkoppeling? - Excel-adviseur<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leert u hoe u een sneltoets gebruikt om te kopi\u00ebren en plakken in Excel. 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\/kopieren-plakken\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe kopi\u00ebren en plakken via de Excel-snelkoppeling? - Excel-adviseur\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leert u hoe u een sneltoets gebruikt om te kopi\u00ebren en plakken in Excel. Nu deze sneltoets\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:49:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.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\/kopieren-plakken\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/\",\"name\":\"Hoe kopi\u00ebren en plakken via de Excel-snelkoppeling? - Excel-adviseur\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png\",\"datePublished\":\"2023-11-16T04:16:08+00:00\",\"dateModified\":\"2023-12-06T05:49:31+00:00\",\"description\":\"In deze zelfstudie leert u hoe u een sneltoets gebruikt om te kopi\u00ebren en plakken in Excel. Nu deze sneltoets\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe kopi\u00ebren en plakken via de excel-snelkoppeling?\"}]},{\"@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 kopi\u00ebren en plakken via de Excel-snelkoppeling? - Excel-adviseur","description":"In deze zelfstudie leert u hoe u een sneltoets gebruikt om te kopi\u00ebren en plakken in Excel. 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\/kopieren-plakken\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe kopi\u00ebren en plakken via de Excel-snelkoppeling? - Excel-adviseur","og_description":"In deze zelfstudie leert u hoe u een sneltoets gebruikt om te kopi\u00ebren en plakken in Excel. Nu deze sneltoets","og_url":"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:49:31+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.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\/kopieren-plakken\/","url":"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/","name":"Hoe kopi\u00ebren en plakken via de Excel-snelkoppeling? - Excel-adviseur","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png","datePublished":"2023-11-16T04:16:08+00:00","dateModified":"2023-12-06T05:49:31+00:00","description":"In deze zelfstudie leert u hoe u een sneltoets gebruikt om te kopi\u00ebren en plakken in Excel. Nu deze sneltoets","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-copie-de-raccourci-clavier.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe kopi\u00ebren en plakken via de excel-snelkoppeling?"}]},{"@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\/1590","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=1590"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1590\/revisions"}],"predecessor-version":[{"id":2624,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1590\/revisions\/2624"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1590"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}