{"id":9905,"date":"2024-10-04T11:49:00","date_gmt":"2024-10-04T09:49:00","guid":{"rendered":"https:\/\/sosexcel.com\/exceltippek\/?p=9905"},"modified":"2025-11-27T13:47:05","modified_gmt":"2025-11-27T12:47:05","slug":"tablazat-alja-ha-ures-cellak-vannak","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/tablazat-alja-ha-ures-cellak-vannak\/","title":{"rendered":"\u00cdgy juthatsz le gyorsan a t\u00e1bl\u00e1zat alj\u00e1ra, ha \u00fcres cell\u00e1k vannak benne"},"content":{"rendered":"\n<p>Kaptam egy \u00e9rdekes k\u00e9rd\u00e9st, ami sokaknak seg\u00edthet: Az a probl\u00e9m\u00e1m, hogy a Ctrl \u2b07 kombin\u00e1ci\u00f3 csak akkor megy az utols\u00f3 kit\u00f6lt\u00f6tt sorba, ha nincsen a sorok k\u00f6z\u00f6tt \u00fcres sor.<\/p>\n\n\n\n<p>A mi renszer\u00fcnkben minden kit\u00f6lt\u00f6tt sor ut\u00e1n van egy&nbsp;<strong>\u00fcres sor.&nbsp;<\/strong>Ebben az&nbsp;<strong>esetben hogyan lehet eljutni az utols\u00f3 sorba?<\/strong><\/p>\n\n\n\n<p>Megjegyz\u00e9s: Alapvet\u0151en nem szerencs\u00e9s \u00fcres sorokkal tagolni egy t\u00e1bl\u00e1zat, hiszen az adatb\u00e1zisnak pont az a l\u00e9nyege, hogy egybef\u00fcgg\u0151en kezeljed az adatokat&#8230; <a href=\"https:\/\/sosexcel.com\/exceltippek\/ures-sorok-torlese\/\">\u00cdgy tudod gyorsan t\u00f6r\u00f6lni az\u00fcres sorokat.<\/a><\/p>\n\n\n\n<p>Szerencs\u00e9re van megold\u00e1s!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Legals\u00f3 kit\u00f6lt\u00f6tt sor<\/h2>\n\n\n\n<p>Lehet pr\u00f3b\u00e1lkozni a&nbsp;<strong>Ctrl End<\/strong>-del, de az n\u00e9ha \u00e9rdekes helyekre visz&#8230;<\/p>\n\n\n\n<p>Viszont egy teljesen \u00fcres oszlopban a Ctrl \u2b07 az Excel alj\u00e1ra visz, majd egy kit\u00f6lt\u00f6tt oszlopba \u00e1tl\u00e9pve (szigor\u00faan nyilakkal!) a Ctrl \u2b06 visszaugrik az &#8222;els\u0151 tal\u00e1latra&#8221;, azaz az utols\u00f3 kit\u00f6lt\u00f6tt sorra.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Kattint\u00e1s b\u00e1rhov\u00e1, kijel\u00f6l\u00e9s b\u00e1rhol<\/h2>\n\n\n\n<p>Emellett l\u00e9tezik az &#8222;Ugr\u00e1s&#8221; funkci\u00f3, aminek az&nbsp;<strong>F5 vagy a Ctrl G<\/strong>&nbsp;a gyorsgombja &#8211; amelyik szimpatikusabb.<\/p>\n\n\n\n<p>Az ugr\u00e1s panelben&nbsp;<strong>b\u00e1rmelyik cella azonos\u00edt\u00f3j\u00e1t megadhatod, \u00e9s az Enterrel m\u00e1r ott is vagy!&nbsp;<\/strong>Ehhez persze tudni kell a cellaazonos\u00edt\u00f3t &#8211; azaz egyszer le kell menni legalulra.&nbsp;<\/p>\n\n\n\n<p>Ha nagyobb ter\u00fclett szeretn\u00e9l kijel\u00f6lni, akkor&nbsp;tartom\u00e1nyt adj meg az ablakban, pl. B2:J100<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ingyenes gyorsbillenty\u0171 webin\u00e1r<\/h2>\n\n\n\n<p>Gyere el okt\u00f3ber 8-\u00e1n a d\u00edjmentes el\u0151ad\u00e1somra, \u00e9s fedezd fel az Excel gyorsbillenty\u0171k vil\u00e1g\u00e1t:&nbsp;<a href=\"https:\/\/exceltitok.t.emesz.com\/t\/l\/2UJMZ\/5YQN\/1pM\/2z8\/2sy\/0\/0\/0\/0\/wp7TbHCPqP_BYCrbLYlasYBWNgJ6tZcqTw8\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/webinar<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Egy\u00e9ni fejl\u0151d\u00e9s \u00e9s k\u00f6z\u00f6s gyakorl\u00e1s<\/h2>\n\n\n\n<p>Ha viszont szeretn\u00e9l komolyan fejl\u0151dni, akkor v\u00e1rlak a&nbsp;VIP Klubban!&nbsp;<strong>A szok\u00e1sok megv\u00e1ltoztat\u00e1sa egy\u00fctt k\u00f6nnyebb<\/strong>, mint egyed\u00fcl.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Rendszeresen \u00e9l\u0151ben, k\u00f6z\u00f6sen&nbsp;<\/strong>gyakoroljuk a billenty\u0171kombin\u00e1ci\u00f3kat &#8211; a kor\u00e1bbi alkalmakat felv\u00e9telr\u0151l visszan\u00e9zheted<\/li>\n\n\n\n<li><strong>Aj\u00e1nd\u00e9k<\/strong>ba megkapod az 55 napos kih\u00edv\u00e1s anyag\u00e1t egy&nbsp;<strong>pdf<\/strong>-ben \u00f6sszeszerkesztve<\/li>\n\n\n\n<li>Klubtagk\u00e9nt&nbsp;<strong>b\u00e1rmikor k\u00e9rdezhetsz<\/strong>, ha elakadsz az Excellel, gyorsan seg\u00edt\u00fcnk<\/li>\n\n\n\n<li>Az oktat\u00f3 anyagainkra \u00e9s a csoportos tr\u00e9ningjeinkre&nbsp;<strong>25% kedvezm\u00e9ny<\/strong>&nbsp;j\u00e1r<\/li>\n\n\n\n<li>a\u00a0<strong>7.875 Ft-os havid\u00edj<\/strong>at garant\u00e1ljuk, am\u00edg folyamatosan tag maradsz<\/li>\n<\/ul>\n\n\n\n<p>Csatlakozz\u00a0<strong>mind\u00f6ssze 7.875 Ft-\u00e9rt<\/strong>:\u00a0<a href=\"https:\/\/exceltitok.t.emesz.com\/t\/l\/2UJMb\/5YQN\/1pM\/2z8\/2sy\/0\/0\/0\/0\/wp7TbHCPqP_BYCrbLYlasYBWNgJ6tZcqTw8\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/vip-klub<\/a>\u00a0<\/p>\n\n\n\n<p><strong>V\u00e1laszd az \u00e9ves tags\u00e1got<\/strong>, \u00e9s k\u00f6telezd el magad a folyamatos fejl\u0151d\u00e9s mellett. \u00cdgy\u00a0<strong>2 h\u00f3nap aj\u00e1nd\u00e9k<\/strong>, azaz az \u00e9ves d\u00edj brutt\u00f3 78.750 Ft.<\/p>\n\n\n\n<p>Az Excel&nbsp;<strong>tanul\u00e1s egy gyorsan megt\u00e9r\u00fcl\u0151 befektet\u00e9s<\/strong>.&nbsp;<\/p>\n\n\n\n<p>V\u00e1rlak&nbsp;szeretettel a webin\u00e1riumon, tanfolyamokon&nbsp;\u00e9s a Klubban!<\/p>\n\n\n\n<p>Ha szeretn\u00e9d \u00e1tfog\u00f3an rendbe tenni az Excelt, akkor gyere el csoportos Excel tanfolyamunkra! B\u0151vebb inform\u00e1ci\u00f3:&nbsp;<br><a href=\"https:\/\/exceltitok.t.emesz.com\/t\/l\/2UJMc\/5YQN\/1pM\/2z8\/2sy\/0\/0\/0\/0\/wp7TbHCPqP_BYCrbLYlasYBWNgJ6tZcqTw8\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/csoportos<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Kaptam egy \u00e9rdekes k\u00e9rd\u00e9st, ami sokaknak seg\u00edthet: Az a probl\u00e9m\u00e1m, hogy a Ctrl \u2b07 kombin\u00e1ci\u00f3 csak akkor megy az utols\u00f3 kit\u00f6lt\u00f6tt sorba, ha nincsen a sorok k\u00f6z\u00f6tt \u00fcres sor. A mi renszer\u00fcnkben minden kit\u00f6lt\u00f6tt sor ut\u00e1n van egy&nbsp;\u00fcres sor.&nbsp;Ebben az&nbsp;esetben hogyan lehet eljutni az utols\u00f3 sorba? Megjegyz\u00e9s: Alapvet\u0151en nem szerencs\u00e9s \u00fcres sorokkal tagolni egy t\u00e1bl\u00e1zat, [&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":"","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":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","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-9905","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>\u00cdgy juthatsz le gyorsan a t\u00e1bl\u00e1zat alj\u00e1ra, ha \u00fcres cell\u00e1k vannak benne - 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\/tablazat-alja-ha-ures-cellak-vannak\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00cdgy juthatsz le gyorsan a t\u00e1bl\u00e1zat alj\u00e1ra, ha \u00fcres cell\u00e1k vannak benne - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Kaptam egy \u00e9rdekes k\u00e9rd\u00e9st, ami sokaknak seg\u00edthet: Az a probl\u00e9m\u00e1m, hogy a Ctrl \u2b07 kombin\u00e1ci\u00f3 csak akkor megy az utols\u00f3 kit\u00f6lt\u00f6tt sorba, ha nincsen a sorok k\u00f6z\u00f6tt \u00fcres sor. A mi renszer\u00fcnkben minden kit\u00f6lt\u00f6tt sor ut\u00e1n van egy&nbsp;\u00fcres sor.&nbsp;Ebben az&nbsp;esetben hogyan lehet eljutni az utols\u00f3 sorba? Megjegyz\u00e9s: Alapvet\u0151en nem szerencs\u00e9s \u00fcres sorokkal tagolni egy t\u00e1bl\u00e1zat, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/tablazat-alja-ha-ures-cellak-vannak\/\" \/>\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=\"2024-10-04T09:49:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-11-27T12:47:05+00:00\" \/>\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\/tablazat-alja-ha-ures-cellak-vannak\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/tablazat-alja-ha-ures-cellak-vannak\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"\u00cdgy juthatsz le gyorsan a t\u00e1bl\u00e1zat alj\u00e1ra, ha \u00fcres cell\u00e1k vannak benne\",\"datePublished\":\"2024-10-04T09:49:00+00:00\",\"dateModified\":\"2025-11-27T12:47:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/tablazat-alja-ha-ures-cellak-vannak\/\"},\"wordCount\":506,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/tablazat-alja-ha-ures-cellak-vannak\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/tablazat-alja-ha-ures-cellak-vannak\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/tablazat-alja-ha-ures-cellak-vannak\/\",\"name\":\"\u00cdgy juthatsz le gyorsan a t\u00e1bl\u00e1zat alj\u00e1ra, ha \u00fcres cell\u00e1k vannak benne - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\"},\"datePublished\":\"2024-10-04T09:49:00+00:00\",\"dateModified\":\"2025-11-27T12:47:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/tablazat-alja-ha-ures-cellak-vannak\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/tablazat-alja-ha-ures-cellak-vannak\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/tablazat-alja-ha-ures-cellak-vannak\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sosexcel.com\/exceltippek\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00cdgy juthatsz le gyorsan a t\u00e1bl\u00e1zat alj\u00e1ra, ha \u00fcres cell\u00e1k vannak benne\"}]},{\"@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":"\u00cdgy juthatsz le gyorsan a t\u00e1bl\u00e1zat alj\u00e1ra, ha \u00fcres cell\u00e1k vannak benne - 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\/tablazat-alja-ha-ures-cellak-vannak\/","og_locale":"hu_HU","og_type":"article","og_title":"\u00cdgy juthatsz le gyorsan a t\u00e1bl\u00e1zat alj\u00e1ra, ha \u00fcres cell\u00e1k vannak benne - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Kaptam egy \u00e9rdekes k\u00e9rd\u00e9st, ami sokaknak seg\u00edthet: Az a probl\u00e9m\u00e1m, hogy a Ctrl \u2b07 kombin\u00e1ci\u00f3 csak akkor megy az utols\u00f3 kit\u00f6lt\u00f6tt sorba, ha nincsen a sorok k\u00f6z\u00f6tt \u00fcres sor. A mi renszer\u00fcnkben minden kit\u00f6lt\u00f6tt sor ut\u00e1n van egy&nbsp;\u00fcres sor.&nbsp;Ebben az&nbsp;esetben hogyan lehet eljutni az utols\u00f3 sorba? Megjegyz\u00e9s: Alapvet\u0151en nem szerencs\u00e9s \u00fcres sorokkal tagolni egy t\u00e1bl\u00e1zat, [&hellip;]","og_url":"https:\/\/sosexcel.com\/exceltippek\/tablazat-alja-ha-ures-cellak-vannak\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2024-10-04T09:49:00+00:00","article_modified_time":"2025-11-27T12:47:05+00:00","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\/tablazat-alja-ha-ures-cellak-vannak\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/tablazat-alja-ha-ures-cellak-vannak\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"\u00cdgy juthatsz le gyorsan a t\u00e1bl\u00e1zat alj\u00e1ra, ha \u00fcres cell\u00e1k vannak benne","datePublished":"2024-10-04T09:49:00+00:00","dateModified":"2025-11-27T12:47:05+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/tablazat-alja-ha-ures-cellak-vannak\/"},"wordCount":506,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/tablazat-alja-ha-ures-cellak-vannak\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/tablazat-alja-ha-ures-cellak-vannak\/","url":"https:\/\/sosexcel.com\/exceltippek\/tablazat-alja-ha-ures-cellak-vannak\/","name":"\u00cdgy juthatsz le gyorsan a t\u00e1bl\u00e1zat alj\u00e1ra, ha \u00fcres cell\u00e1k vannak benne - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"datePublished":"2024-10-04T09:49:00+00:00","dateModified":"2025-11-27T12:47:05+00:00","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/tablazat-alja-ha-ures-cellak-vannak\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/tablazat-alja-ha-ures-cellak-vannak\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/tablazat-alja-ha-ures-cellak-vannak\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"\u00cdgy juthatsz le gyorsan a t\u00e1bl\u00e1zat alj\u00e1ra, ha \u00fcres cell\u00e1k vannak benne"}]},{"@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\/9905","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=9905"}],"version-history":[{"count":2,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/9905\/revisions"}],"predecessor-version":[{"id":10014,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/9905\/revisions\/10014"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=9905"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=9905"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=9905"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}