{"id":2322,"date":"2023-07-22T18:55:57","date_gmt":"2023-07-22T18:55:57","guid":{"rendered":"https:\/\/statorials.org\/nl\/google-spreadsheets-vervangen-lege-cellen-door-nul\/"},"modified":"2023-07-22T18:55:57","modified_gmt":"2023-07-22T18:55:57","slug":"google-spreadsheets-vervangen-lege-cellen-door-nul","status":"publish","type":"post","link":"https:\/\/statorials.org\/nl\/google-spreadsheets-vervangen-lege-cellen-door-nul\/","title":{"rendered":"Lege cellen vervangen door nul in google spreadsheets"},"content":{"rendered":"<p><\/p>\n<hr>\n<p><span style=\"color: #000000;\">De eenvoudigste manier om lege cellen te vervangen door nullen in Google Spreadsheets is door de functie <strong>Zoeken en vervangen<\/strong> op het tabblad <strong>Bewerken<\/strong> te gebruiken.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Het volgende voorbeeld laat zien hoe u deze functie in de praktijk kunt gebruiken.<\/span><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Voorbeeld: Vervang lege cellen door nul in Google Spreadsheets<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">Stel dat we de volgende gegevens hebben die de punten laten zien die door verschillende basketbalteams zijn gescoord:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21112 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacer21.png\" alt=\"\" width=\"478\" height=\"483\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Stel dat we lege cellen in de kolom Punten willen vervangen door nullen.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Om dit te doen, klikt u op het tabblad <strong>Bewerken<\/strong> en vervolgens op <strong>Zoeken en vervangen<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21113 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacer22.png\" alt=\"\" width=\"384\" height=\"493\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">In het nieuwe venster dat verschijnt typt u <strong>^\\s*$<\/strong> om lege cellen te vinden en gebruikt u <strong>0<\/strong> als vervanging.<\/span><\/p>\n<p> <span style=\"color: #000000;\">Typ het celbereik waarop u deze formule wilt gebruiken en vink vervolgens de vakjes aan naast <strong>Hoofdlettergebruik<\/strong> en <strong>Zoeken met reguliere expressies<\/strong> .<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter wp-image-21114\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacer23.png\" alt=\"Google Spreadsheets vervangt lege cellen door nullen\" width=\"557\" height=\"505\" srcset=\"\" sizes=\"auto, \"><\/p>\n<p> <span style=\"color: #000000;\">Klik vervolgens op <strong>Alles vervangen<\/strong> en klik vervolgens op <strong>Gereed<\/strong> .<\/span><\/p>\n<p> <span style=\"color: #000000;\">Elk van de lege cellen in de kolom Punten wordt automatisch vervangen door nullen:<\/span> <\/p>\n<p><img decoding=\"async\" loading=\"lazy\" class=\" wp-image-21115 aligncenter\" src=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacer24.png\" alt=\"\" width=\"466\" height=\"419\" srcset=\"\" sizes=\"auto, \"><\/p>\n<h3> <span style=\"color: #000000;\"><strong>Aanvullende bronnen<\/strong><\/span><\/h3>\n<p> <span style=\"color: #000000;\">In de volgende tutorials wordt uitgelegd hoe u andere veelvoorkomende taken in Google Spreadsheets kunt uitvoeren:<\/span><\/p>\n<p> <a href=\"https:\/\/statorials.org\/nl\/aantal-exemplaren-van-google-spreadsheets\/\" target=\"_blank\" rel=\"noopener\">Hoe u het aantal gebeurtenissen in Google Spreadsheets kunt tellen<\/a><br \/> <a href=\"https:\/\/statorials.org\/nl\/google-spreadsheets-vinden-waarde-binnen-bereik\/\" target=\"_blank\" rel=\"noopener\">Hoe u kunt controleren of de waarde binnen het bereik valt in Google Spreadsheets<\/a><br \/> <a href=\"https:\/\/statorials.org\/nl\/google-spreadsheets-tellen-unieke-waarden\/\" target=\"_blank\" rel=\"noopener\">Hoe u unieke waarden kunt tellen in Google Spreadsheets<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>De eenvoudigste manier om lege cellen te vervangen door nullen in Google Spreadsheets is door de functie Zoeken en vervangen op het tabblad Bewerken te gebruiken. Het volgende voorbeeld laat zien hoe u deze functie in de praktijk kunt gebruiken. Voorbeeld: Vervang lege cellen door nul in Google Spreadsheets Stel dat we de volgende gegevens [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[11],"tags":[],"class_list":["post-2322","post","type-post","status-publish","format-standard","hentry","category-gids"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Lege cellen vervangen door nul in Google Spreadsheets - Statorials<\/title>\n<meta name=\"description\" content=\"In deze tutorial wordt uitgelegd hoe u lege cellen vervangt door nullen in Google Spreadsheets, met verschillende voorbeelden.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/statorials.org\/nl\/google-spreadsheets-vervangen-lege-cellen-door-nul\/\" \/>\n<meta property=\"og:locale\" content=\"de_DE\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Lege cellen vervangen door nul in Google Spreadsheets - Statorials\" \/>\n<meta property=\"og:description\" content=\"In deze tutorial wordt uitgelegd hoe u lege cellen vervangt door nullen in Google Spreadsheets, met verschillende voorbeelden.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/statorials.org\/nl\/google-spreadsheets-vervangen-lege-cellen-door-nul\/\" \/>\n<meta property=\"og:site_name\" content=\"Statorials\" \/>\n<meta property=\"article:published_time\" content=\"2023-07-22T18:55:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacer21.png\" \/>\n<meta name=\"author\" content=\"Dr.benjamin anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Verfasst von\" \/>\n\t<meta name=\"twitter:data1\" content=\"Dr.benjamin anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Gesch\u00e4tzte Lesezeit\" \/>\n\t<meta name=\"twitter:data2\" content=\"1\u00a0Minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/statorials.org\/nl\/google-spreadsheets-vervangen-lege-cellen-door-nul\/\",\"url\":\"https:\/\/statorials.org\/nl\/google-spreadsheets-vervangen-lege-cellen-door-nul\/\",\"name\":\"Lege cellen vervangen door nul in Google Spreadsheets - Statorials\",\"isPartOf\":{\"@id\":\"https:\/\/statorials.org\/nl\/#website\"},\"datePublished\":\"2023-07-22T18:55:57+00:00\",\"dateModified\":\"2023-07-22T18:55:57+00:00\",\"author\":{\"@id\":\"https:\/\/statorials.org\/nl\/#\/schema\/person\/d4b8842173cca1bb62cdec41860e4219\"},\"description\":\"In deze tutorial wordt uitgelegd hoe u lege cellen vervangt door nullen in Google Spreadsheets, met verschillende voorbeelden.\",\"breadcrumb\":{\"@id\":\"https:\/\/statorials.org\/nl\/google-spreadsheets-vervangen-lege-cellen-door-nul\/#breadcrumb\"},\"inLanguage\":\"de\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/statorials.org\/nl\/google-spreadsheets-vervangen-lege-cellen-door-nul\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/statorials.org\/nl\/google-spreadsheets-vervangen-lege-cellen-door-nul\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/statorials.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Lege cellen vervangen door nul in google spreadsheets\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/statorials.org\/nl\/#website\",\"url\":\"https:\/\/statorials.org\/nl\/\",\"name\":\"Statorials\",\"description\":\"Uw gids voor statistische competentie\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/statorials.org\/nl\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"de\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/statorials.org\/nl\/#\/schema\/person\/d4b8842173cca1bb62cdec41860e4219\",\"name\":\"Dr.benjamin anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"de\",\"@id\":\"https:\/\/statorials.org\/nl\/#\/schema\/person\/image\/\",\"url\":\"http:\/\/statorials.org\/nl\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"contentUrl\":\"http:\/\/statorials.org\/nl\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg\",\"caption\":\"Dr.benjamin anderson\"},\"description\":\"Ik ben Benjamin, een gepensioneerde hoogleraar statistiek die nu een toegewijde Statorials-lesgever is. Ik heb uitgebreide ervaring en expertise op het gebied van statistiek en ik ben vastbesloten om mijn kennis te delen met studenten via Statorials. Lees verder\",\"sameAs\":[\"http:\/\/statorials.org\/nl\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Lege cellen vervangen door nul in Google Spreadsheets - Statorials","description":"In deze tutorial wordt uitgelegd hoe u lege cellen vervangt door nullen in Google Spreadsheets, met verschillende voorbeelden.","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:\/\/statorials.org\/nl\/google-spreadsheets-vervangen-lege-cellen-door-nul\/","og_locale":"de_DE","og_type":"article","og_title":"Lege cellen vervangen door nul in Google Spreadsheets - Statorials","og_description":"In deze tutorial wordt uitgelegd hoe u lege cellen vervangt door nullen in Google Spreadsheets, met verschillende voorbeelden.","og_url":"https:\/\/statorials.org\/nl\/google-spreadsheets-vervangen-lege-cellen-door-nul\/","og_site_name":"Statorials","article_published_time":"2023-07-22T18:55:57+00:00","og_image":[{"url":"https:\/\/statorials.org\/wp-content\/uploads\/2023\/08\/remplacer21.png"}],"author":"Dr.benjamin anderson","twitter_card":"summary_large_image","twitter_misc":{"Verfasst von":"Dr.benjamin anderson","Gesch\u00e4tzte Lesezeit":"1\u00a0Minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/statorials.org\/nl\/google-spreadsheets-vervangen-lege-cellen-door-nul\/","url":"https:\/\/statorials.org\/nl\/google-spreadsheets-vervangen-lege-cellen-door-nul\/","name":"Lege cellen vervangen door nul in Google Spreadsheets - Statorials","isPartOf":{"@id":"https:\/\/statorials.org\/nl\/#website"},"datePublished":"2023-07-22T18:55:57+00:00","dateModified":"2023-07-22T18:55:57+00:00","author":{"@id":"https:\/\/statorials.org\/nl\/#\/schema\/person\/d4b8842173cca1bb62cdec41860e4219"},"description":"In deze tutorial wordt uitgelegd hoe u lege cellen vervangt door nullen in Google Spreadsheets, met verschillende voorbeelden.","breadcrumb":{"@id":"https:\/\/statorials.org\/nl\/google-spreadsheets-vervangen-lege-cellen-door-nul\/#breadcrumb"},"inLanguage":"de","potentialAction":[{"@type":"ReadAction","target":["https:\/\/statorials.org\/nl\/google-spreadsheets-vervangen-lege-cellen-door-nul\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/statorials.org\/nl\/google-spreadsheets-vervangen-lege-cellen-door-nul\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/statorials.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Lege cellen vervangen door nul in google spreadsheets"}]},{"@type":"WebSite","@id":"https:\/\/statorials.org\/nl\/#website","url":"https:\/\/statorials.org\/nl\/","name":"Statorials","description":"Uw gids voor statistische competentie","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/statorials.org\/nl\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"de"},{"@type":"Person","@id":"https:\/\/statorials.org\/nl\/#\/schema\/person\/d4b8842173cca1bb62cdec41860e4219","name":"Dr.benjamin anderson","image":{"@type":"ImageObject","inLanguage":"de","@id":"https:\/\/statorials.org\/nl\/#\/schema\/person\/image\/","url":"http:\/\/statorials.org\/nl\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","contentUrl":"http:\/\/statorials.org\/nl\/wp-content\/uploads\/2023\/10\/Dr.-Benjamin-Anderson-96x96.jpg","caption":"Dr.benjamin anderson"},"description":"Ik ben Benjamin, een gepensioneerde hoogleraar statistiek die nu een toegewijde Statorials-lesgever is. Ik heb uitgebreide ervaring en expertise op het gebied van statistiek en ik ben vastbesloten om mijn kennis te delen met studenten via Statorials. Lees verder","sameAs":["http:\/\/statorials.org\/nl"]}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/posts\/2322","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/comments?post=2322"}],"version-history":[{"count":0,"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/posts\/2322\/revisions"}],"wp:attachment":[{"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/media?parent=2322"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/categories?post=2322"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/statorials.org\/nl\/wp-json\/wp\/v2\/tags?post=2322"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}