{"id":8962,"date":"2020-10-28T08:22:00","date_gmt":"2020-10-28T07:22:00","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=8962"},"modified":"2020-11-01T00:40:07","modified_gmt":"2020-10-31T23:40:07","slug":"automatikus-kitoltes-az-excelben","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/","title":{"rendered":"Automatikus kit\u00f6lt\u00e9s az Excelben"},"content":{"rendered":"\n<p>Ismered m\u00e1r az Excelnek az automatikus kit\u00f6lt\u00e9s funkci\u00f3j\u00e1t? Nagyon hasznos, ha \u00faj t\u00e1bl\u00e1zat el\u0151tt vagy, \u00e9s Neked kell kit\u00f6ltened a t\u00e1bl\u00e1zat tengelyeit.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Automatikus kit\u00f6lt\u00e9s napokkal<\/h2>\n\n\n\n<p>P\u00e9ld\u00e1ul, ha napokat kell be\u00edrnod, akkor csak add meg az els\u0151 \u00e9rt\u00e9ket, hogy &#8216;h\u00e9tf\u0151&#8217;, \u00e9s alul a jobb cs\u00fccs\u00f6kkel leh\u00fazva m\u00e1ris ki tudod t\u00f6lteni a cell\u00e1kat. A j\u00f3 h\u00edr az az, hogy nem csak h\u00e9tf\u0151vel tudod kezdeni a list\u00e1t, \u00e9s nem csak lefel\u00e9 tudod m\u00e1solni az \u00e9rt\u00e9keket, hanem ak\u00e1r v\u00edzszintesen is. S\u0151t, ak\u00e1r visszafel\u00e9 is m\u0171k\u00f6dik a funkci\u00f3.\u00a0<\/p>\n\n\n\n<p>N\u00e9zd meg a vide\u00f3ban, hogy hogyan m\u0171k\u00f6dik a funkci\u00f3:<\/p>\n\n\n\n<iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/klgPoh8q3CM\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n\n\n\n<p>Ahol v\u00e9get \u00e9r a h\u00e9t (sorozat), ott elkezdi \u00fajra t\u00f6lteni a napokat.\u00a0 <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">H\u00f3napok automatikus kit\u00f6lt\u00e9se<\/h2>\n\n\n\n<p>Ugyanez m\u0171k\u00f6dik h\u00f3napokra is. Ha v\u00e9get \u00e9r az \u00e9v, a december ut\u00e1n egyb\u0151l j\u00f6n a janu\u00e1r. <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img fetchpriority=\"high\" decoding=\"async\" width=\"923\" height=\"400\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-honapok-huzas.png\" alt=\"Napok, h\u00f3napok automatikus kit\u00f6lt\u00e9se\" class=\"wp-image-8965\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-honapok-huzas.png 923w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-honapok-huzas-300x130.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-honapok-huzas-768x333.png 768w\" sizes=\"(max-width: 923px) 100vw, 923px\" \/><\/figure>\n\n\n\n<p>Ha valami miatt nem szeretn\u00e9d ezt az automatikus kit\u00f6lt\u00e9s funkci\u00f3t, mert mindenhova j\u00faniust szeretn\u00e9l \u00edrni, akkor v\u00e1laszd itt alul a kis ikont, \u00e9s \u00e1ll\u00edtsd \u00e1t a &#8216;Cell\u00e1k m\u00e1sol\u00e1sa&#8217;-ra. <\/p>\n\n\n\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\" style=\"grid-template-columns:32% auto\"><figure class=\"wp-block-media-text__media\"><img decoding=\"async\" width=\"355\" height=\"217\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/11\/automatikus-kitoltes-kitoltes-adatsorral.png\" alt=\"Automatikus kit\u00f6lt\u00e9s lehet\u0151s\u00e9gei: m\u00e1sol\u00e1s, adatsor (sorozat), form\u00e1tummal vagy form\u00e1tum n\u00e9lk\u00fcl.\" class=\"wp-image-8975\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/11\/automatikus-kitoltes-kitoltes-adatsorral.png 355w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/11\/automatikus-kitoltes-kitoltes-adatsorral-300x183.png 300w\" sizes=\"(max-width: 355px) 100vw, 355px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<p class=\"has-normal-font-size\">Vagy lehet csak form\u00e1tummal, form\u00e1tum n\u00e9lk\u00fcl is t\u00f6lteni. Maradjunk a h\u00f3napokn\u00e1l (Kit\u00f6lt\u00e9s adatsorral).\u00a0\u00a0A k\u00e9p alj\u00e1n l\u00e1that\u00f3 <a rel=\"noreferrer noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/villamkitoltes\/\" target=\"_blank\">vill\u00e1mkit\u00f6lt\u00e9st <\/a>ink\u00e1bb ismerd meg k\u00fcl\u00f6n.<\/p>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">D\u00e1tumok folytat\u00e1sa<\/h2>\n\n\n\n<p>N\u00e9zz\u00fck meg, hogyha <a href=\"https:\/\/sosexcel.com\/exceltippek\/tudtad-hogy-a-datumok-szamok\/\" target=\"_blank\" rel=\"noreferrer noopener\">d\u00e1tumokkal dolgozol<\/a>, akkor milyen lehet\u0151s\u00e9geket k\u00edn\u00e1l az Excel. <\/p>\n\n\n\n<p>Itt is az az alap\u00e9rtelmezett, hogy n\u00f6veli a napok sz\u00e1m\u00e1t egyes\u00e9vel. Viszont, ha megn\u00e9zed a kit\u00f6lt\u00e9si lehet\u0151s\u00e9gek ikont, akkor itt m\u00e1r sokkal t\u00f6bb opci\u00f3 van.\u00a0 <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft size-large\"><img decoding=\"async\" width=\"360\" height=\"395\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-datumok-1.png\" alt=\"D\u00e1tumok folytat\u00e1sa. Az automatikus kit\u00f6lt\u00e9s t\u00f6bb lehet\u0151s\u00e9get k\u00edn\u00e1l.\" class=\"wp-image-8968\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-datumok-1.png 360w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-datumok-1-273x300.png 273w\" sizes=\"(max-width: 360px) 100vw, 360px\" \/><\/figure><\/div>\n\n\n\n<p>P\u00e9ld\u00e1ul mondhatod azt, hogy csak a h\u00e9tk\u00f6znapokkal szeretn\u00e9d kit\u00f6lteni a t\u00e1bl\u00e1zatot.\u00a0\u00a0<\/p>\n\n\n\n<p>Akkor, mivel 6-a h\u00e9tf\u0151 volt, ez\u00e9rt a janu\u00e1r 10-e p\u00e9ntek ut\u00e1n kihagyja a 11-12-t, \u00e9s 2020.01.13 k\u00f6vetkezik.<\/p>\n\n\n\n<p>Vagy mondhatod azt is, hogy Te nem a h\u00e9tk\u00f6znapokkal, hanem a h\u00f3napokkal szeretn\u00e9d\u00a0 kit\u00f6lteni a t\u00e1bl\u00e1zatot. Ebben az esetben r\u00f6gt\u00f6n a k\u00f6vetkez\u0151 h\u00f3napnak, ugyanazt a napj\u00e1t adja meg: 2020.01.06, 2020.02.06, 2020.03.06, \u00e9s \u00edgy tov\u00e1bb.<\/p>\n\n\n\n<p>Ugyan\u00edgy lehet az \u00e9vekkel is kit\u00f6lteni a t\u00e1bl\u00e1zatot, akkor mindig egy \u00e9vet ugrik: 2020.01.06, 2021.01.06, 2022.01.06, &#8230;\u00a0\u00a0<\/p>\n\n\n\n<p>Vagy mondhatod azt is, hogy ugyanazt az \u00e9rt\u00e9ket m\u00e1solja, teh\u00e1t mindenhol maradjon a janu\u00e1r 6-a.\u00a0\u00a0<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">D\u00e1tumok megad\u00e1sa hetente<\/h2>\n\n\n\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\" style=\"grid-template-columns:19% auto\"><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"256\" height=\"401\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-hetek.png\" alt=\"Heti d\u00e1tumok be\u00edr\u00e1sa az automatikus kit\u00f6lt\u00e9s seg\u00edts\u00e9g\u00e9vel.\" class=\"wp-image-8970\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-hetek.png 256w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-hetek-192x300.png 192w\" sizes=\"(max-width: 256px) 100vw, 256px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<p>Hogyha azt szeretn\u00e9d, hogy hetente t\u00f6ltse ki az Excel, akkor a m\u00e1sodik \u00e9rt\u00e9knek add meg a k\u00f6vetkez\u0151 h\u00e9tf\u0151i napot, ami janu\u00e1r 13. Egy\u00fctt jel\u00f6ld ki a k\u00e9t \u00e9rt\u00e9ket, \u00fagy m\u00e1sold le.\u00a0 A m\u00e1sol\u00e1shoz haszn\u00e1lhatod a <a href=\"https:\/\/sosexcel.com\/exceltippek\/3-duplakattos-trukk-a-gyorsabb-munkaert\/\" target=\"_blank\" rel=\"noreferrer noopener\">duplakattot <\/a>is.\u00a0<\/p>\n\n\n\n<p>\u00cdgy megmarad a &#8216;t\u00e1vols\u00e1g&#8217;, \u00e9s mindenhol egy-egy h\u00e9t sz\u00fcnet lesz.&nbsp;&nbsp;<\/p>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Sorozat vagy m\u00e1sol\u00e1s?<\/h2>\n\n\n\n<p>Ha sz\u00e1mokat \u00edrsz be, akkor alap\u00e9rtelmezetten m\u00e1sol az Excel. Viszont az &#8216;Automatikus kit\u00f6lt\u00e9si lehet\u0151s\u00e9gek&#8217; ikonon mindig mindig ott van a mindk\u00e9t lehet\u0151s\u00e9g: m\u00e1sol\u00e1s vagy adatsor (sorozat). Itt \u00e1t tudod \u00e1ll\u00edtani sorozatra az \u00e9rt\u00e9ket, \u00edgy n\u00f6vekv\u0151 sz\u00e1msort kapsz.<\/p>\n\n\n\n<p>Viszont haszn\u00e1lhatod a Ctrl gombot h\u00faz\u00e1s k\u00f6zben, \u00e9s automatikusan a sorozatot fogja be\u00edrni.\u00a0\u00a0<\/p>\n\n\n\n<p>Ugyan\u00edgy a h\u00f3napokn\u00e1l a sorozat az alap\u00e9rtelmez\u00e9s, de ha nyomod a Ctrl-t, akkor mindenhov\u00e1 ugyanazt a h\u00f3napot \u00edrja be.<\/p>\n\n\n\n<p>Egy id\u0151 ut\u00e1n megtanulod, hogy melyik az alap\u00e9rtelmezett \u00e9s a Ctrl-lal meg tudod ford\u00edtani.\u00a0<\/p>\n\n\n\n<p>Viszont azt fontos megjegyezni, hogy a duplakatt \u00e9s a Ctrl egyszerre nem haszn\u00e1lhat\u00f3.\u00a0 Duplakattn\u00e1l az alap\u00e9rtelmezett sorozat vagy m\u00e1sol\u00e1s alapj\u00e1n fogja kit\u00f6lteni neked az Excel az \u00e9rt\u00e9keket.<\/p>\n\n\n\n<p>Ismerkedj ezzel a funkci\u00f3val, gyakorolj sokat! <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ismerd meg jobban az Excelt!<\/h2>\n\n\n\n<p>Ha szeretn\u00e9l szem\u00e9lyes seg\u00edts\u00e9get, akkor szeretettel v\u00e1runk az <a href=\"https:\/\/exceltitok.hu\/oktatas\/\">egy\u00e9ni tanfolyamokon<\/a>. Vagy a<a href=\"https:\/\/excelklub.hu\/\"> VIP klubban<\/a>, ahol b\u00e1rmikor b\u00e1rmit k\u00e9rdezhetsz, \u00e9s gyorsan seg\u00edt\u00fcnk Neked.\u00a0Illetve sz\u00e1mtalan feladatot adunk, amikkel tudsz gyakorolni. <\/p>\n\n\n\n<p>A l\u00e9nyeg, hogy ha sz\u00fcks\u00e9ged van jobb Excel tud\u00e1sra, akkor mindenk\u00e9ppen foglalkozz\u00e1l az Excellel.\u00a0 Gyakorolj sokat, legyen a bar\u00e1tod az Excel! Sz\u00e9p napot!\u00a0<\/p>\n\n\n\n<iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/Zj23CGqs7dE\" frameborder=\"0\" allow=\"accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n\n\n","protected":false},"excerpt":{"rendered":"<p>Ismered m\u00e1r az Excelnek az automatikus kit\u00f6lt\u00e9s funkci\u00f3j\u00e1t? Nagyon hasznos, ha \u00faj t\u00e1bl\u00e1zat el\u0151tt vagy, \u00e9s Neked kell kit\u00f6ltened a t\u00e1bl\u00e1zat tengelyeit. Automatikus kit\u00f6lt\u00e9s napokkal P\u00e9ld\u00e1ul, ha napokat kell be\u00edrnod, akkor csak add meg az els\u0151 \u00e9rt\u00e9ket, hogy &#8216;h\u00e9tf\u0151&#8217;, \u00e9s alul a jobb cs\u00fccs\u00f6kkel leh\u00fazva m\u00e1ris ki tudod t\u00f6lteni a cell\u00e1kat. A j\u00f3 h\u00edr az [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","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":[],"class_list":["post-8962","post","type-post","status-publish","format-standard","hentry","category-excel-tippek-gyakori-kerdesek"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Automatikus kit\u00f6lt\u00e9s az Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"A szomsz\u00e9dos cell\u00e1k kit\u00f6lt\u00e9s\u00e9t megk\u00f6nny\u00edti az Automatikus kit\u00f6lt\u00e9s funkci\u00f3. K\u00fcl\u00f6n\u00f6sen napok, h\u00f3napok, d\u00e1tumok \u00e9s sz\u00e1mok eset\u00e9n tud rengeteg id\u0151t sp\u00f3rolni.\" \/>\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\/automatikus-kitoltes-az-excelben\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Automatikus kit\u00f6lt\u00e9s az Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"A szomsz\u00e9dos cell\u00e1k kit\u00f6lt\u00e9s\u00e9t megk\u00f6nny\u00edti az Automatikus kit\u00f6lt\u00e9s funkci\u00f3. K\u00fcl\u00f6n\u00f6sen napok, h\u00f3napok, d\u00e1tumok \u00e9s sz\u00e1mok eset\u00e9n tud rengeteg id\u0151t sp\u00f3rolni.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/\" \/>\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=\"2020-10-28T07:22:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-10-31T23:40:07+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-honapok-huzas.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=\"4 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Automatikus kit\u00f6lt\u00e9s az Excelben\",\"datePublished\":\"2020-10-28T07:22:00+00:00\",\"dateModified\":\"2020-10-31T23:40:07+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/\"},\"wordCount\":754,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-honapok-huzas.png\",\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/\",\"name\":\"Automatikus kit\u00f6lt\u00e9s az Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-honapok-huzas.png\",\"datePublished\":\"2020-10-28T07:22:00+00:00\",\"dateModified\":\"2020-10-31T23:40:07+00:00\",\"description\":\"A szomsz\u00e9dos cell\u00e1k kit\u00f6lt\u00e9s\u00e9t megk\u00f6nny\u00edti az Automatikus kit\u00f6lt\u00e9s funkci\u00f3. K\u00fcl\u00f6n\u00f6sen napok, h\u00f3napok, d\u00e1tumok \u00e9s sz\u00e1mok eset\u00e9n tud rengeteg id\u0151t sp\u00f3rolni.\",\"breadcrumb\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/#primaryimage\",\"url\":\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-honapok-huzas.png\",\"contentUrl\":\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-honapok-huzas.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sosexcel.com\/exceltippek\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Automatikus kit\u00f6lt\u00e9s az Excelben\"}]},{\"@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":"Automatikus kit\u00f6lt\u00e9s az Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"A szomsz\u00e9dos cell\u00e1k kit\u00f6lt\u00e9s\u00e9t megk\u00f6nny\u00edti az Automatikus kit\u00f6lt\u00e9s funkci\u00f3. K\u00fcl\u00f6n\u00f6sen napok, h\u00f3napok, d\u00e1tumok \u00e9s sz\u00e1mok eset\u00e9n tud rengeteg id\u0151t sp\u00f3rolni.","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\/automatikus-kitoltes-az-excelben\/","og_locale":"hu_HU","og_type":"article","og_title":"Automatikus kit\u00f6lt\u00e9s az Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"A szomsz\u00e9dos cell\u00e1k kit\u00f6lt\u00e9s\u00e9t megk\u00f6nny\u00edti az Automatikus kit\u00f6lt\u00e9s funkci\u00f3. K\u00fcl\u00f6n\u00f6sen napok, h\u00f3napok, d\u00e1tumok \u00e9s sz\u00e1mok eset\u00e9n tud rengeteg id\u0151t sp\u00f3rolni.","og_url":"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2020-10-28T07:22:00+00:00","article_modified_time":"2020-10-31T23:40:07+00:00","og_image":[{"url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-honapok-huzas.png","type":"","width":"","height":""}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"4 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Automatikus kit\u00f6lt\u00e9s az Excelben","datePublished":"2020-10-28T07:22:00+00:00","dateModified":"2020-10-31T23:40:07+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/"},"wordCount":754,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-honapok-huzas.png","articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/","url":"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/","name":"Automatikus kit\u00f6lt\u00e9s az Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-honapok-huzas.png","datePublished":"2020-10-28T07:22:00+00:00","dateModified":"2020-10-31T23:40:07+00:00","description":"A szomsz\u00e9dos cell\u00e1k kit\u00f6lt\u00e9s\u00e9t megk\u00f6nny\u00edti az Automatikus kit\u00f6lt\u00e9s funkci\u00f3. K\u00fcl\u00f6n\u00f6sen napok, h\u00f3napok, d\u00e1tumok \u00e9s sz\u00e1mok eset\u00e9n tud rengeteg id\u0151t sp\u00f3rolni.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/#primaryimage","url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-honapok-huzas.png","contentUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2020\/10\/automatikus-kitoltes-honapok-huzas.png"},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/automatikus-kitoltes-az-excelben\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Automatikus kit\u00f6lt\u00e9s az Excelben"}]},{"@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\/8962","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=8962"}],"version-history":[{"count":6,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/8962\/revisions"}],"predecessor-version":[{"id":8980,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/8962\/revisions\/8980"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=8962"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=8962"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=8962"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}