{"id":26,"date":"2013-07-31T01:49:24","date_gmt":"2013-07-30T23:49:24","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=26"},"modified":"2017-04-29T11:38:25","modified_gmt":"2017-04-29T09:38:25","slug":"hogyan-lehet-megcserelni-az-oszlopokat","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/hogyan-lehet-megcserelni-az-oszlopokat\/","title":{"rendered":"Hogyan lehet megcser\u00e9lni az oszlopokat?"},"content":{"rendered":"<p>Mit kell tennem, ha szeretn\u00e9k megcser\u00e9lni 2 oszlopot az Excel t\u00e1bl\u00e1ban?<\/p>\n<p><strong><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere.png\"><img decoding=\"async\" class=\"alignleft wp-image-3919\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere.png\" alt=\"oszlopcsere\" width=\"206\" height=\"108\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere.png 406w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere-300x157.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere-240x126.png 240w\" sizes=\"(max-width: 206px) 100vw, 206px\" \/><\/a>V\u00e1lasz<\/strong>: Oszlopcsere funkci\u00f3 nincs az Excelben.<\/p>\n<p>Az \u00e1trendez\u00e9shez az\u00a0adott oszlopot ki kell v\u00e1gni (Ctrl X) \u00e9s az \u00faj helyre pedig be kell\u00a0sz\u00farni. <!--more-->Nagyon fontos, hogy ez nem sima beilleszt\u00e9s, hiszen az\u00a0fel\u00fcl\u00edrn\u00e1 az oszlopban szerepl\u0151 eredeti adatokat!\u00a0Most\u00a0mindenk\u00e9ppen \u00faj hely kell az\u00a0adatnak.<\/p>\n<p>Viszont megsp\u00f3rolhatod, hogy \u00fcres oszlopot kelljen besz\u00farnod: jel\u00f6ld ki azt\u00a0az oszlopot, amely el\u00e9 szeretn\u00e9d tenni az el\u0151bb kiv\u00e1gott\u00a0oszlopot. Itt a jobbklikk lebeg\u0151 men\u00fcb\u0151l v\u00e1laszd<strong> a Kiv\u00e1gott cell\u00e1k\u00a0besz\u00far\u00e1sa opci\u00f3t.<\/strong><\/p>\n<p>Ez egyszerre sz\u00far be egy \u00faj oszlopot az \u00faj adatoknak \u00e9s tolja arr\u00e9bb a t\u00f6bbit.<\/p>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/kivagott-oszlop-beszurasa.jpg\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignleft wp-image-142 size-full\" style=\"border: 1px solid grey;\" title=\"Kiv\u00e1gott oszlop besz\u00far\u00e1sa\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/kivagott-oszlop-beszurasa.jpg\" alt=\"Oszlopcsere helyett Kiv\u00e1gott oszlop besz\u00far\u00e1sa\" width=\"342\" height=\"158\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/kivagott-oszlop-beszurasa.jpg 342w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/kivagott-oszlop-beszurasa-300x138.jpg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/kivagott-oszlop-beszurasa-240x110.jpg 240w\" sizes=\"(max-width: 342px) 100vw, 342px\" \/><\/a><\/p>\n<p>Ez a fajta &#8222;oszlopcsere&#8221;\u00a0m\u0171k\u00f6dik m\u00e1sol\u00e1sn\u00e1l is, ilyenkor automatikusan a <strong>M\u00e1solt cell\u00e1k besz\u00far\u00e1sa<\/strong> parancs jelenik meg a jobbklikkes lebeg\u0151 men\u00fcn.<\/p>\n<p>Nem csak oszlopok, hanem sorok, cell\u00e1k\u00a0eset\u00e9n is haszn\u00e1lhatod.<\/p>\n<h3>Oszlopcsere tr\u00fckk\u00f6sen az eg\u00e9rrel<\/h3>\n<p>Ugyanezt az eredm\u00e9nyt kapod, ha a Shift gomb nyomva tart\u00e1sa mellett <a href=\"https:\/\/sosexcel.com\/exceltippek\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\/\" target=\"_blank\" rel=\"noopener noreferrer\">mozgatod a tartom\u00e1nyt<\/a>\u00a0a kijel\u00f6l\u00e9s sz\u00e9l\u00e9n\u00e9l.<\/p>\n<p>A Shift \u00e9s Ctrl egy\u00fcttes lenyom\u00e1s\u00e1val pedig a m\u00e1solatot tudod besz\u00farni.<\/p>\n<p>Mindk\u00e9t esetben egy sz\u00fcrke &#8222;cs\u00edk&#8221; mutatja, hogy hov\u00e1 ker\u00fclnek \u00e1t az adatok. (A sz\u00fcrke kisablakban megjelenik\u00a0a pontos cellatartom\u00e1ny is.) Ahogy\u00a0elengeded az egeret (a Shiftet k\u00f6zben m\u00e9g tartsd nyomva), egyb\u0151l jobbra cs\u00fasznak a cell\u00e1k, \u00e9s m\u00e1ris k\u00e9sz a &#8222;csere&#8221;.<a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere-eg\u00e9rrel.png\"><img decoding=\"async\" class=\"alignleft wp-image-4047 size-full\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere-eg\u00e9rrel.png\" alt=\"Oszlopcsere eg\u00e9rrel: a sz\u00fcrke cs\u00edk mutatja a besz\u00far\u00e1s hely\u00e9t.\" width=\"717\" height=\"377\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere-eg\u00e9rrel.png 717w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere-eg\u00e9rrel-300x158.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere-eg\u00e9rrel-660x347.png 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere-eg\u00e9rrel-240x126.png 240w\" sizes=\"(max-width: 717px) 100vw, 717px\" \/><\/a><\/p>\n<p>Az Excel logik\u00e1j\u00e1ban a besz\u00far\u00e1s mindig &#8222;<a href=\"https:\/\/sosexcel.com\/exceltippek\/oszlop-beszuras\/\" target=\"_blank\" rel=\"noopener noreferrer\">el\u00e9<\/a>&#8221; t\u00f6rt\u00e9nik, vagyis a r\u00e9gi cell\u00e1k (oszlopok) jobbra vagy (sorok) lefel\u00e9 cs\u00fasznak.<\/p>\n<p><strong>Ha \u00a0tetszett az oszlopcsere tr\u00fckk, akkor ezek\u00a0a cikkek is hasznosak lehetnek:<\/strong><\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"tbL6GFwPVd\"><p><a href=\"https:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/\">Meg lehet ford\u00edtani a t\u00e1bl\u00e1zatot?<\/a><\/p><\/blockquote>\n<p><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Meg lehet ford\u00edtani a t\u00e1bl\u00e1zatot?&#8221; &#8212; Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" src=\"https:\/\/sosexcel.com\/exceltippek\/meg-lehet-forditani-a-tablazatot\/embed\/#?secret=K1h3XMwJgJ#?secret=tbL6GFwPVd\" data-secret=\"tbL6GFwPVd\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>https:\/\/sosexcel.com\/exceltippek\/hogyan-tudok-2-excel-tablazatot-egymas-melle-helyezni\/<\/p>\n<p><strong>Tov\u00e1bbi hasznos tippek\u00e9rt<\/strong>\u00a0\u00e9s praktikus billenty\u0171-parancsok\u00e9rt rendeld meg a\u00a0<strong><a href=\"http:\/\/exceltitok.hu\/111-excel-tipp\/\" target=\"_blank\" rel=\"noopener noreferrer\">111 Hasznos Excel Tipp kiadv\u00e1nyt!<\/a><\/strong><\/p>\n<p><strong>Ha a munk\u00e1d miatt <\/strong>szeretn\u00e9d m\u00e9g gyorsabban \u00e9s \u00fcgyesebben\u00a0haszn\u00e1lni az Excel t\u00e1bl\u00e1zatokat, vagy csak jobban \u00e9rteni az \u00f6sszef\u00fcgg\u00e9seket, kattints ide, \u00e9s profi tan\u00e1rainkkal sz\u00edvesen seg\u00edt\u00fcnk:<strong> <a href=\"http:\/\/exceltitok.hu\/arak\/\" target=\"_blank\" rel=\"noopener noreferrer\">Szem\u00e9lyre szabott, egy\u00e9ni Excel tanfolyamok<\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mit kell tennem, ha szeretn\u00e9k megcser\u00e9lni 2 oszlopot az Excel t\u00e1bl\u00e1ban? V\u00e1lasz: Oszlopcsere funkci\u00f3 nincs az Excelben. Az \u00e1trendez\u00e9shez az\u00a0adott oszlopot ki kell v\u00e1gni (Ctrl X) \u00e9s az \u00faj helyre pedig be kell\u00a0sz\u00farni.<\/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":[1],"tags":[16,18],"class_list":["post-26","post","type-post","status-publish","format-standard","hentry","category-excel-tippek-gyakori-kerdesek","tag-masolas","tag-sporolj-kattintast"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Hogyan lehet megcser\u00e9lni az oszlopokat? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"L\u00e9tezik oszlopcsere az Excelben? Nem, de vannak tr\u00fckk\u00f6k, amivel gyorsan megcser\u00e9lheted az oszlopban l\u00e9v\u0151 adatokat.\" \/>\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\/hogyan-lehet-megcserelni-az-oszlopokat\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hogyan lehet megcser\u00e9lni az oszlopokat? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"L\u00e9tezik oszlopcsere az Excelben? Nem, de vannak tr\u00fckk\u00f6k, amivel gyorsan megcser\u00e9lheted az oszlopban l\u00e9v\u0151 adatokat.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-lehet-megcserelni-az-oszlopokat\/\" \/>\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-07-30T23:49:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-04-29T09:38:25+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere.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\\\/hogyan-lehet-megcserelni-az-oszlopokat\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hogyan-lehet-megcserelni-az-oszlopokat\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Hogyan lehet megcser\u00e9lni az oszlopokat?\",\"datePublished\":\"2013-07-30T23:49:24+00:00\",\"dateModified\":\"2017-04-29T09:38:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hogyan-lehet-megcserelni-az-oszlopokat\\\/\"},\"wordCount\":394,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hogyan-lehet-megcserelni-az-oszlopokat\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/07\\\/oszlopcsere.png\",\"keywords\":[\"m\u00e1sol\u00e1s\",\"sp\u00f3rolj kattint\u00e1st\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hogyan-lehet-megcserelni-az-oszlopokat\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hogyan-lehet-megcserelni-az-oszlopokat\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hogyan-lehet-megcserelni-az-oszlopokat\\\/\",\"name\":\"Hogyan lehet megcser\u00e9lni az oszlopokat? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hogyan-lehet-megcserelni-az-oszlopokat\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hogyan-lehet-megcserelni-az-oszlopokat\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/07\\\/oszlopcsere.png\",\"datePublished\":\"2013-07-30T23:49:24+00:00\",\"dateModified\":\"2017-04-29T09:38:25+00:00\",\"description\":\"L\u00e9tezik oszlopcsere az Excelben? Nem, de vannak tr\u00fckk\u00f6k, amivel gyorsan megcser\u00e9lheted az oszlopban l\u00e9v\u0151 adatokat.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hogyan-lehet-megcserelni-az-oszlopokat\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hogyan-lehet-megcserelni-az-oszlopokat\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hogyan-lehet-megcserelni-az-oszlopokat\\\/#primaryimage\",\"url\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/07\\\/oszlopcsere.png\",\"contentUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/07\\\/oszlopcsere.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hogyan-lehet-megcserelni-az-oszlopokat\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hogyan lehet megcser\u00e9lni az oszlopokat?\"}]},{\"@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":"Hogyan lehet megcser\u00e9lni az oszlopokat? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"L\u00e9tezik oszlopcsere az Excelben? Nem, de vannak tr\u00fckk\u00f6k, amivel gyorsan megcser\u00e9lheted az oszlopban l\u00e9v\u0151 adatokat.","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\/hogyan-lehet-megcserelni-az-oszlopokat\/","og_locale":"hu_HU","og_type":"article","og_title":"Hogyan lehet megcser\u00e9lni az oszlopokat? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"L\u00e9tezik oszlopcsere az Excelben? Nem, de vannak tr\u00fckk\u00f6k, amivel gyorsan megcser\u00e9lheted az oszlopban l\u00e9v\u0151 adatokat.","og_url":"https:\/\/sosexcel.com\/exceltippek\/hogyan-lehet-megcserelni-az-oszlopokat\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2013-07-30T23:49:24+00:00","article_modified_time":"2017-04-29T09:38:25+00:00","og_image":[{"url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere.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\/hogyan-lehet-megcserelni-az-oszlopokat\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hogyan-lehet-megcserelni-az-oszlopokat\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Hogyan lehet megcser\u00e9lni az oszlopokat?","datePublished":"2013-07-30T23:49:24+00:00","dateModified":"2017-04-29T09:38:25+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hogyan-lehet-megcserelni-az-oszlopokat\/"},"wordCount":394,"commentCount":4,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hogyan-lehet-megcserelni-az-oszlopokat\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere.png","keywords":["m\u00e1sol\u00e1s","sp\u00f3rolj kattint\u00e1st"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/hogyan-lehet-megcserelni-az-oszlopokat\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/hogyan-lehet-megcserelni-az-oszlopokat\/","url":"https:\/\/sosexcel.com\/exceltippek\/hogyan-lehet-megcserelni-az-oszlopokat\/","name":"Hogyan lehet megcser\u00e9lni az oszlopokat? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hogyan-lehet-megcserelni-az-oszlopokat\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hogyan-lehet-megcserelni-az-oszlopokat\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere.png","datePublished":"2013-07-30T23:49:24+00:00","dateModified":"2017-04-29T09:38:25+00:00","description":"L\u00e9tezik oszlopcsere az Excelben? Nem, de vannak tr\u00fckk\u00f6k, amivel gyorsan megcser\u00e9lheted az oszlopban l\u00e9v\u0151 adatokat.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hogyan-lehet-megcserelni-az-oszlopokat\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/hogyan-lehet-megcserelni-az-oszlopokat\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/hogyan-lehet-megcserelni-az-oszlopokat\/#primaryimage","url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere.png","contentUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/07\/oszlopcsere.png"},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/hogyan-lehet-megcserelni-az-oszlopokat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Hogyan lehet megcser\u00e9lni az oszlopokat?"}]},{"@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\/26","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=26"}],"version-history":[{"count":14,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/26\/revisions"}],"predecessor-version":[{"id":5022,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/26\/revisions\/5022"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=26"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=26"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=26"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}