{"id":9160,"date":"2021-08-03T18:24:24","date_gmt":"2021-08-03T16:24:24","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=9160"},"modified":"2021-08-04T11:08:04","modified_gmt":"2021-08-04T09:08:04","slug":"negyzet-cellak-keszitese-excelben","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/","title":{"rendered":"N\u00e9gyzet cell\u00e1k k\u00e9sz\u00edt\u00e9se Excelben"},"content":{"rendered":"\n<p>K\u00e9rd\u00e9s: Excelben szeretn\u00e9k egyforma magas oszlopokat \u00e9s sorokat, vagyis n\u00e9gyzet cell\u00e1kat csin\u00e1lni. Hogyan \u00e1ll\u00edtsam be az oszlopok \u00e9s a sorok m\u00e9ret\u00e9t?<\/p>\n\n\n\n<div class=\"wp-block-media-text alignwide is-stacked-on-mobile\" style=\"grid-template-columns:43% auto\"><figure class=\"wp-block-media-text__media\"><img decoding=\"async\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2013\/08\/negyzetracs.jpg\" alt=\"Ak\u00e1r egy sakkt\u00e1bla k\u00e9sz\u00edt\u00e9s\u00e9hez is sz\u00fcks\u00e9ged lehet a n\u00e9gyzet cell\u00e1k el\u0151\u00e1ll\u00edt\u00e1s\u00e1ra.\"\/><\/figure><div class=\"wp-block-media-text__content\">\n<p class=\"has-normal-font-size\">Alap\u00e9rtelmezetten a sormagass\u00e1g \u2018m\u00e9rete\u2019 (12,75 vagy 15,00) j\u00f3val nagyobb, mint az oszlop\u00e9 (8,43) \u2013 \u00e9s mellette csak z\u00e1r\u00f3jelben szerepel a k\u00f6z\u00f6s m\u00e9rt\u00e9kegys\u00e9g, ami a k\u00e9ppont (pixel).<\/p>\n\n\n\n<p class=\"has-normal-font-size\"><strong>Az eredeti sz\u00e1mok a nyomd\u00e1szatb\u00f3l j\u00f6nnek<\/strong>, a sz\u00e9less\u00e9g kb. a l\u00e1that\u00f3 sz\u00f6veg karaktersz\u00e1m\u00e1ra, m\u00edg a magass\u00e1g a bet\u0171 m\u00e9ret\u00e9re utal. A r\u00e9szletes magyar\u00e1zatot a&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/sormagassag-oszlopszelesseg\/\" target=\"_blank\"><span style=\"text-decoration: underline;\">Mi\u00e9rt \u201cnagyobbak\u201d a sorok?<\/span>&nbsp;<\/a>cikkben tal\u00e1lod.<\/p>\n<\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">N\u00e9gyzet cell\u00e1k k\u00e9sz\u00edt\u00e9se<\/h2>\n\n\n\n<p>Ha a kiindul\u00f3 t\u00e1bl\u00e1zatban szeretn\u00e9l n\u00e9gyzet cell\u00e1kat (vagyis egyforma magas oszlopok \u00e9s sorokat), akkor 15-\u00f6s sormagass\u00e1ghoz az oszlopsz\u00e9less\u00e9get \u00e1ll\u00edtsd 2,14-re.<\/p>\n\n\n\n<div class=\"wp-block-media-text alignwide has-media-on-the-right is-stacked-on-mobile\"><figure class=\"wp-block-media-text__media\"><img fetchpriority=\"high\" decoding=\"async\" width=\"413\" height=\"443\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/08\/negyzet_kocka_excel.png\" alt=\"\" class=\"wp-image-9210 size-full\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/08\/negyzet_kocka_excel.png 413w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/08\/negyzet_kocka_excel-280x300.png 280w\" sizes=\"(max-width: 413px) 100vw, 413px\" \/><\/figure><div class=\"wp-block-media-text__content\">\n<p>Nagyobb n\u00e9gyzet cell\u00e1khoz hagyd az oszlopokat az eredeti 8,43-as m\u00e9reten, \u00e9s a sorokat \u00e1ll\u00edtsd 48 egys\u00e9gre.<\/p>\n\n\n\n<p>Ha a 2 k\u00f6z\u00f6tt, pl. 30 pixelesre akarsz m\u00e9retezni, akkor ezt \u00e1ll\u00edtsd be:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>sormagass\u00e1g: 22,5<\/li><li>oszlopsz\u00e9less\u00e9g: 3,57<\/li><\/ul>\n<\/div><\/div>\n\n\n\n<p>M\u00edg a sorok magass\u00e1ga \u00e9s a pixelek k\u00f6z\u00f6tt van v\u00e1lt\u00f3sz\u00e1m (pixel = magass\u00e1g x 4\/3 ), addig az oszlopsz\u00e9less\u00e9g nem sz\u00e1m\u00edthat\u00f3 \u00e1t ilyen k\u00f6nnyen.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Cell\u00e1k m\u00e9retez\u00e9se<\/h2>\n\n\n\n<p><strong>K\u00fcl\u00f6n egy-egy cell\u00e1t m\u00e9retezni nem lehet, mindig csak a sorokat \u00e9s az oszlopokat. <\/strong>A cella m\u00e9rete mindig az adott sor \u00e9s oszlop m\u00e9ret\u00e9t\u0151l f\u00fcgg, amit az azonos\u00edt\u00f3 bet\u0171k vagy sz\u00e1mok k\u00f6z\u00f6tti vonalon \u00e1ll\u00edthatsz, mindig a &#8216;t\u00e1volabbi&#8217; vonaln\u00e1l. A&nbsp;<a rel=\"noreferrer noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/oszlopszelesseg-modositasa\/\" target=\"_blank\"><span style=\"text-decoration: underline;\">sorok \u00e9s oszlopok m\u00e9retez\u00e9s\u00e9r\u0151l<\/span><\/a>&nbsp;itt olvashatsz b\u0151vebben.<\/p>\n\n\n\n<p>Ha szeretn\u00e9d jobban megismerni az Excelt, akkor olvass tov\u00e1bb a blogon, vagy rendeld meg az <span style=\"text-decoration: underline;\"><a rel=\"noreferrer noopener\" href=\"https:\/\/exceltitok.hu\/excel-tankonyv\/\" data-type=\"URL\" data-id=\"https:\/\/exceltitok.hu\/excel-tankonyv\/\" target=\"_blank\">Excel Kezd\u0151 &amp; Halad\u00f3 Tank\u00f6nyvet<\/a><\/span>.<\/p>\n\n\n\n<p><span style=\"text-decoration: underline;\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/cella-mertekegyseget-atallitani\/\" data-type=\"URL\" data-id=\"https:\/\/sosexcel.com\/exceltippek\/cella-mertekegyseget-atallitani\/\">Hogyan lehet a cella m\u00e9rt\u00e9kegys\u00e9g\u00e9t \u00e1t\u00e1ll\u00edtani?<\/a><\/span><\/p>\n\n\n\n<p><span style=\"text-decoration: underline;\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/igy-hasznald-kreativan-az-excelt\/\" data-type=\"URL\" data-id=\"https:\/\/sosexcel.com\/exceltippek\/igy-hasznald-kreativan-az-excelt\/\">\u00cdgy haszn\u00e1ld kreat\u00edvan az Excelt!<\/a><\/span><\/p>\n\n\n\n<iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/klgPoh8q3CM\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen=\"\"><\/iframe>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>K\u00e9rd\u00e9s: Excelben szeretn\u00e9k egyforma magas oszlopokat \u00e9s sorokat, vagyis n\u00e9gyzet cell\u00e1kat csin\u00e1lni. Hogyan \u00e1ll\u00edtsam be az oszlopok \u00e9s a sorok m\u00e9ret\u00e9t? Alap\u00e9rtelmezetten a sormagass\u00e1g \u2018m\u00e9rete\u2019 (12,75 vagy 15,00) j\u00f3val nagyobb, mint az oszlop\u00e9 (8,43) \u2013 \u00e9s mellette csak z\u00e1r\u00f3jelben szerepel a k\u00f6z\u00f6s m\u00e9rt\u00e9kegys\u00e9g, ami a k\u00e9ppont (pixel). Az eredeti sz\u00e1mok a nyomd\u00e1szatb\u00f3l j\u00f6nnek, a sz\u00e9less\u00e9g [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":9215,"comment_status":"open","ping_status":"closed","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":[19,23],"class_list":["post-9160","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek","tag-formazas","tag-oszlop-sor-cella"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>N\u00e9gyzet cell\u00e1k k\u00e9sz\u00edt\u00e9se Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"N\u00e9gyzet cell\u00e1k k\u00e9sz\u00edt\u00e9s\u00e9hez a sorok \u00e9s oszlopok helyes be\u00e1ll\u00edt\u00e1s\u00e1ra figyelj, \u00e9s arra, hogy az Excel elt\u00e9r\u0151 m\u00e9rt\u00e9kegys\u00e9geket haszn\u00e1l.\" \/>\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\/negyzet-cellak-keszitese-excelben\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"N\u00e9gyzet cell\u00e1k k\u00e9sz\u00edt\u00e9se Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"N\u00e9gyzet cell\u00e1k k\u00e9sz\u00edt\u00e9s\u00e9hez a sorok \u00e9s oszlopok helyes be\u00e1ll\u00edt\u00e1s\u00e1ra figyelj, \u00e9s arra, hogy az Excel elt\u00e9r\u0151 m\u00e9rt\u00e9kegys\u00e9geket haszn\u00e1l.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/\" \/>\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=\"2021-08-03T16:24:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-08-04T09:08:04+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/08\/pont_negyzet_cella.png\" \/>\n\t<meta property=\"og:image:width\" content=\"2240\" \/>\n\t<meta property=\"og:image:height\" content=\"1260\" \/>\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=\"2 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"N\u00e9gyzet cell\u00e1k k\u00e9sz\u00edt\u00e9se Excelben\",\"datePublished\":\"2021-08-03T16:24:24+00:00\",\"dateModified\":\"2021-08-04T09:08:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/\"},\"wordCount\":351,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#organization\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/08\/pont_negyzet_cella.png\",\"keywords\":[\"form\u00e1z\u00e1s\",\"oszlop-sor-cella\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/\",\"name\":\"N\u00e9gyzet cell\u00e1k k\u00e9sz\u00edt\u00e9se Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/08\/pont_negyzet_cella.png\",\"datePublished\":\"2021-08-03T16:24:24+00:00\",\"dateModified\":\"2021-08-04T09:08:04+00:00\",\"description\":\"N\u00e9gyzet cell\u00e1k k\u00e9sz\u00edt\u00e9s\u00e9hez a sorok \u00e9s oszlopok helyes be\u00e1ll\u00edt\u00e1s\u00e1ra figyelj, \u00e9s arra, hogy az Excel elt\u00e9r\u0151 m\u00e9rt\u00e9kegys\u00e9geket haszn\u00e1l.\",\"breadcrumb\":{\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/#primaryimage\",\"url\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/08\/pont_negyzet_cella.png\",\"contentUrl\":\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/08\/pont_negyzet_cella.png\",\"width\":2240,\"height\":1260},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/sosexcel.com\/exceltippek\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"N\u00e9gyzet cell\u00e1k k\u00e9sz\u00edt\u00e9se Excelben\"}]},{\"@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":"N\u00e9gyzet cell\u00e1k k\u00e9sz\u00edt\u00e9se Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"N\u00e9gyzet cell\u00e1k k\u00e9sz\u00edt\u00e9s\u00e9hez a sorok \u00e9s oszlopok helyes be\u00e1ll\u00edt\u00e1s\u00e1ra figyelj, \u00e9s arra, hogy az Excel elt\u00e9r\u0151 m\u00e9rt\u00e9kegys\u00e9geket haszn\u00e1l.","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\/negyzet-cellak-keszitese-excelben\/","og_locale":"hu_HU","og_type":"article","og_title":"N\u00e9gyzet cell\u00e1k k\u00e9sz\u00edt\u00e9se Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"N\u00e9gyzet cell\u00e1k k\u00e9sz\u00edt\u00e9s\u00e9hez a sorok \u00e9s oszlopok helyes be\u00e1ll\u00edt\u00e1s\u00e1ra figyelj, \u00e9s arra, hogy az Excel elt\u00e9r\u0151 m\u00e9rt\u00e9kegys\u00e9geket haszn\u00e1l.","og_url":"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2021-08-03T16:24:24+00:00","article_modified_time":"2021-08-04T09:08:04+00:00","og_image":[{"width":2240,"height":1260,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/08\/pont_negyzet_cella.png","type":"image\/png"}],"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\/negyzet-cellak-keszitese-excelben\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"N\u00e9gyzet cell\u00e1k k\u00e9sz\u00edt\u00e9se Excelben","datePublished":"2021-08-03T16:24:24+00:00","dateModified":"2021-08-04T09:08:04+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/"},"wordCount":351,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/08\/pont_negyzet_cella.png","keywords":["form\u00e1z\u00e1s","oszlop-sor-cella"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/","url":"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/","name":"N\u00e9gyzet cell\u00e1k k\u00e9sz\u00edt\u00e9se Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/08\/pont_negyzet_cella.png","datePublished":"2021-08-03T16:24:24+00:00","dateModified":"2021-08-04T09:08:04+00:00","description":"N\u00e9gyzet cell\u00e1k k\u00e9sz\u00edt\u00e9s\u00e9hez a sorok \u00e9s oszlopok helyes be\u00e1ll\u00edt\u00e1s\u00e1ra figyelj, \u00e9s arra, hogy az Excel elt\u00e9r\u0151 m\u00e9rt\u00e9kegys\u00e9geket haszn\u00e1l.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/08\/pont_negyzet_cella.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2021\/08\/pont_negyzet_cella.png","width":2240,"height":1260},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/negyzet-cellak-keszitese-excelben\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"N\u00e9gyzet cell\u00e1k k\u00e9sz\u00edt\u00e9se Excelben"}]},{"@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\/9160","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=9160"}],"version-history":[{"count":9,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/9160\/revisions"}],"predecessor-version":[{"id":9213,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/9160\/revisions\/9213"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/9215"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=9160"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=9160"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=9160"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}