{"id":13,"date":"2013-06-27T16:03:15","date_gmt":"2013-06-27T14:03:15","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=13"},"modified":"2022-10-17T11:20:31","modified_gmt":"2022-10-17T09:20:31","slug":"oszlopok-felfedese","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/oszlopok-felfedese\/","title":{"rendered":"Elrejtett oszlopok felfed\u00e9se"},"content":{"rendered":"\n<p>Van egy t\u00e1bl\u00e1zat, ahol n\u00e9h\u00e1ny oszlop nem l\u00e1tsz\u00f3dik, pedig ezekben&nbsp;kellene dolgoznom. Hogyan tudom feloldani \u0151ket?<\/p>\n\n\n\n<p><strong>V\u00e1lasz<\/strong>: Ahhoz, hogy \u00fajra l\u00e1that\u00f3ak legyenek az adatok, jel\u00f6ld ki a&nbsp;felfedni k\u00edv\u00e1nt oszlopok el\u0151tti \u00e9s ut\u00e1ni oszlopokat, majd a jobbklikk&nbsp;lebeg\u0151 men\u00fcb\u0151l v\u00e1laszd az &#8216;Felfed\u00e9s&#8217; parancsot.<\/p>\n\n\n\n<!--more-->\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/06\/felfedes.jpg\"><img fetchpriority=\"high\" decoding=\"async\" width=\"314\" height=\"334\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/06\/felfedes.jpg\" alt=\"Oszlopok felfed\u00e9se: Jel\u00f6ld ki a hi\u00e1nyz\u00f3 oszlopok melletti 2 oszlopot a felfed\u00e9shez.\" class=\"wp-image-132\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/06\/felfedes.jpg 314w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/06\/felfedes-282x300.jpg 282w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/06\/felfedes-240x255.jpg 240w\" sizes=\"(max-width: 314px) 100vw, 314px\" \/><\/a><figcaption>Jel\u00f6ld ki a hi\u00e1nyz\u00f3 oszlopok melletti 2 oszlopot a felfed\u00e9shez.<\/figcaption><\/figure><\/div>\n\n\n\n<p>Az Elrejt\u00e9s paranccsal tudod elrejteni a kijel\u00f6lt oszlopokat.<\/p>\n\n\n\n<p>A sorokn\u00e1l ugyan\u00edgy m\u0171k\u00f6dik a felfed\u00e9s-elrejt\u00e9s..<\/p>\n\n\n\n<p>Ha olyan r\u00e9szeket akarsz felfedni, amit nem tudsz kijel\u00f6lni, akkor kattints az A oszlop \u00e9s az els\u0151 sor k\u00f6z\u00f6tt l\u00e9v\u0151 h\u00e1romsz\u00f6gre, ami kijel\u00f6li a teljes t\u00e1bl\u00e1zatot (ugyanez a Ctrl A k\u00e9tszeri megnyom\u00e1sa). \u00cdgy az \u00f6sszes elrejtett oszlopot \u00e9s sort el\u0151var\u00e1zsolhatod.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Mikor \u00e9rdemes az Elrejt\u00e9s parancsot haszn\u00e1lni?<\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Ha k\u00e9s\u0151bb m\u00e9g sz\u00fcks\u00e9ged lehet az adatra,<\/li><li>ha t\u00f6bb l\u00e9p\u00e9sben vezett\u00e9l le egy sz\u00e1m\u00edt\u00e1st, de azt nem kell felt\u00e9tlen\u00fcl l\u00e1tni,<\/li><li>ha k\u00f6t\u00f6tt oszlopokkal dolgozol (ak\u00e1r t\u00f6bben is), emiatt nem t\u00f6r\u00f6lheted az oszlopokat, de nincs is r\u00e1 sz\u00fcks\u00e9ged.<\/li><\/ul>\n\n\n\n<p>Viszont semmik\u00e9ppen ne tegy\u00e9l titkos adatokat ide, mert b\u00e1rki haszn\u00e1lhatja a jobbklikkel az oszlopok felfed\u00e9se parancsot.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Elrejt\u00e9s \/ Felfed\u00e9s billenty\u0171kkel<\/h2>\n\n\n\n<p>A <strong>Ctrl 8 billenty\u0171kombin\u00e1ci\u00f3<\/strong> elt\u00fcnteti az(oka)t az oszlopo(ka)t, amelyikben a kurzor vagy kijel\u00f6l\u00e9s van. Az angol nyelv\u0171 g\u00e9peken \u00e9s Mac-n Ctrl 0 (nulla) teszi ugyanezt. <\/p>\n\n\n\n<p>Visszahozni (Felfed\u00e9s) \u00fagy tudod, hogy egyben (Shift ny\u00edl) kijel\u00f6lsz az el\u0151tte \u00e9s ut\u00e1na l\u00e9v\u0151 oszlopban is legal\u00e1bb 1-1 cell\u00e1t, majd megnyomod a <strong>Ctrl Shift 8 kombin\u00e1ci\u00f3t.<\/strong> (Az angol nyelv\u0171 g\u00e9peken \u00e9s Mac-n Ctrl Shift 0 a Felfed\u00e9s, b\u00e1r n\u00e1lam a Mac-en a Ctrl Shift 9 m\u0171k\u00f6dik.)<\/p>\n\n\n\n<p>Ha az A oszlopot rejted el, azt picit nehezebb visszahozni, mert ilyenkor is az el\u0151tte \u00e9s ut\u00e1na l\u00e9v\u0151 oszlopot kellene kijel\u00f6lni. Egyszer\u0171bb, ha kijel\u00f6l\u00f6d a teljes t\u00e1bl\u00e1zatot: &#8211; \u00fcres r\u00e9szen nyomod meg a Ctrl A-t, vagy &#8211; kit\u00f6lt\u00f6tt cell\u00e1n dupl\u00e1n nyomod meg a Ctrl A-t, majd ut\u00e1na a Ctrl Shift 8 billenty\u0171kombin\u00e1ci\u00f3t.<\/p>\n\n\n\n<p>A sorok elt\u00fcntet\u00e9se, felfed\u00e9se hasonl\u00f3an m\u0171k\u00f6dik, a billenty\u0171kombin\u00e1ci\u00f3ja Ctrl 9 \u00e9s Ctrl Shift 9 <\/p>\n\n\n\n<p>A Ctrl-lal mindig a fenti sz\u00e1mokat kell nyomni (a numerikus bilenty\u0171zettel nem m\u0171k\u00f6dik).<\/p>\n\n\n\n<p>Tanulj m\u00e9g t\u00f6bb hasznos billenty\u0171kombin\u00e1ci\u00f3t az 55 napos <a href=\"https:\/\/exceltitok.hu\/55-excel-billentyukombinacio\/\" data-type=\"URL\" data-id=\"https:\/\/exceltitok.hu\/55-excel-billentyukombinacio\/\" target=\"_blank\" rel=\"noreferrer noopener\">Excel billenty\u0171kombin\u00e1ci\u00f3 kih\u00edv\u00e1ssal<\/a>!<\/p>\n\n\n\n<p><strong>Tov\u00e1bbi hasznos tippek\u00e9rt \u00a0\u00e9s praktikus billenty\u0171-parancsok\u00e9rt rendeld meg a <a rel=\"noopener noreferrer\" href=\"http:\/\/exceltitok.hu\/111-excel-tipp\/\" target=\"_blank\">111 Hasznos Excel Tipp kiadv\u00e1nyt<\/a>\u00a0vagy <a href=\"http:\/\/exceltitok.hu\/arak\/\">jelentkezz tanfolyamra<\/a>!<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ez is hasznos Excel tud\u00e1s<\/h2>\n\n\n\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/elrejtett-adatok-megjelenitese\/\" data-type=\"URL\" data-id=\"https:\/\/sosexcel.com\/exceltippek\/elrejtett-adatok-megjelenitese\/\">Hogyan lehet az elrejtett adatokat \u00fajra megjelen\u00edteni?<\/a><\/p>\n\n\n\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/tobb-ful-nyomtatasa\/\" data-type=\"URL\" data-id=\"https:\/\/sosexcel.com\/exceltippek\/tobb-ful-nyomtatasa\/\">Nyomtass egyszerre t\u00f6bb f\u00fclet<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Van egy t\u00e1bl\u00e1zat, ahol n\u00e9h\u00e1ny oszlop nem l\u00e1tsz\u00f3dik, pedig ezekben&nbsp;kellene dolgoznom. Hogyan tudom feloldani \u0151ket? V\u00e1lasz: Ahhoz, hogy \u00fajra l\u00e1that\u00f3ak legyenek az adatok, jel\u00f6ld ki a&nbsp;felfedni k\u00edv\u00e1nt oszlopok el\u0151tti \u00e9s ut\u00e1ni oszlopokat, majd a jobbklikk&nbsp;lebeg\u0151 men\u00fcb\u0151l v\u00e1laszd az &#8216;Felfed\u00e9s&#8217; parancsot.<\/p>\n","protected":false},"author":1,"featured_media":6194,"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":[23],"class_list":["post-13","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek","tag-oszlop-sor-cella"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Elrejtett oszlopok felfed\u00e9se - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"Az oszlopok felfed\u00e9se miatt jel\u00f6ld ki a\u00a0felfedni k\u00edv\u00e1nt oszlopok el\u0151tti \u00e9s ut\u00e1ni oszlopokat, majd a jobbklikk men\u00fcn v\u00e1laszd az &#039;Felfed\u00e9s&#039; parancsot.\" \/>\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\/oszlopok-felfedese\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Elrejtett oszlopok felfed\u00e9se - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Az oszlopok felfed\u00e9se miatt jel\u00f6ld ki a\u00a0felfedni k\u00edv\u00e1nt oszlopok el\u0151tti \u00e9s ut\u00e1ni oszlopokat, majd a jobbklikk men\u00fcn v\u00e1laszd az &#039;Felfed\u00e9s&#039; parancsot.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/oszlopok-felfedese\/\" \/>\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-27T14:03:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-17T09:20:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/06\/oszlopok-elrejtese-felfedese.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2480\" \/>\n\t<meta property=\"og:image:height\" content=\"520\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bernadett\" \/>\n<meta name=\"twitter:label1\" content=\"Szerz\u0151:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bernadett\" \/>\n\t<meta name=\"twitter:label2\" content=\"Becs\u00fclt olvas\u00e1si id\u0151\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlopok-felfedese\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlopok-felfedese\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Elrejtett oszlopok felfed\u00e9se\",\"datePublished\":\"2013-06-27T14:03:15+00:00\",\"dateModified\":\"2022-10-17T09:20:31+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlopok-felfedese\\\/\"},\"wordCount\":510,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlopok-felfedese\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/06\\\/oszlopok-elrejtese-felfedese.png\",\"keywords\":[\"oszlop-sor-cella\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlopok-felfedese\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlopok-felfedese\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlopok-felfedese\\\/\",\"name\":\"Elrejtett oszlopok felfed\u00e9se - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlopok-felfedese\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlopok-felfedese\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/06\\\/oszlopok-elrejtese-felfedese.png\",\"datePublished\":\"2013-06-27T14:03:15+00:00\",\"dateModified\":\"2022-10-17T09:20:31+00:00\",\"description\":\"Az oszlopok felfed\u00e9se miatt jel\u00f6ld ki a\u00a0felfedni k\u00edv\u00e1nt oszlopok el\u0151tti \u00e9s ut\u00e1ni oszlopokat, majd a jobbklikk men\u00fcn v\u00e1laszd az 'Felfed\u00e9s' parancsot.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlopok-felfedese\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlopok-felfedese\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlopok-felfedese\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/06\\\/oszlopok-elrejtese-felfedese.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/06\\\/oszlopok-elrejtese-felfedese.png\",\"width\":2480,\"height\":520},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlopok-felfedese\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Elrejtett oszlopok felfed\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":"Elrejtett oszlopok felfed\u00e9se - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"Az oszlopok felfed\u00e9se miatt jel\u00f6ld ki a\u00a0felfedni k\u00edv\u00e1nt oszlopok el\u0151tti \u00e9s ut\u00e1ni oszlopokat, majd a jobbklikk men\u00fcn v\u00e1laszd az 'Felfed\u00e9s' parancsot.","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\/oszlopok-felfedese\/","og_locale":"hu_HU","og_type":"article","og_title":"Elrejtett oszlopok felfed\u00e9se - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Az oszlopok felfed\u00e9se miatt jel\u00f6ld ki a\u00a0felfedni k\u00edv\u00e1nt oszlopok el\u0151tti \u00e9s ut\u00e1ni oszlopokat, majd a jobbklikk men\u00fcn v\u00e1laszd az 'Felfed\u00e9s' parancsot.","og_url":"https:\/\/sosexcel.com\/exceltippek\/oszlopok-felfedese\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2013-06-27T14:03:15+00:00","article_modified_time":"2022-10-17T09:20:31+00:00","og_image":[{"width":2480,"height":520,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/06\/oszlopok-elrejtese-felfedese.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"3 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/oszlopok-felfedese\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/oszlopok-felfedese\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Elrejtett oszlopok felfed\u00e9se","datePublished":"2013-06-27T14:03:15+00:00","dateModified":"2022-10-17T09:20:31+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/oszlopok-felfedese\/"},"wordCount":510,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/oszlopok-felfedese\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/06\/oszlopok-elrejtese-felfedese.png","keywords":["oszlop-sor-cella"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/oszlopok-felfedese\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/oszlopok-felfedese\/","url":"https:\/\/sosexcel.com\/exceltippek\/oszlopok-felfedese\/","name":"Elrejtett oszlopok felfed\u00e9se - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/oszlopok-felfedese\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/oszlopok-felfedese\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/06\/oszlopok-elrejtese-felfedese.png","datePublished":"2013-06-27T14:03:15+00:00","dateModified":"2022-10-17T09:20:31+00:00","description":"Az oszlopok felfed\u00e9se miatt jel\u00f6ld ki a\u00a0felfedni k\u00edv\u00e1nt oszlopok el\u0151tti \u00e9s ut\u00e1ni oszlopokat, majd a jobbklikk men\u00fcn v\u00e1laszd az 'Felfed\u00e9s' parancsot.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/oszlopok-felfedese\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/oszlopok-felfedese\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/oszlopok-felfedese\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/06\/oszlopok-elrejtese-felfedese.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/06\/oszlopok-elrejtese-felfedese.png","width":2480,"height":520},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/oszlopok-felfedese\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Elrejtett oszlopok felfed\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\/13","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=13"}],"version-history":[{"count":8,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/13\/revisions"}],"predecessor-version":[{"id":9650,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/13\/revisions\/9650"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/6194"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=13"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=13"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=13"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}