{"id":50371,"date":"2016-11-02T14:55:54","date_gmt":"2016-11-02T13:55:54","guid":{"rendered":"http:\/\/hlrnet.com\/technoblog\/?p=50371"},"modified":"2016-10-29T15:03:25","modified_gmt":"2016-10-29T14:03:25","slug":"speciaal-plakken-in-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/speciaal-plakken-in-excel\/","title":{"rendered":"Speciaal plakken in Excel"},"content":{"rendered":"<p>V. Is het mogelijk om iets anders te doen dan Ctrtl+V om te plakken in Excel? Dikwijls komt er opmaak mee die ik niet wil, en soms wil ik alleen de opmaak (en niet de inhoud) plakken.<\/p>\n<p>A. Ja.<\/p>\n<ul>\n<li>Je kan de opmaak kopi\u00ebren\/plakken met de borstel. Ga op de cel staan met de bedoelde opmaak. Klik op de borstel. Klik nu op de cel die die opmaak moet overnemen. Klaar!<\/li>\n<li>Maar je kan nog v\u00e9\u00e9l meer doen met speciaal plakken<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-50372\" src=\"http:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2016\/10\/xl-speciaalplakken-142x300.png\" alt=\"xl-speciaalplakken\" width=\"142\" height=\"300\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2016\/10\/xl-speciaalplakken-142x300.png 142w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2016\/10\/xl-speciaalplakken.png 224w\" sizes=\"auto, (max-width: 142px) 100vw, 142px\" \/><br \/>\nVan links naar rechts en van onder naar boven kan je plakken:<\/p>\n<ul>\n<li>(1) alles (&#8216;gewoon&#8217; plakken)<\/li>\n<li>alleen de formules<\/li>\n<li>alleen de opmaak van formules en getallen<\/li>\n<li>de opmaak van de bron behouden<\/li>\n<li>(2) zonder randen<\/li>\n<li>met behoud van de breedte van de bronkolom<\/li>\n<li>transponeren (rijen en kolommen wisselen)<\/li>\n<li>(3) alleen de waarden<\/li>\n<li>opmaak van waarden en getallen<\/li>\n<li>opmaak van waarden en bronnen<\/li>\n<li>(4) alleen de opmaak<\/li>\n<li>koppeling plakken<\/li>\n<li>afbeelding plakken<\/li>\n<li>gekoppelde afbeelding<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>Voor meer details verwijzen we graag naar: <em>Opmaak kopi\u00ebren\/plakken gebruiken<\/em>\u00c2\u00a0 &#8211; <a href=\"https:\/\/support.office.com\/nl-nl\/article\/Opmaak-kopi\u00ebren-plakken-gebruiken-4bb415a9-d4e4-42b7-b579-170adc594e40\" rel=\"nofollow\">https:\/\/support.office.com\/nl-nl\/article\/Opmaak-kopi\u00ebren-plakken-gebruiken-4bb415a9-d4e4-42b7-b579-170adc594e40<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>V. Is het mogelijk om iets anders te doen dan Ctrtl+V om te plakken in Excel? Dikwijls komt er opmaak mee die ik niet wil, en soms wil ik alleen de opmaak (en niet de inhoud) plakken. A. Ja. Je kan de opmaak kopi\u00ebren\/plakken met de borstel. Ga op de<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":39,"footnotes":""},"categories":[78,464,54,375,10,246,160],"tags":[],"class_list":["post-50371","post","type-post","status-publish","format-standard","hentry","category-cvosemper","category-ebp","category-excel","category-excel-office-2010","category-office","category-office-2010","category-tabellen"],"publishpress_future_action":{"enabled":false,"date":"2026-05-02 23:07:45","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\/50371","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=50371"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/50371\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=50371"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=50371"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=50371"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}