{"id":5133,"date":"2017-08-01T08:10:56","date_gmt":"2017-08-01T06:10:56","guid":{"rendered":"http:\/\/sosexcel.com\/exceltippek\/?p=5133"},"modified":"2020-12-18T23:29:17","modified_gmt":"2020-12-18T22:29:17","slug":"tablazat-formazasa","status":"publish","type":"post","link":"https:\/\/sosexcel.com\/exceltippek\/tablazat-formazasa\/","title":{"rendered":"T\u00e1bl\u00e1zat form\u00e1z\u00e1sa"},"content":{"rendered":"<p>A t\u00e1bl\u00e1zat form\u00e1z\u00e1sa egyszer\u0171, de ezt is be kell gyakorolni. Ide tartozik pl.: bet\u0171t\u00edpus, bet\u0171m\u00e9ret, sz\u00ednek, szeg\u00e9lyek, sormagass\u00e1g, oszlopsz\u00e9less\u00e9g, sz\u00e1mok megjelen\u00edt\u00e9se.<\/p>\n<p>Hoztam egy egyszer\u0171 t\u00e1bl\u00e1zatot &#8211; pr\u00f3b\u00e1ld meg a mint\u00e1hoz hasonl\u00f3ra form\u00e1zni a cell\u00e1kat.<\/p>\n\n\n<div class=\"wp-block-image\"><figure class=\"alignright size-large\"><img decoding=\"async\" width=\"102\" height=\"100\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/09\/Excel-2013-logo.png\" alt=\"\" class=\"wp-image-2789\"\/><\/figure><\/div>\n\n\n\n<!--more-->\n\n\n\n<p>A t\u00e1bl\u00e1zatot <a href=\"https:\/\/exceltitok.hu\/wp-content\/uploads\/2020\/12\/form1.xlsx\">innen le tudod t\u00f6lteni<\/a>.<\/p>\n\n\n\n<p>N\u00e9zd meg a megold\u00e1sr\u00f3l sz\u00f3l\u00f3 vide\u00f3t:<\/p>\n\n\n\n<iframe width=\"560\" height=\"315\" src=\"https:\/\/www.youtube.com\/embed\/BXUEZNmBmHY\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe>\n\n\n\n<p>\u00cdme a minta, \u00e9s alatta a nyers adatok. Term\u00e9szetesen a legegyszer\u0171bb megold\u00e1s a <a rel=\"noreferrer noopener\" href=\"https:\/\/sosexcel.com\/exceltippek\/ecset-formazas-ismetles\/\" target=\"_blank\">form\u00e1tumm\u00e1sol\u00f3 ecset haszn\u00e1lata<\/a> lenne &#8211; de most pont <strong>az a c\u00e9l, hogy Te is meg tudd form\u00e1zni az adatokat a terveid, vagy egy (pap\u00edr) minta szerint.<\/strong><\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><img fetchpriority=\"high\" decoding=\"async\" width=\"346\" height=\"254\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/formazas-tablazat-minta.png\" alt=\"T\u00e1bl\u00e1zat form\u00e1z\u00e1sa a minta alapj\u00e1n\" class=\"wp-image-5498\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/formazas-tablazat-minta.png 346w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/formazas-tablazat-minta-300x220.png 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/formazas-tablazat-minta-240x176.png 240w\" sizes=\"(max-width: 346px) 100vw, 346px\" \/><\/figure><\/div>\n\n\n\n<p>Figyelj&nbsp;arra, hogy az adatok 4 oszlopban helyezkednek el, ez\u00e9rt csak ennyit kell kijel\u00f6lni, form\u00e1zni.<\/p>\n\n\n\n<p><strong>Az, hogy a sz\u00f6veg t\u00fall\u00f3g, csak &#8222;\u00e9rz\u00e9ki csal\u00f3d\u00e1s&#8221;.<\/strong> Az oszlop sz\u00e9less\u00e9g\u00e9t\u0151l f\u00fcggetlen\u00fcl b\u00e1rmilyen hossz\u00fa sz\u00f6veget \u00edrhatsz egy cell\u00e1ba.<\/p>\n\n\n\n<p>Ha a k\u00f6vetkez\u0151 cell\u00e1ba nem \u00edrsz semmit, akkor az Excel a be\u00edrt sz\u00f6vegnek ad priorit\u00e1st, \u00e9s teljes hossz\u00e1ban ki\u00edrja. Ez\u00e9rt l\u00e1tod p\u00e9ld\u00e1ul a B14-es cell\u00e1ban olvashat\u00f3an a t\u00e1bl\u00e1zat c\u00edm\u00e9t. (Ha p\u00e9ld\u00e1ul a bet\u0171m\u00e9retet \u00e1t\u00e1ll\u00edtod 12-esre, j\u00f3val tov\u00e1bb fog l\u00f3gni a sz\u00f6veg.)<\/p>\n\n\n\n<p>Ha a k\u00f6vetkez\u0151 cell\u00e1ba is sz\u00f6veg ker\u00fcl, akkor m\u00e1r az \u00f6v\u00e9 az els\u0151bbs\u00e9g a megjelen\u00edt\u00e9sben, \u00e9s az el\u0151z\u0151 sz\u00f6veg csak addig lesz olvashat\u00f3, am\u00edg a cell\u00e1ja tart. Ezt l\u00e1tod p\u00e9ld\u00e1ul a D15 cell\u00e1ban. Term\u00e9szetesen ett\u0151l a sz\u00f6veg megmarad, a szerkeszt\u0151l\u00e9cen tov\u00e1bbra is el tudod olvasni a teljes tartalmat. Ahhoz, hogy ez t\u00e9nylegesen is olvashat\u00f3 legyen, majd extra form\u00e1z\u00e1st fogunk alkalmazni.<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Ha szeretn\u00e9d a teljes feladatsort,<strong> iratkozz fel \na h\u00edrlevelemre,<\/strong> \u00e9s a billenty\u0171kombin\u00e1ci\u00f3k \nlist\u00e1j\u00e1val egy\u00fctt elk\u00fcld\u00f6m:\n<\/pre>\n\n\n\n\n\n\n<h2 class=\"wp-block-heading\">Bet\u0171t\u00edpus, bet\u0171m\u00e9ret, szeg\u00e9ly<\/h2>\n\n\n\n<p>El\u0151sz\u00f6r jel\u00f6ld ki a kit\u00f6lt\u00f6tt cell\u00e1kat (a B14-t\u0151l E24-ig), \u00e9s \u00e1ll\u00edtsd \u00e1t a <strong>bet\u0171t\u00edpus<\/strong>t Tahom\u00e1ra. A kijel\u00f6l\u00e9st megteheted eg\u00e9rrel, \u00e9s a Ctrl A billenty\u0171kkel is.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><img decoding=\"async\" width=\"101\" height=\"21\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/image003-e1494435314910.jpg\" alt=\"Bet\u0171t\u00edpus kiv\u00e1laszt\u00e1sa - T\u00e1bl\u00e1zat form\u00e1z\u00e1sa\" class=\"wp-image-5134\"\/><\/figure><\/div>\n\n\n\n<p>Ezt a Bet\u0171t\u00edpus&nbsp;mez\u0151ben tudod kiv\u00e1lasztani. A hossz\u00fa list\u00e1ban a g\u00f6rg\u0151t is haszn\u00e1lhatod, de egyszer\u0171bb, ha be\u00fct\u00f6d a keresett bet\u0171t\u00edpus nev\u00e9nek els\u0151 karakter\u00e9t.<\/p>\n\n\n\n<p>Az egeret mozgatva a bet\u0171t\u00edpusok felett m\u00e1r l\u00e1thatsz egy el\u0151zetes k\u00e9pet a megjelen\u00edt\u00e9sr\u0151l, ami csak akkor l\u00e9p \u00e9letbe, ha r\u00e1kattintasz. Ez akkor hasznos, amikor bet\u0171t\u00edpust keresel.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/image005-1.gif\"><img loading=\"lazy\" decoding=\"async\" width=\"274\" height=\"159\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/image005-1.gif\" alt=\"T\u00e1bl\u00e1zat kijel\u00f6l\u00e9sekor csak egy cella akt\u00edv\" class=\"wp-image-5135\"\/><\/a><\/figure><\/div>\n\n\n\n<p>Tal\u00e1n felt\u0171nt, hogy ahogy t\u00f6bb cell\u00e1t is kijel\u00f6lt\u00e9l \u2013, hogy a t\u00e1bl\u00e1zat form\u00e1z\u00e1sa egyszerre t\u00f6rt\u00e9njen \u2013, hirtelen \u00e1rnyaltak lettek az els\u0151 kiv\u00e9tel\u00e9vel.<\/p>\n\n\n\n<p>A bal fels\u0151 cella az\u00e9rt feh\u00e9r, mert ez az akt\u00edv cella, ennek a tartalm\u00e1t l\u00e1tod fent a szerkeszt\u0151l\u00e9cen, valamint ennek a form\u00e1z\u00e1s\u00e1t mutatj\u00e1k az ikonok is. (Vagyis a be\u00e1ll\u00edt\u00e1sok erre a cell\u00e1ra igazak, nem a teljes t\u00e1bl\u00e1zatra. Ez\u00e9rt fordulhat el\u0151, hogy b\u00e1r itt a Tahoma van megadva, a t\u00f6bbi cell\u00e1ban m\u00e1s bet\u0171t\u00edpus van.)<\/p>\n\n\n\n<p>K\u00e9s\u0151bb a sz\u00e1mok form\u00e1z\u00e1s\u00e1n\u00e1l lesz m\u00e9g ennek szerepe. (Vagy sorbarendez\u00e9sn\u00e9l, amikor nagyobb adatb\u00e1zisokkal fogsz dolgozni.)<\/p>\n\n\n\n<p>Keretezd a t\u00e1bl\u00e1zatot vastag <strong>s<\/strong><strong>zeg\u00e9lly<\/strong>el. Az ikont a Bet\u0171t\u00edpus panelen tal\u00e1lod a st\u00edlusok \u00e9s a sz\u00ednek k\u00f6z\u00f6tt. (<a href=\"https:\/\/sosexcel.com\/exceltippek\/szines-szegely\/\" target=\"_blank\" rel=\"noreferrer noopener\">A sz\u00ednes szeg\u00e9lyekr\u0151l itt olvashatsz.<\/a>)<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">Tipp: am\u00edg ugyanazzal a ter\u00fclettel dolgozol, addig ne sz\u0171ntesd meg a kijel\u00f6l\u00e9st, hanem \u00e1ll\u00edts be minden param\u00e9tert egy lend\u00fclettel! (pl. bet\u0171t\u00edpus, bet\u0171m\u00e9ret, bet\u0171sz\u00edn.)<\/pre>\n\n\n\n<p>Jel\u00f6ld ki az als\u00f3 sort (B24-E24) \u00e9s keretezd be azt is.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Cell\u00e1k egyes\u00edt\u00e9se<\/h2>\n\n\n\n<p>A szebb elrendez\u00e9s \u00e9rdek\u00e9ben sz\u00fcks\u00e9ged lehet arra, hogy t\u00f6bb k\u00fcl\u00f6n\u00e1ll\u00f3 cella helyett egy nagyobb cell\u00e1t hozz l\u00e9tre.<\/p>\n\n\n\n<p>P\u00e9ld\u00e1ul, ha a t\u00e1bl\u00e1zatban t\u00f6bb cell\u00e1n \u00e1t\u00edvel\u0151 sz\u00f6veget akarsz elhelyezni (c\u00edmnek), akkor ahhoz ehhez \u00f6ssze kell olvasztanod a cell\u00e1kat.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/cellaegyesites.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"131\" height=\"36\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/cellaegyesites.jpg\" alt=\"Cellaegyes\u00edt\u00e9s - T\u00e1bl\u00e1zat form\u00e1z\u00e1sa\" class=\"wp-image-5504\"\/><\/a><\/figure><\/div>\n\n\n\n<p>Ehhez jel\u00f6ld ki az egyes\u00edtend\u0151 cell\u00e1kat (a B14-t\u0151l E14-ig), majd kattints a Form\u00e1z\u00e1s eszk\u00f6zt\u00e1ron a <strong>Ce<\/strong><strong>ll\u00e1k<\/strong> <strong>e<\/strong><strong>gyes\u00edt\u00e9se<\/strong> ikonra, (vagy a jobbklikk Cellaform\u00e1z\u00e1s men\u00fc Igaz\u00edt\u00e1s lapon jel\u00f6ld be a Cell\u00e1k egyes\u00edt\u00e9se n\u00e9gyzetet).<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Sormagass\u00e1g<\/h2>\n\n\n\n<p>Ha szeretn\u00e9d v\u00e1ltoztatni a <strong>s<\/strong><strong>orok<\/strong> <strong>magass\u00e1g\u00e1t<\/strong>, akkor oldalt az eg\u00e9rrel \u00e1llj a sor als\u00f3 elv\u00e1laszt\u00f3 vonal\u00e1hoz \u2013 figyeld az egeret, hogy mikor v\u00e1ltozik v\u00edzszintes vonall\u00e1 \u2013, \u00e9s a bal eg\u00e9rgombot nyomva tartva h\u00fazd a szeg\u00e9lyt addig, am\u00edg a magass\u00e1g a k\u00edv\u00e1nt m\u00e9ret\u0171 nem lesz.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/image009-1.gif\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"85\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/image009-1-300x85.gif\" alt=\"Sormagass\u00e1g be\u00e1ll\u00edt\u00e1sa - T\u00e1bl\u00e1zat form\u00e1z\u00e1sa\" class=\"wp-image-5137\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/image009-1-300x85.gif 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/image009-1-240x68.gif 240w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/figure><\/div>\n\n\n\n<p>V\u00e9gezd el a magas\u00edt\u00e1st a 14-es \u00e9s a 15-\u00f6s sorban is.<\/p>\n\n\n\n<p>Ugyan\u00edgy v\u00e1ltoztathatod az oszlopsz\u00e9less\u00e9get is &#8211; de azt most nem kell!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Fejl\u00e9c form\u00e1z\u00e1sa: sort\u00f6r\u00e9s \u00e9s igaz\u00edt\u00e1s<\/h2>\n\n\n\n<p>A jobb olvashat\u00f3s\u00e1g miatt \u00e9rdemes egym\u00e1s al\u00e1 t\u00f6rdelni a sz\u00f6vegeket a c\u00edmsorokban. Jel\u00f6ld ki a B14-t\u0151l E15 cell\u00e1kat, \u00e9s<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>kattints a Form\u00e1z\u00e1s eszk\u00f6zt\u00e1ron a <strong>Sort\u00f6r\u00e9ssel<\/strong> <strong>t\u00f6bb<\/strong> <strong>s<\/strong><strong>orb<\/strong><strong>a<\/strong> gombra <a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/sortores.jpg\"><\/a>(vagy a Cellaform\u00e1z\u00e1s men\u00fc Igaz\u00edt\u00e1s lapon jel\u00f6ld be a Sort\u00f6r\u00e9ssel t\u00f6bb sorba n\u00e9gyzetet).<\/li><li>A tartalmakat nem csak jobbra \u00e9s balra igaz\u00edthatod, hanem alulra \u00e9s fel\u00fclre is.&nbsp;<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/szoveg-igazitas-cellaban.jpg\" alt=\"Sz\u00f6veg igaz\u00edt\u00e1sa cell\u00e1n bel\u00fcl - T\u00e1bl\u00e1zat form\u00e1z\u00e1sa\" width=\"82\" height=\"81\">A c\u00edmeket <strong>f\u00fcgg\u0151legesen is igaz\u00edtsd k\u00f6z\u00e9pre<\/strong> a megfelel\u0151 ikonnal<br>(vagy a Cellaform\u00e1z\u00e1s men\u00fc Igaz\u00edt\u00e1s lapon a Sz\u00f6veg igaz\u00edt\u00e1sa f\u00fcgg\u0151legesen opci\u00f3val).<\/li><li>Jel\u00f6ld ki a fejl\u00e9cet (B14-es cella), \u00e9s<ul><li>bet\u0171m\u00e9ret\u00e9t \u00e1ll\u00edtsd 12-esre,&nbsp;<\/li><li>haszn\u00e1lj f\u00e9lk\u00f6v\u00e9r kiemel\u00e9st.<\/li><li>Sz\u00ednezd a cell\u00e1t s\u00f6t\u00e9tk\u00e9kre,<\/li><li>a bet\u0171k pedig legyenek feh\u00e9rek.<\/li><\/ul><\/li><li>Alatta a B15-E15 fejl\u00e9cet form\u00e1zd vil\u00e1gosabb k\u00e9k h\u00e1tt\u00e9rel.<\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">Sz\u00e1mok form\u00e1z\u00e1sa<\/h2>\n\n\n\n<p>A cell\u00e1kban l\u00e9v\u0151 sz\u00e1mokat t\u00f6bbf\u00e9le m\u00f3don jelen\u00edtheted meg. Ha egym\u00e1s al\u00e1 igaz\u00edtod a sz\u00e1mokat (tizedesjegyeket), akkor k\u00f6nnyebben \u00e9rtelmezhet\u0151ek lesznek. Ezt a be\u00e1ll\u00edt\u00e1st <strong>s<\/strong><strong>z\u00e1mform\u00e1tum<\/strong>nak h\u00edvj\u00e1k.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/szamformatum.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"140\" height=\"96\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/szamformatum.jpg\" alt=\"Sz\u00e1mform\u00e1tumok - T\u00e1bl\u00e1zat form\u00e1z\u00e1sa\" class=\"wp-image-5505\"\/><\/a><\/figure><\/div>\n\n\n\n<p>Jel\u00f6ld ki az \u00f6sszes sz\u00e1mot (D16-t\u00f3l E24) \u00e9s a 00-s ikonokkal <strong>cs\u00f6kkentsd le a tizedesjegyek sz\u00e1m\u00e1t<\/strong>. Nem baj, ha nem tal\u00e1lod el els\u0151re (\u00e9n is gyakran \u00f6sszekeverem ezt a 2 ikont), korrig\u00e1lj a m\u00e1sik ir\u00e1nyba.<\/p>\n\n\n\n<p>Egy\u00e9bk\u00e9nt az Excel az akt\u00edv (feh\u00e9r) cell\u00e1hoz viszony\u00edt, teh\u00e1t a 17,51-t kell kett\u0151r\u0151l egy tizedesjegyre cs\u00f6kkenteni. Ilyenkor az Excel <strong>a kerek\u00edt\u00e9s szab\u00e1lyainak megfelel\u0151en mutatja az \u00e9rt\u00e9keket.<\/strong><\/p>\n\n\n\n<p>A sz\u00e1m\u00edt\u00e1sokhoz a program tov\u00e1bbra is a val\u00f3s \u00e9rt\u00e9ket haszn\u00e1lja, melyet a szerkeszt\u0151l\u00e9cr\u0151l olvashatsz le. P\u00e9ld\u00e1ul a D4 cell\u00e1ban csak 16 szerepel, a cella m\u00e9gis 16,0-t mutat, a D3-ban viszont&nbsp;17,51 szerepel, amib\u0151l csak 17,5 l\u00e1tszik. Az E4-ben l\u00e9v\u0151 8,37-b\u0151l viszont 8,4 lett.<\/p>\n\n\n\n<p>Vagyis <strong>a tartalom nem v\u00e1ltozik, csak a megjelen\u00e9s.<\/strong><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">T\u00e1bl\u00e1zat m\u00e1sol\u00e1sa<\/h2>\n\n\n\n<p>A cell\u00e1k m\u00e1sol\u00e1s\u00e1hoz jel\u00f6ld ki a t\u00e1bl\u00e1zatot, \u00e9s nyomd meg a&nbsp;<strong>Ctrl C <\/strong>billenty\u0171ket.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/uj-munkalap-beszurasa.jpg\"><img loading=\"lazy\" decoding=\"async\" width=\"131\" height=\"39\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/08\/uj-munkalap-beszurasa.jpg\" alt=\"\u00daj munkalap besz\u00far\u00e1sa\" class=\"wp-image-5507\"\/><\/a><\/figure><\/div>\n\n\n\n<p>Sz\u00farj be egy \u00faj f\u00fclet a t\u00e1bl\u00e1zat&nbsp;v\u00e9g\u00e9re, ehhez haszn\u00e1ld a munkalapok ut\u00e1n tal\u00e1lhat\u00f3 Munkalap besz\u00far\u00e1sa f\u00fclet.<\/p>\n\n\n\n<p>Jel\u00f6ld ki az \u00faj hely els\u0151 cell\u00e1j\u00e1t \u00e9s nyomd meg a <strong>C<\/strong><strong>t<\/strong><strong>rl<\/strong> <strong>V<\/strong> parancsot. Els\u0151 r\u00e1n\u00e9z\u00e9sre nem felt\u00e9tlen\u00fcl ide\u00e1lis a t\u00e1bl\u00e1zat kin\u00e9zete. Mivel cell\u00e1kat m\u00e1solt\u00e1l, ez\u00e9rt a cell\u00e1k jellemz\u0151it illesztheted be az \u00faj helyre (tartalom, form\u00e1z\u00e1s) \u2013 az oszlopokra \u00e9s sorokra jellemz\u0151 be\u00e1ll\u00edt\u00e1sok nem m\u00e1sol\u00f3dnak.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><a href=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/image016.gif\"><img loading=\"lazy\" decoding=\"async\" width=\"300\" height=\"177\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/image016-300x177.gif\" alt=\"\" class=\"wp-image-5140\" srcset=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/image016-300x177.gif 300w, https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/image016-240x142.gif 240w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/figure><\/div>\n\n\n\n<p>Miel\u0151tt b\u00e1rmit tenn\u00e9l, a jobb als\u00f3 sarokban tal\u00e1lhat\u00f3 <strong>Beilleszt\u00e9s<\/strong> <strong>b<\/strong><strong>e<\/strong><strong>\u00e1ll\u00edt\u00e1<\/strong><strong>s<\/strong><strong>ai<\/strong> ikonra kattintva <a href=\"https:\/\/sosexcel.com\/exceltippek\/beillesztesi-lehetosegek\/\" target=\"_blank\" rel=\"noreferrer noopener\">n\u00e9zd v\u00e9gig a lehet\u0151s\u00e9geidet<\/a>.<\/p>\n\n\n\n<p>Itt most v\u00e1laszd az&nbsp;&#8222;Oszlopsz\u00e9less\u00e9g a forr\u00e1sb\u00f3l&#8221; lehet\u0151s\u00e9get, \u00edgy az oszlopok ugyanolyan sz\u00e9lesek lesznek, mint az eredeti t\u00e1bl\u00e1zatban. Praktikus, ha nem akarod egyes\u00e9vel \u00e1ll\u00edtgatni a sz\u00e9less\u00e9geket.<\/p>\n\n\n\n<p><strong>Cell\u00e1k helyett sorokat is m\u00e1solsz, \u00edgy a sormagass\u00e1g is \u00e1tker\u00fcl az \u00faj helyre beilleszt\u00e9skor.<\/strong> Ebben az esetben is d\u00f6nthetsz a beilleszt\u00e9s m\u00f3dj\u00e1r\u00f3l, mindenk\u00e9ppen n\u00e9zd v\u00e9gig a lehet\u0151s\u00e9geket.<\/p>\n\n\n\n<p>Beilleszt\u00e9sn\u00e9l el\u00e9g egy (az A oszlopban l\u00e9v\u0151) cell\u00e1t megadni.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"alignleft\"><img loading=\"lazy\" decoding=\"async\" width=\"237\" height=\"225\" src=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2017\/05\/image018.gif\" alt=\"Excel munkalap m\u00e1sol\u00e1sa\" class=\"wp-image-5141\"\/><\/figure><\/div>\n\n\n\n<p>Ak\u00e1r <strong>az eg\u00e9sz munkalapot lem\u00e1solhatod<\/strong>, \u00edgy biztosan olyan lesz a t\u00e1bl\u00e1zat, mint az eredeti f\u00fcl\u00f6n.<\/p>\n\n\n\n<p>Kattints a munkalap nev\u00e9re jobbklikkel, \u00e9s v\u00e1laszd az <strong>\u00c1thelyez\u00e9s vagy m\u00e1sol\u00e1s parancsot<\/strong>. A felugr\u00f3 ablakon mindenk\u00e9ppen pip\u00e1ld be a Legyen m\u00e1solat mez\u0151t.<\/p>\n\n\n\n<p>Majd az \u00faj lapot nevezd \u00e1t a jobbklikk&nbsp;\u00c1tnevez\u00e9s paranccsal (vagy a r\u00e9gi n\u00e9vre duplakattal) Pr\u00f3ba-ra.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Besz\u00far\u00e1s \u00e9s t\u00f6rl\u00e9s<\/h2>\n\n\n\n<p>Sz\u00farj&nbsp;be&nbsp;5&nbsp;sort&nbsp;a&nbsp;Pfizer&nbsp;ut\u00e1n!&nbsp;<\/p>\n\n\n\n<p>Mindig azt a sort jel\u00f6ld ki, <a href=\"https:\/\/sosexcel.com\/exceltippek\/oszlop-beszuras\/\" target=\"_blank\" rel=\"noreferrer noopener\">amelyik el\u00e9 be akarsz sz\u00farni<\/a>, majd lefel\u00e9 annyit, ah\u00e1ny \u00faj sort szeretn\u00e9l. Vagyis nem kell egyes\u00e9vel besz\u00farni a sorokat, lehet egyszerre is.<\/p>\n\n\n\n<p>Teh\u00e1t a 23-27 sorokat kell kijel\u00f6ln\u00f6d, majd jobbklikk Besz\u00far\u00e1s, vagy ha billenty\u0171ket haszn\u00e1ln\u00e1l, akkor <strong>Ctrl +<\/strong> (pluszjel a numerikus billenty\u0171zetr\u0151l)<\/p>\n\n\n\n<p>T\u00f6r\u00f6ld&nbsp;ki&nbsp;a&nbsp;fenti&nbsp;t\u00e1bl\u00e1zatot!<\/p>\n\n\n\n<p>Cell\u00e1kat \u00e9s sorokat is kijel\u00f6lhetsz a t\u00f6rl\u00e9shez. Ha teheted, ink\u00e1bb a sort (vagy oszlopot) jel\u00f6ld ki, \u00edgy egy\u00e9rtelm\u0171bb leszel az Excel sz\u00e1m\u00e1ra, \u00e9s az oldalt sem fogod \u00f6sszekavarni.<\/p>\n\n\n\n<p>Jel\u00f6ld ki az 1-12 sorokat, majd v\u00e1laszd a jobbklikk T\u00f6rl\u00e9s parancsot. (Billenty\u0171vel <strong>Ctrl &#8211;<\/strong>) Ahogy elt\u0171nnek a kijel\u00f6lt sorok, a lenti sorok felcs\u00fasznak a hely\u00e9re.<\/p>\n\n\n\n<p>A Delete gomb csak a tartalmat t\u00f6rli, de a cell\u00e1k \u00e9s a form\u00e1z\u00e1sok megmaradnak.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Gratul\u00e1lok, k\u00e9sz a t\u00e1bl\u00e1zat form\u00e1z\u00e1sa<\/h2>\n\n\n\n<p>Elsaj\u00e1t\u00edtottad az alapokat! Gyakorolj sokat, oldd meg a f\u00e1jlban tal\u00e1lhat\u00f3 t\u00f6bbi p\u00e9ld\u00e1t is!<\/p>\n\n\n\n<p>Ha pedig szeretn\u00e9l tov\u00e1bb haladni az Excellel, <strong>\u00e9s szem\u00e9lyre szabott tippeket kapni,<\/strong> akkor gyere el (vagy k\u00fcldd el a munkat\u00e1rsaidat) egy <a href=\"http:\/\/exceltitok.hu\/arak\" target=\"_blank\" rel=\"noreferrer noopener\">egy\u00e9ni Excel tanfolyam<\/a>ra!<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">M\u00e9g t\u00f6bb gyakorl\u00e1s<\/h2>\n\n\n\n<p><a href=\"https:\/\/sosexcel.com\/exceltippek\/ingyenes-excel-tippek-formazashoz\/\">https:\/\/sosexcel.com\/exceltippek\/ingyenes-excel-tippek-formazashoz\/<\/a><\/p>\n\n\n\n<p><a href=\"http:\/\/exceltitok.hu\/excel-feladatok-es-megoldasok\/\">http:\/\/exceltitok.hu\/excel-feladatok-es-megoldasok\/<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>A t\u00e1bl\u00e1zat form\u00e1z\u00e1sa egyszer\u0171, de ezt is be kell gyakorolni. Ide tartozik pl.: bet\u0171t\u00edpus, bet\u0171m\u00e9ret, sz\u00ednek, szeg\u00e9lyek, sormagass\u00e1g, oszlopsz\u00e9less\u00e9g, sz\u00e1mok megjelen\u00edt\u00e9se. Hoztam egy egyszer\u0171 t\u00e1bl\u00e1zatot &#8211; pr\u00f3b\u00e1ld meg a mint\u00e1hoz hasonl\u00f3ra form\u00e1zni a cell\u00e1kat.<\/p>\n","protected":false},"author":3,"featured_media":2921,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[1],"tags":[9,19,78],"class_list":["post-5133","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-tippek-gyakori-kerdesek","tag-formatum","tag-formazas","tag-gyakorlo-feladat"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>T\u00e1bl\u00e1zat form\u00e1z\u00e1sa - Azonnal haszn\u00e1lhat\u00f3 Excel tippek<\/title>\n<meta name=\"description\" content=\"A t\u00e1bl\u00e1zat form\u00e1z\u00e1sa egyszer\u0171, de be kell gyakorolni. Ide tartozik pl.: bet\u0171t\u00edpus, bet\u0171m\u00e9ret, sz\u00ednek, szeg\u00e9lyek, sormagass\u00e1g, oszlopsz\u00e9less\u00e9g, sz\u00e1mform\u00e1tum.\" \/>\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\/tablazat-formazasa\/\" \/>\n<meta property=\"og:locale\" content=\"hu_HU\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T\u00e1bl\u00e1zat form\u00e1z\u00e1sa - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"og:description\" content=\"A t\u00e1bl\u00e1zat form\u00e1z\u00e1sa egyszer\u0171, de be kell gyakorolni. Ide tartozik pl.: bet\u0171t\u00edpus, bet\u0171m\u00e9ret, sz\u00ednek, szeg\u00e9lyek, sormagass\u00e1g, oszlopsz\u00e9less\u00e9g, sz\u00e1mform\u00e1tum.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/sosexcel.com\/exceltippek\/tablazat-formazasa\/\" \/>\n<meta property=\"og:site_name\" content=\"Azonnal haszn\u00e1lhat\u00f3 Excel tippek\" \/>\n<meta property=\"article:published_time\" content=\"2017-08-01T06:10:56+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-12-18T22:29:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/10\/ecsetek.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"301\" \/>\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=\"9 perc\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazat-formazasa\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazat-formazasa\\\/\"},\"author\":{\"name\":\"Bernadett\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#\\\/schema\\\/person\\\/d0cd6959dcc11f6ed25f7d4e5681a846\"},\"headline\":\"T\u00e1bl\u00e1zat form\u00e1z\u00e1sa\",\"datePublished\":\"2017-08-01T06:10:56+00:00\",\"dateModified\":\"2020-12-18T22:29:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazat-formazasa\\\/\"},\"wordCount\":1851,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazat-formazasa\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2015\\\/10\\\/ecsetek.png\",\"keywords\":[\"form\u00e1tum\",\"form\u00e1z\u00e1s\",\"gyakorl\u00f3 feladat\"],\"articleSection\":[\"Excel tippek, gyakori k\u00e9rd\u00e9sek\"],\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazat-formazasa\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazat-formazasa\\\/\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazat-formazasa\\\/\",\"name\":\"T\u00e1bl\u00e1zat form\u00e1z\u00e1sa - Azonnal haszn\u00e1lhat\u00f3 Excel tippek\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazat-formazasa\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazat-formazasa\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2015\\\/10\\\/ecsetek.png\",\"datePublished\":\"2017-08-01T06:10:56+00:00\",\"dateModified\":\"2020-12-18T22:29:17+00:00\",\"description\":\"A t\u00e1bl\u00e1zat form\u00e1z\u00e1sa egyszer\u0171, de be kell gyakorolni. Ide tartozik pl.: bet\u0171t\u00edpus, bet\u0171m\u00e9ret, sz\u00ednek, szeg\u00e9lyek, sormagass\u00e1g, oszlopsz\u00e9less\u00e9g, sz\u00e1mform\u00e1tum.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazat-formazasa\\\/#breadcrumb\"},\"inLanguage\":\"hu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazat-formazasa\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazat-formazasa\\\/#primaryimage\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2015\\\/10\\\/ecsetek.png\",\"contentUrl\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/wp-content\\\/uploads\\\/2015\\\/10\\\/ecsetek.png\",\"width\":1024,\"height\":301},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/tablazat-formazasa\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"T\u00e1bl\u00e1zat form\u00e1z\u00e1sa\"}]},{\"@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\\\/d0cd6959dcc11f6ed25f7d4e5681a846\",\"name\":\"Bernadett\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"hu\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/33077ee5ef07e5534d55447c6c9053579eed4ee4578f92057b006f6955da6bd0?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/33077ee5ef07e5534d55447c6c9053579eed4ee4578f92057b006f6955da6bd0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/33077ee5ef07e5534d55447c6c9053579eed4ee4578f92057b006f6955da6bd0?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.\",\"url\":\"https:\\\/\\\/sosexcel.com\\\/exceltippek\\\/author\\\/bernadett\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"T\u00e1bl\u00e1zat form\u00e1z\u00e1sa - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","description":"A t\u00e1bl\u00e1zat form\u00e1z\u00e1sa egyszer\u0171, de be kell gyakorolni. Ide tartozik pl.: bet\u0171t\u00edpus, bet\u0171m\u00e9ret, sz\u00ednek, szeg\u00e9lyek, sormagass\u00e1g, oszlopsz\u00e9less\u00e9g, sz\u00e1mform\u00e1tum.","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\/tablazat-formazasa\/","og_locale":"hu_HU","og_type":"article","og_title":"T\u00e1bl\u00e1zat form\u00e1z\u00e1sa - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","og_description":"A t\u00e1bl\u00e1zat form\u00e1z\u00e1sa egyszer\u0171, de be kell gyakorolni. Ide tartozik pl.: bet\u0171t\u00edpus, bet\u0171m\u00e9ret, sz\u00ednek, szeg\u00e9lyek, sormagass\u00e1g, oszlopsz\u00e9less\u00e9g, sz\u00e1mform\u00e1tum.","og_url":"https:\/\/sosexcel.com\/exceltippek\/tablazat-formazasa\/","og_site_name":"Azonnal haszn\u00e1lhat\u00f3 Excel tippek","article_published_time":"2017-08-01T06:10:56+00:00","article_modified_time":"2020-12-18T22:29:17+00:00","og_image":[{"width":1024,"height":301,"url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/10\/ecsetek.png","type":"image\/png"}],"author":"Bernadett","twitter_misc":{"Szerz\u0151:":"Bernadett","Becs\u00fclt olvas\u00e1si id\u0151":"9 perc"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/sosexcel.com\/exceltippek\/tablazat-formazasa\/#article","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/tablazat-formazasa\/"},"author":{"name":"Bernadett","@id":"https:\/\/sosexcel.com\/exceltippek\/#\/schema\/person\/d0cd6959dcc11f6ed25f7d4e5681a846"},"headline":"T\u00e1bl\u00e1zat form\u00e1z\u00e1sa","datePublished":"2017-08-01T06:10:56+00:00","dateModified":"2020-12-18T22:29:17+00:00","mainEntityOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/tablazat-formazasa\/"},"wordCount":1851,"commentCount":0,"publisher":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#organization"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/tablazat-formazasa\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/10\/ecsetek.png","keywords":["form\u00e1tum","form\u00e1z\u00e1s","gyakorl\u00f3 feladat"],"articleSection":["Excel tippek, gyakori k\u00e9rd\u00e9sek"],"inLanguage":"hu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/sosexcel.com\/exceltippek\/tablazat-formazasa\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/sosexcel.com\/exceltippek\/tablazat-formazasa\/","url":"https:\/\/sosexcel.com\/exceltippek\/tablazat-formazasa\/","name":"T\u00e1bl\u00e1zat form\u00e1z\u00e1sa - Azonnal haszn\u00e1lhat\u00f3 Excel tippek","isPartOf":{"@id":"https:\/\/sosexcel.com\/exceltippek\/#website"},"primaryImageOfPage":{"@id":"https:\/\/sosexcel.com\/exceltippek\/tablazat-formazasa\/#primaryimage"},"image":{"@id":"https:\/\/sosexcel.com\/exceltippek\/tablazat-formazasa\/#primaryimage"},"thumbnailUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/10\/ecsetek.png","datePublished":"2017-08-01T06:10:56+00:00","dateModified":"2020-12-18T22:29:17+00:00","description":"A t\u00e1bl\u00e1zat form\u00e1z\u00e1sa egyszer\u0171, de be kell gyakorolni. Ide tartozik pl.: bet\u0171t\u00edpus, bet\u0171m\u00e9ret, sz\u00ednek, szeg\u00e9lyek, sormagass\u00e1g, oszlopsz\u00e9less\u00e9g, sz\u00e1mform\u00e1tum.","breadcrumb":{"@id":"https:\/\/sosexcel.com\/exceltippek\/tablazat-formazasa\/#breadcrumb"},"inLanguage":"hu","potentialAction":[{"@type":"ReadAction","target":["https:\/\/sosexcel.com\/exceltippek\/tablazat-formazasa\/"]}]},{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/sosexcel.com\/exceltippek\/tablazat-formazasa\/#primaryimage","url":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/10\/ecsetek.png","contentUrl":"https:\/\/sosexcel.com\/exceltippek\/wp-content\/uploads\/2015\/10\/ecsetek.png","width":1024,"height":301},{"@type":"BreadcrumbList","@id":"https:\/\/sosexcel.com\/exceltippek\/tablazat-formazasa\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/sosexcel.com\/exceltippek\/"},{"@type":"ListItem","position":2,"name":"T\u00e1bl\u00e1zat form\u00e1z\u00e1sa"}]},{"@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\/d0cd6959dcc11f6ed25f7d4e5681a846","name":"Bernadett","image":{"@type":"ImageObject","inLanguage":"hu","@id":"https:\/\/secure.gravatar.com\/avatar\/33077ee5ef07e5534d55447c6c9053579eed4ee4578f92057b006f6955da6bd0?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/33077ee5ef07e5534d55447c6c9053579eed4ee4578f92057b006f6955da6bd0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/33077ee5ef07e5534d55447c6c9053579eed4ee4578f92057b006f6955da6bd0?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.","url":"https:\/\/sosexcel.com\/exceltippek\/author\/bernadett\/"}]}},"_links":{"self":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/5133","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\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/comments?post=5133"}],"version-history":[{"count":23,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/5133\/revisions"}],"predecessor-version":[{"id":9012,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/posts\/5133\/revisions\/9012"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media\/2921"}],"wp:attachment":[{"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/media?parent=5133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/categories?post=5133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sosexcel.com\/exceltippek\/wp-json\/wp\/v2\/tags?post=5133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}