{"id":59008,"date":"2021-07-09T16:17:38","date_gmt":"2021-07-09T15:17:38","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=59008"},"modified":"2021-07-09T16:17:38","modified_gmt":"2021-07-09T15:17:38","slug":"alleen-zichtbare-rijen-of-kolommen-plakken","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/alleen-zichtbare-rijen-of-kolommen-plakken\/","title":{"rendered":"Alleen zichtbare rijen of kolommen plakken"},"content":{"rendered":"<p>V. Ik heb een aantal kolommen verborgen. Hoe kan ik alleen die kolommen kopi\u00ebren en plakken? En gaat dat ook voor rijen?<\/p>\n<p>A. Ja, daar is een functietoets voor.<\/p>\n<ul>\n<li>Selecteer de gegevens<\/li>\n<li>Druk <strong>Alt+;<\/strong> (puntkomma), en dan Ctrl+C<\/li>\n<li>Plak<\/li>\n<\/ul>\n<p>Enkele bijkomende bemerkingen:<\/p>\n<ul>\n<li>Je kan <strong>discontinu selecteren<\/strong> met ctrl+pijltje. Nadien kan je bv. kopi\u00ebren, maar je kan ook opmaken.<\/li>\n<li>Als je de rijen <strong>filtert<\/strong> (met een filter), dan zal ctrl+c \/ ctrl+v alleen de zichtbare rijen kopi\u00ebren en plakken.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>V. Ik heb een aantal kolommen verborgen. Hoe kan ik alleen die kolommen kopi\u00ebren en plakken? En gaat dat ook voor rijen? A. Ja, daar is een functietoets voor. Selecteer de gegevens Druk Alt+; (puntkomma), en dan Ctrl+C Plak Enkele bijkomende bemerkingen: Je kan discontinu selecteren met ctrl+pijltje. Nadien 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":5,"footnotes":""},"categories":[54,375,10,160],"tags":[],"class_list":["post-59008","post","type-post","status-publish","format-standard","hentry","category-excel","category-excel-office-2010","category-office","category-tabellen"],"publishpress_future_action":{"enabled":false,"date":"2026-05-02 17:48:18","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\/59008","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=59008"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/59008\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=59008"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=59008"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=59008"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}