{"id":2202,"date":"2023-09-25T03:07:26","date_gmt":"2023-09-25T03:07:26","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/tabblad-wijzigen\/"},"modified":"2023-12-06T05:49:20","modified_gmt":"2023-12-06T05:49:20","slug":"tabblad-wijzigen","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/tabblad-wijzigen\/","title":{"rendered":"Hoe kan ik van tabblad wisselen via de excel-snelkoppeling?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-3715586782\"><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 kan de gebruiker meerdere tabbladen in een werkmap gebruiken om meerdere gegevens in te voeren en men kan de werkmap met gegevens ook op meerdere tabbladen ontvangen. Om tussen tabbladen te schakelen, kan de gebruiker handmatig schakelen met behulp van een muis door op elke tabbladnaam te klikken, of kan tussen tabbladen schakelen met behulp van de sneltoets.<\/p><p> In deze tutorial hebben we de sneltoets uitgelegd om tussen meerdere tabbladen (werkbladen) in een werkmap te schakelen.<\/p><h2 class=\"wp-block-heading\"> Sneltoets om tussen tabbladen te schakelen in Excel<\/h2><p> <kbd>Ctrl<\/kbd> + <kbd>PgDn<\/kbd> (Pagina omlaag) \u2013 Om naar de juiste tabbladen te gaan <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69484\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-pour-basculer-les-onglets-vers-la-droite.png\" sizes=\"auto, \" srcset=\"\" alt=\"sneltoets om van tabblad naar rechts te wisselen\" width=\"1918\" height=\"393\"><\/figure><\/div><p> <kbd>Ctrl<\/kbd> + <kbd>PgUp<\/kbd> (Page Up) \u2013 Om terug te gaan of naar de linkertabbladen <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69485\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-raccourci-clavier-pour-basculer-les-onglets-vers-la-gauche-png.png\" sizes=\"auto, \" srcset=\"\" alt=\"sneltoets om van tabblad naar links te wisselen\" width=\"1918\" height=\"393\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Stappen om van tabblad te wisselen met behulp van een sneltoets<\/h2><ol><li> Houd de \u201cCtrl\u201d-toets ingedrukt en druk vervolgens op de \u201cPgDn\u201d-toets om naar het volgende tabblad rechts van het huidige tabblad te gaan.<\/li><li> Of Houd de \u201cCtrl\u201d-toets ingedrukt en druk vervolgens op de \u201cPgUp\u201d-toets om terug te keren naar de linkertabbladen van het huidige tabblad.<\/li><\/ol><h2 class=\"wp-block-heading\"> Afhaalrestaurants<\/h2><ol><li> De gebruiker moet meerdere keren op de \u201cPgDn\u201d- of PgUp\u201d-toets drukken om naar meerdere tabbladen te schakelen totdat hij naar het gewenste tabblad gaat.<\/li><li> Als de werkmap bijvoorbeeld 15-20 of meer tabbladen heeft, is het geen goede optie om te wisselen met behulp van de sneltoets, omdat de sneltoets niet rechtstreeks naar de tabbladen schakelt, maar tabblad voor tabblad wordt verplaatst. In dit geval kunnen we dus op de browsertekens op de schuifbalk hieronder klikken en met de pijltjestoetsen omhoog en omlaag op het toetsenbord kunnen we het tabblad (spreadsheet) selecteren en op Enter drukken om rechtstreeks naar dit tabblad te gaan <\/li><\/ol><div class=\"wp-block-image\"><figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-69486\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-signe-de-navigation-sous-la-barre-de-defilement.png\" sizes=\"auto, \" srcset=\"\" alt=\"browser-teken-onder-schuifbalk\" width=\"379\" height=\"375\"><\/figure><\/div><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-39\"><div class=\"wp-block-column is-layout-flow\"><ul><li> <a href=\"https:\/\/exceladvisor.org\/nl\/dichtbij\/\">Dichtbij<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/volledig-scherm\/\">Volledig scherm<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/band\/\">Band<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/opslaan-als\/\">Opslaan als<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/ongedaan-maken-opnieuw\/\">Ongedaan maken en opnieuw uitvoeren<\/a><\/li><\/ul><\/div><div class=\"wp-block-column is-layout-flow\"><\/div><\/div><p> \u21e0 Terug naar <a href=\"https:\/\/exceladvisor.org\/nl\/toetsenbord-sneltoetsen\/\">Excel-snelkoppelingen (PDF-spiekbriefje)<\/a><\/p><\/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-2202","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 kan ik van tabblad wisselen via de Excel-snelkoppeling?<\/title>\n<meta name=\"description\" content=\"In deze zelfstudie leert u hoe u een sneltoets gebruikt om tussen tabbladen (werkbladen) in Excel te schakelen. Nu dit\" \/>\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\/tabblad-wijzigen\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u25b7 Hoe kan ik van tabblad wisselen via de Excel-snelkoppeling?\" \/>\n<meta property=\"og:description\" content=\"In deze zelfstudie leert u hoe u een sneltoets gebruikt om tussen tabbladen (werkbladen) in Excel te schakelen. Nu dit\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/tabblad-wijzigen\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:49:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-pour-basculer-les-onglets-vers-la-droite.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\/tabblad-wijzigen\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/tabblad-wijzigen\/\",\"name\":\"\u25b7 Hoe kan ik van tabblad wisselen via de Excel-snelkoppeling?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tabblad-wijzigen\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tabblad-wijzigen\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-pour-basculer-les-onglets-vers-la-droite.png\",\"datePublished\":\"2023-09-25T03:07:26+00:00\",\"dateModified\":\"2023-12-06T05:49:20+00:00\",\"description\":\"In deze zelfstudie leert u hoe u een sneltoets gebruikt om tussen tabbladen (werkbladen) in Excel te schakelen. Nu dit\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/tabblad-wijzigen\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/tabblad-wijzigen\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/tabblad-wijzigen\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-pour-basculer-les-onglets-vers-la-droite.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-pour-basculer-les-onglets-vers-la-droite.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/tabblad-wijzigen\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe kan ik van tabblad wisselen via 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":"\u25b7 Hoe kan ik van tabblad wisselen via de Excel-snelkoppeling?","description":"In deze zelfstudie leert u hoe u een sneltoets gebruikt om tussen tabbladen (werkbladen) in Excel te schakelen. Nu dit","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\/tabblad-wijzigen\/","og_locale":"nl_NL","og_type":"article","og_title":"\u25b7 Hoe kan ik van tabblad wisselen via de Excel-snelkoppeling?","og_description":"In deze zelfstudie leert u hoe u een sneltoets gebruikt om tussen tabbladen (werkbladen) in Excel te schakelen. Nu dit","og_url":"https:\/\/exceladvisor.org\/nl\/tabblad-wijzigen\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:49:20+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-pour-basculer-les-onglets-vers-la-droite.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\/tabblad-wijzigen\/","url":"https:\/\/exceladvisor.org\/nl\/tabblad-wijzigen\/","name":"\u25b7 Hoe kan ik van tabblad wisselen via de Excel-snelkoppeling?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/tabblad-wijzigen\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/tabblad-wijzigen\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-pour-basculer-les-onglets-vers-la-droite.png","datePublished":"2023-09-25T03:07:26+00:00","dateModified":"2023-12-06T05:49:20+00:00","description":"In deze zelfstudie leert u hoe u een sneltoets gebruikt om tussen tabbladen (werkbladen) in Excel te schakelen. Nu dit","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/tabblad-wijzigen\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/tabblad-wijzigen\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/tabblad-wijzigen\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-pour-basculer-les-onglets-vers-la-droite.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-raccourci-clavier-pour-basculer-les-onglets-vers-la-droite.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/tabblad-wijzigen\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe kan ik van tabblad wisselen via 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\/2202","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=2202"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2202\/revisions"}],"predecessor-version":[{"id":2609,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/2202\/revisions\/2609"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=2202"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}