{"id":7517,"date":"2019-05-13T07:32:54","date_gmt":"2019-05-13T05:32:54","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=7517"},"modified":"2019-06-05T20:47:48","modified_gmt":"2019-06-05T18:47:48","slug":"fixalhatom-a-cella-helyet","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/fixalhatom-a-cella-helyet\/","title":{"rendered":"Hogyan fix\u00e1lhatom a cella hely\u00e9t a k\u00e9pletben?"},"content":{"rendered":"<p><strong>K\u00e9rd\u00e9s<\/strong>: Hogyan\u00a0fix\u00e1lhatom a cella hely\u00e9t, hogy ne kelljen egyes\u00e9vel \u00e1t\u00edrnom a k\u00e9pleteket? Van egy t\u00e1bl\u00e1zatom, ahol a C oszlopba a B oszlop 20%-\u00e1t akarom kisz\u00e1molni, de a 20% v\u00e1ltozhat, ez\u00e9rt a K1-es cell\u00e1ban szerepel.<\/p>\n<p>Teh\u00e1t a B oszlop \u00e9rt\u00e9keit akarom beszorozni a K1-es cell\u00e1val.\u00a0Hi\u00e1ba rakom ki a $ jelet \u00edgy, nem m\u0171k\u00f6dik: =B2*$K1\u00a0\u00a0<\/p>\n<p><!--more--><\/p>\n\n\n<h2 class=\"wp-block-heading\">Fix\u00e1l\u00e1s vagy doll\u00e1roz\u00e1s<\/h2>\n\n\n\n<p><strong>Az\u00a0Excelben\u00a0val\u00f3ban\u00a0a\u00a0doll\u00e1rjelet\u00a0haszn\u00e1ljuk\u00a0ilyen\u00a0esetekben<\/strong>,\u00a0amikor nem szeretn\u00e9nk, ha a hivatkoz\u00e1s elmozdulna. <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright is-resized\"><img fetchpriority=\"high\" decoding=\"async\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/fixalas.png\" alt=\"Hogyan fix\u00e1lhatom a cella hely\u00e9t?\" class=\"wp-image-7536\" width=\"419\" height=\"258\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/fixalas.png 458w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/fixalas-300x185.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/fixalas-240x148.png 240w\" sizes=\"(max-width: 419px) 100vw, 419px\" \/><\/figure><\/div>\n\n\n\n<p>A $ jel mindig a r\u00e1k\u00f6vetkez\u0151 karaktert r\u00f6gz\u00edti. Lehet az oszlop- \u00e9s a sorazonos\u00edt\u00f3 el\u0151tt is, vagyis a bet\u0171 (K) \u00e9s lehet a sz\u00e1m (1) el\u0151tt is, vagy ak\u00e1r mindkett\u0151 el\u0151tt.<\/p>\n\n\n\n<p>Mivel itt az oszlopot akarod kit\u00f6lteni, azaz lefel\u00e9 m\u00e1solod a k\u00e9pletet, alapvet\u0151en a sorsz\u00e1m mozog tov\u00e1bb K1-r\u0151l: K2, K3, K4, stb.<\/p>\n\n\n\n<div class=\"wp-block-media-text alignwide\" style=\"grid-template-columns:38% auto\"><figure class=\"wp-block-media-text__media\"><img decoding=\"async\" width=\"190\" height=\"289\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/dollarozas.png\" alt=\"Hova tegyem a doll\u00e1rjelet, hogy minden k\u00e9pletben K1 maradjon?\" class=\"wp-image-7537\"\/><\/figure><div class=\"wp-block-media-text__content\">\n<p>Teh\u00e1t fontos, hogy az 1-es el\u0151tt mindenk\u00e9ppen legyen doll\u00e1rjel, ezzel&nbsp;fix\u00e1lhatod a cella hely\u00e9t: K$1 vagy $K$1<\/p>\n\n\n\n<p>Azaz a helyes k\u00e9plet:&nbsp; =B2*$K$1 &nbsp;vagy&nbsp; =B2*K$1&nbsp;<\/p>\n\n\n\n<p>Ilyen esetekben \u00e9n szem\u00e9ly szerint a dupla doll\u00e1rjelet szeretem jobban.<\/p>\n\n\n\n<p>\u00cdgy lem\u00e1solva, minden k\u00e9pletben a $K$1 szerepel.<\/p>\n<\/div><\/div>\n\n\n\n<p><strong>Tipp:&nbsp;<\/strong>A doll\u00e1rjelet ($) nem kell beg\u00e9pelned, egyszer\u0171bb az F4 funkci\u00f3gombbal fix\u00e1lni a kiv\u00e1lasztott cell\u00e1t. Vagyis el\u0151bb \u00edrd be a k\u00e9pletbe a cellahivatkoz\u00e1st, cellaazonos\u00edt\u00f3t, \u00e9s ut\u00e1na nyomd meg az F4 gombot.&nbsp;\u00cdgy pl. a K1-b\u0151l $K$1 lesz, majd K$1, azut\u00e1n&nbsp;$K1, v\u00e9g\u00fcl \u00fajra K1, \u00e9s kezd\u0151dik a sor el\u00f6lr\u0151l, att\u00f3l f\u00fcgg\u0151en, hogy h\u00e1nyszor nyomod meg a&nbsp;funkci\u00f3gombot. A dupladoll\u00e1rral garant\u00e1ltan fix\u00e1lhatod a cella hely\u00e9t.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Ha szeretn\u00e9l t\u00f6bbet tudni a k\u00e9pletekr\u0151l \u00e9s a doll\u00e1rjelekr\u0151l:&nbsp;<\/strong><\/h2>\n\n\n\n<p><a rel=\"noreferrer noopener\" aria-label=\" (\u00faj f\u00fcl\u00f6n nyitja meg)\" href=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-irj-kepleteket-az-excelben\/\" target=\"_blank\">Hogyan \u00edrj Excel k\u00e9pleteket<\/a>&nbsp;<br><a rel=\"noreferrer noopener\" aria-label=\" (\u00faj f\u00fcl\u00f6n nyitja meg)\" href=\"http:\/\/exceltitok.hu\/excel-kepletek-eger-nelkul\/\" target=\"_blank\">Excel k\u00e9pletek eg\u00e9r n\u00e9lk\u00fcl<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/mi-a-muveletek-sorrendje-es-mikor-kell-zarojelet-hasznalni\/\" target=\"_blank\">Mi a m\u0171veletek sorrendje, \u00e9s mikor kell z\u00e1r\u00f3jelet haszn\u00e1lni?<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/kepletek-ellenorzese\/\" target=\"_blank\">3 m\u00f3dszer a k\u00e9pleteket ellen\u0151rz\u00e9s\u00e9re<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/hogyan-szamold-ki-brutto-ertek-afatartalmat\/\" target=\"_blank\">Hogyan sz\u00e1mold ki a brutt\u00f3 \u00e9rt\u00e9k \u00e1fa-tartalm\u00e1t?<\/a><br><a rel=\"noreferrer noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/mit-viszonyitsak-mihez-azaz-a-szazalekszamitas-buktatoi\/\" target=\"_blank\">Mit viszony\u00edtsak mihez, azaz a sz\u00e1zal\u00e9ksz\u00e1m\u00edt\u00e1s buktat\u00f3i<\/a><br><a rel=\"noreferrer noopener\" aria-label=\"Milyen m\u0171veletek vannak az Excelben? (\u00faj f\u00fcl\u00f6n nyitja meg)\" href=\"https:\/\/sosexcel.com\/exceltippek\/excel-muveletek\/\" target=\"_blank\">Milyen m\u0171veletek vannak az Excelben?<\/a><br><a rel=\"noreferrer noopener\" aria-label=\" (\u00faj f\u00fcl\u00f6n nyitja meg)\" href=\"https:\/\/sosexcel.com\/exceltippek\/mire-jo-az-f4-funkciobillentyu\/\" target=\"_blank\">Mire j\u00f3 az F4 funkci\u00f3billenty\u0171?<\/a><br><a href=\"https:\/\/sosexcel.com\/exceltippek\/nem-reagal-az-f4-gomb\/\" target=\"_blank\" rel=\"noreferrer noopener\" aria-label=\" (\u00faj f\u00fcl\u00f6n nyitja meg)\">Nem reag\u00e1l az F4 gomb<\/a><br><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"https:\/\/exceltitok.hu\/excel-nagyagyu\/\"><img decoding=\"async\" width=\"728\" height=\"90\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/oldalra-sajat-banner.jpg\" alt=\"Hogyan\u00a0fix\u00e1lhatom a cella hely\u00e9t?\" class=\"wp-image-7522\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/oldalra-sajat-banner.jpg 728w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/oldalra-sajat-banner-300x37.jpg 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/oldalra-sajat-banner-660x82.jpg 660w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/oldalra-sajat-banner-240x30.jpg 240w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><figcaption><a href=\"https:\/\/exceltitok.hu\/excel-nagyagyu\/\"><span style=\"text-decoration: underline;\">http:\/\/exceltitok.hu\/excel-feladatsorok\/<\/span><\/a><\/figcaption><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Ez is \u00e9rdekelhet:<\/h2>\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=\"BRX2LhiLa4\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/\">3 Excel funkci\u00f3, amit mindenkinek ismernie kellene<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;3 Excel funkci\u00f3, amit mindenkinek ismernie kellene&#8221; &#8212; Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" src=\"https:\/\/sosexcel.com\/exceltippek\/excel-tablazat-hasznalata-3-alap-funkcio\/embed\/#?secret=ur26f3gOT2#?secret=BRX2LhiLa4\" data-secret=\"BRX2LhiLa4\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/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=\"vsUjrEgztd\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/keszits-brutto-netto-berkalkulatort\/\">K\u00e9sz\u00edts brutt\u00f3-nett\u00f3 b\u00e9rkalkul\u00e1tort Excelben!<\/a><\/blockquote><iframe class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;K\u00e9sz\u00edts brutt\u00f3-nett\u00f3 b\u00e9rkalkul\u00e1tort Excelben!&#8221; &#8212; Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" src=\"https:\/\/sosexcel.com\/exceltippek\/keszits-brutto-netto-berkalkulatort\/embed\/#?secret=J8378ACi9E#?secret=vsUjrEgztd\" data-secret=\"vsUjrEgztd\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n","protected":false},"excerpt":{"rendered":"<p>K\u00e9rd\u00e9s: Hogyan\u00a0fix\u00e1lhatom a cella hely\u00e9t, hogy ne kelljen egyes\u00e9vel \u00e1t\u00edrnom a k\u00e9pleteket? Van egy t\u00e1bl\u00e1zatom, ahol a C oszlopba a B oszlop 20%-\u00e1t akarom kisz\u00e1molni, de a 20% v\u00e1ltozhat, ez\u00e9rt a K1-es cell\u00e1ban szerepel. Teh\u00e1t a B oszlop \u00e9rt\u00e9keit akarom beszorozni a K1-es cell\u00e1val.\u00a0Hi\u00e1ba rakom ki a $ jelet \u00edgy, nem m\u0171k\u00f6dik: =B2*$K1\u00a0\u00a0<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","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":"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":[],"class_list":["post-7517","post","type-post","status-publish","format-standard","hentry","category-excel-tippek-gyakori-kerdesek"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Hogyan fix\u00e1lhatom a cella hely\u00e9t a k\u00e9pletben? - ExcelTitok<\/title>\n<meta name=\"description\" content=\"Hogyan\u00a0fix\u00e1lhatom a cella hely\u00e9t, hogy ne kelljen egyes\u00e9vel \u00e1t\u00edrnom a k\u00e9pleteket? Haszn\u00e1ld hozz\u00e1 a doll\u00e1rjelet, r\u00f6gz\u00edtsd a sort.\" \/>\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\/fixalhatom-a-cella-helyet\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Hogyan fix\u00e1lhatom a cella hely\u00e9t a k\u00e9pletben? - ExcelTitok\" \/>\n<meta property=\"og:description\" content=\"Hogyan\u00a0fix\u00e1lhatom a cella hely\u00e9t, hogy ne kelljen egyes\u00e9vel \u00e1t\u00edrnom a k\u00e9pleteket? Haszn\u00e1ld hozz\u00e1 a doll\u00e1rjelet, r\u00f6gz\u00edtsd a sort.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/fixalhatom-a-cella-helyet\/\" \/>\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=\"2019-05-13T05:32:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-06-05T18:47:48+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/fixalas.png\" \/>\n\t<meta property=\"og:image:width\" content=\"458\" \/>\n\t<meta property=\"og:image:height\" content=\"282\" \/>\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\\\/fixalhatom-a-cella-helyet\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/fixalhatom-a-cella-helyet\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Hogyan fix\u00e1lhatom a cella hely\u00e9t a k\u00e9pletben?\",\"datePublished\":\"2019-05-13T05:32:54+00:00\",\"dateModified\":\"2019-06-05T18:47:48+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/fixalhatom-a-cella-helyet\\\/\"},\"wordCount\":445,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/fixalhatom-a-cella-helyet\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/fixalas.png\",\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/fixalhatom-a-cella-helyet\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/fixalhatom-a-cella-helyet\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/fixalhatom-a-cella-helyet\\\/\",\"name\":\"Hogyan fix\u00e1lhatom a cella hely\u00e9t a k\u00e9pletben? - ExcelTitok\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/fixalhatom-a-cella-helyet\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/fixalhatom-a-cella-helyet\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/fixalas.png\",\"datePublished\":\"2019-05-13T05:32:54+00:00\",\"dateModified\":\"2019-06-05T18:47:48+00:00\",\"description\":\"Hogyan\u00a0fix\u00e1lhatom a cella hely\u00e9t, hogy ne kelljen egyes\u00e9vel \u00e1t\u00edrnom a k\u00e9pleteket? Haszn\u00e1ld hozz\u00e1 a doll\u00e1rjelet, r\u00f6gz\u00edtsd a sort.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/fixalhatom-a-cella-helyet\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/fixalhatom-a-cella-helyet\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/fixalhatom-a-cella-helyet\\\/#primaryimage\",\"url\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/fixalas.png\",\"contentUrl\":\"http:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2019\\\/05\\\/fixalas.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/fixalhatom-a-cella-helyet\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Hogyan fix\u00e1lhatom a cella hely\u00e9t a k\u00e9pletben?\"}]},{\"@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":"Hogyan fix\u00e1lhatom a cella hely\u00e9t a k\u00e9pletben? - ExcelTitok","description":"Hogyan\u00a0fix\u00e1lhatom a cella hely\u00e9t, hogy ne kelljen egyes\u00e9vel \u00e1t\u00edrnom a k\u00e9pleteket? Haszn\u00e1ld hozz\u00e1 a doll\u00e1rjelet, r\u00f6gz\u00edtsd a sort.","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\/fixalhatom-a-cella-helyet\/","og_locale":"hu_HU","og_type":"article","og_title":"Hogyan fix\u00e1lhatom a cella hely\u00e9t a k\u00e9pletben? - ExcelTitok","og_description":"Hogyan\u00a0fix\u00e1lhatom a cella hely\u00e9t, hogy ne kelljen egyes\u00e9vel \u00e1t\u00edrnom a k\u00e9pleteket? Haszn\u00e1ld hozz\u00e1 a doll\u00e1rjelet, r\u00f6gz\u00edtsd a sort.","og_url":"https:\/\/sosexcel.com\/exceltippek\/fixalhatom-a-cella-helyet\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2019-05-13T05:32:54+00:00","article_modified_time":"2019-06-05T18:47:48+00:00","og_image":[{"width":458,"height":282,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/fixalas.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\/fixalhatom-a-cella-helyet\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/fixalhatom-a-cella-helyet\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Hogyan fix\u00e1lhatom a cella hely\u00e9t a k\u00e9pletben?","datePublished":"2019-05-13T05:32:54+00:00","dateModified":"2019-06-05T18:47:48+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/fixalhatom-a-cella-helyet\/"},"wordCount":445,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/fixalhatom-a-cella-helyet\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/fixalas.png","articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/fixalhatom-a-cella-helyet\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/fixalhatom-a-cella-helyet\/","url":"https:\/\/sosexcel.com\/exceltippek\/fixalhatom-a-cella-helyet\/","name":"Hogyan fix\u00e1lhatom a cella hely\u00e9t a k\u00e9pletben? - ExcelTitok","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/fixalhatom-a-cella-helyet\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/fixalhatom-a-cella-helyet\/#primaryimage"},"thumbnailUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/fixalas.png","datePublished":"2019-05-13T05:32:54+00:00","dateModified":"2019-06-05T18:47:48+00:00","description":"Hogyan\u00a0fix\u00e1lhatom a cella hely\u00e9t, hogy ne kelljen egyes\u00e9vel \u00e1t\u00edrnom a k\u00e9pleteket? Haszn\u00e1ld hozz\u00e1 a doll\u00e1rjelet, r\u00f6gz\u00edtsd a sort.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/fixalhatom-a-cella-helyet\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/fixalhatom-a-cella-helyet\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/fixalhatom-a-cella-helyet\/#primaryimage","url":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/fixalas.png","contentUrl":"http:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2019\/05\/fixalas.png"},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/fixalhatom-a-cella-helyet\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Hogyan fix\u00e1lhatom a cella hely\u00e9t a k\u00e9pletben?"}]},{"@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\/7517","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=7517"}],"version-history":[{"count":17,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/7517\/revisions"}],"predecessor-version":[{"id":7731,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/7517\/revisions\/7731"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=7517"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=7517"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=7517"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}