{"id":63462,"date":"2023-10-02T14:21:27","date_gmt":"2023-10-02T13:21:27","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/inicio\/?p=63462"},"modified":"2023-10-02T14:34:00","modified_gmt":"2023-10-02T13:34:00","slug":"formules-kopieren-in-excel-wat-je-misschien-nog-niet-wist","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/formules-kopieren-in-excel-wat-je-misschien-nog-niet-wist\/","title":{"rendered":"Formules kopi\u00ebren in Excel: wat je misschien nog niet wist"},"content":{"rendered":"<p>Er zijn een aantal manieren om in Excel een bewerking te kopi\u00ebren. Die met + kende je mogelijk nog niet.<\/p>\n<ul>\n<li>Ctrl+C en Ctrl+V<\/li>\n<li>slepen met het vakje rechtsonder (ga op de rand van de cel staan, en ga naar het vakje rechtsbeneden, tot je een dikke plus ziet. Nu kan je slepen om naar rechts (of links) of beneden (of boven) te slepen.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-63463\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2023\/10\/xl-celranden.png\" alt=\"\" width=\"189\" height=\"75\" \/><\/li>\n<li>+ dubbelklikken op het vierkantje, waardoor de formules naar benden worden gekopieerd<\/li>\n<li>Start, Bewerken, Doorvoeren<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-63464\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2023\/10\/xl-doorvoeren-194x300.png\" alt=\"\" width=\"194\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2023\/10\/xl-doorvoeren-194x300.png 194w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2023\/10\/xl-doorvoeren.png 276w\" sizes=\"auto, (max-width: 194px) 100vw, 194px\" \/><\/li>\n<li>+Selecteren naar rechts, en dan Ctrl+R (right)<br \/>\nof selecteren naar beneden, en dan Ctrl+D (down)<\/li>\n<\/ul>\n<p>Zie ook:<\/p>\n<ul>\n<li>Cellen en celinhoud verplaatsen of kopi\u00ebren &#8211; Microsoft Ondersteuning<br \/>\n<a href=\"https:\/\/support.microsoft.com\/nl-nl\/office\/cellen-en-celinhoud-verplaatsen-of-kopi%C3%ABren-803d65eb-6a3e-4534-8c6f-ff12d1c4139e\" rel=\"nofollow\">https:\/\/support.microsoft.com\/nl-nl\/office\/cellen-en-celinhoud-verplaatsen-of-kopi%C3%ABren-803d65eb-6a3e-4534-8c6f-ff12d1c4139e<\/a><\/li>\n<li>Excel Tips: A Faster Way to Use the Fill Handle<br \/>\n<a href=\"https:\/\/edu.gcfglobal.org\/en\/excel-tips\/a-faster-way-to-use-the-fill-handle\/1\/\" rel=\"nofollow\">https:\/\/edu.gcfglobal.org\/en\/excel-tips\/a-faster-way-to-use-the-fill-handle\/1\/<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Er zijn een aantal manieren om in Excel een bewerking te kopi\u00ebren. Die met + kende je mogelijk nog niet. Ctrl+C en Ctrl+V slepen met het vakje rechtsonder (ga op de rand van de cel staan, en ga naar het vakje rechtsbeneden, tot je een dikke plus ziet. Nu kan<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":7,"footnotes":""},"categories":[539,464,54,79,160],"tags":[],"class_list":["post-63462","post","type-post","status-publish","format-standard","hentry","category-berekeningen","category-ebp","category-excel","category-odisee","category-tabellen"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 20:38:09","action":"delete","newStatus":"draft","terms":[],"taxonomy":"category","extraData":[]},"publishpress_future_workflow_manual_trigger":{"enabledWorkflows":[]},"_links":{"self":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/63462","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/comments?post=63462"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/63462\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=63462"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=63462"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=63462"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}