{"id":2561,"date":"2015-07-27T09:35:24","date_gmt":"2015-07-27T07:35:24","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=2561"},"modified":"2023-05-31T23:33:44","modified_gmt":"2023-05-31T21:33:44","slug":"egyszerre-tobb-cellaba-adatokat","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/","title":{"rendered":"\u00cdgy \u00edrd be egyszerre t\u00f6bb cell\u00e1ba ugyanazt az adatot!"},"content":{"rendered":"\n<p>Ha ki&nbsp;van jel\u00f6lve egy ter\u00fclet, t\u00f6bb cell\u00e1ba ugyanazt az \u00e9rt\u00e9ket \u00edrhatod be, ha g\u00e9pel\u00e9s ut\u00e1n a sima Enter helyett <strong>Ctrl Entert<\/strong> nyomsz:<\/p>\n\n\n\n<!--more-->\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter-excel.png\"><img fetchpriority=\"high\" decoding=\"async\" width=\"600\" height=\"312\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter-excel.png\" alt=\"T\u00f6bb cell\u00e1ba ugyanazt az adatot a Ctrl Enter lenyom\u00e1s\u00e1val \u00edrhatod be.\" class=\"wp-image-2567\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter-excel.png 600w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter-excel-300x156.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter-excel-240x125.png 240w\" sizes=\"(max-width: 600px) 100vw, 600px\" \/><\/a><\/figure><\/div>\n\n\n\n<p>M\u0171k\u00f6dik akkor is, ha lentr\u0151l felfel\u00e9 jel\u00f6lsz ki cell\u00e1kat, \u00e9s az utols\u00f3 cell\u00e1ban&nbsp;\u00edrsz, valamint akkor is, ha egym\u00e1st\u00f3l t\u00e1voli cell\u00e1kat jel\u00f6lt\u00e9l ki:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter-t\u00f6bb-cella.png\"><img decoding=\"async\" width=\"599\" height=\"315\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter-t\u00f6bb-cella.png\" alt=\"Egym\u00e1st\u00f3l t\u00e1voli cell\u00e1kba is \u00edrhatsz egyszerre a Ctrl Enter seg\u00edts\u00e9g\u00e9vel.\" class=\"wp-image-2568\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter-t\u00f6bb-cella.png 599w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter-t\u00f6bb-cella-300x158.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter-t\u00f6bb-cella-240x126.png 240w\" sizes=\"(max-width: 599px) 100vw, 599px\" \/><\/a><\/figure><\/div>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter-k\u00e9plet.png\"><img decoding=\"async\" width=\"769\" height=\"282\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter-k\u00e9plet.png\" alt=\"A Ctrl Enter egyszerre be\u00edrja t\u00f6bb cell\u00e1ba ugyanazt a k\u00e9pletet.\" class=\"wp-image-2565\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter-k\u00e9plet.png 769w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter-k\u00e9plet-300x110.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter-k\u00e9plet-660x242.png 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter-k\u00e9plet-240x88.png 240w\" sizes=\"(max-width: 769px) 100vw, 769px\" \/><\/a><\/figure><\/div>\n\n\n\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter-t\u00f6bb-cella.png\"><br>\n<\/a>A&nbsp;k\u00e9pletekre is vonatkozik: a relat\u00edv \u00e9s abszol\u00fat hivatkoz\u00e1sok megtart\u00e1s\u00e1val, \u00edgy nem kell ut\u00f3lag m\u00e1solgatnod a cell\u00e1kat:<\/p>\n\n\n\n<p>A&nbsp;<a href=\"https:\/\/sosexcel.com\/exceltippek\/a-kijeloles-fortelyai-avagy-hogyan-hasznald-az-egeret-tablazatokban\/\" target=\"_blank\" rel=\"noopener\">kijel\u00f6l\u00e9s gyors\u00edt\u00e1s\u00e1hoz<\/a>&nbsp;mindenk\u00e9ppen \u00e9rdemes billenty\u0171kombin\u00e1ci\u00f3kat haszn\u00e1lnod!<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Mi t\u00f6rt\u00e9nik, ha elfelejted a Ctrl-t lenyomni, \u00e9s sima Entert \u00fctsz?<\/h3>\n\n\n\n<p>Ilyenkor a kijel\u00f6l\u00e9s megmarad, viszont csak egy cell\u00e1ba ker\u00fcl \u00e9rt\u00e9k, az akt\u00edv cella viszont eggyel lejjebb ker\u00fcl.<\/p>\n\n\n\n<p>Ilyenkor a <strong>Shift Enter<\/strong>rel tudsz visszal\u00e9pni a kijel\u00f6l\u00e9s megsz\u00fcntet\u00e9se n\u00e9lk\u00fcl, \u00e9s az <strong>F2 <\/strong>gombbal tudod folytatni a szerkeszt\u00e9st, majd a&nbsp;<strong>Ctrl Enter<\/strong>rel be\u00edrni mindenhov\u00e1 a tartalmat.<\/p>\n\n\n\n<p>Vagyis az egyik lehets\u00e9ges megold\u00e1s: <strong>Shift Enter \/ F2 \/ Ctrl Enter<\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter-jav\u00edt\u00e1s.png\"><img loading=\"lazy\" decoding=\"async\" width=\"142\" height=\"245\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter-jav\u00edt\u00e1s.png\" alt=\"ctrl-enter-jav\u00edt\u00e1s\" class=\"wp-image-2576\"\/><\/a><\/figure><\/div>\n\n\n\n<p>Ennek az el\u0151nye az, hogy az \u00e9rt\u00e9k (akt\u00edv cella) a kijel\u00f6l\u00e9s b\u00e1rmely cell\u00e1ja lehet &#8211; nem csak a legfels\u0151.<\/p>\n\n\n\n<p>Gyakorlati p\u00e9lda erre, mikor az adatb\u00e1zisban el\u00edr\u00e1sok vannak, amelyeket jav\u00edtani kell.<\/p>\n\n\n\n<p>Ilyenkor a kijel\u00f6lt ter\u00fcleten bel\u00fcl addig &#8222;ugr\u00e1lj&#8221; az Enterrel, m\u00edg helyes sz\u00f6veget nem tal\u00e1lsz.<\/p>\n\n\n\n<p>Ut\u00e1na az&nbsp;<strong>F2 \/ Ctrl Enter <\/strong>seg\u00edts\u00e9g\u00e9vel \u00e1t\u00edrhatod a sz\u00f6vegeket.<\/p>\n\n\n\n<p>T\u00e1voli cell\u00e1k vagy sz\u0171rt adatok eset\u00e9n is ugyan\u00fagy m\u0171k\u00f6dik.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">T\u00f6bb cell\u00e1ba ugyanazt&nbsp;m\u00e9g egyszer\u0171bben<\/h3>\n\n\n\n<p>Ha viszont a fenti \u00e9rt\u00e9ket akarod lem\u00e1solni, akkor egyszer\u0171bb a <strong>Ctrl L <\/strong>billenyt\u0171-kombin\u00e1ci\u00f3t haszn\u00e1lnod. (Itt ugyanis nem kell szerkeszt\u0151 m\u00f3dba kapcsolnod az F2-vel.)<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">L, mint le! Ctrl L vagy Ctrl D<\/h4>\n\n\n\n<p>Angolban <strong>Ctrl D<\/strong>, a down miatt. Illetve az \u00fajabb verzi\u00f3kban m\u00e1r magyarul is a Ctrl D-t kell haszn\u00e1lni.<\/p>\n\n\n\n<p>Ez csak lefel\u00e9 m\u0171k\u00f6dik, felfel\u00e9 m\u00e1sol\u00e1s nincs!<br>Viszont lehet jobbra is m\u00e1solni: <strong>Ctrl J<\/strong> Itt is: J, mint jobbra, vagy \u00fajabban <strong>Ctrl Shift J<\/strong>. (Angolul <strong>Ctrl R<\/strong> &#8211; right).<\/p>\n\n\n\n<p>T\u00f6bb oszlop&nbsp;eset\u00e9n minden oszlopba a &#8222;saj\u00e1t&#8221; adat\u00e1t m\u00e1solja le a Ctrl D &#8211; \u00edgy ak\u00e1r k\u00fcl\u00f6nb\u00f6z\u0151 \u00e9rt\u00e9kekre is alkalmazhatod.<\/p>\n\n\n\n<p>A fenti = B15\/$L$15 k\u00e9pletet a\u00a0<span style=\"text-decoration: underline;\">kijel\u00f6lt<\/span> ter\u00fcletre (r\u00f6gz\u00edt\u00e9skor) Enter helyett a Ctrl Enter-rel \u00edrhatod be. Sima Enter ut\u00e1n\u00a0a <strong>Ctrl J\u00a0\u00e9s\u00a0Ctrl L<\/strong> (illetve Ctrl Shift J \u00e9s Ctrl D) kombin\u00e1ci\u00f3kkal m\u00e1solhatod \u00e1t a t\u00f6bbi cell\u00e1ba.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Extr\u00e1k a&nbsp;Ctrl Enter&nbsp;kombin\u00e1ci\u00f3r\u00f3l<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Ha csak egy cella van kijel\u00f6lve, akkor a Ctrl Enter be\u00edrja a tartalmat, de a kijel\u00f6l\u00e9s ugyanabban a cell\u00e1ban marad. (Nem ugrik eggyel lejjebb, mint a sima Enter) P\u00e9ld\u00e1ul hasznos, ha ut\u00e1na m\u00e1solni akarod az adatokat.<\/li><li>Internet b\u00f6ng\u00e9sz\u0151ben a be\u00edrt c\u00edmet (pl. SosExcel) automatikusan kieg\u00e9sz\u00edti a .com v\u00e9gz\u0151d\u00e9ssel.<\/li><li>A <a href=\"https:\/\/sosexcel.com\/exceltippek\/gmail-billentyuparancsok\/\" target=\"_blank\" rel=\"noopener\">Gmail<\/a>&nbsp;egyb\u0151l elk\u00fcldi a levelet.<\/li><\/ul>\n\n\n\n<p><strong><a rel=\"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 111 Hasznos Excel Tipp kiadv\u00e1nyt!<\/a><\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ismerd meg jobban az Excelt<\/h2>\n\n\n\n<p>Ha szorgalmas vagy \u00e9s szeretsz \u00f6n\u00e1ll\u00f3an tanulni, szeretn\u00e9l hasznos tippeket, billenty\u0171kombin\u00e1ci\u00f3kat \u00e9s f\u00fcggv\u00e9nyeket tanulni, akkor rendeld meg az&nbsp;<strong><a href=\"https:\/\/exceltitok.hu\/excel-tankonyv\/\" target=\"_blank\" rel=\"noreferrer noopener\">Excel Kezd\u0151 &amp; Halad\u00f3 tank\u00f6nyv\u00fcnket<\/a><\/strong>. A gyakorl\u00e1shoz aj\u00e1nlom a kimondottan&nbsp;<a href=\"https:\/\/exceltitok.hu\/excel-nagyagyu\/\" target=\"_blank\" rel=\"noreferrer noopener\"><strong>kezd\u0151knek k\u00e9sz\u00fclt feladatsorokat<\/strong><\/a>.<\/p>\n\n\n\n<p>Ha szeretn\u00e9d rendszerezetten \u00e1tn\u00e9zni az Excel alapjait, \u00e9s szeretsz m\u00e1sokkal egy\u00fctt tanulni, akkor gyere az online&nbsp;<strong><a rel=\"noreferrer noopener\" href=\"https:\/\/exceltitok.hu\/csoportos-kezdo-excel-tanfolyam\/\" target=\"_blank\">csoportos Excel k\u00e9pz\u00e9s\u00fcnkre<\/a><\/strong>! Ha ink\u00e1bb egy\u00e9nileg tanuln\u00e1l, vagy a munk\u00e1ddal kapcsolatos t\u00e1bl\u00e1zatokat rendbe tenni, akkor v\u00e1runk&nbsp;<strong><a href=\"https:\/\/exceltitok.hu\/oktatas\/\">egy\u00e9ni Excel oktat\u00e1sra<\/a><\/strong>.<\/p>\n\n\n\n<p>Vagy gyere a VIP Klubba, ahol\u00a0<strong>hasonl\u00f3 \u00e9rdekes tippeket tal\u00e1lsz<\/strong>, \u00e9s Te is b\u00e1rmikor k\u00e9rdezhetsz \u2013 \u00edgy egy biztos h\u00e1tt\u00e9rrel a saj\u00e1t temp\u00f3dban haladhatsz:\u00a0<strong><a rel=\"noreferrer noopener\" href=\"https:\/\/exceltitok.hu\/vip-klub-2021\/\" target=\"_blank\">Excel VIP Klub<\/a><\/strong>.<\/p>\n\n\n\n","protected":false},"excerpt":{"rendered":"<p>Ha ki&nbsp;van jel\u00f6lve egy ter\u00fclet, t\u00f6bb cell\u00e1ba ugyanazt az \u00e9rt\u00e9ket \u00edrhatod be, ha g\u00e9pel\u00e9s ut\u00e1n a sima Enter helyett Ctrl Entert nyomsz:<\/p>\n","protected":false},"author":1,"featured_media":2564,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[40,27,16],"class_list":["post-2561","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek","tag-adatbevitel","tag-billentyukombinacio","tag-masolas"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u00cdgy \u00edrd be egyszerre t\u00f6bb cell\u00e1ba ugyanazt az adatot! - ExcelTitok<\/title>\n<meta name=\"description\" content=\"T\u00f6bb cell\u00e1ba ugyanazt az \u00e9rt\u00e9ket \u00edrhatod be, ha g\u00e9pel\u00e9s ut\u00e1n a sima Enter helyett Ctrl Entert nyomsz. Mire j\u00f3, \u00e9s milyen m\u00e1s megold\u00e1sok l\u00e9teznek?\" \/>\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\/egyszerre-tobb-cellaba-adatokat\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00cdgy \u00edrd be egyszerre t\u00f6bb cell\u00e1ba ugyanazt az adatot! - ExcelTitok\" \/>\n<meta property=\"og:description\" content=\"T\u00f6bb cell\u00e1ba ugyanazt az \u00e9rt\u00e9ket \u00edrhatod be, ha g\u00e9pel\u00e9s ut\u00e1n a sima Enter helyett Ctrl Entert nyomsz. Mire j\u00f3, \u00e9s milyen m\u00e1s megold\u00e1sok l\u00e9teznek?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/\" \/>\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=\"2015-07-27T07:35:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-05-31T21:33:44+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter.png\" \/>\n\t<meta property=\"og:image:width\" content=\"776\" \/>\n\t<meta property=\"og:image:height\" content=\"285\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Bernadett\" \/>\n<meta name=\"twitter:label1\" content=\"Szerz\u0151:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Bernadett\" \/>\n\t<meta name=\"twitter:label2\" content=\"Becs\u00fclt olvas\u00e1si id\u0151\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"\u00cdgy \u00edrd be egyszerre t\u00f6bb cell\u00e1ba ugyanazt az adatot!\",\"datePublished\":\"2015-07-27T07:35:24+00:00\",\"dateModified\":\"2023-05-31T21:33:44+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/\"},\"wordCount\":738,\"commentCount\":4,\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter.png\",\"keywords\":[\"adatbevitel\",\"billenty\u0171kombin\u00e1ci\u00f3\",\"m\u00e1sol\u00e1s\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/\",\"name\":\"\u00cdgy \u00edrd be egyszerre t\u00f6bb cell\u00e1ba ugyanazt az adatot! - ExcelTitok\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter.png\",\"datePublished\":\"2015-07-27T07:35:24+00:00\",\"dateModified\":\"2023-05-31T21:33:44+00:00\",\"description\":\"T\u00f6bb cell\u00e1ba ugyanazt az \u00e9rt\u00e9ket \u00edrhatod be, ha g\u00e9pel\u00e9s ut\u00e1n a sima Enter helyett Ctrl Entert nyomsz. Mire j\u00f3, \u00e9s milyen m\u00e1s megold\u00e1sok l\u00e9teznek?\",\"breadcrumb\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/#primaryimage\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter.png\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter.png\",\"width\":776,\"height\":285},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sosexcel.com\/exceltippek\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00cdgy \u00edrd be egyszerre t\u00f6bb cell\u00e1ba ugyanazt az adatot!\"}]},{\"@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":"\u00cdgy \u00edrd be egyszerre t\u00f6bb cell\u00e1ba ugyanazt az adatot! - ExcelTitok","description":"T\u00f6bb cell\u00e1ba ugyanazt az \u00e9rt\u00e9ket \u00edrhatod be, ha g\u00e9pel\u00e9s ut\u00e1n a sima Enter helyett Ctrl Entert nyomsz. Mire j\u00f3, \u00e9s milyen m\u00e1s megold\u00e1sok l\u00e9teznek?","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\/egyszerre-tobb-cellaba-adatokat\/","og_locale":"hu_HU","og_type":"article","og_title":"\u00cdgy \u00edrd be egyszerre t\u00f6bb cell\u00e1ba ugyanazt az adatot! - ExcelTitok","og_description":"T\u00f6bb cell\u00e1ba ugyanazt az \u00e9rt\u00e9ket \u00edrhatod be, ha g\u00e9pel\u00e9s ut\u00e1n a sima Enter helyett Ctrl Entert nyomsz. Mire j\u00f3, \u00e9s milyen m\u00e1s megold\u00e1sok l\u00e9teznek?","og_url":"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2015-07-27T07:35:24+00:00","article_modified_time":"2023-05-31T21:33:44+00:00","og_image":[{"width":776,"height":285,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"4 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"\u00cdgy \u00edrd be egyszerre t\u00f6bb cell\u00e1ba ugyanazt az adatot!","datePublished":"2015-07-27T07:35:24+00:00","dateModified":"2023-05-31T21:33:44+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/"},"wordCount":738,"commentCount":4,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter.png","keywords":["adatbevitel","billenty\u0171kombin\u00e1ci\u00f3","m\u00e1sol\u00e1s"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/","url":"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/","name":"\u00cdgy \u00edrd be egyszerre t\u00f6bb cell\u00e1ba ugyanazt az adatot! - ExcelTitok","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter.png","datePublished":"2015-07-27T07:35:24+00:00","dateModified":"2023-05-31T21:33:44+00:00","description":"T\u00f6bb cell\u00e1ba ugyanazt az \u00e9rt\u00e9ket \u00edrhatod be, ha g\u00e9pel\u00e9s ut\u00e1n a sima Enter helyett Ctrl Entert nyomsz. Mire j\u00f3, \u00e9s milyen m\u00e1s megold\u00e1sok l\u00e9teznek?","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/07\/ctrl-enter.png","width":776,"height":285},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/egyszerre-tobb-cellaba-adatokat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"\u00cdgy \u00edrd be egyszerre t\u00f6bb cell\u00e1ba ugyanazt az adatot!"}]},{"@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\/2561","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=2561"}],"version-history":[{"count":16,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/2561\/revisions"}],"predecessor-version":[{"id":9754,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/2561\/revisions\/9754"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/2564"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=2561"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=2561"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=2561"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}