{"id":24637,"date":"2022-07-13T16:36:08","date_gmt":"2022-07-13T14:36:08","guid":{"rendered":"https:\/\/www.fiatluxefel.info\/?p=24637"},"modified":"2022-07-13T17:27:45","modified_gmt":"2022-07-13T15:27:45","slug":"tipp-ertek-masolasa-excel-allapotsorarol","status":"publish","type":"post","link":"https:\/\/www.fiatluxefel.info\/?p=24637","title":{"rendered":"Tipp: \u00e9rt\u00e9k m\u00e1sol\u00e1sa a V\u00e1g\u00f3lapra az Excel \u00e1llapotsor\u00e1r\u00f3l [#175]"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"24637\" class=\"elementor elementor-24637\" 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 irodai alkalmaz\u00e1sainak <strong>j\u00fanius 29-\u00e9n befutott 2206 Build 15330.20196 sz\u00e1m\u00fa verzi\u00f3j\u00e1val<\/strong> az Excel t\u00e1bl\u00e1zatkezel\u0151 kapott egy nagyon hasznos funkcion\u00e1lis friss\u00edt\u00e9st. Ezzel a fejleszt\u00e9ssel <strong>az \u00e1llapotsoron megjelen\u0151 kiv\u00e1lasztott \u00e9rt\u00e9ket a V\u00e1g\u00f3lapra m\u00e1solhatjuk<\/strong>.Ezt a funkcion\u00e1lis friss\u00edt\u00e9st minden t\u00e1mogatott asztali kiad\u00e1s megkapta, \u00edgy a Microsoft Office 2016\/2019\/2021 \u00e9s a Microsoft 365 is.<\/p><p>L\u00e1ssuk, hogyan haszn\u00e1lhat\u00f3 ez az \u00fajdons\u00e1g!<\/p><p><strong>Az Excel \u00e1llapotsora sz\u00e1mos inform\u00e1ci\u00f3nak ad helyet<\/strong>, ugyanakkor tartalmaz n\u00e9h\u00e1ny kezel\u0151szervet is, mint p\u00e9ld\u00e1ul a n\u00e9zetv\u00e1lt\u00f3 vagy a nagy\u00edt\u00f3 gombokat. Az \u00e1llapotsor elej\u00e9n pedig az alkalmaz\u00e1s \u00fczemm\u00f3dj\u00e1r\u00f3l (<strong>K\u00e9sz<\/strong>, <strong>Be\u00edr\u00e1s<\/strong> \u00e9s <strong>Szerkeszt\u00e9s<\/strong>) vagy egy hosszan tart\u00f3 folyamat halad\u00e1s\u00e1r\u00f3l t\u00e1j\u00e9koz\u00f3dhatunk. Jobbra mellette a munkaf\u00fczet akad\u00e1lymentes \u00e1llapot\u00e1r\u00f3l kapunk inform\u00e1ci\u00f3t. A k\u00e9t ter\u00fclet k\u00f6z\u00f6tt alapesetben h\u00e1rom olyan gyakran haszn\u00e1lt f\u00fcggv\u00e9ny jelen\u00edt meg eredm\u00e9nyt, mint az \u00c1TLAG (<strong>\u00c1tlag<\/strong>), a DARAB (<strong>Cell\u00e1k sz\u00e1ma<\/strong>) vagy a SZUM (<strong>\u00d6sszeg<\/strong>). A <i>Men\u00fc <\/i>billenty\u0171vel <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_1_Menugomb.jpg\">(1. \u00e1bra)<\/a> \u00fajabb h\u00e1rom f\u00fcggv\u00e9ny eredm\u00e9nyeit is megjelen\u00edthetj\u00fck DARAB2 (<strong>Numerikus cell\u00e1k sz\u00e1ma<\/strong>), MIN (<strong>Minimum<\/strong>) \u00e9s MAX (<strong>Maximum<\/strong>).(Ezek az \u00e9rt\u00e9kek csak akkor jelennek meg az \u00e1llapotsoron, vagyis ez a funkci\u00f3 csak akkor m\u0171k\u00f6dik, ha\u00a0 kijel\u00f6lt\u00fcnk egy vagy t\u00f6bb cellatartom\u00e1nyt.)<\/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-4af41e3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4af41e3\" 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-dc111b0\" data-id=\"dc111b0\" 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-27a6c17 elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"27a6c17\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_1_Menugomb.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_1_Menugomb-1024x576.jpg\" class=\"attachment-large size-large wp-image-24640\" alt=\"1. \u00e1bra: A Men\u00fc billenty\u0171vel \u00fajabb h\u00e1rom f\u00fcggv\u00e9ny eredm\u00e9nyeit jelen\u00edthetj\u00fck meg az \u00e1llapotsoron.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_1_Menugomb-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_1_Menugomb-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_1_Menugomb-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_1_Menugomb-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_1_Menugomb-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_1_Menugomb-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_1_Menugomb.jpg 1920w\" 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<figcaption class=\"widget-image-caption wp-caption-text\">1. \u00e1bra: A <i>Men\u00fc <\/i>billenty\u0171vel \u00fajabb h\u00e1rom f\u00fcggv\u00e9ny eredm\u00e9nyeit jelen\u00edthetj\u00fck meg az \u00e1llapotsoron.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-7783d62 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"7783d62\" 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-e492a36\" data-id=\"e492a36\" 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-e190cc8 elementor-widget elementor-widget-text-editor\" data-id=\"e190cc8\" 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>Eddig ezeket az inform\u00e1ci\u00f3kat csup\u00e1n leolvasni tudtuk. Mostant\u00f3l <strong>ezek a feliratok gombokk\u00e9nt m\u0171k\u00f6dnek, vagyis kiv\u00e1laszt\u00e1sukkal az adott \u00e9rt\u00e9ket a V\u00e1g\u00f3lapra m\u00e1solhatjuk<\/strong>. A gombok neve ehhez az \u00faj funkci\u00f3hoz igazodva kieg\u00e9sz\u00fclt a <strong>(m\u00e1sol\u00e1s a v\u00e1g\u00f3lapra)<\/strong> kifejez\u00e9ssel, \u00edgy a k\u00e9perny\u0151olvas\u00f3 szoftverek is t\u00e1j\u00e9koztatni tudnak minket az \u00faj funkci\u00f3r\u00f3l. Ha eg\u00e9rrel dolgozunk, akkor csup\u00e1n r\u00e1 kell kattintanunk kiv\u00e1lasztott gombra az adott \u00e9rt\u00e9k V\u00e1g\u00f3lapra m\u00e1sol\u00e1s\u00e1hoz. Ha billenty\u0171zettel dolgozunk, akkor tegy\u00fck a k\u00f6vetkez\u0151ket:<\/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-4ba8ce7 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"4ba8ce7\" 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-32ddb61\" data-id=\"32ddb61\" 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-f7bb6b2 elementor-widget elementor-widget-text-editor\" data-id=\"f7bb6b2\" 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<ol><li>Az <em>F6<\/em> funkci\u00f3billenty\u0171 \u00fct\u00f6get\u00e9s\u00e9vel l\u00e9pj\u00fcnk az \u00e1llapotsorra &#8211; ha j\u00f3l csin\u00e1ljuk, akkor a f\u00f3kusz az akad\u00e1lymentess\u00e9ggel kapcsolatos vagy az utolj\u00e1ra kezelt gombra ker\u00fcl.<\/li><li>Most m\u00e1r mind a <em>Tab\/Shift+Tab<\/em>, mind a <em>Ny\u00edlbillenty\u0171kkel<\/em> l\u00e9pegethet\u00fcnk az \u00e1llapotsor gombjai k\u00f6z\u00f6tt. L\u00e9pj\u00fcnk a k\u00edv\u00e1nt gombra, vagy el\u0151tte jelen\u00edts\u00fck meg a helyi men\u00fcvel a k\u00edv\u00e1nt \u00e9rt\u00e9ket vagy \u00e9rt\u00e9keket!<\/li><li>A kiv\u00e1lasztott \u00e9rt\u00e9kr\u0151l k\u00e9sz\u00edts\u00fcnk m\u00e1solatot a V\u00e1g\u00f3lapra\u00a0az <em>Enter<\/em> le\u00fct\u00e9s\u00e9vel! (Az \u00faj funkci\u00f3ra n\u00e9h\u00e1ny alkalommal egy felugr\u00f3 ablak h\u00edvja fel a figyelm\u00fcnket <a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_2_Masolas.jpg\">(2. \u00e1bra)<\/a>. A k\u00e9perny\u0151olvas\u00f3 szoftverek bejegyz\u00e9s \u00edr\u00e1sakor akt\u00edv verzi\u00f3i a m\u00e1sol\u00e1s sikeress\u00e9g\u00e9r\u0151l m\u00e9g nem sz\u00e1molnak be.)<\/li><li>A f\u00f3kusz a gombon marad, \u00edgy a munkalapra az <em>Esc<\/em> le\u00fct\u00e9s\u00e9vel l\u00e9phet\u00fcnk vissza \u00e9s illeszthetj\u00fck be a V\u00e1g\u00f3lap tartalm\u00e1t.<\/li><\/ol>\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-717e782 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"717e782\" 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-29c1986\" data-id=\"29c1986\" 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-109039e elementor-widget__width-inherit elementor-invisible elementor-widget elementor-widget-image\" data-id=\"109039e\" 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<figure class=\"wp-caption\">\n\t\t\t\t\t\t\t\t\t\t\t<a href=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_2_Masolas.jpg\" data-elementor-open-lightbox=\"no\">\n\t\t\t\t\t\t\t<img decoding=\"async\" width=\"800\" height=\"450\" src=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_2_Masolas-1024x576.jpg\" class=\"attachment-large size-large wp-image-24641\" alt=\"2. \u00e1bra: A m\u00e1sol\u00e1s t\u00e9ny\u00e9r\u0151l egy darabig \u00fczenetablak \u00e9rtes\u00edt.\" srcset=\"https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_2_Masolas-1024x576.jpg 1024w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_2_Masolas-300x169.jpg 300w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_2_Masolas-768x432.jpg 768w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_2_Masolas-1536x864.jpg 1536w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_2_Masolas-150x84.jpg 150w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_2_Masolas-250x141.jpg 250w, https:\/\/www.fiatluxefel.info\/wp-content\/uploads\/2022\/07\/175_2_Masolas.jpg 1920w\" 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<figcaption class=\"widget-image-caption wp-caption-text\">2. \u00e1bra: A m\u00e1sol\u00e1s t\u00e9ny\u00e9r\u0151l egy darabig \u00fczenetablak \u00e9rtes\u00edt.<\/figcaption>\n\t\t\t\t\t\t\t\t\t\t<\/figure>\n\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-d89ec9a elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"d89ec9a\" 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-cabe5d7\" data-id=\"cabe5d7\" 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-f9fdedd elementor-widget elementor-widget-text-editor\" data-id=\"f9fdedd\" 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<strong>Megjegyz\u00e9sek:<\/strong>\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-0c6e4f3 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"0c6e4f3\" 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-b178996\" data-id=\"b178996\" 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-b6f1ce4 elementor-icon-list--layout-traditional elementor-list-item-link-full_width elementor-widget elementor-widget-icon-list\" data-id=\"b6f1ce4\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"icon-list.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<ul class=\"elementor-icon-list-items\">\n\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\"><\/strong> A Microsoft fejleszt\u00e9sek az Insider Programb\u00f3l l\u00e9p\u00e9sr\u0151l l\u00e9p\u00e9sre, k\u00fcl\u00f6nb\u00f6z\u0151 szempontok szerint (ter\u00fclet, nyelv stb.) elosztva ker\u00fclnek be a szoftverekbe. Az ezt a funkci\u00f3t ismertet\u0151 <a href=\"https:\/\/insider.office.com\/en-us\/blog\/copy-values-quickly-from-the-status-bar-in-excel-for-windows\" target=\"_blank\" rel=\"noopener nofollow\">Office blog cikket<\/a> m\u00e1rcius 9-\u00e9n publik\u00e1lt\u00e1k, ugyanakkor ez a funkci\u00f3 m\u00e1r egy \u00e9ve r\u00e9sze a csomagnak. Ez azt jelenti, hogy lehetnek olyan felhaszn\u00e1l\u00f3k, akik m\u00e1r kor\u00e1bban tal\u00e1lkoztak ezzel az \u00fajdons\u00e1ggal. Hivatalosan azonban ezzel a builddel lett r\u00e9sze az \u00faj funkci\u00f3 az Excel t\u00e1bl\u00e1zatkezel\u0151nek.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t\t\t<li class=\"elementor-icon-list-item\">\n\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-icon\">\n\t\t\t\t\t\t\t<i aria-hidden=\"true\" class=\"fas fa-file-excel\"><\/i>\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-icon-list-text\">Ugyanez a build a megszokott hibajav\u00edt\u00e1sokon t\u00fal <a href=\"https:\/\/docs.microsoft.com\/en-us\/OfficeUpdates\/current-channel#version-2206-june-29:~:text=Find%20your%20data,larger%20cell%20ranges.\" target=\"_blank\" rel=\"noopener nofollow\">jelent\u0151s sebess\u00e9gn\u00f6veked\u00e9st is mag\u00e1val hozott<\/a> az AutoSz\u0171r\u0151 \u00e9s a k\u00e9pletbevitel ter\u00e9n.<\/span>\n\t\t\t\t\t\t\t\t\t<\/li>\n\t\t\t\t\t\t<\/ul>\n\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-de92856 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"de92856\" 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-20b62c7\" data-id=\"20b62c7\" 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-ef9c98e elementor-widget elementor-widget-text-editor\" data-id=\"ef9c98e\" 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><strong>Sok sikert az \u00faj funkci\u00f3hoz!<\/strong><\/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-c6a44f2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"c6a44f2\" 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-d07bb26\" data-id=\"d07bb26\" 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-948ed2f elementor-widget elementor-widget-global elementor-global-15494 elementor-widget-text-editor\" data-id=\"948ed2f\" 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><strong>V\u00c9GE.<\/strong><\/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-fd435b2 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"fd435b2\" 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-d5163a2\" data-id=\"d5163a2\" 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-6cc8838 elementor-widget elementor-widget-shortcode\" data-id=\"6cc8838\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"shortcode.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-shortcode\"><!-- FeedbackWP Plugin --><div        class=\"rmp-widgets-container rmp-wp-plugin rmp-main-container js-rmp-widgets-container js-rmp-widgets-container--24637 \"        data-post-id=\"24637\">        <!-- Rating widget -->    <div class=\"rmp-rating-widget js-rmp-rating-widget\" role=\"group\" aria-labelledby=\"rmp-title-24637\">                    <p class=\"rmp-heading rmp-heading--title\" id=\"rmp-title-24637\">                Mennyire tal\u00e1ltad hasznosnak ezt a cikket?            <\/p>                            <p class=\"rmp-heading rmp-heading--subtitle\">                V\u00e1lassz egy csillagot!            <\/p>                <div class=\"rmp-rating-widget__icons\">            <ul class=\"rmp-rating-widget__icons-list js-rmp-rating-icons-list\" role=\"radiogroup\" aria-label=\"Rating from 1 to 5\">                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"Nem \u00e9rintett meg\"                            data-value=\"1\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"1 out of 5: Nem \u00e9rintett meg\"                            tabindex=\"0\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"N\u00e9h\u00e1ny dolgon felcsillant a szemem\"                            data-value=\"2\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"2 out of 5: N\u00e9h\u00e1ny dolgon felcsillant a szemem\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"\u00c9rdekes volt\"                            data-value=\"3\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"3 out of 5: \u00c9rdekes volt\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"T\u00f6bbnyire csillog\u00f3 szemmel olvastam\"                            data-value=\"4\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"4 out of 5: T\u00f6bbnyire csillog\u00f3 szemmel olvastam\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                                                        <li                            class=\"rmp-rating-widget__icons-list__icon js-rmp-rating-item\"                            data-descriptive-rating=\"Hasznos volt minden szava\"                            data-value=\"5\"                            role=\"radio\"                            aria-checked=\"false\"                            aria-label=\"5 out of 5: Hasznos volt minden szava\"                            tabindex=\"-1\"                    >                        <i class=\"js-rmp-rating-icon rmp-icon rmp-icon--ratings rmp-icon--star \" aria-hidden=\"true\"><\/i>                    <\/li>                            <\/ul>        <\/div>        <p class=\"rmp-rating-widget__hover-text js-rmp-hover-text\" aria-live=\"polite\"><\/p>                <button class=\"rmp-rating-widget__submit-btn rmp-btn js-submit-rating-btn\">            K\u00fcldd el az \u00e9rt\u00e9kel\u00e9st!        <\/button>        <div aria-live=\"polite\" aria-atomic=\"true\">            <p class=\"rmp-rating-widget__results js-rmp-results rmp-rating-widget__results--hidden\">                Szavazatsz\u00e1m: <span class=\"rmp-rating-widget__results__votes js-rmp-vote-count\">0<\/span>, \u00c1tlag: <span class=\"rmp-rating-widget__results__rating js-rmp-avg-rating\">0<\/span>            <\/p>            <p class=\"rmp-rating-widget__not-rated js-rmp-not-rated \">                M\u00e9g nem szavazott senki! Legy\u00e9l az els\u0151, aki \u00e9rt\u00e9keli ezt a bejegyz\u00e9st!            <\/p>            <p class=\"rmp-rating-widget__msg js-rmp-msg\" role=\"status\"><\/p>        <\/div>    <\/div>    <!--Structured data -->                    <!-- Feedback widget -->        <div class=\"rmp-feedback-widget js-rmp-feedback-widget\">  <p class=\"rmp-heading rmp-heading--title\">    Sajn\u00e1lom, hogy ez a cikk nem volt hasznos sz\u00e1modra!  <\/p>  <p class=\"rmp-heading rmp-heading--subtitle\">    Seg\u00edts nekem, hogy jobb legyen ez a cikk!  <\/p>    <div class=\"rmp-feedback-widget__container\">    <p class=\"rmp-feedback-widget__text\">      \u00cdrd le, mit hi\u00e1nyolsz ebb\u0151l a cikkb\u0151l!    <\/p>    <textarea class=\"rmp-feedback-widget__input js-rmp-feedback-input\" rows=\"5\" id=\"feedback-text\"><\/textarea>        <button type=\"button\" class=\"rmp-feedback-widget__btn rmp-btn rmp-btn--large js-rmp-feedback-button\">      Ez a v\u00e9lem\u00e9nyem!    <\/button>    <div class=\"rmp-feedback-widget__loader js-rmp-feedback-loader\">      <div><\/div><div><\/div><div><\/div>    <\/div>    <p class=\"rmp-feedback-widget__msg js-rmp-feedback-msg\"><\/p>  <\/div>  <\/div>        <\/div><\/div>\n\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-1702759 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"1702759\" 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-a65a02b\" data-id=\"a65a02b\" 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-4e8f715 elementor-share-buttons--skin-flat elementor-share-buttons--view-icon-text elementor-share-buttons--shape-square elementor-grid-0 elementor-share-buttons--color-official elementor-widget elementor-widget-global elementor-global-15485 elementor-widget-share-buttons\" data-id=\"4e8f715\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"share-buttons.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<div class=\"elementor-grid\" role=\"list\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_email\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: email\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fas fa-envelope\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tEmail\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_twitter\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: twitter\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-twitter\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tTwitter\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_facebook\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: facebook\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fab fa-facebook\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tFacebook\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t<div class=\"elementor-grid-item\" role=\"listitem\">\n\t\t\t\t\t\t<div class=\"elementor-share-btn elementor-share-btn_print\" role=\"button\" tabindex=\"0\" aria-label=\"Megoszt\u00e1s itt: print\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__icon\">\n\t\t\t\t\t\t\t\t<i class=\"fas fa-print\" aria-hidden=\"true\"><\/i>\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<div class=\"elementor-share-btn__text\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<span class=\"elementor-share-btn__title\">\n\t\t\t\t\t\t\t\t\t\tNyomtat\t\t\t\t\t\t\t\t\t<\/span>\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\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<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>A j\u00fanius v\u00e9gi friss\u00edt\u00e9ssel \u00e9rkezett \u00fajdons\u00e1ggal az Excel \u00e1llapotsor\u00e1n felt\u00fcntetett \u00e9rt\u00e9keket a V\u00e1g\u00f3lapra m\u00e1solhatjuk. L\u00e1ssuk, hogyan! <a class=\"continue-reading-link\" href=\"https:\/\/www.fiatluxefel.info\/?p=24637\">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,66,56,300,67],"tags":[617,58,618,110],"class_list":["post-24637","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tipp","category-microsoft-365","category-microsoft-excel","category-microsoft-office","category-microsoft-office-desktop","tag-allapotsor","tag-excel","tag-masolas","tag-vagolap"],"_links":{"self":[{"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/posts\/24637","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=24637"}],"version-history":[{"count":0,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=\/wp\/v2\/posts\/24637\/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=24637"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=24637"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fiatluxefel.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=24637"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}