{"id":1885,"date":"2023-10-30T09:05:14","date_gmt":"2023-10-30T09:05:14","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/"},"modified":"2023-12-06T05:50:46","modified_gmt":"2023-12-06T05:50:46","slug":"titels-afdrukken","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/","title":{"rendered":"Hoe printtitels toepassen in excel?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-261532332\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div> <p>Als u in Excel meerdere pagina&#8217;s wilt afdrukken, maar vanaf de eerste regel een koptekst of titel wilt maken die bovenaan elke pagina moet worden afgedrukt, kunt u de optie Titels afdrukken in Excel gebruiken. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72469\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-imprimer-plusieurs-pages.png\" sizes=\"auto, \" srcset=\"\" alt=\"meerdere pagina's afdrukken\" width=\"651\" height=\"403\"><\/figure><\/div><p> Hierboven hebben we de gegevens en we moeten de eerste regel instellen als titel die op elke pagina moet worden afgedrukt. Deze tabel bevat meer dan 1000 rijen met gegevens. Als ik hem probeer af te drukken, zijn er 23 pagina&#8217;s om af te drukken.<\/p><h2 class=\"wp-block-heading\"> Gebruik printtitels om 1 regel als koptekst in afdrukken in te stellen<\/h2><ol><li> Ga eerst naar het tabblad Lay-out \u21e2 Paginasetgroep \u21e2 Titels afdrukken. <br><img loading=\"lazy\" decoding=\"async\" title=\"Bedrukte tegels voor 2 toepassingen\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-utiliser-des-tuiles-dimpression.png\" sizes=\"auto, \" srcset=\"\" alt=\"use-print-tiles\" width=\"654\" height=\"207\"><\/li><li> Klik daarna op de knop \u201cTitel afdrukken\u201d om het dialoogvenster \u201cPagina-instelling\u201d te openen. <br><img loading=\"lazy\" decoding=\"async\" title=\"Configuratiedialoog van 3 pagina's\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/Boite-de-dialogue-de-configuration-a-3-pages.png\" sizes=\"auto, \" srcset=\"\" alt=\"page-setup-dialog-box\" width=\"540\" height=\"521\"><\/li><li> Nu moet u vanuit dit dialoogvenster de optie &#8220;Regels om bovenaan te herhalen:&#8221; gebruiken. Klik dus op de pijl-omhoog die je aan de rechterkant hebt. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-selecteer-regels-om-te-herhalen bovenaan\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-lignes-selectionnees-a-repeter-en-haut.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-rows-to-repeat-at-top\" width=\"541\" height=\"522\"><\/li><li> Op dit punt hebt u een invoerbalk voor bereikselectie en moet u de eerste rij selecteren om deze op te geven. <br><img loading=\"lazy\" decoding=\"async\" title=\"5-specificeer-regel\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-specifier-la-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"specify-the-row\" width=\"672\" height=\"243\"><\/li><li> Klik vervolgens op de pijl-omlaag aan de rechterkant om terug te keren naar de instellingenpagina. <br><img loading=\"lazy\" decoding=\"async\" title=\"6-return-to-page-configuratie\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-revenir-a-la-configuration-de-la-page.png\" sizes=\"auto, \" srcset=\"\" alt=\"go-back-to-the-page-setup\" width=\"683\" height=\"83\"><\/li><li> Klik aan het einde op OK om de instellingen op te slaan. <br><img loading=\"lazy\" decoding=\"async\" title=\"7-opslaan-instellingen\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-enregistrer-les-parametres.png\" sizes=\"auto, \" srcset=\"\" alt=\"save-the-settings\" width=\"542\" height=\"523\"><\/li><\/ol><p> Wanneer u deze gegevens afdrukt, drukt Excel de eerste rij van elke pagina af. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72476\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-donnees-dapercu-avant-impression.png\" sizes=\"auto, \" srcset=\"\" alt=\"afdrukvoorbeeldgegevens\" width=\"812\" height=\"433\"><\/figure><\/div><p> Zoals u in de bovenstaande momentopname kunt zien, hebben we in het afdrukvoorbeeld in totaal 23 pagina&#8217;s en worden de paginatitels weergegeven die we hebben opgegeven, beginnend vanaf de eerste rij.<\/p><h2 class=\"wp-block-heading\"> Meerdere regels gebruiken als printtitels (koppen)<\/h2><p> Op dezelfde manier kunt u, waar u de eerste regel hebt opgegeven, ook meerdere regels opgeven om in te stellen als afdruktitel. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72477\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/9-utiliser-plusieurs-lignes-comme-titre-dimpression.png\" sizes=\"auto, \" srcset=\"\" alt=\"gebruik meerdere regels als printtitel\" width=\"665\" height=\"232\"><\/figure><\/div><p> U hoeft alleen maar deze regels te selecteren, hun adres in de invoerbalk op te geven en vervolgens op OK te klikken. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72478\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/10-selectionner-les-lignes-pour-les-en-tetes.png\" sizes=\"auto, \" srcset=\"\" alt=\"selecteer-rijen-voor-headers\" width=\"500\" height=\"523\"><\/figure><\/div><p> Maar u kunt alleen doorlopende lijnen opgeven. Als u naar niet-doorlopende lijnen probeert te verwijzen, wordt er een foutmelding weergegeven. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-72479\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/11-selectionner-uniquement-les-lignes-continues.png\" sizes=\"auto, \" srcset=\"\" alt=\"alleen-selecteer-doorgaande-lijnen\" width=\"568\" height=\"497\"><\/figure><\/div><div class=\"gb-container gb-container-4db6181c gb-container-mt\"> <a class=\"gb-button gb-button-c5897111 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/nl\/excel-vooruitgang\/\">Geavanceerde Excel-zelfstudies<\/a><h2 class=\"gb-headline gb-headline-665e5f6b gb-headline-text gb-headline-mt-heading\"> Gerelateerde tutorials <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-a20baf7c gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-65ddf67e\"><div class=\"gb-container gb-container-65ddf67e\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/ruitjespapier\/\">Een ruitjespapier afdrukken in Excel (vierkant rastersjabloon)<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/verwijder-pagina-einde\/\">Verwijder pagina-einde in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/afdrukgebied-instellen\/\">Stel het afdrukgebied in Excel in<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/centreer-het-werkblad-horizontaal\/\">Centreer een werkblad horizontaal en verticaal in Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/div><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-1885","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Hoe printtitels toepassen in Excel?<\/title>\n<meta name=\"description\" content=\"Leer een eenvoudige maar krachtige optie om printtitels toe te passen in Excel, waarbij we rij 1 kunnen instellen op afdrukken...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe printtitels toepassen in Excel?\" \/>\n<meta property=\"og:description\" content=\"Leer een eenvoudige maar krachtige optie om printtitels toe te passen in Excel, waarbij we rij 1 kunnen instellen op afdrukken...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:50:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-imprimer-plusieurs-pages.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/\",\"name\":\"Hoe printtitels toepassen in Excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-imprimer-plusieurs-pages.png\",\"datePublished\":\"2023-10-30T09:05:14+00:00\",\"dateModified\":\"2023-12-06T05:50:46+00:00\",\"description\":\"Leer een eenvoudige maar krachtige optie om printtitels toe te passen in Excel, waarbij we rij 1 kunnen instellen op afdrukken...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-imprimer-plusieurs-pages.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-imprimer-plusieurs-pages.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe printtitels toepassen in excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"name\":\"Excel Advisor\",\"description\":\"Uw gids voor datadominantie\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/nl\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Hoe printtitels toepassen in Excel?","description":"Leer een eenvoudige maar krachtige optie om printtitels toe te passen in Excel, waarbij we rij 1 kunnen instellen op afdrukken...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe printtitels toepassen in Excel?","og_description":"Leer een eenvoudige maar krachtige optie om printtitels toe te passen in Excel, waarbij we rij 1 kunnen instellen op afdrukken...","og_url":"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:50:46+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-imprimer-plusieurs-pages.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"2 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/","url":"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/","name":"Hoe printtitels toepassen in Excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-imprimer-plusieurs-pages.png","datePublished":"2023-10-30T09:05:14+00:00","dateModified":"2023-12-06T05:50:46+00:00","description":"Leer een eenvoudige maar krachtige optie om printtitels toe te passen in Excel, waarbij we rij 1 kunnen instellen op afdrukken...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-imprimer-plusieurs-pages.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-imprimer-plusieurs-pages.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/titels-afdrukken\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe printtitels toepassen in excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/nl\/#website","url":"https:\/\/exceladvisor.org\/nl\/","name":"Excel Advisor","description":"Uw gids voor datadominantie","publisher":{"@id":"https:\/\/exceladvisor.org\/nl\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/nl\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/nl\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/nl\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/nl\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1885","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/comments?post=1885"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1885\/revisions"}],"predecessor-version":[{"id":2786,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1885\/revisions\/2786"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1885"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}