{"id":2119,"date":"2023-10-14T20:26:54","date_gmt":"2023-10-14T20:26:54","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/"},"modified":"2023-12-06T05:56:32","modified_gmt":"2023-12-06T05:56:32","slug":"deselecteer-cellen","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/","title":{"rendered":"Hoe cellen in excel te deselecteren?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-2402847065\"><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>Tot nu toe had Excel niet de mogelijkheid om cellen of een bereik uit het geselecteerde celbereik te deselecteren. Niemand kon dus cellen of een bereik van cellen uit hun selectie deselecteren.<\/p><p> Maar nu heeft Excel de functie ge\u00efntroduceerd om geselecteerde cellen of een celbereik uit uw huidige selectie te deselecteren. Op het moment dat deze blog wordt geschreven, is deze nieuwe functie alleen beschikbaar voor pc- en Mac Office 365- en Excel 2019-abonnees.<\/p><p> Hieronder hebben we enkele snelle en eenvoudige stappen vastgelegd waarmee u cellen in Excel kunt deselecteren en selecteren<\/p><h2 id=\"deselect-cells-in-excel\" class=\"wp-block-heading\"> Deselecteer cellen in Excel<\/h2><p> Nadat u de functie Cellen deselecteren in Excel hebt toegevoegd, wordt het eenvoudig om de cellen die u niet nodig heeft uit uw huidige selectie te deselecteren.<\/p><ul><li> Houd eerst de \u201cControl\u201d-toets op het toetsenbord ingedrukt.<\/li><li> Klik daarna op de cellen in uw huidige selectie die u uit de selectie wilt deselecteren. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64054\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png\" sizes=\"auto, \" srcset=\"\" alt=\"deselecteer cellen\" width=\"580\" height=\"284\"><\/figure><\/div><p> In de voorbeeldafbeelding hierboven hielden we de Control-toets ingedrukt en klikten op de cellen B1, B3 en B7 om die kolommen uit de huidige selectie (A1-I15) te deselecteren. Na selectie kunt u zien dat de geselecteerde kolommen zijn gedeselecteerd.<\/p><h2 id=\"deselect-the-entire-columns-in-excel\" class=\"wp-block-heading\"> Deselecteer volledige kolommen in Excel<\/h2><ul><li> Houd eerst de \u201cControl\u201d-toets op het toetsenbord ingedrukt.<\/li><li> Klik daarna op de kolomkop en sleep naar de hele kolom om die kolom uit uw huidige selectie te deselecteren. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64055\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-deselectionner-la-colonne-entiere.png\" sizes=\"auto, \" srcset=\"\" alt=\"deselecteer-hele-kolom\" width=\"654\" height=\"303\"><\/figure><\/div><p> In de voorbeeldafbeelding hierboven hielden we de Control-toets ingedrukt en klikten op de kolomkop (Categorie), en sleepten de hele kolom naar D15 en deden hetzelfde voor de kolomkop (Zone) om deze twee volledige kolommen (D &amp; F) uit de huidige selectie (A1-I15).<\/p><h2 id=\"select-cells-or-ranges-in-excel\" class=\"wp-block-heading\"> Selecteer cellen of bereiken in Excel<\/h2><p> Er is geen verandering in de celselectie of het celbereik in Excel. Het celselectieproces is hetzelfde en wordt hieronder weergegeven:<\/p><ul><li> Voor aaneengesloten cellen selecteert u de cel waaruit u uw selectie wilt maken<\/li><li> Houd daarna de \u201cShift\u201d-knop op het toetsenbord ingedrukt en klik vervolgens op de andere cel waartoe u een selectie wilt maken<\/li><li> Of selecteer de cel waaruit u uw selectie wilt maken en sleep deze vervolgens naar de cel waarin u een selectie wilt maken. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64056\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-selectionner-des-cellules-contigues.png\" sizes=\"auto, \" srcset=\"\" alt=\"selecteer aangrenzende cellen\" width=\"589\" height=\"295\"><\/figure><\/div><p> In de voorbeeldafbeelding hierboven hebben we eerst Shift ingedrukt gehouden op cel A1 en vervolgens rechtstreeks op cel I15 geklikt om een selectie te maken van (A1-I15).<\/p><ul><li> Voor niet-aaneengesloten cellen houdt u de Control-toets ingedrukt en selecteert u vervolgens de gewenste cellen of bereiken als selectie. <\/li><\/ul><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-64057\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-selectionner-des-cellules-non-contigues.png\" sizes=\"auto, \" srcset=\"\" alt=\"selecteer niet-aangrenzende cellen\" width=\"646\" height=\"266\"><\/figure><\/div><p> In de voorbeeldafbeelding hierboven hielden we de Control-toets ingedrukt en selecteerden we de niet-aaneengesloten celbereiken.<\/p><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\/verwijder-verborgen-rijkolommen\/\">Verwijder verborgen rijen in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/voeg-een-kolom-toe\/\">Voeg een kolom toe in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/selecteer-niet-aangrenzende-cellen\/\">Selecteer niet-aangrenzende cellen in Excel<\/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-2119","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 cellen in Excel te deselecteren? (Tutorial 2023)<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leert u hoe u cellen in Excel kunt deselecteren. En u leert ook hoe u een\" \/>\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\/deselecteer-cellen\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe cellen in Excel te deselecteren? (Tutorial 2023)\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leert u hoe u cellen in Excel kunt deselecteren. En u leert ook hoe u een\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:56:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-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=\"2 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/\",\"name\":\"Hoe cellen in Excel te deselecteren? (Tutorial 2023)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png\",\"datePublished\":\"2023-10-14T20:26:54+00:00\",\"dateModified\":\"2023-12-06T05:56:32+00:00\",\"description\":\"In deze zelfstudie leert u hoe u cellen in Excel kunt deselecteren. En u leert ook hoe u een\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe cellen in excel te deselecteren?\"}]},{\"@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 cellen in Excel te deselecteren? (Tutorial 2023)","description":"In deze zelfstudie leert u hoe u cellen in Excel kunt deselecteren. En u leert ook hoe u een","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\/deselecteer-cellen\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe cellen in Excel te deselecteren? (Tutorial 2023)","og_description":"In deze zelfstudie leert u hoe u cellen in Excel kunt deselecteren. En u leert ook hoe u een","og_url":"https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:56:32+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.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\/deselecteer-cellen\/","url":"https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/","name":"Hoe cellen in Excel te deselecteren? (Tutorial 2023)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png","datePublished":"2023-10-14T20:26:54+00:00","dateModified":"2023-12-06T05:56:32+00:00","description":"In deze zelfstudie leert u hoe u cellen in Excel kunt deselecteren. En u leert ook hoe u een","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-deselectionner-les-cellules.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/deselecteer-cellen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe cellen in excel te deselecteren?"}]},{"@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\/2119","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=2119"}],"version-history":[{"count":2,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2119\/revisions"}],"predecessor-version":[{"id":3059,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2119\/revisions\/3059"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=2119"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}