{"id":10077,"date":"2026-03-16T12:04:22","date_gmt":"2026-03-16T11:04:22","guid":{"rendered":"https:\/\/sosexcel.com\/exceltippek\/?p=10077"},"modified":"2026-03-17T10:30:47","modified_gmt":"2026-03-17T09:30:47","slug":"tablazatok-gyors-at-es-osszemasolasa","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/tablazatok-gyors-at-es-osszemasolasa\/","title":{"rendered":"T\u00e1bl\u00e1zatok gyors \u00e1t- \u00e9s \u00f6sszem\u00e1sol\u00e1sa"},"content":{"rendered":"\n<p>Benne vagy a t\u00e1bl\u00e1zatban. A t\u00e1bl\u00e1zat kijel\u00f6l\u00e9se az a Ctrl Alad\u00e1r, azaz &#8216;all in&#8217; &#8211; mindent egyszerre.<strong> Ctrl A<\/strong>. <\/p>\n\n\n\n<p>A m\u00e1sol\u00e1s az a copy Ctrl C. A v\u00e1lt\u00e1s az a Ctrl PageDown volt, \u00e9s akkor ide az A1-be Ctrl V-vel be lehet illeszteni. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Oszlopsz\u00e9less\u00e9g m\u00e1sol\u00e1sa<\/h2>\n\n\n\n<p>Megjelenik a <a href=\"https:\/\/sosexcel.com\/exceltippek\/beillesztesi-lehetosegek\/\" type=\"link\" id=\"https:\/\/sosexcel.com\/exceltippek\/beillesztesi-lehetosegek\/\" target=\"_blank\" rel=\"noreferrer noopener\">m\u00e1sol\u00e1s ut\u00e1ni beilleszt\u00e9si lehet\u0151s\u00e9g<\/a> panel, amit r\u00f6viden, ha megnyomod csak a Ctrl gombot, akkor ki tudsz nyitni. Majd itt az O bet\u0171 r\u00f6viden megnyomva, az az Oszlopsz\u00e9less\u00e9g a forr\u00e1sb\u00f3l. (Angolul W, mint width = sz\u00e9less\u00e9g)<\/p>\n\n\n\n<p>A panelen nyilakkal is mozoghatsz, l\u00e9pdelj le a m\u00e1sodik sor m\u00e1sodik ikonj\u00e1ra, majd Enter.<\/p>\n\n\n\n<iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/XxMr0mrw5uE?si=YMMgCozfK58wjDqN\" title=\"YouTube video player\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">A teljes t\u00e1bl\u00e1zat m\u00e1sol\u00e1sa \u00e9s beilleszt\u00e9se \u00faj munkalapra billenty\u0171kkel<\/h2>\n\n\n\n<p>\ud83d\udccc Kijel\u00f6l\u00e9s: Ctrl A (all in)<br>\ud83d\udccc M\u00e1sol\u00e1s: Ctrl C (copy)<br>\ud83d\udccc \u00c1tl\u00e9p\u00e9s a m\u00e1sik f\u00fclre: Ctrl PgDn (vagy Ctrl PgUp)<br>\ud83d\udccc Beilleszt\u00e9s: Ctrl V<br>\ud83d\udccc Beilleszt\u00e9si lehet\u0151s\u00e9gek panel kinyit\u00e1sa: Ctrl (r\u00f6viden)<br>\ud83d\udccc Oszlopsz\u00e9less\u00e9g a forr\u00e1sb\u00f3l: O bet\u0171 (angolul W), vagy nyilakkal m\u00e1sodik sor 2. ikon + Enter<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u00d6sszem\u00e1sol\u00e1s egym\u00e1s al\u00e1<\/h2>\n\n\n\n<p>Ha m\u00e1r a megl\u00e9v\u0151 t\u00e1bl\u00e1zat al\u00e1 akarsz m\u00e1solni egy \u00fajat, akkor az \u00e1tlapoz\u00e1s (Ctrl PgDn vagy Ctrl PgUp) ut\u00e1n a Ctrl lefele nyillal tudod megtal\u00e1lni a t\u00e1bl\u00e1zat v\u00e9g\u00e9t, majd egy sima lefele ny\u00edllal tudsz eggyel lejjebb, az \u00fcres cell\u00e1ba \u00e1llni. Innen j\u00f6het a beilleszt\u00e9s &#8211; itt m\u00e1r az oszlopsz\u00e9less\u00e9g adott, azt nem kell \u00fajra be\u00e1ll\u00edtani.<\/p>\n\n\n\n<p>Teh\u00e1t <strong>t\u00e1bl\u00e1zat m\u00e1sol\u00e1sa m\u00e1sik f\u00fcl\u00f6n l\u00e9v\u0151 t\u00e1bl\u00e1zat ut\u00e1n billenty\u0171kkel:<\/strong><\/p>\n\n\n\n<p>\ud83d\udccc Kijel\u00f6l\u00e9s: Ctrl A (all in)<br>\ud83d\udccc M\u00e1sol\u00e1s: Ctrl C (copy)<br>\ud83d\udccc \u00c1tl\u00e9p\u00e9s a m\u00e1sik f\u00fclre: Ctrl PgDn (vagy Ctrl PgUp)<br>\ud83d\udccc T\u00e1bl\u00e1zat utols\u00f3 sora: Ctrl \u2b07\ufe0f (lefele ny\u00edl)<br>\ud83d\udccc K\u00f6vetkez\u0151 \u00fcres cella: \u2b07\ufe0f (lefele ny\u00edl)<br>\ud83d\udccc Beilleszt\u00e9s: Ctrl V<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Sormagass\u00e1g m\u00e1sol\u00e1sa<\/h2>\n\n\n\n<p>Joggal mer\u00fcl fel a k\u00e9rd\u00e9s, hogy a sorok magass\u00e1g\u00e1t is lehet-e m\u00e1solni.<\/p>\n\n\n\n<p>Ha fontos a magass\u00e1g is, a m\u00e1sol\u00e1shoz teljes sorokat jel\u00f6lj ki. (Shift Sz\u00f3k\u00f6z kombin\u00e1ci\u00f3val). \u00a0Term\u00e9szetesen, ha a Ctrl V gyorsbillenty\u0171t haszn\u00e1lod a beilleszt\u00e9sre, akkor itt is megadhatod az &#8216;Oszlopsz\u00e9less\u00e9g a forr\u00e1sb\u00f3l&#8217; opci\u00f3t a\u00a0<a href=\"https:\/\/sosexcel.com\/exceltippek\/beillesztesi-lehetosegek\/\" target=\"_blank\" rel=\"noreferrer noopener\">beilleszt\u00e9si lehet\u0151s\u00e9gek<\/a>n\u00e9l.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">M\u00e9g t\u00f6bb gyorsbillenty\u0171?<\/h2>\n\n\n\n<p>N\u00e9zd meg az 55 napos <a href=\"https:\/\/exceltitok.hu\/55-excel-billentyukombinacio\/\" type=\"link\" id=\"https:\/\/exceltitok.hu\/55-excel-billentyukombinacio\/\">billenty\u0171-kombin\u00e1ci\u00f3 kih\u00edv\u00e1st<\/a>.<\/p>\n\n\n\n<p>Tov\u00e1bbi Excel tippek\u00e9rt pedig k\u00f6vess az \u00f6sszes platformon:<br>\ud83d\udd35 Facebook: <a href=\"https:\/\/www.facebook.com\/ExcelTitok\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.facebook.com\/ExcelTitok\/<\/a><br>\ud83d\udfe3 Instagram: <a href=\"https:\/\/www.instagram.com\/excel_titok\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.instagram.com\/excel_titok\/<\/a><br>\ud83d\udd34 Youtube: <a href=\"https:\/\/www.youtube.com\/exceltitok\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.youtube.com\/exceltitok\/<\/a><br>\ud83d\udfe2 Blogjaim: <a href=\"https:\/\/exceltitok.hu\/tippek\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/tippek\/<\/a> \u00e9s https:\/\/sosexcel.com\/exceltippek\/<br>\u26ab Tiktok: <a href=\"https:\/\/www.tiktok.com\/@exceltitok\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.tiktok.com\/@exceltitok<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">M\u00e9g t\u00f6bb Excel tud\u00e1s<\/h2>\n\n\n\n<p>Tanulj vel\u00fcnk a csoportos tanfolyamokon! N\u00e9zd vissza az\u00a0<a href=\"https:\/\/exceltitok.hu\/excel-csoportos-tanfolyamok-infoest-2024-08-27\/\"><strong>Excel tanfolyamokr\u00f3l sz\u00f3l\u00f3 infoestet<\/strong>,<\/a>\u00a0ahol tan\u00e1raink is bemutatkoztak, \u00e9s a leggyakoribb k\u00e9rd\u00e9seket is megv\u00e1laszoltuk. Valamint megtal\u00e1lod az aktu\u00e1lis tanfolyam id\u0151pontokat is.<\/p>\n\n\n\n<p>Profi tr\u00fckk\u00f6k\u00e9rt \u00e9s seg\u00edts\u00e9g\u00e9rt\u00a0<a href=\"https:\/\/excelklub.hu\/\">gyere az ExcelTitok VIP Klubba.<\/a> Itt \u00f6n\u00e1ll\u00f3an tanulhatsz, minden h\u00f3napban van \u00e9l\u0151, online alkalom, \u00e9s az online csoportokban b\u00e1rmikor k\u00e9rdezhetsz, \u00f6r\u00f6mmel seg\u00edt\u00fcnk, ha elakadt\u00e1l az Excellel.<\/p>\n\n\n\n<p><strong>Ha m\u00e9g az elej\u00e9n j\u00e1rsz, de nem akarsz tanfolyamra j\u00f6nni,<\/strong>&nbsp;de szeretn\u00e9l foglalkozni az Excellel, akkor n\u00e9zd meg ezt:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Kezd\u0151 Excel feladatok:\u00a0<a href=\"https:\/\/exceltitok.t.emesz.com\/t\/l\/2Rybb\/5Ugq\/1pM\/2z8\/2sy\/0\/0\/0\/0\/wp7TbHCPqP_BYCrbLYlasYBWNgJ6tZcqTw8\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/excel-nagyagyu\/<\/a><\/li>\n\n\n\n<li>Egy \u00f3r\u00e1s vide\u00f3 kurzusok 4 t\u00e9m\u00e1ban:\u00a0<a href=\"https:\/\/exceltitok.hu\/online-excel-kurzusok\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/online-excel-kurzusok\/<\/a>\u00a0<\/li>\n<\/ul>\n\n\n\n<p><a href=\"https:\/\/exceltitok.hu\/excel-vagy-szoftver\/\"><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Benne vagy a t\u00e1bl\u00e1zatban. A t\u00e1bl\u00e1zat kijel\u00f6l\u00e9se az a Ctrl Alad\u00e1r, azaz &#8216;all in&#8217; &#8211; mindent egyszerre. Ctrl A. A m\u00e1sol\u00e1s az a copy Ctrl C. A v\u00e1lt\u00e1s az a Ctrl PageDown volt, \u00e9s akkor ide az A1-be Ctrl V-vel be lehet illeszteni. Oszlopsz\u00e9less\u00e9g m\u00e1sol\u00e1sa Megjelenik a m\u00e1sol\u00e1s ut\u00e1ni beilleszt\u00e9si lehet\u0151s\u00e9g panel, amit r\u00f6viden, ha [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[],"class_list":["post-10077","post","type-post","status-publish","format-standard","hentry","category-excel-tippek-gyakori-kerdesek"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>T\u00e1bl\u00e1zatok gyors \u00e1t- \u00e9s \u00f6sszem\u00e1sol\u00e1sa - 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\/tablazatok-gyors-at-es-osszemasolasa\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T\u00e1bl\u00e1zatok gyors \u00e1t- \u00e9s \u00f6sszem\u00e1sol\u00e1sa - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Benne vagy a t\u00e1bl\u00e1zatban. A t\u00e1bl\u00e1zat kijel\u00f6l\u00e9se az a Ctrl Alad\u00e1r, azaz &#8216;all in&#8217; &#8211; mindent egyszerre. Ctrl A. A m\u00e1sol\u00e1s az a copy Ctrl C. A v\u00e1lt\u00e1s az a Ctrl PageDown volt, \u00e9s akkor ide az A1-be Ctrl V-vel be lehet illeszteni. Oszlopsz\u00e9less\u00e9g m\u00e1sol\u00e1sa Megjelenik a m\u00e1sol\u00e1s ut\u00e1ni beilleszt\u00e9si lehet\u0151s\u00e9g panel, amit r\u00f6viden, ha [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/tablazatok-gyors-at-es-osszemasolasa\/\" \/>\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=\"2026-03-16T11:04:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-03-17T09:30:47+00:00\" \/>\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\\\/tablazatok-gyors-at-es-osszemasolasa\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazatok-gyors-at-es-osszemasolasa\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"T\u00e1bl\u00e1zatok gyors \u00e1t- \u00e9s \u00f6sszem\u00e1sol\u00e1sa\",\"datePublished\":\"2026-03-16T11:04:22+00:00\",\"dateModified\":\"2026-03-17T09:30:47+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazatok-gyors-at-es-osszemasolasa\\\/\"},\"wordCount\":641,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazatok-gyors-at-es-osszemasolasa\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazatok-gyors-at-es-osszemasolasa\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazatok-gyors-at-es-osszemasolasa\\\/\",\"name\":\"T\u00e1bl\u00e1zatok gyors \u00e1t- \u00e9s \u00f6sszem\u00e1sol\u00e1sa - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"datePublished\":\"2026-03-16T11:04:22+00:00\",\"dateModified\":\"2026-03-17T09:30:47+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazatok-gyors-at-es-osszemasolasa\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazatok-gyors-at-es-osszemasolasa\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazatok-gyors-at-es-osszemasolasa\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"T\u00e1bl\u00e1zatok gyors \u00e1t- \u00e9s \u00f6sszem\u00e1sol\u00e1sa\"}]},{\"@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":"T\u00e1bl\u00e1zatok gyors \u00e1t- \u00e9s \u00f6sszem\u00e1sol\u00e1sa - 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\/tablazatok-gyors-at-es-osszemasolasa\/","og_locale":"hu_HU","og_type":"article","og_title":"T\u00e1bl\u00e1zatok gyors \u00e1t- \u00e9s \u00f6sszem\u00e1sol\u00e1sa - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Benne vagy a t\u00e1bl\u00e1zatban. A t\u00e1bl\u00e1zat kijel\u00f6l\u00e9se az a Ctrl Alad\u00e1r, azaz &#8216;all in&#8217; &#8211; mindent egyszerre. Ctrl A. A m\u00e1sol\u00e1s az a copy Ctrl C. A v\u00e1lt\u00e1s az a Ctrl PageDown volt, \u00e9s akkor ide az A1-be Ctrl V-vel be lehet illeszteni. Oszlopsz\u00e9less\u00e9g m\u00e1sol\u00e1sa Megjelenik a m\u00e1sol\u00e1s ut\u00e1ni beilleszt\u00e9si lehet\u0151s\u00e9g panel, amit r\u00f6viden, ha [&hellip;]","og_url":"https:\/\/sosexcel.com\/exceltippek\/tablazatok-gyors-at-es-osszemasolasa\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2026-03-16T11:04:22+00:00","article_modified_time":"2026-03-17T09:30:47+00:00","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\/tablazatok-gyors-at-es-osszemasolasa\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/tablazatok-gyors-at-es-osszemasolasa\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"T\u00e1bl\u00e1zatok gyors \u00e1t- \u00e9s \u00f6sszem\u00e1sol\u00e1sa","datePublished":"2026-03-16T11:04:22+00:00","dateModified":"2026-03-17T09:30:47+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/tablazatok-gyors-at-es-osszemasolasa\/"},"wordCount":641,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/tablazatok-gyors-at-es-osszemasolasa\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/tablazatok-gyors-at-es-osszemasolasa\/","url":"https:\/\/sosexcel.com\/exceltippek\/tablazatok-gyors-at-es-osszemasolasa\/","name":"T\u00e1bl\u00e1zatok gyors \u00e1t- \u00e9s \u00f6sszem\u00e1sol\u00e1sa - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"datePublished":"2026-03-16T11:04:22+00:00","dateModified":"2026-03-17T09:30:47+00:00","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/tablazatok-gyors-at-es-osszemasolasa\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/tablazatok-gyors-at-es-osszemasolasa\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/tablazatok-gyors-at-es-osszemasolasa\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"T\u00e1bl\u00e1zatok gyors \u00e1t- \u00e9s \u00f6sszem\u00e1sol\u00e1sa"}]},{"@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\/10077","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=10077"}],"version-history":[{"count":4,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/10077\/revisions"}],"predecessor-version":[{"id":10083,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/10077\/revisions\/10083"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=10077"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=10077"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=10077"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}