{"id":1629,"date":"2023-11-15T01:08:57","date_gmt":"2023-11-15T01:08:57","guid":{"rendered":"https:\/\/exceladvisor.org\/nl\/schilder-formaat\/"},"modified":"2023-12-06T05:48:32","modified_gmt":"2023-12-06T05:48:32","slug":"schilder-formaat","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/nl\/schilder-formaat\/","title":{"rendered":"Hoe gebruik ik format painter in excel?"},"content":{"rendered":"<div class=\"excel-voor-de-inhoud\" id=\"excel-2843391525\"><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>Ik kan niet berekenen hoeveel uur ik heb bespaard sinds ik &#8220;Format Painter&#8221; ontdekte. Ja het is waar.<\/p><p> Het punt is dat wanneer u in Excel werkt, er momenten zijn waarop u de opmaak van de ene cel (of bereik) naar de andere wilt kopi\u00ebren.<\/p><p> Format Painter staat voor u klaar. Laten we zeggen dat u vanuit cel A1 (die een specifieke lettertypestijl en achtergrondkleur heeft) die opmaak naar B1 wilt kopi\u00ebren). Nou, alles wat je nodig hebt is \u00e9\u00e9n klik.<\/p><h2 class=\"wp-block-heading\"> Waar is de knop Opmaak kopi\u00ebren\/plakken?<\/h2><p> Het staat op je tabblad Start. Als u naar het klembordgedeelte (linkerkant) van uw tabblad Start kijkt, kunt u het vinden. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/format-peintre-bouton-onglet-accueil-1.png\" sizes=\"\" srcset=\"\" alt=\"knop Starttabblad schilderformaat\"><\/figure><\/div><h2 class=\"wp-block-heading\"> Hoe het werkt<\/h2><ol><li> Wanneer u een cel of bereik selecteert en op de knop Opmaak kopi\u00ebren\/plakken klikt, wordt de opmaak gekopieerd.<\/li><li> Wanneer u daarna een andere cel of bereik selecteert, wordt de opmaak daar geplakt.<\/li><\/ol><h2 class=\"wp-block-heading\"> Hoe u Format Painter gebruikt<\/h2><p> Zoals ik al zei, het is een proces met \u00e9\u00e9n klik. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-format-peintre-excel-1.gif\" sizes=\"\" srcset=\"\" alt=\"gebruik het Excel Painter-formaat\"><\/figure><\/div><ol><li> Selecteer eerst het bereik of het bereik waaruit u de opmaak wilt kopi\u00ebren.<\/li><li> Klik daarna op de knop Format Painter.<\/li><li> Zodra u op de knop klikt, verandert uw cursor in een penseel.<\/li><li> Selecteer nu het bereik waarop u de opmaak wilt toepassen.<\/li><\/ol><p> Het is klaar.<\/p><h3 class=\"wp-block-heading\"> Kan ik <a href=\"https:\/\/exceladvisor.org\/nl\/toetsenbord-sneltoetsen\/\">de sneltoets<\/a> gebruiken?<\/h3><p> Ja, u kunt <strong>Alt+H+F+P<\/strong> gebruiken voor formaatschilder. Selecteer eenvoudig het bereik of de cel waaruit u de notatie wilt kopi\u00ebren en gebruik de sneltoets.<\/p><h2 class=\"wp-block-heading\"> Pas de opmaak meerdere keren toe<\/h2><p> Ja, je kunt het gebruiken om de opmaak meerdere keren te plakken. <\/p><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/utiliser-le-peintre-de-format-plusieurs-fois-excel-1.gif\" sizes=\"\" srcset=\"\" alt=\"gebruik Format Painter meerdere keren Excel\"><\/figure><\/div><ol><li> Selecteer eerst het bereik waaruit u de opmaak wilt kopi\u00ebren.<\/li><li> Ga daarna naar het tabblad Start \u2192 Klembord \u2192 Opmaak kopi\u00ebren\/plakken.<\/li><li> Dubbelklik nu op de knop Format Painter.<\/li><li> Van daaruit kunt u de opmaak meerdere keren plakken.<\/li><\/ol><h2 class=\"wp-block-heading\"> <span style=\"color: #ff0000;\">Bonustip:<\/span> kopieer de kolombreedte met Format Painter <\/h2><div class=\"wp-block-image\"><figure class=\"aligncenter\"><img decoding=\"async\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/peintre-de-format-appliquer-la-largeur-de-colonne-excel-1.gif\" sizes=\"\" srcset=\"\" alt=\"formaatschilder pas Excel-kolombreedte toe\"><\/figure><\/div><ol><li> Selecteer eerst de gehele kolom waarvan u de kolombreedte wilt kopi\u00ebren.<\/li><li> Klik daarna op de knop Format Painter.<\/li><li> Klik op de kolomkop van de doelkolom.<\/li><\/ol><p> <strong>Kende u deze optie voordat u dit artikel las?<\/strong><\/p><p> Deel uw mening met mij in het opmerkingengedeelte. Ik hoor graag van je en vergeet niet om het met je vrienden te delen, ik weet zeker dat ze het zullen waarderen.<\/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\/volledig-rechtvaardigen\/\">Vul Uitvullen in Excel in<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/excel-formulebalk\/\">Formulebalk in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/voeg-een-voettekstkop-toe\/\">Voeg een kop- en voettekst toe in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/liniaal\/\">Toon liniaal in Excel<\/a><\/li><li> <a href=\"https:\/\/exceladvisor.org\/nl\/vulgreep\/\">Vul de handgreep in Excel<\/a> <\/li><\/ul><\/div><\/div><div class=\"gb-grid-column gb-grid-column-50067b57\"><div class=\"gb-container gb-container-50067b57\"><\/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-1629","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 gebruik ik Format Painter in Excel? (Geheime methode)<\/title>\n<meta name=\"description\" content=\"U wilt geen tijd verspillen aan het steeds opnieuw formatteren. Leer hoe u Format Painter in Excel kunt gebruiken om te kopi\u00ebren en toe te passen\" \/>\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\/schilder-formaat\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hoe gebruik ik Format Painter in Excel? (Geheime methode)\" \/>\n<meta property=\"og:description\" content=\"U wilt geen tijd verspillen aan het steeds opnieuw formatteren. Leer hoe u Format Painter in Excel kunt gebruiken om te kopi\u00ebren en toe te passen\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/nl\/schilder-formaat\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-06T05:48:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/format-peintre-bouton-onglet-accueil-1.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\/schilder-formaat\/\",\"url\":\"https:\/\/exceladvisor.org\/nl\/schilder-formaat\/\",\"name\":\"Hoe gebruik ik Format Painter in Excel? (Geheime methode)\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/schilder-formaat\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/schilder-formaat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/format-peintre-bouton-onglet-accueil-1.png\",\"datePublished\":\"2023-11-15T01:08:57+00:00\",\"dateModified\":\"2023-12-06T05:48:32+00:00\",\"description\":\"U wilt geen tijd verspillen aan het steeds opnieuw formatteren. Leer hoe u Format Painter in Excel kunt gebruiken om te kopi\u00ebren en toe te passen\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/nl\/schilder-formaat\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/nl\/schilder-formaat\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/schilder-formaat\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/format-peintre-bouton-onglet-accueil-1.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/format-peintre-bouton-onglet-accueil-1.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/nl\/schilder-formaat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Thuis\",\"item\":\"https:\/\/exceladvisor.org\/nl\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hoe gebruik ik format painter in excel?\"}]},{\"@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 gebruik ik Format Painter in Excel? (Geheime methode)","description":"U wilt geen tijd verspillen aan het steeds opnieuw formatteren. Leer hoe u Format Painter in Excel kunt gebruiken om te kopi\u00ebren en toe te passen","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\/schilder-formaat\/","og_locale":"nl_NL","og_type":"article","og_title":"Hoe gebruik ik Format Painter in Excel? (Geheime methode)","og_description":"U wilt geen tijd verspillen aan het steeds opnieuw formatteren. Leer hoe u Format Painter in Excel kunt gebruiken om te kopi\u00ebren en toe te passen","og_url":"https:\/\/exceladvisor.org\/nl\/schilder-formaat\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-06T05:48:32+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/format-peintre-bouton-onglet-accueil-1.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\/schilder-formaat\/","url":"https:\/\/exceladvisor.org\/nl\/schilder-formaat\/","name":"Hoe gebruik ik Format Painter in Excel? (Geheime methode)","isPartOf":{"@id":"https:\/\/exceladvisor.org\/nl\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/nl\/schilder-formaat\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/nl\/schilder-formaat\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/format-peintre-bouton-onglet-accueil-1.png","datePublished":"2023-11-15T01:08:57+00:00","dateModified":"2023-12-06T05:48:32+00:00","description":"U wilt geen tijd verspillen aan het steeds opnieuw formatteren. Leer hoe u Format Painter in Excel kunt gebruiken om te kopi\u00ebren en toe te passen","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/nl\/schilder-formaat\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/nl\/schilder-formaat\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/exceladvisor.org\/nl\/schilder-formaat\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/format-peintre-bouton-onglet-accueil-1.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/format-peintre-bouton-onglet-accueil-1.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/nl\/schilder-formaat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Thuis","item":"https:\/\/exceladvisor.org\/nl\/"},{"@type":"ListItem","position":2,"name":"Hoe gebruik ik format painter in excel?"}]},{"@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\/1629","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=1629"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1629\/revisions"}],"predecessor-version":[{"id":2539,"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/pages\/1629\/revisions\/2539"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/nl\/wp-json\/wp\/v2\/media?parent=1629"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}