{"id":58843,"date":"2021-06-19T17:28:22","date_gmt":"2021-06-19T16:28:22","guid":{"rendered":"https:\/\/hlrnet.com\/technoblog\/?p=58843"},"modified":"2021-06-21T08:42:38","modified_gmt":"2021-06-21T07:42:38","slug":"een-lijst-hergebruiken-in-excel","status":"publish","type":"post","link":"https:\/\/hlrnet.com\/technoblog\/inicio\/een-lijst-hergebruiken-in-excel\/","title":{"rendered":"Een lijst hergebruiken in Excel"},"content":{"rendered":"<p>V. Kan ik een lijst maken in Excel, en die nadien hergebruiken? Iets zoals de tekstfragmenten in Word, maar dan in Excel?<\/p>\n<p>A. Je kan in Excel je eigen lijsten maken.<\/p>\n<ul>\n<li>Maak de lijst van items die je wil hergebruiken, en selecteer die.<\/li>\n<li>Bestand, Opties, Geavanceerd, Aangepaste lijsten bewerken<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-58844\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/06\/Screenshot-2021-06-19-18.01.44.png\" alt=\"\" width=\"1188\" height=\"856\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/06\/Screenshot-2021-06-19-18.01.44.png 1188w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/06\/Screenshot-2021-06-19-18.01.44-300x216.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/06\/Screenshot-2021-06-19-18.01.44-1024x738.png 1024w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/06\/Screenshot-2021-06-19-18.01.44-768x553.png 768w\" sizes=\"auto, (max-width: 1188px) 100vw, 1188px\" \/><\/li>\n<li>Importeer je lijst<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-trevillethumbnailsmall wp-image-58845\" src=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/06\/Screenshot-2021-06-19-18.15.42.png\" alt=\"\" width=\"790\" height=\"501\" srcset=\"https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/06\/Screenshot-2021-06-19-18.15.42.png 790w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/06\/Screenshot-2021-06-19-18.15.42-300x190.png 300w, https:\/\/hlrnet.com\/technoblog\/wp-content\/uploads\/2021\/06\/Screenshot-2021-06-19-18.15.42-768x487.png 768w\" sizes=\"auto, (max-width: 790px) 100vw, 790px\" \/><\/li>\n<li>m je lijst te hergebruiken, typ je het eerste element en trek je door.<\/li>\n<li>Meer info:<br \/>\n<em>Een aangepaste lijst voor het sorteren en doorvoeren van gegevens maken of verwijderen<\/em> &#8211; Excel<br \/>\n<a href=\"https:\/\/support.microsoft.com\/nl-nl\/office\/een-aangepaste-lijst-voor-het-sorteren-en-doorvoeren-van-gegevens-maken-of-verwijderen-d1cf624f-2d2b-44fa-814b-ba213ec2fd61?ui=nl-NL&#038;rs=nl-NL&#038;ad=NL\" rel=\"nofollow\">https:\/\/support.microsoft.com\/nl-nl\/office\/een-aangepaste-lijst-voor-het-sorteren-en-doorvoeren-van-gegevens-maken-of-verwijderen-d1cf624f-2d2b-44fa-814b-ba213ec2fd61?ui=nl-NL&#038;rs=nl-NL&#038;ad=NL<\/a><\/li>\n<\/ul>\n<p>Als je dat verkiest, kan je de tekstfragmenten van Word gebruiken.<\/p>\n<ul>\n<li>Maak je lijst in Word\n<ul>\n<li>Selecteer en maak het tekstfragment met Alt+F3<\/li>\n<li>Geef een naam<\/li>\n<\/ul>\n<\/li>\n<li>Om te hergebruiken: hergebruik je tekstfragment in Word, selecteer en plak in Excel<\/li>\n<li>Meer info:<br \/>\n<em>Herbruikbare tekstfragmenten maken<\/em> &#8211; Word<br \/>\n<a href=\"https:\/\/support.microsoft.com\/nl-nl\/office\/herbruikbare-tekstfragmenten-maken-0bc40cab-f49c-4e06-bcb2-cd43c1674d1b\" rel=\"nofollow\">https:\/\/support.microsoft.com\/nl-nl\/office\/herbruikbare-tekstfragmenten-maken-0bc40cab-f49c-4e06-bcb2-cd43c1674d1b<\/a><\/li>\n<\/ul>\n<p>Een laatste mogelijkheid is het gebruik van Excel sjablonen (templates).<\/p>\n<ul>\n<li>Maak je lijst in Excel en, sla dat bestand op als sjabloon<\/li>\n<li>Als je dubbelklikt op dat bestand krijg je een kopie.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>V. Kan ik een lijst maken in Excel, en die nadien hergebruiken? Iets zoals de tekstfragmenten in Word, maar dan in Excel? A. Je kan in Excel je eigen lijsten maken. Maak de lijst van items die je wil hergebruiken, en selecteer die. Bestand, Opties, Geavanceerd, Aangepaste lijsten bewerken Importeer<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":26,"footnotes":""},"categories":[54,375,79,160],"tags":[],"class_list":["post-58843","post","type-post","status-publish","format-standard","hentry","category-excel","category-excel-office-2010","category-odisee","category-tabellen"],"publishpress_future_action":{"enabled":false,"date":"2026-05-02 05:10:38","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\/58843","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=58843"}],"version-history":[{"count":0,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/posts\/58843\/revisions"}],"wp:attachment":[{"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/media?parent=58843"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/categories?post=58843"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hlrnet.com\/technoblog\/inicio\/wp-json\/wp\/v2\/tags?post=58843"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}