{"id":10109,"date":"2026-06-11T00:18:21","date_gmt":"2026-06-10T22:18:21","guid":{"rendered":"https:\/\/sosexcel.com\/exceltippek\/?p=10109"},"modified":"2026-06-11T00:42:33","modified_gmt":"2026-06-10T22:42:33","slug":"jelolonegyzet-az-excelben","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/jelolonegyzet-az-excelben\/","title":{"rendered":"Jel\u00f6l\u0151n\u00e9gyzet az Excelben"},"content":{"rendered":"\n

Viszonylag \u00faj funkci\u00f3 az Excelben a ‘Jel\u00f6l\u0151n\u00e9gyzet’ (angolul checkbox). A Besz\u00far\u00e1s f\u00fcl\u00f6n tal\u00e1lhat\u00f3:<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

<\/p>\n\n\n\n

Egyszerre ak\u00e1r t\u00f6bb kijel\u00f6lt cell\u00e1ba is beilleszthet\u0151, vagy k\u00f6nnyen m\u00e1solhat\u00f3.<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

A cell\u00e1kba az IGAZ \/ HAMIS logikai \u00e9rt\u00e9k ker\u00fcl, amelyre k\u00f6nnyen r\u00e1\u00e9p\u00edthet\u0151 egy HA f\u00fcggv\u00e9ny<\/a> vagy Felt\u00e9teles form\u00e1z\u00e1s.<\/p>\n\n\n\n

Pip\u00e1l\u00e1s billenty\u0171kkel<\/h2>\n\n\n\n

A sz\u00e1m\u00edt\u00f3g\u00e9pen a pip\u00e1l\u00e1sra a SZ\u00d3K\u00d6Z billenty\u0171<\/a> haszn\u00e1lhat\u00f3, be- \u00e9s kiteszi a pip\u00e1kat.<\/p>\n\n\n\n

Ha egyszerre t\u00f6bb jel\u00f6l\u0151n\u00e9gyzet (checkbox) is ki van jel\u00f6lve, akkor mindegyikbe ki vagy beteszi egyszerre a pip\u00e1t – ahhoz k\u00e9pest, hogy az els\u0151, akt\u00edv cella \u00e1llapota milyen.<\/p>\n\n\n\n

Checkboxok t\u00f6rl\u00e9se<\/h2>\n\n\n\n

A Delete gombbal t\u00f6r\u00f6lheted a n\u00e9gyzeteket. Ha azonban be vannak pip\u00e1lva, akkor a Delete els\u0151re csak a pip\u00e1t t\u00f6rli, m\u00e1sodikra m\u00e1r a n\u00e9gyzetet.<\/p>\n\n\n\n

Ha az IGAZ \/ HAMIS \u00e9rt\u00e9ket meg szeretn\u00e9d tartani, akkor csak a form\u00e1tumot t\u00f6r\u00f6ld.<\/a><\/p>\n\n\n\n

Logikai m\u0171veletek<\/h2>\n\n\n\n

Itt \u00edrtam kor\u00e1bban a logikai m\u0171veletekr\u0151l<\/a> \u00e9s az IGAZ \/ HAMIS logikai \u00e9rt\u00e9kekr\u0151l. \u00c9rdemes jobban megismerkedni a t\u00e9m\u00e1val, mert a j\u00f3l megfogalmazott szab\u00e1lyokkal sok minden automatiz\u00e1lhat\u00f3, ellen\u0151rizhet\u0151. <\/p>\n\n\n\n

Az IGAZ \u00e9rt\u00e9keket megsz\u00e1molni a DARABHA (COUNTIF) f\u00fcggv\u00e9nnyel lehet. pl:<\/p>\n\n\n\n

=DARABHA(A2:A8;IGAZ)<\/p>\n\n\n\n

M\u00e9g t\u00f6bb hasznos billenty\u0171kombin\u00e1ci\u00f3<\/h2>\n\n\n\n

Gyere az 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 \u2013 \u00e9s garant\u00e1ltan jobban fogod szeretni a gyorsbillenty\u0171ket \u00e9s az Excelt!<\/p>\n\n\n\n

B\u00e1rmikor bekapcsol\u00f3dhatsz \u00e9s a saj\u00e1t temp\u00f3dban haladhatsz \u2013 \u00e9s tud\u00e1sszintt\u0151l f\u00fcggetlen\u00fcl hetente \u00f3r\u00e1kat sp\u00f3rolhatsz.<\/p>\n\n\n\n

Gyere a VIP Klubba,<\/strong> 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\u00a0a logikai m\u0171veleteket \u00e9s f\u00fcggv\u00e9nyeket is gyakoroltuk, valamint hozz\u00e1f\u00e9rsz 3 \u00f3r\u00e1nyi gyorsbillenty\u0171 gyakorl\u00e1s<\/strong>hoz, \u00e9s egy PDF-ben let\u00f6ltheted az 55 napos kih\u00edv\u00e1s anyag\u00e1t:\u00a0https:\/\/excelklub.hu\/<\/a><\/p>\n\n\n\n

Ha szeretn\u00e9l fejl\u0151dni az Excelben<\/h2>\n\n\n\n

Ha szeretn\u00e9d gyakorlatias p\u00e9ld\u00e1kon <\/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: https:\/\/exceltitok.hu\/excel-nagyagyu<\/a><\/p>\n\n\n\n

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 9 alkalmas online \u00e9l\u0151 oktat\u00e1son<\/strong> hasonl\u00f3, egyre halad\u00f3bb feladatokkal dolgozunk: https:\/\/exceltitok.hu\/kezdo-halado\/<\/a><\/p>\n\n\n\n

Excel\u00a0tank\u00f6nyv\u00a0<\/strong>\u2013 gyakorlati p\u00e9ld\u00e1k, \u00e9rthet\u0151 magyar\u00e1zatok, \u00e9s a v\u00e9g\u00e9n 5 oldalnyi gyorsbillenty\u0171-lista:\u00a0https:\/\/exceltitok.hu\/excel-tankonyv\/<\/a>\u00a0<\/p>\n\n\n\n

K\u00fcl\u00f6n Google T\u00e1bl\u00e1zatok k\u00f6nyv:\u00a0https:\/\/exceltitok.hu\/google-tablazatok-tankonyv\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Viszonylag \u00faj funkci\u00f3 az Excelben a ‘Jel\u00f6l\u0151n\u00e9gyzet’ (angolul checkbox). A Besz\u00far\u00e1s f\u00fcl\u00f6n tal\u00e1lhat\u00f3: Egyszerre ak\u00e1r t\u00f6bb kijel\u00f6lt cell\u00e1ba is beilleszthet\u0151, vagy k\u00f6nnyen m\u00e1solhat\u00f3. A cell\u00e1kba az IGAZ \/ HAMIS logikai \u00e9rt\u00e9k ker\u00fcl, amelyre k\u00f6nnyen r\u00e1\u00e9p\u00edthet\u0151 egy HA f\u00fcggv\u00e9ny vagy Felt\u00e9teles form\u00e1z\u00e1s. Pip\u00e1l\u00e1s billenty\u0171kkel A sz\u00e1m\u00edt\u00f3g\u00e9pen a pip\u00e1l\u00e1sra a SZ\u00d3K\u00d6Z billenty\u0171 haszn\u00e1lhat\u00f3, be- \u00e9s kiteszi a […]<\/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-10109","post","type-post","status-publish","format-standard","hentry","category-excel-tippek-gyakori-kerdesek"],"yoast_head":"\nJel\u00f6l\u0151n\u00e9gyzet az Excelben - 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\/jelolonegyzet-az-excelben\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Jel\u00f6l\u0151n\u00e9gyzet az Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"Viszonylag \u00faj funkci\u00f3 az Excelben a ‘Jel\u00f6l\u0151n\u00e9gyzet’ (angolul checkbox). A Besz\u00far\u00e1s f\u00fcl\u00f6n tal\u00e1lhat\u00f3: Egyszerre ak\u00e1r t\u00f6bb kijel\u00f6lt cell\u00e1ba is beilleszthet\u0151, vagy k\u00f6nnyen m\u00e1solhat\u00f3. A cell\u00e1kba az IGAZ \/ HAMIS logikai \u00e9rt\u00e9k ker\u00fcl, amelyre k\u00f6nnyen r\u00e1\u00e9p\u00edthet\u0151 egy HA f\u00fcggv\u00e9ny vagy Felt\u00e9teles form\u00e1z\u00e1s. Pip\u00e1l\u00e1s billenty\u0171kkel A sz\u00e1m\u00edt\u00f3g\u00e9pen a pip\u00e1l\u00e1sra a SZ\u00d3K\u00d6Z billenty\u0171 haszn\u00e1lhat\u00f3, be- \u00e9s kiteszi a […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/jelolonegyzet-az-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=\"2026-06-10T22:18:21+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-06-10T22:42:33+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/jelolonegyzet-checkbox.png\" \/>\n\t<meta property=\"og:image:width\" content=\"781\" \/>\n\t<meta property=\"og:image:height\" content=\"240\" \/>\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\\\/jelolonegyzet-az-excelben\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jelolonegyzet-az-excelben\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/ba32d0d071cf1d2ead4c179c9270f29b\"},\"headline\":\"Jel\u00f6l\u0151n\u00e9gyzet az Excelben\",\"datePublished\":\"2026-06-10T22:18:21+00:00\",\"dateModified\":\"2026-06-10T22:42:33+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jelolonegyzet-az-excelben\\\/\"},\"wordCount\":503,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jelolonegyzet-az-excelben\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/jelolonegyzet-checkbox.png\",\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jelolonegyzet-az-excelben\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jelolonegyzet-az-excelben\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jelolonegyzet-az-excelben\\\/\",\"name\":\"Jel\u00f6l\u0151n\u00e9gyzet az Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jelolonegyzet-az-excelben\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jelolonegyzet-az-excelben\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/jelolonegyzet-checkbox.png\",\"datePublished\":\"2026-06-10T22:18:21+00:00\",\"dateModified\":\"2026-06-10T22:42:33+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jelolonegyzet-az-excelben\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jelolonegyzet-az-excelben\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jelolonegyzet-az-excelben\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/jelolonegyzet-checkbox.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2026\\\/06\\\/jelolonegyzet-checkbox.png\",\"width\":781,\"height\":240},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/jelolonegyzet-az-excelben\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Jel\u00f6l\u0151n\u00e9gyzet az 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":"Jel\u00f6l\u0151n\u00e9gyzet az Excelben - 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\/jelolonegyzet-az-excelben\/","og_locale":"hu_HU","og_type":"article","og_title":"Jel\u00f6l\u0151n\u00e9gyzet az Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"Viszonylag \u00faj funkci\u00f3 az Excelben a ‘Jel\u00f6l\u0151n\u00e9gyzet’ (angolul checkbox). A Besz\u00far\u00e1s f\u00fcl\u00f6n tal\u00e1lhat\u00f3: Egyszerre ak\u00e1r t\u00f6bb kijel\u00f6lt cell\u00e1ba is beilleszthet\u0151, vagy k\u00f6nnyen m\u00e1solhat\u00f3. A cell\u00e1kba az IGAZ \/ HAMIS logikai \u00e9rt\u00e9k ker\u00fcl, amelyre k\u00f6nnyen r\u00e1\u00e9p\u00edthet\u0151 egy HA f\u00fcggv\u00e9ny vagy Felt\u00e9teles form\u00e1z\u00e1s. Pip\u00e1l\u00e1s billenty\u0171kkel A sz\u00e1m\u00edt\u00f3g\u00e9pen a pip\u00e1l\u00e1sra a SZ\u00d3K\u00d6Z billenty\u0171 haszn\u00e1lhat\u00f3, be- \u00e9s kiteszi a […]","og_url":"https:\/\/sosexcel.com\/exceltippek\/jelolonegyzet-az-excelben\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_author":"https:\/\/www.facebook.com\/bernadett.koros","article_published_time":"2026-06-10T22:18:21+00:00","article_modified_time":"2026-06-10T22:42:33+00:00","og_image":[{"width":781,"height":240,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/jelolonegyzet-checkbox.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\/jelolonegyzet-az-excelben\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/jelolonegyzet-az-excelben\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/ba32d0d071cf1d2ead4c179c9270f29b"},"headline":"Jel\u00f6l\u0151n\u00e9gyzet az Excelben","datePublished":"2026-06-10T22:18:21+00:00","dateModified":"2026-06-10T22:42:33+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/jelolonegyzet-az-excelben\/"},"wordCount":503,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/jelolonegyzet-az-excelben\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/jelolonegyzet-checkbox.png","articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/jelolonegyzet-az-excelben\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/jelolonegyzet-az-excelben\/","url":"https:\/\/sosexcel.com\/exceltippek\/jelolonegyzet-az-excelben\/","name":"Jel\u00f6l\u0151n\u00e9gyzet az Excelben - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/jelolonegyzet-az-excelben\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/jelolonegyzet-az-excelben\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/jelolonegyzet-checkbox.png","datePublished":"2026-06-10T22:18:21+00:00","dateModified":"2026-06-10T22:42:33+00:00","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/jelolonegyzet-az-excelben\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/jelolonegyzet-az-excelben\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/jelolonegyzet-az-excelben\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/jelolonegyzet-checkbox.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2026\/06\/jelolonegyzet-checkbox.png","width":781,"height":240},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/jelolonegyzet-az-excelben\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"Jel\u00f6l\u0151n\u00e9gyzet az 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\/10109","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=10109"}],"version-history":[{"count":3,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/10109\/revisions"}],"predecessor-version":[{"id":10122,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/10109\/revisions\/10122"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=10109"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=10109"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=10109"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}