{"id":1630,"date":"2023-11-14T19:39:30","date_gmt":"2023-11-14T19:39:30","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/verwijder-verborgen-rijkolommen\/"},"modified":"2023-12-06T05:51:08","modified_gmt":"2023-12-06T05:51:08","slug":"verwijder-verborgen-rijkolommen","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/verwijder-verborgen-rijkolommen\/","title":{"rendered":"Hoe verborgen rijen in excel verwijderen?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-2977212458\"><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>Soms verbergen gebruikers tijdens het werken aan Excel-gegevens meerdere rijen en kolommen die ze niet willen zien, en later, na het voorbereiden van de gegevens, is het verwijderen van deze meerdere verborgen rijen en kolommen in de gegevens een vervelende taak.<\/p><p> Om dit te ondervangen heeft Excel een ingebouwde functie om verborgen rijen en kolommen in \u00e9\u00e9n keer te vinden en te verwijderen. Hier zijn enkele snelle en eenvoudige stappen om alle verborgen rijen of kolommen in Excel te verwijderen. <\/p><h2 id=\"delete-all-hidden-rows-or-columns-in-excel-using-inspect-document\" class=\"wp-block-heading\">Verwijder alle verborgen rijen of kolommen in Excel met Document inspecteren<\/h2><ol><li> Klik eerst op het tabblad &#8220;Bestand&#8221;. <br><img loading=\"lazy\" decoding=\"async\" title=\"1-bestand-tabblad\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png\" sizes=\"auto, \" srcset=\"\" alt=\"file-tab\" width=\"544\" height=\"120\"><\/li><li> Klik daarna op \u201cInfo\u201d in het contextmenu, klik vervolgens op \u201cControleren op problemen\u201d en vervolgens op \u201cDocument inspecteren\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"2-inspectie-document\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-inspecter-le-document.png\" sizes=\"auto, \" srcset=\"\" alt=\"inspect-document\" width=\"602\" height=\"506\"><\/li><li> Zodra u op &#8216;Document inspecteren&#8217; klikt, opent Excel het menu &#8216;Documentinspecteur&#8217;.<\/li><li> Nu hoeft u alleen maar op de knop &#8220;Inspecteren&#8221; te klikken. <br><img loading=\"lazy\" decoding=\"async\" title=\"3-document-inspecteur\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-inspecteur-de-documents.png\" sizes=\"auto, \" srcset=\"\" alt=\"document-inspector\" width=\"450\" height=\"417\"><\/li><li> Klik aan het einde op \u201cAlles verwijderen\u201d in de selectie \u201cVerborgen rijen en kolommen\u201d. <br><img loading=\"lazy\" decoding=\"async\" title=\"4-alles verwijderen\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-supprimer-tout.png\" sizes=\"auto, \" srcset=\"\" alt=\"remove-all\" width=\"452\" height=\"421\"><\/li><li> Op dit punt zijn alle verborgen rijen of kolommen in Excel verwijderd. <br><img loading=\"lazy\" decoding=\"async\" title=\"5 verborgen rijen en kolommen\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-lignes-et-colonnes-masquees.png\" sizes=\"auto, \" srcset=\"\" alt=\"hidden-rows-and-columns\" width=\"451\" height=\"415\"><\/li><\/ol><h2 id=\"delete-all-hidden-rows-or-column-using-vba-macros\" class=\"wp-block-heading\"> Verwijder alle verborgen rijen of kolommen met VBA<\/h2><p> In de volgende twee codes kunt u de rijen en kolommen uit het gebruikte bereik verwijderen die verborgen zijn.<\/p><pre class=\"wp-block-code\"> <code class=\"language-visual-basic line-numbers\" lang=\"visual-basic\">Sub delete_hidden_columns() Dim ws As Worksheet Dim iCol As Integer Set ws = ActiveSheet iCol = ws.UsedRange.Columns(ws.UsedRange.Columns.Count).Column For i = iCol To 1 Step -1 If Columns(i).Hidden = True Then Columns(i).EntireColumn.Delete Next End Sub '------------------------------------------------- Sub delete_hidden_rows() Dim ws As Worksheet Dim iRow As Integer Set ws = ActiveSheet iRow = ws.UsedRange.Columns(ws.UsedRange.Rows.Count).Row For i = iRow To 1 Step -1 If Rows(i).Hidden = True Then Rows(i).EntireRow.Delete Next End Sub<\/code><\/pre><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-basisbeginselen\/\">Basiskennis van Microsoft Excel (componenten, onderdelen en kennisnotities)<\/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\/toevoegen-hyperlinks-verwijderen\/\">Hyperlinks toevoegen en verwijderen in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/voeg-een-watermerk-toe\/\">Voeg een watermerk toe in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/\">Deselecteer cellen in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/voeg-een-kolom-toe\/\">Voeg een kolom toe in Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/lijnen-verwijderen\/\">Verwijder een rij of meerdere rijen in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/kolom-kopieren\/\">Kopieer en plak een kolom in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/rij-kolom-verplaatsen\/\">Verplaats een rij en kolom in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/kolombreedte\/\">Hoe u de kolombreedte in Excel kunt wijzigen<\/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-1630","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 verborgen rijen in Excel verwijderen?<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leert u hoe u alle verborgen rijen en kolommen op twee verschillende manieren kunt verwijderen.\" \/>\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\/verwijder-verborgen-rijkolommen\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hoe verborgen rijen in Excel verwijderen?\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leert u hoe u alle verborgen rijen en kolommen op twee verschillende manieren kunt verwijderen.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/verwijder-verborgen-rijkolommen\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:51:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.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\/verwijder-verborgen-rijkolommen\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/verwijder-verborgen-rijkolommen\/\",\"name\":\"\u25b7 Hoe verborgen rijen in Excel verwijderen?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/verwijder-verborgen-rijkolommen\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/verwijder-verborgen-rijkolommen\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png\",\"datePublished\":\"2023-11-14T19:39:30+00:00\",\"dateModified\":\"2023-12-06T05:51:08+00:00\",\"description\":\"In deze zelfstudie leert u hoe u alle verborgen rijen en kolommen op twee verschillende manieren kunt verwijderen.\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/verwijder-verborgen-rijkolommen\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/verwijder-verborgen-rijkolommen\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/verwijder-verborgen-rijkolommen\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/verwijder-verborgen-rijkolommen\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe verborgen rijen in excel verwijderen?\"}]},{\"@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 verborgen rijen in Excel verwijderen?","description":"In deze zelfstudie leert u hoe u alle verborgen rijen en kolommen op twee verschillende manieren kunt verwijderen.","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\/verwijder-verborgen-rijkolommen\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe verborgen rijen in Excel verwijderen?","og_description":"In deze zelfstudie leert u hoe u alle verborgen rijen en kolommen op twee verschillende manieren kunt verwijderen.","og_url":"https:\/\/exceladvisor.org\/nl\/verwijder-verborgen-rijkolommen\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:51:08+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.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\/verwijder-verborgen-rijkolommen\/","url":"https:\/\/exceladvisor.org\/nl\/verwijder-verborgen-rijkolommen\/","name":"\u25b7 Hoe verborgen rijen in Excel verwijderen?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/verwijder-verborgen-rijkolommen\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/verwijder-verborgen-rijkolommen\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png","datePublished":"2023-11-14T19:39:30+00:00","dateModified":"2023-12-06T05:51:08+00:00","description":"In deze zelfstudie leert u hoe u alle verborgen rijen en kolommen op twee verschillende manieren kunt verwijderen.","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/verwijder-verborgen-rijkolommen\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/verwijder-verborgen-rijkolommen\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/verwijder-verborgen-rijkolommen\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-onglet-fichier.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/verwijder-verborgen-rijkolommen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe verborgen rijen in excel verwijderen?"}]},{"@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\/1630","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=1630"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1630\/revisions"}],"predecessor-version":[{"id":2820,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1630\/revisions\/2820"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1630"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}