{"id":60966,"date":"2022-05-06T20:20:53","date_gmt":"2022-05-06T19:20:53","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=60966"},"modified":"2024-08-31T17:44:44","modified_gmt":"2024-08-31T16:44:44","slug":"een-tabel-maken-in-excel-maar-hoe-kan-ik-nadien-selecteren","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/een-tabel-maken-in-excel-maar-hoe-kan-ik-nadien-selecteren\/","title":{"rendered":"Een tabel maken in Excel &#8211; maar hoe kan ik nadien selecteren of filteren?"},"content":{"rendered":"<p>Tabellen zijn heel handig in Excel. Ze voorkomen dat je bv. een aantal gegevens vergeet in te vullen of mee te selecteren. Bovendien is het sorteren stuk eenvoudiger. Zo werkt het:<\/p>\n<ul>\n<li>Vul je gegevens in (of op zijn minst alle kolommen) en zet bovenaan kolomkoppen (labels).<\/li>\n<li>Selecteer de gegevens en voeg een tabel in via <em>Invoegen, Tabellen<\/em>. Zeg dat je kopteksten hebt.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-trevillethumbnailsmall wp-image-60969\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2022\/05\/xl-tabel.png\" alt=\"\" width=\"531\" height=\"443\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2022\/05\/xl-tabel.png 531w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2022\/05\/xl-tabel-300x250.png 300w\" sizes=\"auto, (max-width: 531px) 100vw, 531px\" \/><\/li>\n<li>En voil\u00e0: je hebt een mooie tabel met alternerende kleuring. Telkens je een rij toevoegt, krijg je een rij bij <img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-trevillethumbnailsmall wp-image-60968\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2022\/05\/xl-tabel2.png\" alt=\"\" width=\"628\" height=\"192\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2022\/05\/xl-tabel2.png 628w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2022\/05\/xl-tabel2-300x92.png 300w\" sizes=\"auto, (max-width: 628px) 100vw, 628px\" \/><\/li>\n<li>En je kan heel handig sorteren<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-60967\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2022\/05\/xl-tabel3.png\" alt=\"\" width=\"567\" height=\"627\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2022\/05\/xl-tabel3.png 567w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2022\/05\/xl-tabel3-271x300.png 271w\" sizes=\"auto, (max-width: 567px) 100vw, 567px\" \/><\/li>\n<li>Probleempje: je kan niet zo maar filteren op twee kolommen tegelijk. Dat is op te lossen met <em>slicers<\/em>. <em>Filters, Slicer invoegen<\/em>.<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-trevillethumbnailsmall wp-image-60972\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2022\/05\/xl-slicer1.png\" alt=\"\" width=\"410\" height=\"381\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2022\/05\/xl-slicer1.png 410w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2022\/05\/xl-slicer1-300x279.png 300w\" sizes=\"auto, (max-width: 410px) 100vw, 410px\" \/><\/li>\n<li>Selecteer de velden waarop je wil kunnen filteren<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-trevillethumbnailsmall wp-image-60971\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2022\/05\/xl-slicer2.png\" alt=\"\" width=\"297\" height=\"555\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2022\/05\/xl-slicer2.png 297w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2022\/05\/xl-slicer2-161x300.png 161w\" sizes=\"auto, (max-width: 297px) 100vw, 297px\" \/><\/li>\n<li>En dit is het resultaat<br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-trevillethumbnailsmall wp-image-60970\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2022\/05\/xl-slicer3.png\" alt=\"\" width=\"633\" height=\"377\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2022\/05\/xl-slicer3.png 633w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2022\/05\/xl-slicer3-300x179.png 300w\" sizes=\"auto, (max-width: 633px) 100vw, 633px\" \/><\/li>\n<li>Meer informatie nodig?\n<ul>\n<li><em>Slicers gebruiken om gegevens te filteren<\/em><br \/>\n<a href=\"https:\/\/support.microsoft.com\/nl-nl\/office\/slicers-gebruiken-om-gegevens-te-filteren-249f966b-a9d5-4b0f-b31a-12651785d29d\" rel=\"nofollow\">https:\/\/support.microsoft.com\/nl-nl\/office\/slicers-gebruiken-om-gegevens-te-filteren-249f966b-a9d5-4b0f-b31a-12651785d29d<\/a><\/li>\n<li><em>Het formaat van een tabel wijzigen door kolommen en rijen toe te voegen of te verwijderen<\/em> &#8211; Microsoft Ondersteuning<br \/>\n<a href=\"https:\/\/support.microsoft.com\/nl-nl\/office\/het-formaat-van-een-tabel-wijzigen-door-kolommen-en-rijen-toe-te-voegen-of-te-verwijderen-e65ae4bb-e44b-43f4-ad8b-7d68784f1165\" rel=\"nofollow\">https:\/\/support.microsoft.com\/nl-nl\/office\/het-formaat-van-een-tabel-wijzigen-door-kolommen-en-rijen-toe-te-voegen-of-te-verwijderen-e65ae4bb-e44b-43f4-ad8b-7d68784f1165<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Tabellen zijn heel handig in Excel. Ze voorkomen dat je bv. een aantal gegevens vergeet in te vullen of mee te selecteren. Bovendien is het sorteren stuk eenvoudiger. Zo werkt het: Vul je gegevens in (of op zijn minst alle kolommen) en zet bovenaan kolomkoppen (labels). Selecteer de gegevens en<\/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,79,10,160],"tags":[],"class_list":["post-60966","post","type-post","status-publish","format-standard","hentry","category-excel","category-excel-office-2010","category-odisee","category-office","category-tabellen"],"publishpress_future_action":{"enabled":false,"date":"2026-05-03 19:27:00","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\/60966","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=60966"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/60966\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=60966"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=60966"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=60966"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}