{"id":2106,"date":"2023-10-16T03:28:30","date_gmt":"2023-10-16T03:28:30","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/"},"modified":"2023-12-06T05:50:28","modified_gmt":"2023-12-06T05:50:28","slug":"tekst-omwikkelen","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/","title":{"rendered":"Hoe tekst in excel in te pakken?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-291815847\"><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>Excel heeft de standaardcelbreedte en -hoogte, dus wanneer u de lange tekst in de cel invoert, loopt het deel van die tekst over de cellen heen of wordt het onzichtbaar vanwege de grotere omvang van die tekst.<\/p><p> Om dit te ondervangen heeft Excel de tekstomloopfunctie die de tekst omzet in meerdere regels in de cel, zodat deze in de tekst in de cel past. Hierdoor wordt de tekst in meerdere regels geconverteerd en wordt de celhoogte vergroot zodat de tekst in de cel past. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69497\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-reparties-sur-les-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"waarden-op-de-cellen gegoten\" width=\"552\" height=\"216\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Sneltoets om tekst terug te laten lopen in Excel<\/h2><p> De sneltoets voor tekstterugloop is als volgt:<\/p><p> <kbd>Alt<\/kbd> \u2192 <kbd>H<\/kbd> \u2192 <kbd>W<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69499\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-raccourci-clavier-pour-envelopper-le-texte.png\" sizes=\"auto, \" srcset=\"\" alt=\"sneltoets om tekst terug te laten lopen\" width=\"810\" height=\"318\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Stappen om tekst terug te laten lopen met behulp van een sneltoets<\/h2><ol><li> Selecteer eerst de cel, het celbereik of de hele kolom. <br><img decoding=\"async\" title=\"Bereik van 3 cellen geselecteerd\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-selectionner-une-plage-de-cellules.png\" sizes=\"\" srcset=\"\" alt=\"select-cells-range\"><\/li><li> Druk daarna op de toetsen \u201cAlt \u2192 H \u2192 W\u201d en uw gegevens in de cellen worden verpakt. <br><img decoding=\"async\" title=\"4-omwikkelde tekst\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-texte-enveloppe.png\" sizes=\"\" srcset=\"\" alt=\"wrapped-text\"><\/li><\/ol><p class=\"mynote\"> Met tekstterugloop wordt de tekst omwikkeld door de celhoogte te vergroten; de celbreedte blijft ongewijzigd. Dus wanneer u de celbreedte vergroot of verkleint, wordt de tekstomloop automatisch aangepast.<\/p><div class=\"gb-container gb-container-2116538e gb-container-mt\"> <a class=\"gb-button gb-button-f7d2c131 gb-button-text gb-button-mt-button\" href=\"https:\/\/exceladvisor.org\/nl\/toetsenbord-sneltoetsen\/\">Sneltoetsen voor Excel PDF-toetsenbord<\/a><h2 class=\"gb-headline gb-headline-7ed68554 gb-headline-text gb-headline-mt-heading\"> Meer snelkoppelingen <\/h2><div class=\"gb-grid-wrapper gb-grid-wrapper-edeef538 gb-grid-wrapper-mt-grid\"><div class=\"gb-grid-column gb-grid-column-6ab6fbc6\"><div class=\"gb-container gb-container-6ab6fbc6\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/open-formaat-celopties\/\">Optie om opmaakcellen te openen<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/automatische-aanpassing\/\">Automatische aanpassing<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/schilderformaat-1\/\">Schilder formaat<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-766d598b\"><div class=\"gb-container gb-container-766d598b\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/voeg-een-streepje-toe\/\">Voeg een streepje toe<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/randen-toepassen\/\">Rand toepassen<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/opvulkleur\/\">Opvulkleur<\/a><\/li><\/ul><\/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-2106","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 tekst in Excel in te pakken? (Excel-snelkoppeling)<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leert u hoe u een sneltoets gebruikt om tekst toe te passen op rijen in Excel. Nu deze snelkoppeling\" \/>\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\/tekst-omwikkelen\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe tekst in Excel in te pakken? (Excel-snelkoppeling)\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leert u hoe u een sneltoets gebruikt om tekst toe te passen op rijen in Excel. Nu deze snelkoppeling\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:50:28+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-reparties-sur-les-cellules.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=\"1 minuut\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/\",\"name\":\"Hoe tekst in Excel in te pakken? (Excel-snelkoppeling)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-reparties-sur-les-cellules.png\",\"datePublished\":\"2023-10-16T03:28:30+00:00\",\"dateModified\":\"2023-12-06T05:50:28+00:00\",\"description\":\"In deze zelfstudie leert u hoe u een sneltoets gebruikt om tekst toe te passen op rijen in Excel. Nu deze snelkoppeling\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-reparties-sur-les-cellules.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-reparties-sur-les-cellules.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe tekst in excel in te pakken?\"}]},{\"@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 tekst in Excel in te pakken? (Excel-snelkoppeling)","description":"In deze zelfstudie leert u hoe u een sneltoets gebruikt om tekst toe te passen op rijen in Excel. Nu deze snelkoppeling","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\/tekst-omwikkelen\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe tekst in Excel in te pakken? (Excel-snelkoppeling)","og_description":"In deze zelfstudie leert u hoe u een sneltoets gebruikt om tekst toe te passen op rijen in Excel. Nu deze snelkoppeling","og_url":"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:50:28+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-reparties-sur-les-cellules.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Geschatte leestijd":"1 minuut"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/","url":"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/","name":"Hoe tekst in Excel in te pakken? (Excel-snelkoppeling)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-reparties-sur-les-cellules.png","datePublished":"2023-10-16T03:28:30+00:00","dateModified":"2023-12-06T05:50:28+00:00","description":"In deze zelfstudie leert u hoe u een sneltoets gebruikt om tekst toe te passen op rijen in Excel. Nu deze snelkoppeling","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-reparties-sur-les-cellules.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-reparties-sur-les-cellules.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe tekst in excel in te pakken?"}]},{"@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\/2106","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=2106"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2106\/revisions"}],"predecessor-version":[{"id":2735,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2106\/revisions\/2735"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=2106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}