{"id":6517,"date":"2018-11-23T08:10:37","date_gmt":"2018-11-23T07:10:37","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=6517"},"modified":"2021-11-18T17:42:33","modified_gmt":"2021-11-18T16:42:33","slug":"villamkitoltes","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/","title":{"rendered":"Vill\u00e1mkit\u00f6lt\u00e9s (Flash Fill) &#8211; ha ezt kipr\u00f3b\u00e1lod, le fog esni az \u00e1llad"},"content":{"rendered":"<p>A Vill\u00e1mkit\u00f6lt\u00e9s (angolul Flash Fill) az Excel 2013-t\u00f3l el\u00e9rhet\u0151&nbsp;funkci\u00f3, melynek seg\u00edts\u00e9g\u00e9vel vill\u00e1mgyorsan tudod sz\u00e9tszedni vagy \u00f6sszef\u0171zni a sz\u00f6vegeidet. Val\u00f3sz\u00edn\u0171leg innen kapta a nev\u00e9t is.<!--more--><\/p>\n<p>Az ikon az <strong>Adatok men\u00fcben tal\u00e1lhat\u00f3, \u00e9s Ctrl E a gyorsbillenty\u0171je<\/strong> (sajnos pl. a 2013-as verzi\u00f3ban a billenty\u0171kombin\u00e1ci\u00f3 m\u00e9g nem m\u0171k\u00f6dik). Az \u00faj Excelekben pedig kicsi lett az ikon, neh\u00e9z \u00e9szrevenni &#8211; tedd ki ink\u00e1bb a <a href=\"http:\/\/exceltitok.hu\/gyorsmenu-gyorseleresi-eszkoztar\/\" target=\"_blank\" rel=\"noopener\">Gyorsmen\u00fcre:<\/a><\/p>\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"aligncenter wp-image-7068\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/10\/adatok-villamkitoltes.png\" alt=\"A vill\u00e1mkit\u00f6lt\u00e9s ikon az Adatok f\u00fcl\u00f6n tal\u00e1lhat\u00f3\" width=\"650\" height=\"337\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/10\/adatok-villamkitoltes.png 648w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/10\/adatok-villamkitoltes-300x156.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/10\/adatok-villamkitoltes-240x124.png 240w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/p>\n<p>Csak adj meg egy mint\u00e1t a megl\u00e9v\u0151 adataid mell\u00e9 egy \u00faj oszlopba, nyomd meg a Ctrl E -t, \u00e9s a Vill\u00e1mkit\u00f6lt\u00e9s megpr\u00f3b\u00e1lja felismerni a szab\u00e1lyt, \u00e9s az alapj\u00e1n kit\u00f6lti az oszlopban az \u00f6sszes adatsort.<\/p>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-7067\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/05\/villamkitoltes-minta.png\" alt=\"\" width=\"650\" height=\"445\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/05\/villamkitoltes-minta.png 577w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/05\/villamkitoltes-minta-300x205.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/05\/villamkitoltes-minta-240x164.png 240w\" sizes=\"(max-width: 650px) 100vw, 650px\" \/><\/p>\n<p>Egyszerre egy oszlopot (mint\u00e1t) tudsz kit\u00f6lteni, de gyorsan v\u00e9gigszaladhatsz minden oszlopon. Annak nincs jelent\u0151s\u00e9ge, hogy az oszlopon bel\u00fcl hol \u00e1ll a kurzor, mikor az ikonra kattintasz, vagy&nbsp;megnyomod a Ctrl E kombin\u00e1ci\u00f3t.<\/p>\n<p><img decoding=\"async\" class=\"alignright wp-image-7084\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes-automatikus-kitoltes.png\" alt=\"\" width=\"420\" height=\"251\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes-automatikus-kitoltes.png 539w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes-automatikus-kitoltes-300x179.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes-automatikus-kitoltes-240x143.png 240w\" sizes=\"(max-width: 420px) 100vw, 420px\" \/><\/p>\n<p>A funkci\u00f3t az automatikus kit\u00f6lt\u00e9si opci\u00f3k k\u00f6z\u00f6tt is megtal\u00e1lhatod:<\/p>\n<p>(Vagy a Kezd\u0151lap \/ Kit\u00f6lt\u00e9s parancsn\u00e1l is, az AutoSzum alatt.)<\/p>\n<h2>Klasszikus esetek, amit a Vill\u00e1mkit\u00f6lt\u00e9s megold<\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignright wp-image-7066\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/05\/villamkitoltes-lehetosegek.png\" alt=\"\" width=\"420\" height=\"328\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/05\/villamkitoltes-lehetosegek.png 486w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/05\/villamkitoltes-lehetosegek-300x235.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/05\/villamkitoltes-lehetosegek-240x188.png 240w\" sizes=\"(max-width: 420px) 100vw, 420px\" \/><\/p>\n<p>\u25ba nevek, adatok&nbsp;<span style=\"font-size: 16px;\">sz\u00e9tv\u00e1laszt\u00e1sa, \u00f6sszef\u0171z\u00e9se (pl. vezet\u00e9kn\u00e9v, keresztn\u00e9v, teljes n\u00e9v)<\/span><br \/>\n\u25ba kisbet\u0171, nagybet\u0171 \u00e1t\u00edr\u00e1s<br \/>\n\u25ba sz\u00f6vegr\u00e9sz kimetsz\u00e9se<br \/>\n\u25ba felesleges karakterek (pl. &#8211; vagy sz\u00f3k\u00f6z) elt\u00e1vol\u00edt\u00e1sa<br \/>\n\u25ba bonyolultabb &#8222;k\u00f3dok&#8221; k\u00e9sz\u00edt\u00e9s\u00e9vel is pr\u00f3b\u00e1lkozhatsz, ha kell\u0151en egy\u00e9rtelm\u0171 a minta, felismeri az Excel<br \/>\n\u25ba sz\u00f6veg form\u00e1tum\u00fa d\u00e1tumok \u00e1talak\u00edt\u00e1sa val\u00f3s d\u00e1tumm\u00e1<\/p>\n<p>Ebben a vide\u00f3ban megn\u00e9zheted, hogyan alak\u00edthat\u00f3 \u00e1t a kis-\u00e9s nagybet\u0171 a Vill\u00e1mkit\u00f6lt\u00e9s (illetve f\u00fcggv\u00e9nyek) seg\u00edts\u00e9g\u00e9vel:<\/p>\n<div class=\"ast-oembed-container \" style=\"height: 100%;\"><iframe title=\"Kis \u00e9s nagybet\u0171k \u00e1talak\u00edt\u00e1sa Vill\u00e1mkit\u00f6lt\u00e9ssel \u00e9s f\u00fcggv\u00e9nyekkel [ExcelTitok]\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/9djgyYqBiUA?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/div>\n<h2>Ha nincs m\u00e9g Vill\u00e1mkit\u00f6lt\u00e9s funkci\u00f3d<\/h2>\n<p>Ha m\u00e9g 2010-es vagy kor\u00e1bbi Excelt haszn\u00e1lsz, akkor sajnos nem tudod kipr\u00f3b\u00e1lni. A Vill\u00e1mkit\u00f6lt\u00e9s megfelel\u0151je a&nbsp;<a href=\"https:\/\/sosexcel.com\/exceltippek\/vezetek-es-keresztnev\/\"><span style=\"text-decoration: underline;\">Sz\u00f6vegb\u0151l oszlopok funkci\u00f3<\/span><\/a>, illetve az <span style=\"text-decoration: underline;\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/szovegek-osszefuzese\/\">\u00f6sszef\u0171z\u00e9s<\/a><\/span>.<\/p>\n<h2>Statikus vagy dinamikus megold\u00e1s?<\/h2>\n<p>A Vill\u00e1mkit\u00f6lt\u00e9s el\u0151nye, hogy nagyon gyorsan ad eredm\u00e9nyt. Mivel sz\u00f6veges \u00e9rt\u00e9keket ad, \u00edgy a k\u00e9s\u0151bbi adatv\u00e1ltoz\u00e1sokat nem k\u00f6veti le. Ha szeretn\u00e9l olyan t\u00e1bl\u00e1zatot, amely folyamatosan, mag\u00e1t\u00f3l jav\u00edtja az adatokat, akkor sz\u00f6veges f\u00fcggv\u00e9nyeket vagy <a href=\"https:\/\/exceltitok.hu\/power-query\/\" target=\"_blank\" rel=\"noopener\"><span style=\"text-decoration: underline;\">Power Queryt \u00e9rdemes haszn\u00e1lnod<\/span><\/a>.<\/p>\n<h2>T\u00f6bb seg\u00edts\u00e9g kell?<\/h2>\n<p>Ha szeretn\u00e9l szem\u00e9lyes seg\u00edts\u00e9get az Excel tanul\u00e1shoz, vagy a t\u00e1bl\u00e1zataid \u00e1talak\u00edt\u00e1s\u00e1hoz akkor <strong>gyere hozz\u00e1nk <span style=\"text-decoration: underline;\"><a href=\"http:\/\/exceltitok.hu\/oktatas\">egy\u00e9ni Excel oktat\u00e1sra<\/a><\/span><\/strong>, vagy szerezd be az&nbsp;<span style=\"text-decoration: underline;\"><a href=\"https:\/\/exceltitok.hu\/excel-tankonyv\/\"><strong>Excel Tank\u00f6nyv<\/strong><\/a>et,<\/span> ami kezd\u0151t\u0151l a halad\u00f3 szintig bemutatja az Excelben rejl\u0151 lehet\u0151s\u00e9geket. Ha szeretsz k\u00f6nyvb\u0151l tanulni, akkor ez egy j\u00f3 lehet\u0151s\u00e9g, hogy egy \u00e1ltal\u00e1nos k\u00e9ped legyen az Excel funkci\u00f3ir\u00f3l.<\/p>\n\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/sorozat-felsorolas-kitoltes\/\"><span style=\"text-decoration: underline;\">Automatikus kit\u00f6lt\u00e9s, sorsz\u00e1moz\u00e1s, sorozat, felsorol\u00e1s<\/span><\/a><\/p>\n<p><span style=\"text-decoration: underline;\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/elrejtett-adatok-megjelenitese\/\">Hogyan lehet az elrejtett adatokat \u00fajra megjelen\u00edteni?<\/a><\/span><\/p>\n<p><span style=\"text-decoration: underline;\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/excel-tippek-a-youtube-on\/\">Excel tippek a YouTube-on<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A Vill\u00e1mkit\u00f6lt\u00e9s (angolul Flash Fill) az Excel 2013-t\u00f3l el\u00e9rhet\u0151&nbsp;funkci\u00f3, melynek seg\u00edts\u00e9g\u00e9vel vill\u00e1mgyorsan tudod sz\u00e9tszedni vagy \u00f6sszef\u0171zni a sz\u00f6vegeidet. Val\u00f3sz\u00edn\u0171leg innen kapta a nev\u00e9t is.<\/p>\n","protected":false},"author":1,"featured_media":9309,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[40,54,34],"class_list":["post-6517","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek","tag-adatbevitel","tag-gyorsasag","tag-szovegek"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Vill\u00e1mkit\u00f6lt\u00e9s (Flash Fill) - ha ezt kipr\u00f3b\u00e1lod, le fog esni az \u00e1llad - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"Adj meg egy mint\u00e1t az adataid mell\u00e9, nyomd meg a Ctrl E -t, \u00e9s a Vill\u00e1mkit\u00f6lt\u00e9s megpr\u00f3b\u00e1lja felismerni a szab\u00e1lyt, \u00e9s az alapj\u00e1n kit\u00f6lti a t\u00f6bbi cell\u00e1t.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Vill\u00e1mkit\u00f6lt\u00e9s (Flash Fill) - ha ezt kipr\u00f3b\u00e1lod, le fog esni az \u00e1llad - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Adj meg egy mint\u00e1t az adataid mell\u00e9, nyomd meg a Ctrl E -t, \u00e9s a Vill\u00e1mkit\u00f6lt\u00e9s megpr\u00f3b\u00e1lja felismerni a szab\u00e1lyt, \u00e9s az alapj\u00e1n kit\u00f6lti a t\u00f6bbi cell\u00e1t.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/\" \/>\n<meta property=\"og:site_name\" content=\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/bernadett.koros\" \/>\n<meta property=\"article:published_time\" content=\"2018-11-23T07:10:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-18T16:42:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes_borito.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1600\" \/>\n\t<meta property=\"og:image:height\" content=\"900\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bernadett\" \/>\n<meta name=\"twitter:label1\" content=\"Szerz\u0151:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bernadett\" \/>\n\t<meta name=\"twitter:label2\" content=\"Becs\u00fclt olvas\u00e1si id\u0151\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Vill\u00e1mkit\u00f6lt\u00e9s (Flash Fill) &#8211; ha ezt kipr\u00f3b\u00e1lod, le fog esni az \u00e1llad\",\"datePublished\":\"2018-11-23T07:10:37+00:00\",\"dateModified\":\"2021-11-18T16:42:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/\"},\"wordCount\":559,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes_borito.png\",\"keywords\":[\"adatbevitel\",\"gyorsas\u00e1g\",\"sz\u00f6vegek\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/\",\"name\":\"Vill\u00e1mkit\u00f6lt\u00e9s (Flash Fill) - ha ezt kipr\u00f3b\u00e1lod, le fog esni az \u00e1llad - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes_borito.png\",\"datePublished\":\"2018-11-23T07:10:37+00:00\",\"dateModified\":\"2021-11-18T16:42:33+00:00\",\"description\":\"Adj meg egy mint\u00e1t az adataid mell\u00e9, nyomd meg a Ctrl E -t, \u00e9s a Vill\u00e1mkit\u00f6lt\u00e9s megpr\u00f3b\u00e1lja felismerni a szab\u00e1lyt, \u00e9s az alapj\u00e1n kit\u00f6lti a t\u00f6bbi cell\u00e1t.\",\"breadcrumb\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/#primaryimage\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes_borito.png\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes_borito.png\",\"width\":1600,\"height\":900},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sosexcel.com\/exceltippek\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Vill\u00e1mkit\u00f6lt\u00e9s (Flash Fill) &#8211; ha ezt kipr\u00f3b\u00e1lod, le fog esni az \u00e1llad\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"description\":\"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!\",\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"hu\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\",\"name\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png\",\"width\":600,\"height\":133,\"caption\":\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\",\"name\":\"Bernadett\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g\",\"caption\":\"Bernadett\"},\"description\":\"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.\",\"sameAs\":[\"http:\/\/exceltitok.hu\/\",\"https:\/\/www.facebook.com\/bernadett.koros\"],\"url\":\"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Vill\u00e1mkit\u00f6lt\u00e9s (Flash Fill) - ha ezt kipr\u00f3b\u00e1lod, le fog esni az \u00e1llad - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"Adj meg egy mint\u00e1t az adataid mell\u00e9, nyomd meg a Ctrl E -t, \u00e9s a Vill\u00e1mkit\u00f6lt\u00e9s megpr\u00f3b\u00e1lja felismerni a szab\u00e1lyt, \u00e9s az alapj\u00e1n kit\u00f6lti a t\u00f6bbi cell\u00e1t.","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:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/","og_locale":"hu_HU","og_type":"article","og_title":"Vill\u00e1mkit\u00f6lt\u00e9s (Flash Fill) - ha ezt kipr\u00f3b\u00e1lod, le fog esni az \u00e1llad - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Adj meg egy mint\u00e1t az adataid mell\u00e9, nyomd meg a Ctrl E -t, \u00e9s a Vill\u00e1mkit\u00f6lt\u00e9s megpr\u00f3b\u00e1lja felismerni a szab\u00e1lyt, \u00e9s az alapj\u00e1n kit\u00f6lti a t\u00f6bbi cell\u00e1t.","og_url":"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2018-11-23T07:10:37+00:00","article_modified_time":"2021-11-18T16:42:33+00:00","og_image":[{"width":1600,"height":900,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes_borito.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"3 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Vill\u00e1mkit\u00f6lt\u00e9s (Flash Fill) &#8211; ha ezt kipr\u00f3b\u00e1lod, le fog esni az \u00e1llad","datePublished":"2018-11-23T07:10:37+00:00","dateModified":"2021-11-18T16:42:33+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/"},"wordCount":559,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes_borito.png","keywords":["adatbevitel","gyorsas\u00e1g","sz\u00f6vegek"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/","url":"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/","name":"Vill\u00e1mkit\u00f6lt\u00e9s (Flash Fill) - ha ezt kipr\u00f3b\u00e1lod, le fog esni az \u00e1llad - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes_borito.png","datePublished":"2018-11-23T07:10:37+00:00","dateModified":"2021-11-18T16:42:33+00:00","description":"Adj meg egy mint\u00e1t az adataid mell\u00e9, nyomd meg a Ctrl E -t, \u00e9s a Vill\u00e1mkit\u00f6lt\u00e9s megpr\u00f3b\u00e1lja felismerni a szab\u00e1lyt, \u00e9s az alapj\u00e1n kit\u00f6lti a t\u00f6bbi cell\u00e1t.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes_borito.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2018\/11\/villamkitoltes_borito.png","width":1600,"height":900},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Vill\u00e1mkit\u00f6lt\u00e9s (Flash Fill) &#8211; ha ezt kipr\u00f3b\u00e1lod, le fog esni az \u00e1llad"}]},{"@type":"WebSite","@id":"https:\/\/sosexcel.com\/exceltippek\/#website","url":"https:\/\/sosexcel.com\/exceltippek\/","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"ha S.O.S. seg\u00edts\u00e9gre van sz\u00fcks\u00e9ged!","publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/sosexcel.com\/exceltippek\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"hu"},{"@type":"Organization","@id":"https:\/\/sosexcel.com\/exceltippek\/#organization","name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","url":"https:\/\/sosexcel.com\/exceltippek\/","logo":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/07\/cropped-sos-excel-logo-nagy-tippek-oktatas.png","width":600,"height":133,"caption":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b","name":"Bernadett","image":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b83c1df02932359022967a1ac90aea0e45512b862866e93d439ba8ae464b6693?s=96&d=mm&r=g","caption":"Bernadett"},"description":"Bernadett 10 \u00e9vig dolgozott a versenyszf\u00e9r\u00e1ban, majd az ott szerzett tapasztalatok alapj\u00e1n \u00e1ll\u00edtotta \u00f6ssze az ExcelTitok k\u00e9pz\u00e9si m\u00f3dszert. 2010 szeptembere \u00f3ta csak Excel oktat\u00e1ssal foglalkozik. Oktat\u00f3i csapat\u00e1val m\u00e1ra m\u00e1r t\u00f6bb mint 2000 emberrel foglalkoztak szem\u00e9lyesen, egy\u00e9ni oktat\u00e1s keret\u00e9ben. C\u00e9lja, hogy \u00edr\u00e1sainak \u00e9s munk\u00e1j\u00e1nak k\u00f6sz\u00f6nhet\u0151en min\u00e9l t\u00f6bben megbar\u00e1tkozzanak az Excellel.","sameAs":["http:\/\/exceltitok.hu\/","https:\/\/www.facebook.com\/bernadett.koros"],"url":"https:\/\/sosexcel.com\/exceltippek\/author\/sos-excel\/"}]}},"_links":{"self":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/6517","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/comments?post=6517"}],"version-history":[{"count":21,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/6517\/revisions"}],"predecessor-version":[{"id":9310,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/6517\/revisions\/9310"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/9309"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=6517"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=6517"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=6517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}