{"id":10007,"date":"2025-12-01T14:39:00","date_gmt":"2025-12-01T13:39:00","guid":{"rendered":"https:\/\/sosexcel.com\/exceltippek\/?p=10007"},"modified":"2026-01-12T13:35:30","modified_gmt":"2026-01-12T12:35:30","slug":"ures-cellak-kijelolese","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/ures-cellak-kijelolese\/","title":{"rendered":"\u00dcres cell\u00e1k kijel\u00f6l\u00e9se"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">El\u0151fordulhat, hogy egy adott tartom\u00e1nyban csak az \u00fcres cell\u00e1kat szeretn\u00e9d kijel\u00f6lni. Ilyenkor el\u0151sz\u00f6r jel\u00f6lj ki egy nagyobb tartom\u00e1nyt. Haszn\u00e1lhatod a&nbsp;<strong>Shift PgDn<\/strong> kombin\u00e1ci\u00f3t, amivel oldalank\u00e9nt tudsz lefel\u00e9 kijel\u00f6lni, ha nem akarsz az eg\u00e9rrel bajl\u00f3dni. Vagy ha ismered a t\u00e1bl\u00e1zat v\u00e9g\u00e9t, a<strong>&nbsp;Ctrl G (Ugr\u00e1s)<\/strong>&nbsp;ablakban megadhatod a z\u00e1r\u00f3 cell\u00e1t, \u00e9s a&nbsp;<strong>Shift Enter<\/strong>rel hagyd j\u00f3v\u00e1, hogy ki is jel\u00f6lje a k\u00f6ztes cell\u00e1kat.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ir\u00e1ny\u00edtott kijel\u00f6l\u00e9s<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Az \u00fcres cell\u00e1k kijel\u00f6l\u00e9s\u00e9hez az&nbsp;<strong>Ir\u00e1ny\u00edtott kijel\u00f6l\u00e9s&nbsp;<\/strong>parancsot haszn\u00e1ld.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ezt vagy a Kezd\u0151lap v\u00e9g\u00e9n a Keres\u00e9s \u00e9s kijel\u00f6l\u00e9s men\u00fcben tal\u00e1lod:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/iranyitott-kijeloles-1.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"643\" height=\"832\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/iranyitott-kijeloles-1.png\" alt=\"\" class=\"wp-image-10015\" style=\"width:389px;height:auto\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/iranyitott-kijeloles-1.png 643w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/iranyitott-kijeloles-1-232x300.png 232w\" sizes=\"(max-width: 643px) 100vw, 643px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Vagy a&nbsp;<strong>Ctrl G (Ugr\u00e1s)<\/strong> ablak bal als\u00f3 sark\u00e1ban l\u00e9v\u0151&nbsp;&#8216;Ir\u00e1ny\u00edtott\u2026&#8217; gombra nyomj (vagy helyette haszn\u00e1lhatod az <strong>Alt R<\/strong> kombin\u00e1ci\u00f3t &#8211; a k\u00e9pen l\u00e1tsz\u00f3dik, hogy az r bet\u0171 al\u00e1 van h\u00fazva.)<\/p>\n\n\n\n<figure class=\"wp-block-image size-full is-resized\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/iranyitott-kijeloles-2.png\"><img decoding=\"async\" width=\"570\" height=\"613\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/iranyitott-kijeloles-2.png\" alt=\"\" class=\"wp-image-10016\" style=\"width:392px;height:auto\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/iranyitott-kijeloles-2.png 570w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/iranyitott-kijeloles-2-279x300.png 279w\" sizes=\"(max-width: 570px) 100vw, 570px\" \/><\/a><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">A megjelen\u0151 ablakban v\u00e1laszd az &#8216;\u00dcres cell\u00e1k&#8217; opci\u00f3t.<\/p>\n\n\n\n<figure class=\"wp-block-image alignleft is-resized\"><img decoding=\"async\" src=\"http:\/\/exceltitok.hu\/wp-content\/uploads\/2018\/06\/iranyitott-kijel%C3%B6l%C3%A9s-%C3%BCres-cella.png\" alt=\"\" style=\"width:390px;height:auto\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Az &#8216;Ok&#8217; gomb megnyom\u00e1sa ut\u00e1n (vagy haszn\u00e1lhatod az <a href=\"https:\/\/sosexcel.com\/exceltippek\/2-egyszeru-gomb-ami-helyett-feleslegesen-kattintasz\/\">Enter billenty\u0171t<\/a> is) m\u00e1r csak az \u00fcres cell\u00e1k lesznek kijel\u00f6lve<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Szeretn\u00e9d jobban megismerni, begyakorolni az Excelt?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">*&nbsp;V\u00e1laszd a Tank\u00f6nyvb\u0151l \u00e9s&nbsp;29 \u00edr\u00e1sban kidolgozott p\u00e9ld\u00e1b\u00f3l \u00e9s 34 extra&nbsp;feladatb\u00f3l \u00e1ll\u00f3&nbsp;<strong>\u2018Kezd\u0151 Tanul\u00f3csomagot\u2019,<\/strong>&nbsp;amivel elkezdheted&nbsp;a tanul\u00e1st. V\u00e1gj bele min\u00e9l el\u0151bb:&nbsp;<a href=\"https:\/\/exceltitok.hu\/excel-nagyagyu\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/excel-nagyagyu<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">*&nbsp;Ha saj\u00e1t temp\u00f3dban tanuln\u00e1l tov\u00e1bbi hasznos tr\u00fckk\u00f6ket, \u00fagy, hogy van seg\u00edts\u00e9g is, ha b\u00e1rmivel elakadt\u00e1l, akkor gyere az <a href=\"https:\/\/excelklub.hu\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>ExcelTitok VIP Klubba<\/strong><\/a>! <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">* Ha szeretsz m\u00e1sokkal egy\u00fctt tanulni, akkor gyere az online&nbsp;<strong><a href=\"https:\/\/exceltitok.hu\/stabil-excel\/\" target=\"_blank\" rel=\"noreferrer noopener\">csoportos Excel k\u00e9pz\u00e9s\u00fcnkre<\/a><\/strong>!<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">* 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","protected":false},"excerpt":{"rendered":"<p>El\u0151fordulhat, hogy egy adott tartom\u00e1nyban csak az \u00fcres cell\u00e1kat szeretn\u00e9d kijel\u00f6lni. Ilyenkor el\u0151sz\u00f6r jel\u00f6lj ki egy nagyobb tartom\u00e1nyt. Haszn\u00e1lhatod a&nbsp;Shift PgDn kombin\u00e1ci\u00f3t, amivel oldalank\u00e9nt tudsz lefel\u00e9 kijel\u00f6lni, ha nem akarsz az eg\u00e9rrel bajl\u00f3dni. Vagy ha ismered a t\u00e1bl\u00e1zat v\u00e9g\u00e9t, a&nbsp;Ctrl G (Ugr\u00e1s)&nbsp;ablakban megadhatod a z\u00e1r\u00f3 cell\u00e1t, \u00e9s a&nbsp;Shift Enterrel hagyd j\u00f3v\u00e1, hogy ki is jel\u00f6lje [&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-10007","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.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u00dcres cell\u00e1k kijel\u00f6l\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\/ures-cellak-kijelolese\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00dcres cell\u00e1k kijel\u00f6l\u00e9se - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"El\u0151fordulhat, hogy egy adott tartom\u00e1nyban csak az \u00fcres cell\u00e1kat szeretn\u00e9d kijel\u00f6lni. Ilyenkor el\u0151sz\u00f6r jel\u00f6lj ki egy nagyobb tartom\u00e1nyt. Haszn\u00e1lhatod a&nbsp;Shift PgDn kombin\u00e1ci\u00f3t, amivel oldalank\u00e9nt tudsz lefel\u00e9 kijel\u00f6lni, ha nem akarsz az eg\u00e9rrel bajl\u00f3dni. Vagy ha ismered a t\u00e1bl\u00e1zat v\u00e9g\u00e9t, a&nbsp;Ctrl G (Ugr\u00e1s)&nbsp;ablakban megadhatod a z\u00e1r\u00f3 cell\u00e1t, \u00e9s a&nbsp;Shift Enterrel hagyd j\u00f3v\u00e1, hogy ki is jel\u00f6lje [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/ures-cellak-kijelolese\/\" \/>\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=\"2025-12-01T13:39:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-12T12:35:30+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/iranyitott-kijeloles-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"643\" \/>\n\t<meta property=\"og:image:height\" content=\"832\" \/>\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=\"2 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/ures-cellak-kijelolese\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/ures-cellak-kijelolese\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"\u00dcres cell\u00e1k kijel\u00f6l\u00e9se\",\"datePublished\":\"2025-12-01T13:39:00+00:00\",\"dateModified\":\"2026-01-12T12:35:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/ures-cellak-kijelolese\\\/\"},\"wordCount\":352,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/ures-cellak-kijelolese\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/iranyitott-kijeloles-1.png\",\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/ures-cellak-kijelolese\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/ures-cellak-kijelolese\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/ures-cellak-kijelolese\\\/\",\"name\":\"\u00dcres cell\u00e1k kijel\u00f6l\u00e9se - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/ures-cellak-kijelolese\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/ures-cellak-kijelolese\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/iranyitott-kijeloles-1.png\",\"datePublished\":\"2025-12-01T13:39:00+00:00\",\"dateModified\":\"2026-01-12T12:35:30+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/ures-cellak-kijelolese\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/ures-cellak-kijelolese\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/ures-cellak-kijelolese\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/iranyitott-kijeloles-1.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2025\\\/11\\\/iranyitott-kijeloles-1.png\",\"width\":643,\"height\":832},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/ures-cellak-kijelolese\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00dcres cell\u00e1k kijel\u00f6l\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":"\u00dcres cell\u00e1k kijel\u00f6l\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\/ures-cellak-kijelolese\/","og_locale":"hu_HU","og_type":"article","og_title":"\u00dcres cell\u00e1k kijel\u00f6l\u00e9se - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"El\u0151fordulhat, hogy egy adott tartom\u00e1nyban csak az \u00fcres cell\u00e1kat szeretn\u00e9d kijel\u00f6lni. Ilyenkor el\u0151sz\u00f6r jel\u00f6lj ki egy nagyobb tartom\u00e1nyt. Haszn\u00e1lhatod a&nbsp;Shift PgDn kombin\u00e1ci\u00f3t, amivel oldalank\u00e9nt tudsz lefel\u00e9 kijel\u00f6lni, ha nem akarsz az eg\u00e9rrel bajl\u00f3dni. Vagy ha ismered a t\u00e1bl\u00e1zat v\u00e9g\u00e9t, a&nbsp;Ctrl G (Ugr\u00e1s)&nbsp;ablakban megadhatod a z\u00e1r\u00f3 cell\u00e1t, \u00e9s a&nbsp;Shift Enterrel hagyd j\u00f3v\u00e1, hogy ki is jel\u00f6lje [&hellip;]","og_url":"https:\/\/sosexcel.com\/exceltippek\/ures-cellak-kijelolese\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2025-12-01T13:39:00+00:00","article_modified_time":"2026-01-12T12:35:30+00:00","og_image":[{"width":643,"height":832,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/iranyitott-kijeloles-1.png","type":"image\/png"}],"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\/ures-cellak-kijelolese\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/ures-cellak-kijelolese\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"\u00dcres cell\u00e1k kijel\u00f6l\u00e9se","datePublished":"2025-12-01T13:39:00+00:00","dateModified":"2026-01-12T12:35:30+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/ures-cellak-kijelolese\/"},"wordCount":352,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/ures-cellak-kijelolese\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/iranyitott-kijeloles-1.png","articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/ures-cellak-kijelolese\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/ures-cellak-kijelolese\/","url":"https:\/\/sosexcel.com\/exceltippek\/ures-cellak-kijelolese\/","name":"\u00dcres cell\u00e1k kijel\u00f6l\u00e9se - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/ures-cellak-kijelolese\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/ures-cellak-kijelolese\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/iranyitott-kijeloles-1.png","datePublished":"2025-12-01T13:39:00+00:00","dateModified":"2026-01-12T12:35:30+00:00","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/ures-cellak-kijelolese\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/ures-cellak-kijelolese\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/ures-cellak-kijelolese\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/iranyitott-kijeloles-1.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2025\/11\/iranyitott-kijeloles-1.png","width":643,"height":832},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/ures-cellak-kijelolese\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"\u00dcres cell\u00e1k kijel\u00f6l\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\/10007","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=10007"}],"version-history":[{"count":5,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/10007\/revisions"}],"predecessor-version":[{"id":10026,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/10007\/revisions\/10026"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=10007"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=10007"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=10007"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}