{"id":32,"date":"2013-06-20T15:36:52","date_gmt":"2013-06-20T13:36:52","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=32"},"modified":"2022-03-21T19:44:56","modified_gmt":"2022-03-21T18:44:56","slug":"lenyilo-lista-keszitese","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/","title":{"rendered":"Leny\u00edl\u00f3 lista k\u00e9sz\u00edt\u00e9se"},"content":{"rendered":"<p>K\u00e9sz\u00edtettem egy t\u00e1bl\u00e1zatot, amibe leny\u00edl\u00f3 list\u00e1t szeretn\u00e9k tenni, hogy\u00a0csak a megadott \u00e9rt\u00e9kekb\u0151l v\u00e1laszthasson a haszn\u00e1l\u00f3ja.<\/p>\n<p><strong>V\u00e1lasz<\/strong>: A sz\u00fcks\u00e9ges funkci\u00f3t <strong>\u00c9rv\u00e9nyes\u00edt\u00e9snek<\/strong> h\u00edvj\u00e1k, \u00e9s az Adatok\u00a0f\u00fcl\u00f6n tal\u00e1lhat\u00f3. <!--more--><\/p>\n<h2>Leny\u00edl\u00f3 lista k\u00e9sz\u00edt\u00e9se<\/h2>\n\n\n<p>A kiindul\u00f3 helyzet alapj\u00e1n b\u00e1rmely cell\u00e1ba b\u00e1rmilyen&nbsp;\u00e9rt\u00e9ket \u00edrhatsz (pl. sz\u00e1m, sz\u00f6veg, d\u00e1tum).<\/p>\n\n\n\n<p>Akkor haszn\u00e1ld a funkci\u00f3t,&nbsp;ha bizonyos param\u00e9tereket korl\u00e1tozni akarsz: p\u00e9ld\u00e1ul a cell\u00e1ba csak&nbsp;megadott hossz\u00fas\u00e1g\u00fa sz\u00f6veg (Sz\u00f6veghossz), vagy bizonyos \u00e9rt\u00e9kek k\u00f6z\u00e9&nbsp;es\u0151 d\u00e1tum (D\u00e1tum) ker\u00fclhet.<\/p>\n\n\n\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\"><figure class=\"wp-block-media-text__media\"><img fetchpriority=\"high\" decoding=\"async\" width=\"407\" height=\"322\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/ervenyesites.jpg\" alt=\"\u00c9rv\u00e9nyes\u00edt\u00e9s, adatok korl\u00e1toz\u00e1sa\" class=\"wp-image-226 size-full\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/ervenyesites.jpg 407w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/ervenyesites-300x237.jpg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/ervenyesites-240x189.jpg 240w\" sizes=\"(max-width: 407px) 100vw, 407px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<p>V\u00e1laszd a &#8216;Lista&#8217; opci\u00f3t a leny\u00edl\u00f3 lista k\u00e9sz\u00edt\u00e9s\u00e9hez, majd a Forr\u00e1sn\u00e1l\u00a0jel\u00f6ld ki azokat a cell\u00e1kat, ahonnan hivatkozni akarod az \u00e9rt\u00e9ket.<\/p>\n\n\n\n<p>A\u00a0tartalom ebben az esetben a cell\u00e1kkal egy\u00fctt friss\u00fcl.<\/p>\n\n\n\n<p>(A mez\u0151 v\u00e9g\u00e9ben tal\u00e1lhat\u00f3 ikonra NEM kell r\u00e1kattintani. Csak ha \u00f6ssze akarod csukni az eg\u00e9sz ablakot mez\u0151 m\u00e9retre.)<\/p>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-media-text alignwide has-media-on-the-right is-stacked-on-mobile\"><figure class=\"wp-block-media-text__media\"><img decoding=\"async\" width=\"394\" height=\"319\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/03\/lenyilo-lista-adatok-ervenyesitese-forras.png\" alt=\"\" class=\"wp-image-9445 size-full\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/03\/lenyilo-lista-adatok-ervenyesitese-forras.png 394w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/03\/lenyilo-lista-adatok-ervenyesitese-forras-300x243.png 300w\" sizes=\"(max-width: 394px) 100vw, 394px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<p><strong>Tipp<\/strong>: Ha csak egyszer\u0171 Igen\/Nem vagy F\u00e9rfi\/N\u0151 lehet\u0151s\u00e9geket akarsz,\u00a0akkor pontosvessz\u0151vel elv\u00e1lasztva g\u00e9peld be a sz\u00f6vegeket. <\/p>\n\n\n\n<p>Angol nyelv\u0171 programokn\u00e1l be\u00e1ll\u00edt\u00e1st\u00f3l f\u00fcgg\u0151en vessz\u0151vel vagy pontosvessz\u0151vel kell megadni a lehets\u00e9ges \u00e9rt\u00e9keket.<\/p>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Adatok \u00e9rv\u00e9nyes\u00edt\u00e9se<\/h2>\n\n\n\n<p>N\u00e9zd v\u00e9gig a t\u00f6bbi lehet\u0151s\u00e9get is, hiszen rengeteg korl\u00e1toz\u00e1st megadhatsz az Adatok \u00e9rv\u00e9nyes\u00edt\u00e9se ablakban. Pl. a sz\u00f6vegek hossz\u00e1t, vagy a sz\u00e1mok, d\u00e1tumok \u00e9rt\u00e9khat\u00e1rait.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/03\/adatok-ervenyesitese-egesz-szam-datum.png\"><img decoding=\"async\" width=\"810\" height=\"319\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/03\/adatok-ervenyesitese-egesz-szam-datum.png\" alt=\"\" class=\"wp-image-9444\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/03\/adatok-ervenyesitese-egesz-szam-datum.png 810w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/03\/adatok-ervenyesitese-egesz-szam-datum-300x118.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/03\/adatok-ervenyesitese-egesz-szam-datum-768x302.png 768w\" sizes=\"(max-width: 810px) 100vw, 810px\" \/><\/a><\/figure>\n\n\n\n<p>Javaslom, hogy tedd ki az Adatok \u00e9rv\u00e9nyes\u00edt\u00e9se ikont a <span style=\"text-decoration: underline;\"><a rel=\"noreferrer noopener\" href=\"https:\/\/exceltitok.hu\/gyorsmenu-gyorseleresi-eszkoztar\/\" data-type=\"URL\" data-id=\"https:\/\/exceltitok.hu\/gyorsmenu-gyorseleresi-eszkoztar\/\" target=\"_blank\">Gyorsel\u00e9r\u00e9si eszk\u00f6zt\u00e1rra is<\/a><\/span>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Leny\u00edl\u00f3 lista korl\u00e1tja<\/h2>\n\n\n\n<p>Sajnos, hi\u00e1ba \u00e1ll\u00edtod be gondosan a cell\u00e1kra az &#8216;\u00c9rv\u00e9nyes\u00edt\u00e9st&#8217;, egy sima Ctrl C-Ctrl V-vel fel\u00fcl lehet \u0151ket \u00edrni. Tapasztalat, hogy a mindenre elsz\u00e1nt Excel felhaszn\u00e1l\u00f3k \u00e9lnek is ezzel a lehet\u0151s\u00e9ggel. <\/p>\n\n\n\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\"><figure class=\"wp-block-media-text__media\"><img loading=\"lazy\" decoding=\"async\" width=\"332\" height=\"141\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/03\/lenyilo-lista-adatok-ervenyesitese-figyelmeztetes.png\" alt=\"\" class=\"wp-image-9443 size-full\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/03\/lenyilo-lista-adatok-ervenyesitese-figyelmeztetes.png 332w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2022\/03\/lenyilo-lista-adatok-ervenyesitese-figyelmeztetes-300x127.png 300w\" sizes=\"(max-width: 332px) 100vw, 332px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<p class=\"has-medium-font-size\">Jobb, ha ezt megel\u0151z\u00f6d a r\u00e9szletes betan\u00edt\u00e1ssal, illetve a cell\u00e1ba \u00edrhat\u00f3 figyelmeztet\u0151 \u00fczenettel. <\/p>\n\n\n\n<p class=\"has-medium-font-size\">Ezt a &#8216;Beviteli \u00fczenet&#8217; f\u00fcl\u00f6n adhatod meg.<\/p>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Fejleszd az Excel tud\u00e1sod<\/h2>\n\n\n\n<p>Ha szorgalmas vagy \u00e9s szeretsz k\u00f6nyvb\u0151l tanulni, akkor rendeld meg az&nbsp;<strong><a rel=\"noreferrer noopener\" href=\"https:\/\/exceltitok.hu\/excel-tankonyv\/\" target=\"_blank\">Excel Kezd\u0151 &amp; Halad\u00f3 tank\u00f6nyv\u00fcnket<\/a><\/strong>.<\/p>\n\n\n\n<p>Ha szeretn\u00e9d rendszerezetten \u00e1tn\u00e9zni az Excel alapjait, \u00e9s szeretsz m\u00e1sokkal egy\u00fctt tanulni, akkor gyere az online&nbsp;<strong><a rel=\"noreferrer noopener\" href=\"https:\/\/exceltitok.hu\/csoportos-kezdo-excel-tanfolyam\/\" target=\"_blank\">csoportos Excel k\u00e9pz\u00e9s\u00fcnkre<\/a><\/strong>!<\/p>\n\n\n\n<p>Ha egy\u00e9nileg szeretn\u00e9l tanulni vagy a munk\u00e1ddal kapcsolatos t\u00e1bl\u00e1zatokat rendbe tenni, akkor v\u00e1runk&nbsp;<strong><a href=\"https:\/\/exceltitok.hu\/oktatas\/\">egy\u00e9ni Excel oktat\u00e1sra<\/a><\/strong>.<\/p>\n\n\n\n<p>Vagy gyere a VIP Klubba, ahol&nbsp;<strong>hasonl\u00f3 \u00e9rdekes megold\u00e1sokat tal\u00e1lsz<\/strong>, \u00e9s Te is b\u00e1rmikor k\u00e9rdezhetsz:&nbsp;<strong><a rel=\"noreferrer noopener\" href=\"https:\/\/exceltitok.hu\/vip-klub-2021\/\" target=\"_blank\">Excel VIP Klub<\/a><\/strong>.<\/p>\n\n\n\n<p><a href=\"https:\/\/exceltitok.hu\/excel-fuggveny\/\">30 Excel f\u00fcggv\u00e9ny, amit mindenkinek tudni \u00e9rdemes<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/hasznald-ki-csereben-rejlo-lehetosegeket\/\">https:\/\/sosexcel.com\/exceltippek\/hasznald-ki-csereben-rejlo-lehetosegeket\/<\/a><\/p>\n\n\n\n","protected":false},"excerpt":{"rendered":"<p>K\u00e9sz\u00edtettem egy t\u00e1bl\u00e1zatot, amibe leny\u00edl\u00f3 list\u00e1t szeretn\u00e9k tenni, hogy\u00a0csak a megadott \u00e9rt\u00e9kekb\u0151l v\u00e1laszthasson a haszn\u00e1l\u00f3ja. V\u00e1lasz: A sz\u00fcks\u00e9ges funkci\u00f3t \u00c9rv\u00e9nyes\u00edt\u00e9snek h\u00edvj\u00e1k, \u00e9s az Adatok\u00a0f\u00fcl\u00f6n tal\u00e1lhat\u00f3.<\/p>\n","protected":false},"author":1,"featured_media":0,"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":[9,119,7],"class_list":["post-32","post","type-post","status-publish","format-standard","hentry","category-excel-tippek-gyakori-kerdesek","tag-formatum","tag-lenyilo-lista","tag-vedelem"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Leny\u00edl\u00f3 lista k\u00e9sz\u00edt\u00e9se - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\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\/lenyilo-lista-keszitese\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Leny\u00edl\u00f3 lista k\u00e9sz\u00edt\u00e9se - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"K\u00e9sz\u00edtettem egy t\u00e1bl\u00e1zatot, amibe leny\u00edl\u00f3 list\u00e1t szeretn\u00e9k tenni, hogy\u00a0csak a megadott \u00e9rt\u00e9kekb\u0151l v\u00e1laszthasson a haszn\u00e1l\u00f3ja. V\u00e1lasz: A sz\u00fcks\u00e9ges funkci\u00f3t \u00c9rv\u00e9nyes\u00edt\u00e9snek h\u00edvj\u00e1k, \u00e9s az Adatok\u00a0f\u00fcl\u00f6n tal\u00e1lhat\u00f3.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/\" \/>\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=\"2013-06-20T13:36:52+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-03-21T18:44:56+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/ervenyesites.jpg\" \/>\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=\"2 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Leny\u00edl\u00f3 lista k\u00e9sz\u00edt\u00e9se\",\"datePublished\":\"2013-06-20T13:36:52+00:00\",\"dateModified\":\"2022-03-21T18:44:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/\"},\"wordCount\":502,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/ervenyesites.jpg\",\"keywords\":[\"form\u00e1tum\",\"leny\u00edl\u00f3 lista\",\"v\u00e9delem\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/\",\"name\":\"Leny\u00edl\u00f3 lista k\u00e9sz\u00edt\u00e9se - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/#primaryimage\"},\"thumbnailUrl\":\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/ervenyesites.jpg\",\"datePublished\":\"2013-06-20T13:36:52+00:00\",\"dateModified\":\"2022-03-21T18:44:56+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/#primaryimage\",\"url\":\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/ervenyesites.jpg\",\"contentUrl\":\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/ervenyesites.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sosexcel.com\/exceltippek\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Leny\u00edl\u00f3 lista k\u00e9sz\u00edt\u00e9se\"}]},{\"@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":"Leny\u00edl\u00f3 lista k\u00e9sz\u00edt\u00e9se - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","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\/lenyilo-lista-keszitese\/","og_locale":"hu_HU","og_type":"article","og_title":"Leny\u00edl\u00f3 lista k\u00e9sz\u00edt\u00e9se - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"K\u00e9sz\u00edtettem egy t\u00e1bl\u00e1zatot, amibe leny\u00edl\u00f3 list\u00e1t szeretn\u00e9k tenni, hogy\u00a0csak a megadott \u00e9rt\u00e9kekb\u0151l v\u00e1laszthasson a haszn\u00e1l\u00f3ja. V\u00e1lasz: A sz\u00fcks\u00e9ges funkci\u00f3t \u00c9rv\u00e9nyes\u00edt\u00e9snek h\u00edvj\u00e1k, \u00e9s az Adatok\u00a0f\u00fcl\u00f6n tal\u00e1lhat\u00f3.","og_url":"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2013-06-20T13:36:52+00:00","article_modified_time":"2022-03-21T18:44:56+00:00","og_image":[{"url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/ervenyesites.jpg","type":"","width":"","height":""}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"2 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Leny\u00edl\u00f3 lista k\u00e9sz\u00edt\u00e9se","datePublished":"2013-06-20T13:36:52+00:00","dateModified":"2022-03-21T18:44:56+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/"},"wordCount":502,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/ervenyesites.jpg","keywords":["form\u00e1tum","leny\u00edl\u00f3 lista","v\u00e9delem"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/","url":"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/","name":"Leny\u00edl\u00f3 lista k\u00e9sz\u00edt\u00e9se - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/ervenyesites.jpg","datePublished":"2013-06-20T13:36:52+00:00","dateModified":"2022-03-21T18:44:56+00:00","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/#primaryimage","url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/ervenyesites.jpg","contentUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/ervenyesites.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/lenyilo-lista-keszitese\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Leny\u00edl\u00f3 lista k\u00e9sz\u00edt\u00e9se"}]},{"@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\/32","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=32"}],"version-history":[{"count":14,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/32\/revisions"}],"predecessor-version":[{"id":9448,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/32\/revisions\/9448"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=32"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=32"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=32"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}