{"id":50318,"date":"2016-10-24T16:30:39","date_gmt":"2016-10-24T15:30:39","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=50318"},"modified":"2020-10-30T12:31:45","modified_gmt":"2020-10-30T11:31:45","slug":"cellen-kopieren-of-verplaatsen-zonder-de-adressen-te-laten-aanpassen","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/cellen-kopieren-of-verplaatsen-zonder-de-adressen-te-laten-aanpassen\/","title":{"rendered":"Cellen kopi\u00ebren of verplaatsen zonder de adressen te laten aanpassen"},"content":{"rendered":"<p>V. Als ik cellen kopieer passen de adressen zich aan &#8211; tenzij de adressen met dollartekens. Kan ik cellen verplaatsen (dus niet kopi\u00ebren) z\u00f3nder dat adressen opschuiven? En van \u00e9\u00e9n blad naar een adres blad?<\/p>\n<p>A. Ja, er zijn drie opties:<\/p>\n<ul>\n<li>Verplaatsen door op de rand van de cel te gaan staan. Als de muisaanwijzer in vier pijlen verandert, kan je slepen. De adressen worden niet aangepast.<\/li>\n<li>Knippen en plakken (Ctrl+X en nadien plakken).\u00a0 De adressen blijven staan.<\/li>\n<li>Of: de formules omzetten in tekst en dan kopi\u00ebren.<br \/>\nEen en ander staat o.m. beschreven in <em>How to copy formula in Excel: down a column, without changing references, etc.<\/em><br \/>\n<a href=\"https:\/\/www.ablebits.com\/office-addins-blog\/2016\/01\/20\/copy-formula-excel\/Zie\" rel=\"nofollow\">https:\/\/www.ablebits.com\/office-addins-blog\/2016\/01\/20\/copy-formula-excel\/Zie<\/a> ook:<br \/>\n<em>How to copy formula without changing its cell references in Excel?<\/em><br \/>\n<a href=\"https:\/\/www.extendoffice.com\/documents\/excel\/598-excel-copy-without-changing-formulas.html\" rel=\"nofollow\">https:\/\/www.extendoffice.com\/documents\/excel\/598-excel-copy-without-changing-formulas.html<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>V. Als ik cellen kopieer passen de adressen zich aan &#8211; tenzij de adressen met dollartekens. Kan ik cellen verplaatsen (dus niet kopi\u00ebren) z\u00f3nder dat adressen opschuiven? En van \u00e9\u00e9n blad naar een adres blad? A. Ja, er zijn drie opties: Verplaatsen door op de rand van de cel te<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":12,"footnotes":""},"categories":[54,375,79,10,246],"tags":[],"class_list":["post-50318","post","type-post","status-publish","format-standard","hentry","category-excel","category-excel-office-2010","category-odisee","category-office","category-office-2010"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 13:46:36","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\/50318","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=50318"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/50318\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=50318"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=50318"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=50318"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}