{"id":10112,"date":"2026-06-09T22:50:50","date_gmt":"2026-06-09T20:50:50","guid":{"rendered":"https:\/\/sosexcel.com\/exceltippek\/?p=10112"},"modified":"2026-06-09T22:59:20","modified_gmt":"2026-06-09T20:59:20","slug":"cellaformazas-billentyukkel","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/cellaformazas-billentyukkel\/","title":{"rendered":"Cellaform\u00e1z\u00e1s billenty\u0171kkel"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Jel\u00f6ld ki a G oszlop sz\u00e1mait a sz\u00e1mform\u00e1tum be\u00e1ll\u00edt\u00e1s\u00e1hoz. A G2 lesz kezd\u0151 poz\u00edci\u00f3.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Az A1 cell\u00e1b\u00f3l el\u0151sz\u00f6r <a href=\"https:\/\/www.facebook.com\/photo.php?fbid=1459078092910892&amp;set=a.472488294903215\" type=\"link\" id=\"https:\/\/www.facebook.com\/photo.php?fbid=1459078092910892&amp;set=a.472488294903215\" target=\"_blank\" rel=\"noreferrer noopener\">Ctrl + jobbra ny\u00edllal ugorj<\/a> a G1 cell\u00e1ba, majd a sima lefele ny\u00edllal a G2-be. Innen az oszlopban szerepl\u0151 \u00f6sszes sz\u00e1m kijel\u00f6l\u00e9s\u00e9hez haszn\u00e1ld a <a href=\"https:\/\/www.facebook.com\/ExcelTitok\/posts\/1459786946173340\" type=\"link\" id=\"https:\/\/www.facebook.com\/ExcelTitok\/posts\/1459786946173340\" target=\"_blank\" rel=\"noreferrer noopener\">Ctrl + Shift + lefele nyilat<\/a>. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Az ezres csoportos\u00edt\u00e1st t\u00f6bbf\u00e9lek\u00e9ppen be lehet \u00e1ll\u00edtani. Most n\u00e9zz\u00fck a Cellaform\u00e1z\u00e1s panelt. A Cellaform\u00e1z\u00e1s gyorsgombja a <a href=\"https:\/\/www.facebook.com\/photo.php?fbid=1465758445576190&amp;set=a.472488294903215&amp;type=3\" type=\"link\" id=\"https:\/\/www.facebook.com\/photo.php?fbid=1465758445576190&amp;set=a.472488294903215&amp;type=3\" target=\"_blank\" rel=\"noreferrer noopener\">Ctrl + 1<\/a>. A Cellaform\u00e1z\u00e1s panelen, eg\u00e9r n\u00e9lk\u00fcl akarsz dolgozni, akkor <a href=\"https:\/\/www.facebook.com\/photo.php?fbid=1470879425064092&amp;set=a.472488294903215&amp;type=3\" type=\"link\" id=\"https:\/\/www.facebook.com\/photo.php?fbid=1470879425064092&amp;set=a.472488294903215&amp;type=3\" target=\"_blank\" rel=\"noreferrer noopener\">a Tab gombbal<\/a> tudsz a r\u00e9szek k\u00f6z\u00f6tt ugor\u00e1lni. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Figyeld csak meg: eredetileg fent a &#8216;Sz\u00e1m&#8217; f\u00fcl\u00f6n volt egy kis keret, de ha megnyomod a Tab gombot, akkor \u00e1tj\u00f6n az &#8216;\u00c1ltal\u00e1nos&#8217;-ra, \u00e9s itt m\u00e1r a nyilakkal tudsz a kateg\u00f3ri\u00e1k k\u00f6z\u00f6tt v\u00e1ltani. A &#8216;Sz\u00e1m&#8217; form\u00e1tumn\u00e1l jelenik meg az ezres csoportos\u00edt\u00e1s \u00e9s a tizedes jegyek opci\u00f3.<\/p>\n\n\n\n<div class=\"wp-block-media-text is-stacked-on-mobile\"><figure class=\"wp-block-media-text__media\"><img fetchpriority=\"high\" decoding=\"async\" width=\"1012\" height=\"1024\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Szam-formatum-1012x1024.png\" alt=\"\" class=\"wp-image-10114 size-full\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Szam-formatum-1012x1024.png 1012w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Szam-formatum-297x300.png 297w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Szam-formatum-768x777.png 768w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Szam-formatum.png 1038w\" sizes=\"(max-width: 1012px) 100vw, 1012px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<p class=\"wp-block-paragraph\">Erre a r\u00e9szre is a Tab gombbal tudsz \u00e1tugrani. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Teh\u00e1t az ilyen felugr\u00f3 panelekn\u00e9l mindig a Tab gomb mozog a k\u00fcl\u00f6nb\u00f6z\u0151 r\u00e9szek k\u00f6z\u00f6tt.<\/p>\n<\/div><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A tizedesjegyekhez \u00e9rve r\u00f6gt\u00f6n ki is jel\u00f6li a 2-es sz\u00e1mot, \u00edgy k\u00f6nnyen \u00e1t\u00edrhat\u00f3 null\u00e1ra. (Vagy itt is lehet a fel \/ le nyilakat haszn\u00e1lni.) Majd a Tab gombban lehet tov\u00e1bbugrani az ezres csoportos\u00edt\u00e1sra.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A jel\u00f6l\u0151n\u00e9gyzetekbe (checkboxokba) pip\u00e1t kirakni, mindig <a href=\"https:\/\/www.facebook.com\/ExcelTitok\/posts\/pfbid0r9qaJ5ZsKuu6KYMX3VWbJUCSxJQ5qMYHbjaRhpKSKLiRfxCLokJgLS7e7GHFnbpDl\" type=\"link\" id=\"https:\/\/www.facebook.com\/ExcelTitok\/posts\/pfbid0r9qaJ5ZsKuu6KYMX3VWbJUCSxJQ5qMYHbjaRhpKSKLiRfxCLokJgLS7e7GHFnbpDl\" target=\"_blank\" rel=\"noreferrer noopener\">a sz\u00f3k\u00f6z billenty\u0171vel lehet<\/a>. Teh\u00e1t a Space vagy sz\u00f3k\u00f6z gomb ki\/be kapcsol\u00f3k\u00e9nt m\u0171k\u00f6dik. (A &#8216;Mint\u00e1&#8217;-n\u00e1l l\u00e1tszikaz el\u0151n\u00e9zet.)<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">V\u00e9g\u00fcl az OK, azaz Enter.<\/p>\n\n\n\n<iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/sOIUkfraj_E?si=GDfDpbrHtehWjNSv\" 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<h2 class=\"wp-block-heading\">M\u00e9g t\u00f6bb hasznos billenty\u0171kombin\u00e1ci\u00f3<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Gyere az <a href=\"https:\/\/exceltitok.hu\/gyb55\" type=\"link\" id=\"https:\/\/exceltitok.hu\/gyb55\" target=\"_blank\" rel=\"noreferrer noopener\">55 napos billenty\u0171kombin\u00e1ci\u00f3 kihiv\u00e1sba<\/a> \u2013 \u00e9s tanuljunk k\u00f6z\u00f6sen! Napi p\u00e1r perc gyakorl\u00e1ssal \u00f3r\u00e1kat, napokat sp\u00f3rolhatsz &#8211; \u00e9s garant\u00e1ltan jobban fogod szeretni a gyorsbillenty\u0171ket \u00e9s az Excelt! <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">B\u00e1rmikor bekapcsol\u00f3dhatsz \u00e9s a saj\u00e1t temp\u00f3dban haladhatsz &#8211; \u00e9s tud\u00e1sszintt\u0151l f\u00fcggetlen\u00fcl hetente \u00f3r\u00e1kat sp\u00f3rolhatsz.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Vagy gyere a VIP Klubba, ahol havonta k\u00f6z\u00f6sen tanulunk \u2013 \u00e9s egyb\u0151l hozz\u00e1f\u00e9rsz a kor\u00e1bbi 20+ alkalom felv\u00e9tel\u00e9hez is. T\u00f6bbek k\u00f6z\u00f6tt\u00a0<strong>3 \u00f3r\u00e1nyi gyorsbillenty\u0171 gyakorl\u00e1s<\/strong>hoz, valamint egy PDF-ben let\u00f6ltheted az 55 napos kih\u00edv\u00e1s anyag\u00e1t:\u00a0<a href=\"https:\/\/excelklub.hu\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/excelklub.hu\/<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Ha szeretn\u00e9l fejl\u0151dni az Excelben<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Ha szeretn\u00e9d <strong>gyakorlatias p\u00e9ld\u00e1kon\u00a0<\/strong>begyakorolni az Excel alapjait, akkor aj\u00e1nlom a Kezd\u0151 Excel feladatok p\u00e9ldat\u00e1rat, amelyben 29 kidolgozott \u00e9s tov\u00e1bbi 34 extra feladatot tal\u00e1lsz:\u00a0<a href=\"https:\/\/exceltitok.hu\/excel-nagyagyu\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/excel-nagyagyu<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Ha a kezd\u0151 szintr\u0151l eg\u00e9szen halad\u00f3ig szeretn\u00e9l eljutni, \u00e9s ehhez szeretn\u00e9l \u00e9l\u0151 t\u00e1mogat\u00e1st is, akkor gyere hozz\u00e1nk tanfolyamra! A<strong>\u00a09 alkalmas online \u00e9l\u0151 oktat\u00e1son<\/strong>\u00a0hasonl\u00f3, egyre halad\u00f3bb feladatokkal dolgozunk:\u00a0<a href=\"https:\/\/exceltitok.hu\/kezdo-halado\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/kezdo-halado\/<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Excel\u00a0<strong>tank\u00f6nyv\u00a0<\/strong>\u2013 gyakorlati p\u00e9ld\u00e1k, \u00e9rthet\u0151 magyar\u00e1zatok, \u00e9s a v\u00e9g\u00e9n 5 oldalnyi gyorsbillenty\u0171-lista:\u00a0<a href=\"https:\/\/exceltitok.hu\/excel-tankonyv\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/excel-tankonyv\/<\/a>\u00a0K\u00fcl\u00f6n Google T\u00e1bl\u00e1zatok k\u00f6nyv:\u00a0<a href=\"https:\/\/exceltitok.hu\/google-tablazatok-tankonyv\/\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/exceltitok.hu\/google-tablazatok-tankonyv\/<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Jel\u00f6ld ki a G oszlop sz\u00e1mait a sz\u00e1mform\u00e1tum be\u00e1ll\u00edt\u00e1s\u00e1hoz. A G2 lesz kezd\u0151 poz\u00edci\u00f3. Az A1 cell\u00e1b\u00f3l el\u0151sz\u00f6r Ctrl + jobbra ny\u00edllal ugorj a G1 cell\u00e1ba, majd a sima lefele ny\u00edllal a G2-be. Innen az oszlopban szerepl\u0151 \u00f6sszes sz\u00e1m kijel\u00f6l\u00e9s\u00e9hez haszn\u00e1ld a Ctrl + Shift + lefele nyilat. Az ezres csoportos\u00edt\u00e1st t\u00f6bbf\u00e9lek\u00e9ppen be lehet \u00e1ll\u00edtani. [&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-10112","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.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Cellaform\u00e1z\u00e1s billenty\u0171kkel - 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\/cellaformazas-billentyukkel\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cellaform\u00e1z\u00e1s billenty\u0171kkel - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Jel\u00f6ld ki a G oszlop sz\u00e1mait a sz\u00e1mform\u00e1tum be\u00e1ll\u00edt\u00e1s\u00e1hoz. A G2 lesz kezd\u0151 poz\u00edci\u00f3. Az A1 cell\u00e1b\u00f3l el\u0151sz\u00f6r Ctrl + jobbra ny\u00edllal ugorj a G1 cell\u00e1ba, majd a sima lefele ny\u00edllal a G2-be. Innen az oszlopban szerepl\u0151 \u00f6sszes sz\u00e1m kijel\u00f6l\u00e9s\u00e9hez haszn\u00e1ld a Ctrl + Shift + lefele nyilat. Az ezres csoportos\u00edt\u00e1st t\u00f6bbf\u00e9lek\u00e9ppen be lehet \u00e1ll\u00edtani. [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/cellaformazas-billentyukkel\/\" \/>\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-06-09T20:50:50+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-09T20:59:20+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Szam-formatum.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1038\" \/>\n\t<meta property=\"og:image:height\" content=\"1050\" \/>\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=\"3 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/cellaformazas-billentyukkel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/cellaformazas-billentyukkel\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Cellaform\u00e1z\u00e1s billenty\u0171kkel\",\"datePublished\":\"2026-06-09T20:50:50+00:00\",\"dateModified\":\"2026-06-09T20:59:20+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/cellaformazas-billentyukkel\\\/\"},\"wordCount\":550,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/cellaformazas-billentyukkel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/Szam-formatum-1012x1024.png\",\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/cellaformazas-billentyukkel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/cellaformazas-billentyukkel\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/cellaformazas-billentyukkel\\\/\",\"name\":\"Cellaform\u00e1z\u00e1s billenty\u0171kkel - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/cellaformazas-billentyukkel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/cellaformazas-billentyukkel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/Szam-formatum-1012x1024.png\",\"datePublished\":\"2026-06-09T20:50:50+00:00\",\"dateModified\":\"2026-06-09T20:59:20+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/cellaformazas-billentyukkel\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/cellaformazas-billentyukkel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/cellaformazas-billentyukkel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/Szam-formatum.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/Szam-formatum.png\",\"width\":1038,\"height\":1050},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/cellaformazas-billentyukkel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cellaform\u00e1z\u00e1s billenty\u0171kkel\"}]},{\"@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":"Cellaform\u00e1z\u00e1s billenty\u0171kkel - 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\/cellaformazas-billentyukkel\/","og_locale":"hu_HU","og_type":"article","og_title":"Cellaform\u00e1z\u00e1s billenty\u0171kkel - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Jel\u00f6ld ki a G oszlop sz\u00e1mait a sz\u00e1mform\u00e1tum be\u00e1ll\u00edt\u00e1s\u00e1hoz. A G2 lesz kezd\u0151 poz\u00edci\u00f3. Az A1 cell\u00e1b\u00f3l el\u0151sz\u00f6r Ctrl + jobbra ny\u00edllal ugorj a G1 cell\u00e1ba, majd a sima lefele ny\u00edllal a G2-be. Innen az oszlopban szerepl\u0151 \u00f6sszes sz\u00e1m kijel\u00f6l\u00e9s\u00e9hez haszn\u00e1ld a Ctrl + Shift + lefele nyilat. Az ezres csoportos\u00edt\u00e1st t\u00f6bbf\u00e9lek\u00e9ppen be lehet \u00e1ll\u00edtani. [&hellip;]","og_url":"https:\/\/sosexcel.com\/exceltippek\/cellaformazas-billentyukkel\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2026-06-09T20:50:50+00:00","article_modified_time":"2026-06-09T20:59:20+00:00","og_image":[{"width":1038,"height":1050,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Szam-formatum.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"3 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/cellaformazas-billentyukkel\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/cellaformazas-billentyukkel\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Cellaform\u00e1z\u00e1s billenty\u0171kkel","datePublished":"2026-06-09T20:50:50+00:00","dateModified":"2026-06-09T20:59:20+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/cellaformazas-billentyukkel\/"},"wordCount":550,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/cellaformazas-billentyukkel\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Szam-formatum-1012x1024.png","articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/cellaformazas-billentyukkel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/cellaformazas-billentyukkel\/","url":"https:\/\/sosexcel.com\/exceltippek\/cellaformazas-billentyukkel\/","name":"Cellaform\u00e1z\u00e1s billenty\u0171kkel - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/cellaformazas-billentyukkel\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/cellaformazas-billentyukkel\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Szam-formatum-1012x1024.png","datePublished":"2026-06-09T20:50:50+00:00","dateModified":"2026-06-09T20:59:20+00:00","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/cellaformazas-billentyukkel\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/cellaformazas-billentyukkel\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/cellaformazas-billentyukkel\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Szam-formatum.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/Szam-formatum.png","width":1038,"height":1050},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/cellaformazas-billentyukkel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Cellaform\u00e1z\u00e1s billenty\u0171kkel"}]},{"@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\/10112","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=10112"}],"version-history":[{"count":4,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/10112\/revisions"}],"predecessor-version":[{"id":10119,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/10112\/revisions\/10119"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=10112"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=10112"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=10112"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}