{"id":10303,"date":"2021-01-07T19:29:53","date_gmt":"2021-01-07T18:29:53","guid":{"rendered":"https:\/\/www.fiatluxefel.info\/?p=10303"},"modified":"2021-05-24T08:34:52","modified_gmt":"2021-05-24T06:34:52","slug":"tipp-a-cellaegyesites-modjai-excelben-79","status":"publish","type":"post","link":"https:\/\/www.fiatluxefel.info\/?p=10303","title":{"rendered":"Tipp: a cellaegyes\u00edt\u00e9s m\u00f3djai Excelben [#79]"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"10303\" class=\"elementor elementor-10303\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-5ba739c elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"5ba739c\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-fc26ea9\" data-id=\"fc26ea9\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-fad5450 elementor-invisible elementor-widget elementor-widget-image\" data-id=\"fad5450\" data-element_type=\"widget\" data-e-type=\"widget\" data-settings=\"{&quot;_animation&quot;:&quot;fadeInRight&quot;}\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/10\/BejegyzesFaceTwitter_Tippekestrukkok_1.png\" data-elementor-open-lightbox=\"yes\" data-elementor-lightbox-title=\"Bejegyz\u00e9s, Facebook, Twitter: Tippek \u00e9s tr\u00fckk\u00f6k, #1\" data-elementor-lightbox-description=\"Bejegyz\u00e9s, Facebook, Twitter: Tippek \u00e9s tr\u00fckk\u00f6k, #1\" data-e-action-hash=\"#elementor-action%3Aaction%3Dlightbox%26settings%3DeyJpZCI6NzQwNiwidXJsIjoiaHR0cHM6XC9cL3d3dy5maWF0bHV4ZWZlbC5pbmZvXC93cC1jb250ZW50XC91cGxvYWRzXC8yMDIwXC8xMFwvQmVqZWd5emVzRmFjZVR3aXR0ZXJfVGlwcGVrZXN0cnVra29rXzEucG5nIn0%3D\">\n\t\t\t\t\t\t\t<img fetchpriority=\"high\" decoding=\"async\" width=\"800\" height=\"419\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/10\/BejegyzesFaceTwitter_Tippekestrukkok_1-1024x536.png\" class=\"elementor-animation-buzz-out attachment-large size-large wp-image-7406\" alt=\"Bejegyz\u00e9s, Facebook, Twitter: Tippek \u00e9s tr\u00fckk\u00f6k, #1\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/10\/BejegyzesFaceTwitter_Tippekestrukkok_1-1024x536.png 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/10\/BejegyzesFaceTwitter_Tippekestrukkok_1-300x157.png 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/10\/BejegyzesFaceTwitter_Tippekestrukkok_1-768x402.png 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/10\/BejegyzesFaceTwitter_Tippekestrukkok_1-150x78.png 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/10\/BejegyzesFaceTwitter_Tippekestrukkok_1-250x131.png 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2020\/10\/BejegyzesFaceTwitter_Tippekestrukkok_1.png 1210w\" sizes=\"(max-width: 800px) 100vw, 800px\" \/>\t\t\t\t\t\t\t\t<\/a>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-996fa80 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"996fa80\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-643eda1\" data-id=\"643eda1\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-c52d482 elementor-widget elementor-widget-text-editor\" data-id=\"c52d482\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t<p>A Microsoft Excel vizsg\u00e1k \u00e1lland\u00f3 szerepl\u0151je a cellaegyes\u00edt\u00e9s, amikor kijel\u00f6lt cell\u00e1kat kell \u00f6sszevonni egy cell\u00e1v\u00e1. Tipikus feladat a t\u00e1bl\u00e1zat c\u00edm\u00e9nek elhelyez\u00e9se a t\u00e1bl\u00e1zat f\u00f6l\u00e9, a t\u00e1bl\u00e1zat feletti cell\u00e1k \u00f6sszevon\u00e1s\u00e1val, illetve a c\u00edmsz\u00f6veg k\u00f6z\u00e9pre z\u00e1r\u00e1s\u00e1val. A c\u00edm bal sz\u00e9ls\u0151 cell\u00e1ba g\u00e9pel\u00e9se, majd a cell\u00e1k kijel\u00f6l\u00e9s\u00e9t k\u00f6vet\u0151en a <strong>Cellaegyes\u00edt\u00e9s<\/strong> parancs haszn\u00e1lata ma m\u00e1r a digit\u00e1lis kult\u00fara r\u00e9sze.<\/p><p>Igen \u00e1m, de keveseknek t\u0171nik fel, \u00edgy a feladatokban sem jelenik meg, hogy az Excel men\u00fcszalaggal ell\u00e1tott 2007-es kiad\u00e1sa \u00f3ta a megszokottal egy\u00fctt h\u00e1romf\u00e9le megold\u00e1ssal is egyes\u00edthetj\u00fck a kijel\u00f6lt cell\u00e1kat. Ezekkel fogunk megismerkedni a hajt\u00e1s ut\u00e1n&#8230;<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-640fb5e elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"640fb5e\" data-element_type=\"section\" data-e-type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-2f19dba\" data-id=\"2f19dba\" data-element_type=\"column\" data-e-type=\"column\">\n\t\t\t<div class=\"elementor-widget-wrap elementor-element-populated\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-51b2d30 elementor-widget elementor-widget-read-more\" data-id=\"51b2d30\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"read-more.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<\/div><\/div><\/div><\/div><\/div><\/section><\/div> <a href=\"https:\/\/www.fiatluxefel.info\/?p=10303#more-10303\" class=\"continue-reading-link elementor-continue-reading-link\">Tov\u00e1bb olvasom... <span class=\"meta-nav\">&rarr; <\/span><\/a>","protected":false},"excerpt":{"rendered":"<p>Szokt\u00e1l Excelben t\u00f6bb cell\u00e1t egybeolvasztani, vagyis egyes\u00edteni? Tudod, hogy van m\u00e9g k\u00e9t m\u00e1sik m\u00f3dja is a cellaegyes\u00edt\u00e9snek? Ha nem, akkor olvasd el ezt a bejegyz\u00e9st! <a class=\"continue-reading-link\" href=\"https:\/\/www.fiatluxefel.info\/?p=10303\">Tov\u00e1bb olvasom&#8230; <span class=\"meta-nav\">&rarr; <\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":7406,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[55,56],"tags":[367,376,379,378,366,57],"class_list":["post-10303","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tipp","category-microsoft-excel","tag-cellaegyesites","tag-cellak-egyesitese","tag-cellak-szetvalasztasa","tag-egyesites-vizszintesen","tag-microsoft-excel","tag-tipp"],"_links":{"self":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/posts\/10303","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10303"}],"version-history":[{"count":0,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/posts\/10303\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/media\/7406"}],"wp:attachment":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}