{"id":2206,"date":"2023-09-25T00:44:32","date_gmt":"2023-09-25T00:44:32","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/randen-toepassen\/"},"modified":"2023-12-06T05:50:43","modified_gmt":"2023-12-06T05:50:43","slug":"randen-toepassen","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/randen-toepassen\/","title":{"rendered":"Hoe pas ik een rand toe via een excel-snelkoppeling?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-1595521764\"><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 past geen rand toe op de cel, maar er zijn verschillende soorten randopties beschikbaar die handmatig door gebruikers of met behulp van sneltoetsen op cellen, bereik of werkblad kunnen worden toegepast.<\/p><p> In deze zelfstudie hebben we enkele sneltoetsen uitgelegd om randen in Excel toe te passen.<\/p><h2 class=\"wp-block-heading\"> Sneltoetsen om rand toe te passen in Excel<\/h2><p> De meest gebruikte randoptie is &#8220;Alle randen&#8221;, waarmee een rand aan alle zijden van de cel wordt toegepast.<\/p><p> <kbd>Alt<\/kbd> \u2192 <kbd>H<\/kbd> \u2192 <kbd>B<\/kbd> \u2192 <kbd>A<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70418\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png\" sizes=\"auto, \" srcset=\"\" alt=\"snelkoppeling naar toepassingsrand\" width=\"774\" height=\"303\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Stappen voor het toepassen van een rand met behulp van een sneltoets<\/h2><ul><li> Selecteer eerst de cel, het celbereik of de volledige gegevens in het werkblad met behulp van &#8220;Ctrl + A&#8221; om de cellen te selecteren waarop u randen wilt toepassen. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-select-bereik\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-selectionner-la-gamme.png\" sizes=\"auto, \" srcset=\"\" alt=\"select-the-range\" width=\"437\" height=\"206\"><\/li><li> Druk daarna achtereenvolgens op Alt \u2192 H \u2192 B \u2192 A en de randen worden op alle zijden van elke geselecteerde cel toegepast. <br><img loading=\"lazy\" decoding=\"async\" title=\"3 randen toegepast op cellen\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-bordure-appliquee-aux-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"border-applied-to-the-cells\" width=\"438\" height=\"207\"><\/li><\/ul><h2 class=\"wp-block-heading\"> Sneltoetsen om verschillende soorten randen toe te passen<\/h2><p> De sneltoetscombinatie voor het toepassen van alle soorten randen is hetzelfde, behalve dat de laatste toets in de combinatie verandert, afhankelijk van het type rand dat u wilt toepassen.<\/p><ol><li> Randen toepassen op de onderkant van cellen: <kbd>Alt<\/kbd> \u2192 <kbd>H<\/kbd> \u2192 <kbd>B<\/kbd> \u2192 <kbd>O<\/kbd><\/li><li> Randen toepassen op de bovenkant van cellen: Alt \u2192 H \u2192 B \u2192 P<\/li><li> Randen links van cellen toepassen: Alt \u2192 H \u2192 B \u2192 L<\/li><li> Randen rechts van cellen toepassen: Alt \u2192 H \u2192 B \u2192 R<\/li><li> Pas randen alleen toe buiten het geselecteerde bereik: Alt \u2192 H \u2192 B \u2192 S<\/li><li> Pas dikke randen alleen toe buiten het geselecteerde bereik: Alt \u2192 H \u2192 B \u2192 T<\/li><li> Dubbele randen toepassen op de onderkant van cellen: Alt \u2192 H \u2192 B \u2192 B<\/li><li> Breng dikke dubbele randen aan op de onderkant van de cellen: Alt \u2192 H \u2192 B \u2192 H <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70421\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-types-de-bordures-multiples.png\" sizes=\"auto, \" srcset=\"\" alt=\"meerdere randtypen\" width=\"225\" height=\"512\"><\/figure><\/div><p> Om meer randopties te vinden en toe te passen, drukt u op \u201cAlt \u2192 H \u2192 B \u2192 M\u201d en u krijgt het dialoogvenster \u201cCellen opmaken\u201d geopend met meer randopties waaruit u kunt kiezen. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-70422\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-autres-options-de-bordure.png\" sizes=\"auto, \" srcset=\"\" alt=\"meer randopties\" width=\"549\" height=\"441\"><\/figure><\/div><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\/automatische-aanpassing\/\">Automatische aanpassing<\/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\"><\/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-2206","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>\u25b7 Hoe pas ik een rand toe via een Excel-snelkoppeling?<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leert u hoe u een sneltoets gebruikt om randen toe te passen in Excel en alle bijbehorende informatie.\" \/>\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\/randen-toepassen\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hoe pas ik een rand toe via een Excel-snelkoppeling?\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leert u hoe u een sneltoets gebruikt om randen toe te passen in Excel en alle bijbehorende informatie.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/randen-toepassen\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:50:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.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\/randen-toepassen\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/randen-toepassen\/\",\"name\":\"\u25b7 Hoe pas ik een rand toe via een Excel-snelkoppeling?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/randen-toepassen\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/randen-toepassen\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png\",\"datePublished\":\"2023-09-25T00:44:32+00:00\",\"dateModified\":\"2023-12-06T05:50:43+00:00\",\"description\":\"In deze zelfstudie leert u hoe u een sneltoets gebruikt om randen toe te passen in Excel en alle bijbehorende informatie.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/randen-toepassen\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/randen-toepassen\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/randen-toepassen\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/randen-toepassen\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe pas ik een rand toe via een excel-snelkoppeling?\"}]},{\"@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":"\u25b7 Hoe pas ik een rand toe via een Excel-snelkoppeling?","description":"In deze zelfstudie leert u hoe u een sneltoets gebruikt om randen toe te passen in Excel en alle bijbehorende informatie.","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\/randen-toepassen\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe pas ik een rand toe via een Excel-snelkoppeling?","og_description":"In deze zelfstudie leert u hoe u een sneltoets gebruikt om randen toe te passen in Excel en alle bijbehorende informatie.","og_url":"https:\/\/exceladvisor.org\/nl\/randen-toepassen\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:50:43+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.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\/randen-toepassen\/","url":"https:\/\/exceladvisor.org\/nl\/randen-toepassen\/","name":"\u25b7 Hoe pas ik een rand toe via een Excel-snelkoppeling?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/randen-toepassen\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/randen-toepassen\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png","datePublished":"2023-09-25T00:44:32+00:00","dateModified":"2023-12-06T05:50:43+00:00","description":"In deze zelfstudie leert u hoe u een sneltoets gebruikt om randen toe te passen in Excel en alle bijbehorende informatie.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/randen-toepassen\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/randen-toepassen\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/randen-toepassen\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-appliquer-la-bordure.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/randen-toepassen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe pas ik een rand toe via een excel-snelkoppeling?"}]},{"@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\/2206","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=2206"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2206\/revisions"}],"predecessor-version":[{"id":2776,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2206\/revisions\/2776"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=2206"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}