{"id":15,"date":"2013-02-17T18:14:15","date_gmt":"2013-02-17T17:14:15","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=15"},"modified":"2021-05-06T03:41:29","modified_gmt":"2021-05-06T01:41:29","slug":"hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\/","title":{"rendered":"Haszn\u00e1lod ezt a gyors tr\u00fckk\u00f6t a cell\u00e1k \u00e9s munkalapok m\u00e1sol\u00e1s\u00e1ra?"},"content":{"rendered":"<p>Ha k\u00f6zeli helyre szeretn\u00e9l \u00e9rt\u00e9keket m\u00e1solni, megsp\u00f3rolhatod a Ctrl C,\u00a0Ctrl V kombin\u00e1ci\u00f3kat.<\/p>\n<h2>Cell\u00e1k m\u00e1sol\u00e1sa eg\u00e9rrel<\/h2>\n<p>Egyszer\u0171en jel\u00f6ld ki a m\u00e1soland\u00f3 cell\u00e1kat, majd \u00e1llj az eg\u00e9rrel a vastag szeg\u00e9ly f\u00f6l\u00e9. Ilyenkor <strong>megjelenik a n\u00e9gy\u00e1g\u00fa\u00a0ny\u00edl, ami a mozgat\u00e1st (\u00e1thelyez\u00e9st) jelenti<\/strong>.<\/p>\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/02\/gyors-masolas.jpg\"><img decoding=\"async\" class=\"alignleft wp-image-157 size-full\" style=\"border: 1px solid grey;\" title=\"Gyors m\u00e1sol\u00e1s\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/02\/gyors-masolas.jpg\" alt=\"Az eg\u00e9rrel gyorsan tudsz m\u00e1solni, \u00e1thelyezni.\" width=\"171\" height=\"187\" \/><\/a><\/p>\n<p>Amennyiben lenyomod a Ctrl billenty\u0171t, a ny\u00edl + jell\u00e9 v\u00e1ltozik. Ha \u00edgy\u00a0mozgatod el a cell\u00e1kat, akkor az eredeti cell\u00e1k megmaradnak, \u00e9s az \u00faj\u00a0helyre m\u00e1solat ker\u00fcl.<\/p>\n<p>Mindig figyeld, hogy mik\u00e9nt jelenik meg az eg\u00e9r, mert az utal a funkci\u00f3ra.<\/p>\n<p>Az eg\u00e9rrel \u00edgy nagyon gyorsan tudsz m\u00e1solni vagy \u00e1thelyezni.<\/p>\n<h2>Munkalapok m\u00e1sol\u00e1sa eg\u00e9rrel<\/h2>\n<p><strong>Ugyan\u00edgy tudod a munkalapokat is \u00e1thelyezni \u00e9s m\u00e1solni.<\/strong><\/p>\n<p>M\u00e1solat\u00a0l\u00e9trehoz\u00e1s\u00e1hoz fogd meg a kiv\u00e1lasztott lapot, \u00e9s a Ctrl billenty\u0171\u00a0nyomva tart\u00e1sa mellett h\u00fazd az \u00faj helyre. A kurzor mellett ilyenkor is\u00a0megjelenik a + jel, amib\u0151l tudhatod, hogy m\u00e1solat k\u00e9sz\u00fcl.<\/p>\n<h2>Drag-n-drop<\/h2>\n\n\n<p>Angolul drag-n-drop (magyarul \u201efogd \u00e9s vidd\u201d) nevezik azt, mikor az eg\u00e9r seg\u00edts\u00e9g\u00e9vel lehet mozgatni, m\u00e1solni f\u00e1jlokat, objektumokat. <\/p>\n\n\n\n<p><strong>Im\u00e1dom a gyorsbillenty\u0171ket<\/strong>, de vannak esetek, amikor az eg\u00e9r haszn\u00e1lata az egyszer\u0171bb, gyorsabb. Ebben a vide\u00f3ban a kedvenc egeres tr\u00fckkjeimet szedtem \u00f6ssze. Vannak benne hasznos duplakattos tr\u00fckk\u00f6k. 4:27-t\u0151l mutatom\u200b cell\u00e1k \u00e9s munkalapok gyors mozgat\u00e1s\u00e1t illetve m\u00e1sol\u00e1s\u00e1t. \u00c9rdemes az elej\u00e9r\u0151l megn\u00e9zned a vide\u00f3t, mert<a href=\"https:\/\/sosexcel.com\/exceltippek\/mit-jelentenek-az-eger-kulonbozo-alakjai\/\" data-type=\"post\" data-id=\"360\" target=\"_blank\" rel=\"noreferrer noopener\"> <span style=\"text-decoration: underline;\">az eg\u00e9r k\u00fcl\u00f6nb\u00f6z\u0151 alakjait<\/span><\/a> \u00e9s funkci\u00f3it is jobban meg\u00e9rted. A vide\u00f3 v\u00e9g\u00e9b\u0151l pedig azt is megtanulhatod, hogyan <a rel=\"noreferrer noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-lehet-megcserelni-az-oszlopokat\/\" data-type=\"post\" data-id=\"26\" target=\"_blank\"><span style=\"text-decoration: underline;\">cser\u00e9lheted fel az oszlopokat<\/span><\/a> egy mozdulattal.<\/p>\n\n\n\n<iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/kWeBObQfyh4\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n\n\n\n<p>Ha szeretn\u00e9d jobban \u00e9rteni az Excelt, akkor <a href=\"http:\/\/exceltitok.hu\/excel-alapok\/\"><span style=\"text-decoration: underline;\">kezdd az alapokka<\/span>l<\/a>.<\/p>\n\n\n\n<p><strong><a rel=\"noreferrer noopener\" href=\"http:\/\/exceltitok.hu\/111-excel-tipp\/\" target=\"_blank\">Tov\u00e1bbi hasznos tippek\u00e9rt \u00a0\u00e9s praktikus billenty\u0171-parancsok\u00e9rt rendeld meg a <span style=\"text-decoration: underline;\">111 Hasznos Excel Tipp kiadv\u00e1nyt!<\/span><\/a><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ha k\u00f6zeli helyre szeretn\u00e9l \u00e9rt\u00e9keket m\u00e1solni, megsp\u00f3rolhatod a Ctrl C,\u00a0Ctrl V kombin\u00e1ci\u00f3kat. Cell\u00e1k m\u00e1sol\u00e1sa eg\u00e9rrel Egyszer\u0171en jel\u00f6ld ki a m\u00e1soland\u00f3 cell\u00e1kat, majd \u00e1llj az eg\u00e9rrel a vastag szeg\u00e9ly f\u00f6l\u00e9. Ilyenkor megjelenik a n\u00e9gy\u00e1g\u00fa\u00a0ny\u00edl, ami a mozgat\u00e1st (\u00e1thelyez\u00e9st) jelenti. Amennyiben lenyomod a Ctrl billenty\u0171t, a ny\u00edl + jell\u00e9 v\u00e1ltozik. Ha \u00edgy\u00a0mozgatod el a cell\u00e1kat, akkor az [&hellip;]<\/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":"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":[102,1],"tags":[20,16,15],"class_list":["post-15","post","type-post","status-publish","format-standard","hentry","category-excel-tablazat-keszitese","category-excel-tippek-gyakori-kerdesek","tag-eger","tag-masolas","tag-munkalap"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Haszn\u00e1lod ezt a gyors tr\u00fckk\u00f6t a cell\u00e1k \u00e9s munkalapok m\u00e1sol\u00e1s\u00e1ra? - 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\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Haszn\u00e1lod ezt a gyors tr\u00fckk\u00f6t a cell\u00e1k \u00e9s munkalapok m\u00e1sol\u00e1s\u00e1ra? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Ha k\u00f6zeli helyre szeretn\u00e9l \u00e9rt\u00e9keket m\u00e1solni, megsp\u00f3rolhatod a Ctrl C,\u00a0Ctrl V kombin\u00e1ci\u00f3kat. Cell\u00e1k m\u00e1sol\u00e1sa eg\u00e9rrel Egyszer\u0171en jel\u00f6ld ki a m\u00e1soland\u00f3 cell\u00e1kat, majd \u00e1llj az eg\u00e9rrel a vastag szeg\u00e9ly f\u00f6l\u00e9. Ilyenkor megjelenik a n\u00e9gy\u00e1g\u00fa\u00a0ny\u00edl, ami a mozgat\u00e1st (\u00e1thelyez\u00e9st) jelenti. Amennyiben lenyomod a Ctrl billenty\u0171t, a ny\u00edl + jell\u00e9 v\u00e1ltozik. Ha \u00edgy\u00a0mozgatod el a cell\u00e1kat, akkor az [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\/\" \/>\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-02-17T17:14:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-06T01:41:29+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/02\/gyors-masolas.jpg\" \/>\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\\\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Haszn\u00e1lod ezt a gyors tr\u00fckk\u00f6t a cell\u00e1k \u00e9s munkalapok m\u00e1sol\u00e1s\u00e1ra?\",\"datePublished\":\"2013-02-17T17:14:15+00:00\",\"dateModified\":\"2021-05-06T01:41:29+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\\\/\"},\"wordCount\":347,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/02\\\/gyors-masolas.jpg\",\"keywords\":[\"eg\u00e9r\",\"m\u00e1sol\u00e1s\",\"munkalap\"],\"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\\\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\\\/\",\"name\":\"Haszn\u00e1lod ezt a gyors tr\u00fckk\u00f6t a cell\u00e1k \u00e9s munkalapok m\u00e1sol\u00e1s\u00e1ra? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/02\\\/gyors-masolas.jpg\",\"datePublished\":\"2013-02-17T17:14:15+00:00\",\"dateModified\":\"2021-05-06T01:41:29+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\\\/#primaryimage\",\"url\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/02\\\/gyors-masolas.jpg\",\"contentUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2013\\\/02\\\/gyors-masolas.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Haszn\u00e1lod ezt a gyors tr\u00fckk\u00f6t a cell\u00e1k \u00e9s munkalapok m\u00e1sol\u00e1s\u00e1ra?\"}]},{\"@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":"Haszn\u00e1lod ezt a gyors tr\u00fckk\u00f6t a cell\u00e1k \u00e9s munkalapok m\u00e1sol\u00e1s\u00e1ra? - 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\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\/","og_locale":"hu_HU","og_type":"article","og_title":"Haszn\u00e1lod ezt a gyors tr\u00fckk\u00f6t a cell\u00e1k \u00e9s munkalapok m\u00e1sol\u00e1s\u00e1ra? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Ha k\u00f6zeli helyre szeretn\u00e9l \u00e9rt\u00e9keket m\u00e1solni, megsp\u00f3rolhatod a Ctrl C,\u00a0Ctrl V kombin\u00e1ci\u00f3kat. Cell\u00e1k m\u00e1sol\u00e1sa eg\u00e9rrel Egyszer\u0171en jel\u00f6ld ki a m\u00e1soland\u00f3 cell\u00e1kat, majd \u00e1llj az eg\u00e9rrel a vastag szeg\u00e9ly f\u00f6l\u00e9. Ilyenkor megjelenik a n\u00e9gy\u00e1g\u00fa\u00a0ny\u00edl, ami a mozgat\u00e1st (\u00e1thelyez\u00e9st) jelenti. Amennyiben lenyomod a Ctrl billenty\u0171t, a ny\u00edl + jell\u00e9 v\u00e1ltozik. Ha \u00edgy\u00a0mozgatod el a cell\u00e1kat, akkor az [&hellip;]","og_url":"https:\/\/sosexcel.com\/exceltippek\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2013-02-17T17:14:15+00:00","article_modified_time":"2021-05-06T01:41:29+00:00","og_image":[{"url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/02\/gyors-masolas.jpg","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\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Haszn\u00e1lod ezt a gyors tr\u00fckk\u00f6t a cell\u00e1k \u00e9s munkalapok m\u00e1sol\u00e1s\u00e1ra?","datePublished":"2013-02-17T17:14:15+00:00","dateModified":"2021-05-06T01:41:29+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\/"},"wordCount":347,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/02\/gyors-masolas.jpg","keywords":["eg\u00e9r","m\u00e1sol\u00e1s","munkalap"],"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\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\/","url":"https:\/\/sosexcel.com\/exceltippek\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\/","name":"Haszn\u00e1lod ezt a gyors tr\u00fckk\u00f6t a cell\u00e1k \u00e9s munkalapok m\u00e1sol\u00e1s\u00e1ra? - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/02\/gyors-masolas.jpg","datePublished":"2013-02-17T17:14:15+00:00","dateModified":"2021-05-06T01:41:29+00:00","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\/#primaryimage","url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/02\/gyors-masolas.jpg","contentUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/02\/gyors-masolas.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/hasznalod-ezt-az-egyszeru-trukkot-a-cellak-es-munkalapok-masolasara\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Haszn\u00e1lod ezt a gyors tr\u00fckk\u00f6t a cell\u00e1k \u00e9s munkalapok m\u00e1sol\u00e1s\u00e1ra?"}]},{"@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\/15","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=15"}],"version-history":[{"count":13,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/15\/revisions"}],"predecessor-version":[{"id":9136,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/15\/revisions\/9136"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=15"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=15"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=15"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}