{"id":2079,"date":"2023-10-20T04:08:08","date_gmt":"2023-10-20T04:08:08","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/selecteer-een-lijn\/"},"modified":"2023-12-06T05:50:52","modified_gmt":"2023-12-06T05:50:52","slug":"selecteer-een-lijn","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/selecteer-een-lijn\/","title":{"rendered":"Hoe rijen selecteren met de excel-snelkoppeling?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-3098308097\"><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>Een Excel-spreadsheet is een combinatie van verschillende rijen en kolommen met cellen.<\/p><p> Bij het werken in Excel is dit het aantal keren dat gebruikers een rij willen selecteren om verschillende redenen, zoals het verwijderen van de specifieke rij, het opmaken van de specifieke rij of het invoegen van een nieuwe rij boven de geselecteerde regel.<\/p><p> Het wordt dus belangrijk dat elke Excel-gebruiker bekend is met de sneltoets voor het selecteren van de rij(en), en in deze tutorial hebben we hetzelfde aan u uitgelegd.<\/p><h2 class=\"wp-block-heading\"> Sneltoets om een rij in Excel te selecteren<\/h2><p> <kbd>Shift<\/kbd> + <kbd>spatie<\/kbd> <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69476\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-selectionner-la-ligne.png\" sizes=\"auto, \" srcset=\"\" alt=\"sneltoets om een lijn te selecteren\" width=\"805\" height=\"316\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Stappen om rij(en) te selecteren met behulp van een sneltoets<\/h2><ul><li> Ga eerst naar een cel in de rij die u wilt selecteren. <br><img decoding=\"async\" title=\"2 cellen op rij\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-cellules-dans-la-rangee.png\" sizes=\"\" srcset=\"\" alt=\"cell-in-the-row\"><\/li><li> Druk daarna gewoon op &#8220;Shift + Spatiebalk&#8221; en uw rij wordt geselecteerd en gemarkeerd.<\/li><li> Als u nu de geselecteerde regel(s) wilt verwijderen, drukt u op \u201cCtrl + \u2013\u201d (minteken), of als u de nieuwe regel boven de geselecteerde regel wilt toevoegen, drukt u op \u201cCtrl + +\u201d (plusteken) of ga naar opmaak als u alleen de geselecteerde rij wilt opmaken.<\/li><li> Om meerdere regels naast de geselecteerde regel te selecteren, drukt u op de toetsen &#8220;Shift + Pijl-omlaag&#8221; of &#8220;Shift + Pijl-omhoog&#8221; om de lijnen omlaag of omhoog te selecteren. <br><img decoding=\"async\" title=\"3 lijnen geselecteerd\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-ligne-selectionnee.png\" sizes=\"\" srcset=\"\" alt=\"selected-row\"><\/li><\/ul><h2 class=\"wp-block-heading\"> Afhaalrestaurants<\/h2><ul><li> Om meerdere niet-aangrenzende lijnen te selecteren, wordt aanbevolen om de lijnen te selecteren met de muis of met behulp van de filteroptie.<\/li><li> Als u meerdere gegevenssets in het huidige blad heeft, is het beter om de gegevenssets naar tabellen te converteren, omdat in tabellen &#8220;Shift + Spatiebalk&#8221; alleen de rij in de tabel selecteert, en zonder tabellen selecteert het de hele rij van begin tot eind in de tabel. spreadsheet. <\/li><\/ul><div class=\"wp-block-group more-tutorials is-layout-flow\"><div class=\"wp-block-group__inner-container\"><h2 class=\"wp-block-heading\"> Meer tutorials <\/h2><div class=\"wp-block-columns is-layout-flex wp-container-47\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/absolute-referentie\/\">Absolute referentie<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/kopieren-plakken\/\">Knippen en plakken<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/knip-en-plak\/\">Knip en plak<\/a><\/li><li> Cellen vergrendelen<\/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-2079","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 rijen selecteren met de Excel-snelkoppeling?<\/title>\n<meta name=\"description\" content=\"Leer hoe u een sneltoets gebruikt om een geselecteerde rij in Excel toe te passen. Deze sneltoets bevat nu ...\" \/>\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\/selecteer-een-lijn\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe rijen selecteren met de Excel-snelkoppeling?\" \/>\n<meta property=\"og:description\" content=\"Leer hoe u een sneltoets gebruikt om een geselecteerde rij in Excel toe te passen. Deze sneltoets bevat nu ...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/selecteer-een-lijn\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:50:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-selectionner-la-ligne.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\/selecteer-een-lijn\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/selecteer-een-lijn\/\",\"name\":\"Hoe rijen selecteren met de Excel-snelkoppeling?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/selecteer-een-lijn\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/selecteer-een-lijn\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-selectionner-la-ligne.png\",\"datePublished\":\"2023-10-20T04:08:08+00:00\",\"dateModified\":\"2023-12-06T05:50:52+00:00\",\"description\":\"Leer hoe u een sneltoets gebruikt om een geselecteerde rij in Excel toe te passen. Deze sneltoets bevat nu ...\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/selecteer-een-lijn\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/selecteer-een-lijn\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/selecteer-een-lijn\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-selectionner-la-ligne.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-selectionner-la-ligne.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/selecteer-een-lijn\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe rijen selecteren met de 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":"Hoe rijen selecteren met de Excel-snelkoppeling?","description":"Leer hoe u een sneltoets gebruikt om een geselecteerde rij in Excel toe te passen. Deze sneltoets bevat nu ...","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\/selecteer-een-lijn\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe rijen selecteren met de Excel-snelkoppeling?","og_description":"Leer hoe u een sneltoets gebruikt om een geselecteerde rij in Excel toe te passen. Deze sneltoets bevat nu ...","og_url":"https:\/\/exceladvisor.org\/nl\/selecteer-een-lijn\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:50:52+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-selectionner-la-ligne.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\/selecteer-een-lijn\/","url":"https:\/\/exceladvisor.org\/nl\/selecteer-een-lijn\/","name":"Hoe rijen selecteren met de Excel-snelkoppeling?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/selecteer-een-lijn\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/selecteer-een-lijn\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-selectionner-la-ligne.png","datePublished":"2023-10-20T04:08:08+00:00","dateModified":"2023-12-06T05:50:52+00:00","description":"Leer hoe u een sneltoets gebruikt om een geselecteerde rij in Excel toe te passen. Deze sneltoets bevat nu ...","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/selecteer-een-lijn\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/selecteer-een-lijn\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/selecteer-een-lijn\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-selectionner-la-ligne.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-pour-selectionner-la-ligne.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/selecteer-een-lijn\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe rijen selecteren met de 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\/2079","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=2079"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2079\/revisions"}],"predecessor-version":[{"id":2798,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2079\/revisions\/2798"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=2079"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}