{"id":5165,"date":"2019-01-23T11:41:32","date_gmt":"2019-01-23T10:41:32","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=5165"},"modified":"2019-08-30T13:07:15","modified_gmt":"2019-08-30T11:07:15","slug":"irj-egyszerre-tobb-cellaba-adatokat","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/","title":{"rendered":"\u00cdrj egyszerre t\u00f6bb cell\u00e1ba adatokat"},"content":{"rendered":"<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/image026.gif\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignright wp-image-5166 size-medium\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/image026-214x300.gif\" alt=\"T\u00f6bb cell\u00e1ba beker\u00fcl a sz\u00f6veg a Ctrl Enter billenty\u0171kombin\u00e1ci\u00f3val\" width=\"214\" height=\"300\"><\/a>T\u00f6bb &nbsp;kijel\u00f6lt &nbsp;cell\u00e1ba &nbsp;r\u00f6gz\u00edthetsz &nbsp;azonos &nbsp;\u00e9rt\u00e9ket, &nbsp;ha g\u00e9pel\u00e9s ut\u00e1n a sima Enter helyett <strong>Ctrl Entert <\/strong>nyomsz.<\/p>\n<p>Ez &nbsp;<a href=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-irj-kepleteket-az-excelben\/\" target=\"_blank\" rel=\"noopener\">k\u00e9pletekre<\/a> &nbsp;is &nbsp;vonatkozik: &nbsp;a &nbsp;relat\u00edv &nbsp;\u00e9s &nbsp;abszol\u00fat hivatkoz\u00e1sok megtart\u00e1s\u00e1val.<!--more--><\/p>\n<p>\u00cdgy nem kell a<a href=\"https:\/\/sosexcel.com\/exceltippek\/sorozat-felsorolas-kitoltes\/\"> kit\u00f6lt\u00e9s funkci\u00f3t<\/a> haszn\u00e1lnod.<\/p>\n<p>\u00dcres t\u00e1bl\u00e1zatban azonban neh\u00e9z megtal\u00e1lni az utols\u00f3 cell\u00e1t. Ha tudod, hogy h\u00e1ny adatod van-lesz, \u00e9s hol van az utols\u00f3 (pl. a 85. sorban), akkor ha G2 cell\u00e1ban vagy, a G85-ig kell kijel\u00f6lni az \u00fcres cell\u00e1kat.<\/p>\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" width=\"421\" height=\"105\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/image028.gif\" alt=\"K\u00f6nnyen kijel\u00f6lhetsz t\u00f6bb cell\u00e1t, ha a N\u00e9vmez\u0151be be\u00edrod a tartpm\u00e1ny v\u00e9g\u00e9t.\" class=\"wp-image-5169\"\/><\/figure>\n\n\n\n<p>A Szerkeszt\u0151l\u00e9c mellett tal\u00e1lhat\u00f3 N\u00e9v mez\u0151ben \u00edrd \u00e1t a G2-t G85-re, <strong>majd nyomj Shift Entert.<\/strong><\/p>\n\n\n\n<p>Az Enter miatt \u00e1tugrasz a G85 cell\u00e1ba, viszont a Shift miatt kijel\u00f6l\u00f6d a k\u00f6ztes cell\u00e1kat. (Egy m\u00e1sik tippet tal\u00e1lsz a 110-es pontban.)<\/p>\n\n\n\n<p>Ez a tipp a 111 Hasznos Excel tipp 60. bejegyz\u00e9se. Ha tetszik, \u00e9s szeretn\u00e9d a m\u00e1sik 110-zel egy\u00fctt nyomtatott spir\u00e1lf\u00fczetk\u00e9nt megkapni, akkor <a rel=\"noreferrer noopener\" aria-label=\"itt rendelheted meg. (\u00faj f\u00fcl\u00f6n nyitja meg)\" href=\"http:\/\/exceltitok.hu\/111-excel-tipp\/\" target=\"_blank\">itt rendelheted meg.<\/a><\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-rich is-provider-azonnal-hasznalhato-excel-tippek\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"bP5moaxCmp\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/\">Mi az a hivatkoz\u00e1s? Avagy ez\u00e9rt haszn\u00e1lj linkeket!<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Mi az a hivatkoz\u00e1s? Avagy ez\u00e9rt haszn\u00e1lj linkeket!&#8221; &#8212; Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" src=\"https:\/\/sosexcel.com\/exceltippek\/hivatkozas-hasznalj-linkeket\/embed\/#?secret=h5bXVde0fY#?secret=bP5moaxCmp\" data-secret=\"bP5moaxCmp\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><figcaption><br><\/figcaption><\/figure>\n\n\n\n<figure class=\"wp-block-embed is-type-rich is-provider-azonnal-hasznalhato-excel-tippek\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"1GG5MszT7L\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/2-ertek-1-cellaban\/\">Hogyan tudok 2 \u00e9rt\u00e9ket 1 cell\u00e1ba \u00edrni?<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Hogyan tudok 2 \u00e9rt\u00e9ket 1 cell\u00e1ba \u00edrni?&#8221; &#8212; Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" src=\"https:\/\/sosexcel.com\/exceltippek\/2-ertek-1-cellaban\/embed\/#?secret=aa6fiHHf1c#?secret=1GG5MszT7L\" data-secret=\"1GG5MszT7L\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>T\u00f6bb &nbsp;kijel\u00f6lt &nbsp;cell\u00e1ba &nbsp;r\u00f6gz\u00edthetsz &nbsp;azonos &nbsp;\u00e9rt\u00e9ket, &nbsp;ha g\u00e9pel\u00e9s ut\u00e1n a sima Enter helyett Ctrl Entert nyomsz. Ez &nbsp;k\u00e9pletekre &nbsp;is &nbsp;vonatkozik: &nbsp;a &nbsp;relat\u00edv &nbsp;\u00e9s &nbsp;abszol\u00fat hivatkoz\u00e1sok megtart\u00e1s\u00e1val.<\/p>\n","protected":false},"author":3,"featured_media":8161,"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,107,96],"class_list":["post-5165","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek","tag-adatbevitel","tag-kitoltes","tag-navigacio"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u00cdrj egyszerre t\u00f6bb cell\u00e1ba adatokat - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"T\u00f6bb\u00a0cell\u00e1ba \u00a0r\u00f6gz\u00edthetsz \u00a0azonos \u00a0\u00e9rt\u00e9ket, \u00a0ha el\u0151bb kijel\u00f6l\u00f6d \u0151ket, majd az adatbevitel ut\u00e1n a sima Enter helyett Ctrl Entert nyomsz.\" \/>\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\/irj-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=\"\u00cdrj egyszerre t\u00f6bb cell\u00e1ba adatokat - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"T\u00f6bb\u00a0cell\u00e1ba \u00a0r\u00f6gz\u00edthetsz \u00a0azonos \u00a0\u00e9rt\u00e9ket, \u00a0ha el\u0151bb kijel\u00f6l\u00f6d \u0151ket, majd az adatbevitel ut\u00e1n a sima Enter helyett Ctrl Entert nyomsz.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/\" \/>\n<meta property=\"og:site_name\" content=\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"article:published_time\" content=\"2019-01-23T10:41:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-08-30T11:07:15+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/01\/egyszerre-tobb-cella-ctrl-enter_fb.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\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=\"1 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/d0cd6959dcc11f6ed25f7d4e5681a846\"},\"headline\":\"\u00cdrj egyszerre t\u00f6bb cell\u00e1ba adatokat\",\"datePublished\":\"2019-01-23T10:41:32+00:00\",\"dateModified\":\"2019-08-30T11:07:15+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/\"},\"wordCount\":208,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/01\/egyszerre-tobb-cella-ctrl-enter-blog.png\",\"keywords\":[\"adatbevitel\",\"kit\u00f6lt\u00e9s\",\"navig\u00e1ci\u00f3\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/\",\"name\":\"\u00cdrj egyszerre t\u00f6bb cell\u00e1ba adatokat - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/01\/egyszerre-tobb-cella-ctrl-enter-blog.png\",\"datePublished\":\"2019-01-23T10:41:32+00:00\",\"dateModified\":\"2019-08-30T11:07:15+00:00\",\"description\":\"T\u00f6bb\u00a0cell\u00e1ba \u00a0r\u00f6gz\u00edthetsz \u00a0azonos \u00a0\u00e9rt\u00e9ket, \u00a0ha el\u0151bb kijel\u00f6l\u00f6d \u0151ket, majd az adatbevitel ut\u00e1n a sima Enter helyett Ctrl Entert nyomsz.\",\"breadcrumb\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/#primaryimage\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/01\/egyszerre-tobb-cella-ctrl-enter-blog.png\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/01\/egyszerre-tobb-cella-ctrl-enter-blog.png\",\"width\":795,\"height\":252},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sosexcel.com\/exceltippek\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00cdrj egyszerre t\u00f6bb cell\u00e1ba adatokat\"}]},{\"@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\/d0cd6959dcc11f6ed25f7d4e5681a846\",\"name\":\"Bernadett\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/33077ee5ef07e5534d55447c6c9053579eed4ee4578f92057b006f6955da6bd0?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/33077ee5ef07e5534d55447c6c9053579eed4ee4578f92057b006f6955da6bd0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/33077ee5ef07e5534d55447c6c9053579eed4ee4578f92057b006f6955da6bd0?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.\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/author\/bernadett\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00cdrj egyszerre t\u00f6bb cell\u00e1ba adatokat - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"T\u00f6bb\u00a0cell\u00e1ba \u00a0r\u00f6gz\u00edthetsz \u00a0azonos \u00a0\u00e9rt\u00e9ket, \u00a0ha el\u0151bb kijel\u00f6l\u00f6d \u0151ket, majd az adatbevitel ut\u00e1n a sima Enter helyett Ctrl Entert nyomsz.","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\/irj-egyszerre-tobb-cellaba-adatokat\/","og_locale":"hu_HU","og_type":"article","og_title":"\u00cdrj egyszerre t\u00f6bb cell\u00e1ba adatokat - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"T\u00f6bb\u00a0cell\u00e1ba \u00a0r\u00f6gz\u00edthetsz \u00a0azonos \u00a0\u00e9rt\u00e9ket, \u00a0ha el\u0151bb kijel\u00f6l\u00f6d \u0151ket, majd az adatbevitel ut\u00e1n a sima Enter helyett Ctrl Entert nyomsz.","og_url":"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_published_time":"2019-01-23T10:41:32+00:00","article_modified_time":"2019-08-30T11:07:15+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/01\/egyszerre-tobb-cella-ctrl-enter_fb.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"1 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/d0cd6959dcc11f6ed25f7d4e5681a846"},"headline":"\u00cdrj egyszerre t\u00f6bb cell\u00e1ba adatokat","datePublished":"2019-01-23T10:41:32+00:00","dateModified":"2019-08-30T11:07:15+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/"},"wordCount":208,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/01\/egyszerre-tobb-cella-ctrl-enter-blog.png","keywords":["adatbevitel","kit\u00f6lt\u00e9s","navig\u00e1ci\u00f3"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/","url":"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/","name":"\u00cdrj egyszerre t\u00f6bb cell\u00e1ba adatokat - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/01\/egyszerre-tobb-cella-ctrl-enter-blog.png","datePublished":"2019-01-23T10:41:32+00:00","dateModified":"2019-08-30T11:07:15+00:00","description":"T\u00f6bb\u00a0cell\u00e1ba \u00a0r\u00f6gz\u00edthetsz \u00a0azonos \u00a0\u00e9rt\u00e9ket, \u00a0ha el\u0151bb kijel\u00f6l\u00f6d \u0151ket, majd az adatbevitel ut\u00e1n a sima Enter helyett Ctrl Entert nyomsz.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/01\/egyszerre-tobb-cella-ctrl-enter-blog.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/01\/egyszerre-tobb-cella-ctrl-enter-blog.png","width":795,"height":252},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/irj-egyszerre-tobb-cellaba-adatokat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"\u00cdrj egyszerre t\u00f6bb cell\u00e1ba adatokat"}]},{"@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\/d0cd6959dcc11f6ed25f7d4e5681a846","name":"Bernadett","image":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/secure.gravatar.com\/avatar\/33077ee5ef07e5534d55447c6c9053579eed4ee4578f92057b006f6955da6bd0?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/33077ee5ef07e5534d55447c6c9053579eed4ee4578f92057b006f6955da6bd0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/33077ee5ef07e5534d55447c6c9053579eed4ee4578f92057b006f6955da6bd0?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.","url":"https:\/\/sosexcel.com\/exceltippek\/author\/bernadett\/"}]}},"_links":{"self":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/5165","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/comments?post=5165"}],"version-history":[{"count":8,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/5165\/revisions"}],"predecessor-version":[{"id":7273,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/5165\/revisions\/7273"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/8161"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=5165"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=5165"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=5165"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}