{"id":596,"date":"2020-02-05T09:37:49","date_gmt":"2020-02-05T07:37:49","guid":{"rendered":"http:\/\/skolarbbos.net\/?p=596"},"modified":"2020-02-10T11:12:31","modified_gmt":"2020-02-10T09:12:31","slug":"rad-s-redovima-i-kolonama","status":"publish","type":"post","link":"https:\/\/skolarbbos.net\/?p=596","title":{"rendered":"Rad s redovima i kolonama"},"content":{"rendered":"<p>Redovi i kolone \u010dine Excelov radni list. Svaki radni list ima ta\u010dno 1.048.576 redova i 16.384 kolone i te vrednosti se ne mogu menjati.<\/p>\n<p>Ako otvorite radnu svesku napravljenu u starijoj verziji Excela, ona \u0107e se otvoriti u \u201ekompatibilnom re\u017eimu\u201c. Te sveske imaju 65.536 redova i 256 kolona. Da biste pove\u0107ali broj redova i kolona, snimite radnu svesku kao datoteku XLSX Excela 2007 i ponovo je otvorite.<\/p>\n<p><strong>Umetanje redova i kolona<\/strong><\/p>\n<p>I pored toga \u0161to je broj redova i kolona nepromenljiv, mo\u017eete ih umetati i brisati ako vam treba prostor za dodatne podatke. Ove operacije ne menjaju broj redova ili kolona, ali se pri umetanju novog reda ostali pomeraju nani\u017ee da bi se za novi red napravilo mesto, a poslednji red se uklanja s liste ako je prazan. Kad ume\u0107ete kolonu, ostale se pomeraju udesno, a poslednja se bri\u0161e &#8211; pod uslovom da je prazna.<\/p>\n<p>Ako poslednji red nije prazan, ne mo\u017eete umetnuti novi. Sli\u010dno tome, ako poslednja kolona sadr\u017ei podatke, Excel ne\u0107e dozvoliti da ubacite novu kolonu. Ako poku\u0161ate da umetenete nov red ili kolonu, prikazuje se okvir za dijalog s upozorenjem. Pritisnite OK, a zatim premestite ili uklonite sadr\u017eaj iz \u0107elija koje nisu prazne da biste mogli da nastavite umetanje novog reda ili kolone.<\/p>\n<p>Da biste umetnuli nov red ili redove, upotrebite slede\u0107e tehnike:<\/p>\n<ul>\n<li>Izaberite jedan ili vi\u0161e redova tako \u0161to \u0107ete pritisnuti njihove brojeve na ivici radnog lista. Pritisnite desni taster mi\u0161a i iz priru\u010dnog menija izaberite Insert.<\/li>\n<li>Pomerite pokaziva\u010d na red koji \u017eelite da umetnete, pa odaberite <strong>Home \u2192 Cells \u2192 Insert \u2192 Insert Sheet Rows<\/strong>. Ako izaberete nekoliko \u0107elija u koloni, Excel ume\u0107e onoliko dodatnih redova koliko ima \u0107elija u selekciji.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-598 aligncenter\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima71.jpg\" alt=\"radsaredovima71\" width=\"171\" height=\"165\" \/><\/p>\n<p>Postupci za umetanje kolona su sli\u010dni, samo \u0107ete birati <strong>Home \u2192 Cells \u2192 Insert \u2192 Insert Sheet Columns<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-599 aligncenter\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima72.jpg\" alt=\"radsaredovima72\" width=\"173\" height=\"163\" \/><\/p>\n<p>Umesto redova i kolona, mo\u017eete da ume\u0107ete i \u0107elije. Izaberite podru\u010dje gde dodajete nove \u0107elije, a zatim odaberite <strong>Home \u2192 Cells \u2192 Insert \u2192 Insert Cells<\/strong> (ili desnim tasterom mi\u0161a pritisnite selekciju i iz priru\u010dnog menija izaberite Insert). Da bi se napravilo mesto za nove \u0107elije, postoje\u0107e moraju da se pomere nadesno ili nadole. Excel tada prikazuje okvir za dijalog Insert (slika) da biste zadali u kom pravcu \u017eelite da pomerite \u0107elije.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-600 aligncenter\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima73.jpg\" alt=\"radsaredovima73\" width=\"178\" height=\"179\" srcset=\"https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima73.jpg 178w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima73-150x150.jpg 150w\" sizes=\"auto, (max-width: 178px) 100vw, 178px\" \/><\/p>\n<p><strong>Brisanje redova i kolona<\/strong><\/p>\n<p>Ponekad \u0107ete \u017eeleti da uklonite redove ili kolone. Recimo, kad radni list sadr\u017ei stare podatke koji vam vi\u0161e ne trebaju.<\/p>\n<p>Da biste obrisali red ili redove, upotrebite jednu od ove dve metode:<\/p>\n<ul>\n<li>Izaberite red ili redove tako \u0161to \u0107ete pritisnuti njihove brojeve na ivici radnog lista, zatim ih pritisnite desnim tasterom mi\u0161a i iz priru\u010dnog menija izaberite <strong>Delete<\/strong>.<\/li>\n<li>Postavite pokaziva\u010d na red koji ho\u0107ete da izbri\u0161ete i odaberite <strong>Home \u2192 Cells \u2192 Delete Sheet Rows<\/strong>. Ako izaberete nekoliko \u0107elija u koloni, Excel bri\u0161e sve izabrane redove.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-601 aligncenter\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima74.jpg\" alt=\"radsaredovima74\" width=\"175\" height=\"166\" \/><\/p>\n<p>Kolone se bri\u0161u na sli\u010dan na\u010din. Ako otkrijete da ste slu\u010dajno obrisali red ili kolonu, odaberite Undo s palete Quick Access (ili pritisnite Ctrl+Z) da biste poni\u0161tili akciju.<\/p>\n<p>&nbsp;<\/p>\n<p><strong>Promena \u0161irine kolona i visine redova<\/strong><\/p>\n<p>\u010cesto \u0107ete \u017eeleti da promenite \u0161irinu kolone ili visinu reda. Na primer, mo\u017eda treba da suzite kolone kako bi na jednu \u0161tampanu stranu stalo vi\u0161e podataka ili da pove\u0107ate visinu reda kako bi zaglavlja tabele bila uo\u010dljivija od podataka u njoj.<\/p>\n<p>Excel pru\u017ea nekoliko mogu\u0107nosti za promenu \u0161irina kolona i visina redova.<\/p>\n<p><strong>Promena \u0161irine kolona<\/strong><\/p>\n<p>\u0160irina kolone se meri brojem znakova<em> fonta fiksne \u0161irine<\/em> (engl.<em> Fixeed pitch font)<\/em> koji staju u \u0107eliju. Svaka kolona je podrazumevano \u0161iroka 8,43 jedinice, \u0161to je jednako \u0161irini 64 piksela.<\/p>\n<p>Ako se u \u0107eliji s numeri\u010dkom vredno\u0161\u0107u pojavi znak taraba (#), to zna\u010di da u kolonu ne staje ceo podatak. Problem re\u0161avate tako \u0161to pro\u0161irite kolonu.<\/p>\n<p>Ukoliko ho\u0107ete da promenite \u0161irinu nekoliko kolona, izaberite ih sve zajedno. Da biste to uradili, pritisnite i povucite ivicu kolone ili dr\u017eite taster <strong>Ctrl<\/strong> dok pojedina\u010dno birate kolone. Ako ho\u0107ete da izaberete sve kolone, pritisnite dugme u preseku zaglavlja redova i kolona (ili pritisnite <strong>Ctrl+A<\/strong>). \u0160irinu kolone mo\u017eete promeniti pomo\u0107u neke od slede\u0107ih tehnika:<\/p>\n<p>Mi\u0161em vucite desnu ivicu kolone dok ne dobijete odgovaraju\u0107u \u0161irinu.<\/p>\n<p>Izaberite <strong>Home \u2192 Cells \u2192 Format \u2192 Width<\/strong> i u okvir za dijalog <strong>Column Width<\/strong> upi\u0161ite \u0161irinu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-604 aligncenter\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima77.jpg\" alt=\"radsaredovima77\" width=\"360\" height=\"445\" srcset=\"https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima77.jpg 360w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima77-243x300.jpg 243w\" sizes=\"auto, (max-width: 360px) 100vw, 360px\" \/><\/p>\n<p>Izaberite <strong>Home \u2192 Cells \u2192 Format \u2192 AutoFit Column<\/strong> Width da biste podesili \u0161irinu kolone tako da u nju staje najdu\u017ei podatak. Umesto da birate celu kolonu, mo\u017eete izabrati i \u0107elije u koloni, a \u0161irina \u0107e se podesiti u skladu s najdu\u017eim podatkom u izabranim \u0107elijama.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-605 aligncenter\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima78.jpg\" alt=\"radsaredovima78\" width=\"178\" height=\"442\" srcset=\"https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima78.jpg 178w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima78-121x300.jpg 121w\" sizes=\"auto, (max-width: 178px) 100vw, 178px\" \/><\/p>\n<p>Dvaput pritisnite desnu ivicu zaglavlja kolone da biste automatski podesili njenu \u0161irinu tako da u nju stane najdu\u017ei podatak.<\/p>\n<p>Ako ho\u0107ete da promenite standardnu \u0161irinu svih kolona, odaberite <strong>Home \u2192 Cells \u2192 Format \u2192 Column \u2192 Default Width<\/strong>. Otvori\u0107ete okvir za dijalog u koji unosite novu standardnu \u0161irinu. Sve kolone koje ranije nisu pode\u0161ene, ima\u0107e novu \u0161irinu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-606 aligncenter\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima79.jpg\" alt=\"radsaredovima79\" width=\"180\" height=\"441\" srcset=\"https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima79.jpg 180w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima79-122x300.jpg 122w\" sizes=\"auto, (max-width: 180px) 100vw, 180px\" \/><\/p>\n<p>Kada sami podesite \u0161irinu kolone, Excel nadalje ne\u0107e automatski pode\u0161avati kolonu tako da odgovara du\u017eim numeri\u010dkim vrednostima.<\/p>\n<p><strong>Promena visine redova<\/strong><\/p>\n<p>Visina reda se meri ta\u010dkama (engl.<em> point, <\/em>standardna jedinica mere u \u0161tamparstvu &#8211; 72 ta\u010dke \u010dine 1 in\u010d). Kada se koristi podrazumevani font, visina iznosi 15 ta\u010daka, odnosno 20 piksela.<\/p>\n<p>Podrazumevana visina reda mo\u017ee biti druga\u010dija, zavisno od fonta definisanog u stilu Normal. Pored toga, Excel automatski pode\u0161ava visinu reda tako da odgovara najvi\u0161em fontu upotrebljenom u tom redu. Shodno tome, ako veli\u010dinu fonta promenite na 20 ta\u010daka, na primer, Excel \u0107e pove\u0107ati visinu reda tako da ceo tekst bude vidljiv.<\/p>\n<p>Visinu reda mo\u017eete da podesite i ru\u010dno, pomo\u0107u slede\u0107ih tehnika; kao kad radite s kolonama, i ovde mo\u017eete izabrati vi\u0161e redova:<\/p>\n<p>Vucite donju ivicu reda mi\u0161em sve dok ne dobijete odgovaraju\u0107u visinu.<\/p>\n<p>Odaberite <strong>Home \u2192 Cells \u2192 Format \u2192 Row Height<\/strong> i unesite visinu (u ta\u010dkama) u okvir za dijalog <strong>Row Height<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-607 aligncenter\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima710.jpg\" alt=\"radsaredovima710\" width=\"360\" height=\"444\" srcset=\"https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima710.jpg 360w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima710-243x300.jpg 243w\" sizes=\"auto, (max-width: 360px) 100vw, 360px\" \/><\/p>\n<p>Dvaput pritisnite donju ivicu reda da bi se visina automatski podesila po najvi\u0161em unetom podatku. Isti efekat posti\u017ee se i kada odaberete <strong>Home \u2192 Cells \u2192 Format \u2192 AutoFit Row Height<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-608 aligncenter\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima711.jpg\" alt=\"radsaredovima711\" width=\"180\" height=\"442\" srcset=\"https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima711.jpg 180w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/radsaredovima711-122x300.jpg 122w\" sizes=\"auto, (max-width: 180px) 100vw, 180px\" \/><\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"Redovi i kolone \u010dine Excelov radni list. Svaki radni list ima ta\u010dno<a class=\"moretag\" href=\"https:\/\/skolarbbos.net\/?p=596\"> &lt;b&gt;[Nastavi sa \u010ditanjem...]&lt;\/b&gt;<\/a>","protected":false},"author":1,"featured_media":597,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-596","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-microsoft-excel"],"_links":{"self":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/596","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=596"}],"version-history":[{"count":1,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/596\/revisions"}],"predecessor-version":[{"id":1265,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/596\/revisions\/1265"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/media\/597"}],"wp:attachment":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=596"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=596"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=596"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}