{"id":2200,"date":"2023-09-25T06:25:20","date_gmt":"2023-09-25T06:25:20","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/automatische-aanpassing\/"},"modified":"2023-12-06T05:50:28","modified_gmt":"2023-12-06T05:50:28","slug":"automatische-aanpassing","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/automatische-aanpassing\/","title":{"rendered":"Hoe tekst automatisch aanpassen via een excel-formule?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-2024805861\"><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>In Excel wordt de functie AutoAanpassen gebruikt om de rijhoogte en celbreedte aan te passen op basis van de grootte van de waarde in de cellen.<\/p><p> Zoals u weet, heeft Excel standaard rijhoogte en celbreedte en wanneer de gebruiker een waarde invoert waarvan de lengte groter is dan de celbreedte, overloopt de waarde de cellen en om de grootte van de cellen aan te passen, kunnen we AutoFit gebruiken, afhankelijk van deze waarde.<\/p><p> In de onderstaande afbeelding kun je zien dat de lengte van de ingevoerde waarden groter was dan de standaard celgrootte, waardoor de waarden over de cellen verspreidden. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67515\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-debordees.png\" sizes=\"auto, \" srcset=\"\" alt=\"overvloed aan waarden\" width=\"327\" height=\"225\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Sneltoets om AutoFit in Excel te gebruiken <\/h2><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67516\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-raccourcis-clavier-pour-ajuster-automatiquement-la-largeur-des-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"sneltoets om de celbreedte automatisch aan te passen\" width=\"821\" height=\"322\"><\/figure><\/div><p> <strong>Celbreedte (kolom) automatisch aanpassen:<\/strong> Alt \u2192 H \u2192 O \u2192 I <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67517\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-raccourci-pour-ajuster-automatiquement-la-hauteur-de-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"snelkoppeling om de rijhoogte automatisch aan te passen\" width=\"804\" height=\"315\"><\/figure><\/div><p> <strong>Lijnhoogte (rijen) automatisch aanpassen:<\/strong> Alt \u2192 H \u2192 O \u2192 A<\/p><h2 class=\"wp-block-heading\"> Stappen om AutoFit-celbreedte te gebruiken met behulp van een sneltoets<\/h2><ol><li> Selecteer eerst de individuele cel of de hele kolom met behulp van de toetsen &#8220;Ctrl + spatiebalk&#8221;. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-select-kolom\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-selectionner-la-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-column\" width=\"334\" height=\"229\"><\/li><li> Druk nu gewoon op \u201cAlt \u2192 H \u2192 O \u2192 I\u201d en de breedte van uw cellen wordt vergroot op basis van de grootste celwaarde in de kolom. <br><img decoding=\"async\" title=\"5 cellen na automatische aanpassing\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-cellules-apres-ajustement-automatique.png\" sizes=\"\" srcset=\"\" alt=\"cells-after-autofit\"><\/li><\/ol><h2 class=\"wp-block-heading\"> Stappen om AutoFit-rijhoogte te gebruiken met behulp van een sneltoets<\/h2><p> Stel dat u ongestructureerde gegevens heeft waarbij u in een kolom waarden in de teruglopende tekst heeft en sommige niet omdat de rijhoogte van de gegevens niet hetzelfde is, en om rijen en AutoFit-kolommen te maken, volgt u de onderstaande stappen: <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-67520\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-donnees-non-structurees-dans-les-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"ongestructureerde gegevens in cellen\" width=\"285\" height=\"306\"><\/figure><\/div><ol><li> Selecteer eerst de kolom en breid de kolombreedte handmatig uit tot een niveau waarop alle waarden kunnen worden afgedekt. <br><img loading=\"lazy\" decoding=\"async\" title=\"7-kolombreedte uitbreiden\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/7-augmenter-la-largeur-de-la-colonne.png\" sizes=\"auto, \" srcset=\"\" alt=\"expand-the-column-width\" width=\"382\" height=\"241\"><\/li><li> Druk daarna gewoon op \u201cAlt \u2192 H \u2192 O \u2192 A\u201d en u krijgt de aangepaste rijhoogte. <br><img loading=\"lazy\" decoding=\"async\" title=\"8 rijen in hoogte verstelbaar door autofit\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/8-rangees-hauteur-ajustee-par-autofit.png\" sizes=\"auto, \" srcset=\"\" alt=\"rows-height-adjusted-by-autofit\" width=\"431\" height=\"223\"><\/li><\/ol><p> Als u in het bovenstaande geval de celsnelkoppeling AutoAanpassen gebruikt om de celbreedte automatisch aan te passen, zal deze niet goed werken omdat automatisch aanpassen niet werkt op ingesloten tekstcellen.<\/p><p> Er kan een mogelijkheid zijn dat er in elke tekstcel een grotere waarde staat. Het is dus raadzaam om de kolom handmatig uit te vouwen en vervolgens de sneltoets Rijhoogte AutoAanpassen te gebruiken.<\/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<\/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\/schilderformaat-1\/\">Schilder formaat<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/tekst-omwikkelen\/\">Tekst omwikkelen<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/commentaar-toevoegen\/\">Commentaar toevoegen<\/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-2200","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 automatisch aanpassen via een Excel-formule?<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leren we hoe u een sneltoets kunt gebruiken om rijen en kolommen in Excel automatisch passend te maken.\" \/>\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\/automatische-aanpassing\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe tekst automatisch aanpassen via een Excel-formule?\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leren we hoe u een sneltoets kunt gebruiken om rijen en kolommen in Excel automatisch passend te maken.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/automatische-aanpassing\/\" \/>\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-debordees.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\/automatische-aanpassing\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/automatische-aanpassing\/\",\"name\":\"Hoe tekst automatisch aanpassen via een Excel-formule?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/automatische-aanpassing\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/automatische-aanpassing\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-debordees.png\",\"datePublished\":\"2023-09-25T06:25:20+00:00\",\"dateModified\":\"2023-12-06T05:50:28+00:00\",\"description\":\"In deze zelfstudie leren we hoe u een sneltoets kunt gebruiken om rijen en kolommen in Excel automatisch passend te maken.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/automatische-aanpassing\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/automatische-aanpassing\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/automatische-aanpassing\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-debordees.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-debordees.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/automatische-aanpassing\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe tekst automatisch aanpassen via een excel-formule?\"}]},{\"@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 automatisch aanpassen via een Excel-formule?","description":"In deze zelfstudie leren we hoe u een sneltoets kunt gebruiken om rijen en kolommen in Excel automatisch passend te maken.","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\/automatische-aanpassing\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe tekst automatisch aanpassen via een Excel-formule?","og_description":"In deze zelfstudie leren we hoe u een sneltoets kunt gebruiken om rijen en kolommen in Excel automatisch passend te maken.","og_url":"https:\/\/exceladvisor.org\/nl\/automatische-aanpassing\/","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-debordees.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\/automatische-aanpassing\/","url":"https:\/\/exceladvisor.org\/nl\/automatische-aanpassing\/","name":"Hoe tekst automatisch aanpassen via een Excel-formule?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/automatische-aanpassing\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/automatische-aanpassing\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-debordees.png","datePublished":"2023-09-25T06:25:20+00:00","dateModified":"2023-12-06T05:50:28+00:00","description":"In deze zelfstudie leren we hoe u een sneltoets kunt gebruiken om rijen en kolommen in Excel automatisch passend te maken.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/automatische-aanpassing\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/automatische-aanpassing\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/automatische-aanpassing\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-debordees.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-valeurs-debordees.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/automatische-aanpassing\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe tekst automatisch aanpassen via een excel-formule?"}]},{"@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\/2200","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=2200"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2200\/revisions"}],"predecessor-version":[{"id":2733,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2200\/revisions\/2733"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=2200"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}