{"id":1271,"date":"2014-07-04T09:34:19","date_gmt":"2014-07-04T07:34:19","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=1271"},"modified":"2018-07-24T03:36:35","modified_gmt":"2018-07-24T01:36:35","slug":"oszlop-beszuras","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/oszlop-beszuras\/","title":{"rendered":"Honnan tudhatod, hogy hov\u00e1 ker\u00fcl a besz\u00fart oszlop?"},"content":{"rendered":"<p>Sosem tudom, hogy besz\u00far\u00e1shoz mit kell kijel\u00f6lni.<\/p>\n<p><strong>V\u00e1lasz:<\/strong> Jegyezd meg, hogy az Excel mindig a kijel\u00f6lt r\u00e9sz el\u00e9 sz\u00farja be azt, amit kijel\u00f6lt\u00e9l. Ez azt jelenti, hogy az oszlopot a kijel\u00f6l\u00e9st\u0151l balra, sort a kijel\u00f6l\u00e9s f\u00f6l\u00e9 sz\u00farja be, cell\u00e1n\u00e1l pedig r\u00e1k\u00e9rdez, hogy melyik ir\u00e1nyba (f\u00f6l\u00e9 vagy balra) k\u00e9red az \u00faj cell\u00e1t.<!--more--><\/p>\n<p>A m\u00f3dszer ugyanaz mindh\u00e1rom esetben. Az egyszer\u0171s\u00e9g kedv\u00e9\u00e9rt n\u00e9zz\u00fck az oszlop besz\u00far\u00e1s\u00e1t.<\/p>\n<h3>Azt jel\u00f6ld ki, ami el\u00e9<\/h3>\n<p>Egyetlen oszlop besz\u00far\u00e1s\u00e1hoz<strong> jel\u00f6ld ki azt az oszlopot, amely el\u00e9 (balra)<\/strong> kell az \u00faj oszlop. Ha p\u00e9ld\u00e1ul a B \u00e9s a C oszlop k\u00f6z\u00e9 szeretn\u00e9d\u00a0besz\u00farni az \u00faj oszlopot, kattints a C oszlopra.<\/p>\n<h3><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/oszlop-beszurasa-excel.png\"><img fetchpriority=\"high\" decoding=\"async\" class=\" wp-image-1273\" style=\"border: 1px solid grey;\" title=\"\u00daj oszlop besz\u00far\u00e1sa\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/oszlop-beszurasa-excel.png\" alt=\"A lebeg\u0151 men\u00fcn megtal\u00e1lod a Besz\u00far\u00e1s parancsot\" width=\"702\" height=\"362\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/oszlop-beszurasa-excel.png 702w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/oszlop-beszurasa-excel-300x154.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/oszlop-beszurasa-excel-660x340.png 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/oszlop-beszurasa-excel-240x123.png 240w\" sizes=\"(max-width: 702px) 100vw, 702px\" \/><\/a>Ha t\u00f6bb oszlopot szeretn\u00e9l besz\u00farni<\/h3>\n<p>A besz\u00far\u00e1s hely\u00e9t\u0151l\u00a0jobbra jel\u00f6lj ki <strong>annyi oszlopot, mint amennyit be\u00a0szeretn\u00e9l sz\u00farni<\/strong>. Ha p\u00e9ld\u00e1ul h\u00e1rom \u00faj oszlopot szeretn\u00e9l besz\u00farni\u00a0a D oszlop el\u00e9, akkor h\u00e1rom oszlopot (D-F) kell kijel\u00f6ln\u00f6d.<\/p>\n<p><strong>Nem szomsz\u00e9dos oszlopok besz\u00far\u00e1s\u00e1hoz<\/strong> az oszlopok kijel\u00f6l\u00e9sekor\u00a0tartsd lenyomva a <a title=\"Haszn\u00e1ld a Ctrl gombot t\u00f6bb cella kijel\u00f6l\u00e9s\u00e9hez'\" href=\"https:\/\/sosexcel.com\/exceltippek\/turbozd-fel-az-egeret\/\" target=\"_blank\">Ctrl billenty\u0171t.<\/a>\u00a0Ez p\u00e9ld\u00e1ul j\u00f3l j\u00f6het, ha csoportok \u00f6sszes\u00edt\u00e9s\u00e9hez van sz\u00fcks\u00e9ged extra helyre (p\u00e9ld\u00e1ul negyed\u00e9vekre akarod a forgalmat l\u00e1tni)<\/p>\n<p>Ha megvan a kijel\u00f6l\u00e9s, kattints a jobb gombbal a kijel\u00f6lt oszlopokra, \u00e9s v\u00e1laszd a helyi men\u00fc Besz\u00far\u00e1s parancs\u00e1t.<\/p>\n<h3>Cell\u00e1k besz\u00far\u00e1sa<\/h3>\n<p>Bizonyos esetekben &#8211; jellemz\u0151en ha t\u00f6bb t\u00e1bl\u00e1zat is van a munkalapon &#8211; el\u00e9g lehet csak n\u00e9h\u00e1ny cella besz\u00far\u00e1sa.<\/p>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/cellak-beszurasa.jpg\"><img decoding=\"async\" class=\"alignleft size-full wp-image-1411\" style=\"border: 1px solid grey;\" title=\"Cell\u00e1k besz\u00far\u00e1sa\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/cellak-beszurasa.jpg\" alt=\"Cell\u00e1k besz\u00far\u00e1sa\" width=\"187\" height=\"184\" \/><\/a>Ilyenkor az Excel mindig r\u00e1k\u00e9rdez, hogy melyik ir\u00e1nyba tolja el a kijel\u00f6lt cell\u00e1t (jobbra vagy lefel\u00e9).<\/p>\n<p>C\u00e9lszer\u0171 a t\u00e1bl\u00e1zatodban eg\u00e9sz sz\u00e9less\u00e9g\u00e9ben kijel\u00f6lni a cell\u00e1kat, ha nem akarod, hogy elcs\u00fasszanak az adatok.<\/p>\n<p>Mindig ellen\u0151rizd a t\u00f6bbi t\u00e1bl\u00e1zatot, \u00e9s \u00fagy ir\u00e1ny\u00edtsd a besz\u00far\u00e1st, hogy azok se essenek sz\u00e9t. Ha sz\u00fcks\u00e9ges, id\u0151ben l\u00e9pj vissza.<\/p>\n<p>A Ctrl seg\u00edts\u00e9g\u00e9vel t\u00f6bb k\u00fcl\u00f6n\u00e1ll\u00f3 cellacsoporton is elv\u00e9gezheted a besz\u00far\u00e1st, ha azonos ir\u00e1nyba akarod tolni az \u00f6sszes cell\u00e1t.<\/p>\n<p>K\u00edv\u00e1ncsi vagy, hogyan lehet besz\u00farni eg\u00e9r n\u00e9lk\u00fcl (csak billenty\u0171vel)? Szeretn\u00e9l tov\u00e1bbi hasznos tippeket megismerni? Akkor <strong><a href=\"http:\/\/exceltitok.hu\/111-excel-tipp\/\" target=\"_blank\">rendeld meg a 111 Hasznos Excel Tipp kiadv\u00e1nyt!<\/a><\/strong><\/p>\n<p><strong>M\u00e9g egy tipp:<\/strong> Ha m\u00e1r form\u00e1zva van a t\u00e1bl\u00e1zat, akkor a Besz\u00far\u00e1si lehet\u0151s\u00e9gek\u00a0paranccsal (ecset ikon) v\u00e1laszthatsz, hogy az el\u0151z\u0151 vagy a k\u00f6vetkez\u0151 oszlop (vagy egyik se)\u00a0form\u00e1tum\u00e1t akarod az \u00fajonnan besz\u00fart cell\u00e1kon l\u00e1tni.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sosem tudom, hogy besz\u00far\u00e1shoz mit kell kijel\u00f6lni. V\u00e1lasz: Jegyezd meg, hogy az Excel mindig a kijel\u00f6lt r\u00e9sz el\u00e9 sz\u00farja be azt, amit kijel\u00f6lt\u00e9l. Ez azt jelenti, hogy az oszlopot a kijel\u00f6l\u00e9st\u0151l balra, sort a kijel\u00f6l\u00e9s f\u00f6l\u00e9 sz\u00farja be, cell\u00e1n\u00e1l pedig r\u00e1k\u00e9rdez, hogy melyik ir\u00e1nyba (f\u00f6l\u00e9 vagy balra) k\u00e9red az \u00faj cell\u00e1t.<\/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":"","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":"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":[102,1],"tags":[23],"class_list":["post-1271","post","type-post","status-publish","format-standard","hentry","category-excel-tablazat-keszitese","category-excel-tippek-gyakori-kerdesek","tag-oszlop-sor-cella"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Honnan tudhatod, hogy hov\u00e1 ker\u00fcl a besz\u00fart oszlop? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"A besz\u00far\u00e1shoz mit kell kijel\u00f6lni? Az Excel mindig a kijel\u00f6lt r\u00e9sz el\u00e9 sz\u00farja be azt, amit kijel\u00f6lt\u00e9l. Ez azt jelenti, hogy az oszlopot a kijel\u00f6l\u00e9st\u0151l balra, sort a kijel\u00f6l\u00e9s f\u00f6l\u00e9 sz\u00farja be, cell\u00e1n\u00e1l pedig r\u00e1k\u00e9rdez.\" \/>\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\/oszlop-beszuras\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Honnan tudhatod, hogy hov\u00e1 ker\u00fcl a besz\u00fart oszlop? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"A besz\u00far\u00e1shoz mit kell kijel\u00f6lni? Az Excel mindig a kijel\u00f6lt r\u00e9sz el\u00e9 sz\u00farja be azt, amit kijel\u00f6lt\u00e9l. Ez azt jelenti, hogy az oszlopot a kijel\u00f6l\u00e9st\u0151l balra, sort a kijel\u00f6l\u00e9s f\u00f6l\u00e9 sz\u00farja be, cell\u00e1n\u00e1l pedig r\u00e1k\u00e9rdez.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/oszlop-beszuras\/\" \/>\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=\"2014-07-04T07:34:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-07-24T01:36:35+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/oszlop-beszurasa-excel.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\\\/oszlop-beszuras\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlop-beszuras\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Honnan tudhatod, hogy hov\u00e1 ker\u00fcl a besz\u00fart oszlop?\",\"datePublished\":\"2014-07-04T07:34:19+00:00\",\"dateModified\":\"2018-07-24T01:36:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlop-beszuras\\\/\"},\"wordCount\":506,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlop-beszuras\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/07\\\/oszlop-beszurasa-excel.png\",\"keywords\":[\"oszlop-sor-cella\"],\"articleSection\":[\"Excel t\u00e1bl\u00e1zat k\u00e9sz\u00edt\u00e9se\",\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlop-beszuras\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlop-beszuras\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlop-beszuras\\\/\",\"name\":\"Honnan tudhatod, hogy hov\u00e1 ker\u00fcl a besz\u00fart oszlop? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlop-beszuras\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlop-beszuras\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/07\\\/oszlop-beszurasa-excel.png\",\"datePublished\":\"2014-07-04T07:34:19+00:00\",\"dateModified\":\"2018-07-24T01:36:35+00:00\",\"description\":\"A besz\u00far\u00e1shoz mit kell kijel\u00f6lni? Az Excel mindig a kijel\u00f6lt r\u00e9sz el\u00e9 sz\u00farja be azt, amit kijel\u00f6lt\u00e9l. Ez azt jelenti, hogy az oszlopot a kijel\u00f6l\u00e9st\u0151l balra, sort a kijel\u00f6l\u00e9s f\u00f6l\u00e9 sz\u00farja be, cell\u00e1n\u00e1l pedig r\u00e1k\u00e9rdez.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlop-beszuras\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlop-beszuras\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlop-beszuras\\\/#primaryimage\",\"url\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/07\\\/oszlop-beszurasa-excel.png\",\"contentUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2014\\\/07\\\/oszlop-beszurasa-excel.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/oszlop-beszuras\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Honnan tudhatod, hogy hov\u00e1 ker\u00fcl a besz\u00fart oszlop?\"}]},{\"@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":"Honnan tudhatod, hogy hov\u00e1 ker\u00fcl a besz\u00fart oszlop? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"A besz\u00far\u00e1shoz mit kell kijel\u00f6lni? Az Excel mindig a kijel\u00f6lt r\u00e9sz el\u00e9 sz\u00farja be azt, amit kijel\u00f6lt\u00e9l. Ez azt jelenti, hogy az oszlopot a kijel\u00f6l\u00e9st\u0151l balra, sort a kijel\u00f6l\u00e9s f\u00f6l\u00e9 sz\u00farja be, cell\u00e1n\u00e1l pedig r\u00e1k\u00e9rdez.","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\/oszlop-beszuras\/","og_locale":"hu_HU","og_type":"article","og_title":"Honnan tudhatod, hogy hov\u00e1 ker\u00fcl a besz\u00fart oszlop? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"A besz\u00far\u00e1shoz mit kell kijel\u00f6lni? Az Excel mindig a kijel\u00f6lt r\u00e9sz el\u00e9 sz\u00farja be azt, amit kijel\u00f6lt\u00e9l. Ez azt jelenti, hogy az oszlopot a kijel\u00f6l\u00e9st\u0151l balra, sort a kijel\u00f6l\u00e9s f\u00f6l\u00e9 sz\u00farja be, cell\u00e1n\u00e1l pedig r\u00e1k\u00e9rdez.","og_url":"https:\/\/sosexcel.com\/exceltippek\/oszlop-beszuras\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2014-07-04T07:34:19+00:00","article_modified_time":"2018-07-24T01:36:35+00:00","og_image":[{"url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/oszlop-beszurasa-excel.png","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\/oszlop-beszuras\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/oszlop-beszuras\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Honnan tudhatod, hogy hov\u00e1 ker\u00fcl a besz\u00fart oszlop?","datePublished":"2014-07-04T07:34:19+00:00","dateModified":"2018-07-24T01:36:35+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/oszlop-beszuras\/"},"wordCount":506,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/oszlop-beszuras\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/oszlop-beszurasa-excel.png","keywords":["oszlop-sor-cella"],"articleSection":["Excel t\u00e1bl\u00e1zat k\u00e9sz\u00edt\u00e9se","Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/oszlop-beszuras\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/oszlop-beszuras\/","url":"https:\/\/sosexcel.com\/exceltippek\/oszlop-beszuras\/","name":"Honnan tudhatod, hogy hov\u00e1 ker\u00fcl a besz\u00fart oszlop? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/oszlop-beszuras\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/oszlop-beszuras\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/oszlop-beszurasa-excel.png","datePublished":"2014-07-04T07:34:19+00:00","dateModified":"2018-07-24T01:36:35+00:00","description":"A besz\u00far\u00e1shoz mit kell kijel\u00f6lni? Az Excel mindig a kijel\u00f6lt r\u00e9sz el\u00e9 sz\u00farja be azt, amit kijel\u00f6lt\u00e9l. Ez azt jelenti, hogy az oszlopot a kijel\u00f6l\u00e9st\u0151l balra, sort a kijel\u00f6l\u00e9s f\u00f6l\u00e9 sz\u00farja be, cell\u00e1n\u00e1l pedig r\u00e1k\u00e9rdez.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/oszlop-beszuras\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/oszlop-beszuras\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/oszlop-beszuras\/#primaryimage","url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/oszlop-beszurasa-excel.png","contentUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2014\/07\/oszlop-beszurasa-excel.png"},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/oszlop-beszuras\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Honnan tudhatod, hogy hov\u00e1 ker\u00fcl a besz\u00fart oszlop?"}]},{"@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\/1271","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=1271"}],"version-history":[{"count":16,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/1271\/revisions"}],"predecessor-version":[{"id":4423,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/1271\/revisions\/4423"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=1271"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=1271"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=1271"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}