{"id":610,"date":"2020-02-07T00:05:37","date_gmt":"2020-02-06T22:05:37","guid":{"rendered":"http:\/\/skolarbbos.net\/?p=610"},"modified":"2020-02-10T11:11:47","modified_gmt":"2020-02-10T09:11:47","slug":"celije-i-podrucja","status":"publish","type":"post","link":"https:\/\/skolarbbos.net\/?p=610","title":{"rendered":"\u0106elije i podru\u010dja"},"content":{"rendered":"<p><em>\u0106elija<\/em> (engl.<em> cell)<\/em> osnovni je element radnog lista u koji se upisuju vrednost, tekst ili formula. Identifikuje se preko<em> adrese,<\/em> koja se sastoji od slova kolone i broja reda. Na primer, \u0107elija B2 nalazi se u drugoj koloni i drugom redu.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-612 aligncenter\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/celijeipodrucja91.jpg\" alt=\"celijeipodrucja91\" width=\"173\" height=\"93\" \/><\/p>\n<p>Grupa \u0107elija naziva se<em> podru\u010dje<\/em> ili<em> opseg<\/em> (engl.<em> range).<\/em> Adresa podru\u010dja sastoji se od adrese gornje leve i donje desne \u0107elije koje deli znak dve ta\u010dke. Evo nekoliko primera adresa podru\u010dja:<\/p>\n<p><strong>C24<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Podru\u010dje s jednom \u0107elijom.<\/p>\n<p><strong>A1:B1<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Dve \u0107elije koje zauzimaju jedan red i dve kolone.<\/p>\n<p><strong>A1:A100<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 100 \u0107elija u redu A.<\/p>\n<p><strong>A1:D4<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 16 \u0107elija (\u010detiri reda i \u010detiri kolone).<\/p>\n<p><strong>C1:C1048576<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Cela kolona \u0107elija; to podru\u010dje se mo\u017ee predstaviti i kao C:C.<\/p>\n<p><strong>A6:XFD6<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Ceo red \u0107elija; to podru\u010dje se mo\u017ee predstaviti i kao 6:6.<\/p>\n<p><strong>A1:XFD1048576<\/strong>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Sve \u0107elije na radnom listu.<\/p>\n<p><strong>Biranje podru\u010dja<\/strong><\/p>\n<p>Da biste obavili operaciju u podru\u010dju \u0107elija na radnom listu, najpre morate izabrati to podru\u010dje. Na primer, ako \u017eelite da tekst u \u0107elijama jednog podru\u010dja bude polucrn, izaberite to podru\u010dje i zatim odaberite <strong>Home \u2192 Font \u2192 Bold<\/strong> (ili pritisnite <strong>Ctrl+B<\/strong>).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-613 aligncenter\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/celijeipodrucja92.jpg\" alt=\"celijeipodrucja92\" width=\"217\" height=\"141\" \/><\/p>\n<p>Kada izaberete podru\u010dje, \u0107elije \u0107e biti istaknute svetlosivom bojom. Izuzetak je aktivna \u0107elija koja ne menja boju. Na slici prikazan je primer izabranog podru\u010dja (B4:C11) na radnom listu. Aktivna \u0107elija B5 je izabrana, ali nije i istaknuta.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-614 aligncenter\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/celijeipodrucja93.jpg\" alt=\"celijeipodrucja93\" width=\"411\" height=\"248\" srcset=\"https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/celijeipodrucja93.jpg 411w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/celijeipodrucja93-300x181.jpg 300w\" sizes=\"auto, (max-width: 411px) 100vw, 411px\" \/><\/p>\n<p>Podru\u010dje mo\u017eete izabrati na slede\u0107i na\u010din:<\/p>\n<ol>\n<li>Pritisnite levi taster mi\u0161a i povucite mi\u0161em da biste istakli podru\u010dje. Kada stignete do kraja ekrana, sadr\u017eaj radnih listova \u0107e se pomeriti.<\/li>\n<li>Dr\u017eite pritisnut taster Shift dok pritiskate tastere sa strelicama.<\/li>\n<li>Pritisnite F8 i pomo\u0107u tastera sa strelicama pomerite pokaziva\u010d. Ponovo pritisnite F8 da biste tasterima sa strelicama vratili normalnu funkciju.<\/li>\n<li>U polje za ime upi\u0161ite adresu \u0107elije ili podru\u010dja i pritisnite Enter. Excel \u0107e izabrati \u0107eliju ili podru\u010dje koje ste zadali.<\/li>\n<li>Odaberite <strong>Home \u2192 Editing \u2192 Find &amp; Select \u2192 Go To<\/strong> (ili pritisnite F5), a potom ru\u010dno unesite adresu podru\u010dja u okvir za dijalog Go To. Kada pritisnete OK, Excel \u0107e izabrati \u0107elije u zadatom podru\u010dju.<\/li>\n<\/ol>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-615 aligncenter\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/celijeipodrucja94.jpg\" alt=\"celijeipodrucja94\" width=\"505\" height=\"323\" srcset=\"https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/celijeipodrucja94.jpg 505w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/celijeipodrucja94-300x192.jpg 300w\" sizes=\"auto, (max-width: 505px) 100vw, 505px\" \/><\/p>\n<p>Dok birate podru\u010dje, Excel u polju za ime (koje se nalazi na levoj strani polja za formule) prikazuje broj redova i kolona koji su izabrani. \u010cim izaberete podru\u010dje, polje za ime opet \u0107e pokazivati adresu aktivne \u0107elije.<\/p>\n<p><strong>Biranje celih redova i kolona<\/strong><\/p>\n<p>Ponekad \u0107ete morati da birate cele redove ili kolone. Na primer, ho\u0107ete da primenite isti format broja ili istu opciju poravnanja u celom redu ili koloni. Cele redove ili kolone mo\u017eete da izaberete na sli\u010dan na\u010din kao i podru\u010dja:<\/p>\n<ul>\n<li>Pritisnite zaglavlje reda ili kolone i tako izaberite ceo red ili kolonu.<\/li>\n<li>Nekoliko susednih redova ili kolona izabra\u0107ete ako pritisnete zaglavlje reda, odnosno kolone i povla\u010dite mi\u0161a da biste istakli ostale redove ili kolone.<\/li>\n<li>Da biste izabrali vi\u0161e (nesusednih) redova ili kolona, dr\u017eite taster Ctrl dok mi\u0161em pritiskate zaglavlja odgovaraju\u0107ih redova ili kolona.<\/li>\n<li>Da biste izabrali kolonu, pritisnite <strong>Ctrl+razmaknica<\/strong>. Bi\u0107e istaknuta kolona aktivne \u0107elije (ili kolone izabranih \u0107elija).<\/li>\n<li>Da biste izabrali red, pritisnite <strong>Shift+razmaknica<\/strong>. Bi\u0107e istaknut red aktivne \u0107elije (ili redovi izabranih \u0107elija).<\/li>\n<\/ul>\n<p>Pritisnite taster Ctrl+A da biste izabrali sve \u0107elije radnog lista, \u0161tojejednako izboru svih redova i svih kolona. Mo\u017eete pritisnuti i podru\u010dje u preseku ivica reda i kolone da biste izabrali sve \u0107elije.<\/p>\n<p><strong>Biranje vi\u0161edelnih podru\u010dja<\/strong><\/p>\n<p>Ve\u0107inom su podru\u010dja koja birate jednodelna, jedinstven pravougaonik \u0107elija. Excel omogu\u0107ava rad i s<em> vi\u0161edelnim podru\u010djima<\/em> (engl.<em> noncontiguous ranges<\/em>); ona se sastoje od dva ili vi\u0161e podru\u010dja (ili pojedina\u010dnih \u0107elija) koja nisu jedno pored drugog. Biranje nesusednih podru\u010dja naziva se i<em> diskontinualna selekcija.<\/em> Ako na isti na\u010din \u017eelite da formatirate \u0107elije koje se nalaze na razli\u010ditim delovima radnog lista, jedna od mogu\u0107nosti je i ta da napravite diskontinualnu selekciju. Kada izaberete odgovaraju\u0107e \u0107elije i podru\u010dja, formatiranje koje odaberete bi\u0107e primenjeno na sve njih. Na slici prikazano je jedno vi\u0161edelno podru\u010dje na radnom listu (izabrana su tri podru\u010dja).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-616 aligncenter\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/celijeipodrucja95.jpg\" alt=\"celijeipodrucja95\" width=\"604\" height=\"184\" srcset=\"https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/celijeipodrucja95.jpg 604w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/celijeipodrucja95-300x91.jpg 300w\" sizes=\"auto, (max-width: 604px) 100vw, 604px\" \/><\/p>\n<p>Vi\u0161edelno podru\u010dje mo\u017eete da izaberete na vi\u0161e na\u010dina:<\/p>\n<ul>\n<li>Izaberite prvo podru\u010dje (ili \u0107eliju). Dr\u017eite pritisnut taster Ctrl i povucite mi\u0161em da biste istakli dodatne \u0107elije ili podru\u010dja.<\/li>\n<li>Izaberite podru\u010dje pomo\u0107u tastature, kao \u0161to je ve\u0107 obja\u0161njeno (koriste\u0107i tastere F8 ili Shift). Zatim pritisnite Shift+F8 da biste izabrali jo\u0161 jedno podru\u010dje, a da pri tom ne poni\u0161tite prethodni izbor.<\/li>\n<li>Unesite adresu podru\u010dja (ili \u0107elije) u polje Name i pritisnite Enter. Adrese podru\u010dja razdvojte zarezima.<\/li>\n<li>Odaberite <strong>Home \u2192 Editing \u2192 Find &amp; Select \u2192 Go To<\/strong> (ili pritisnite F5) da biste otvorili okvir za dijalog Go To. Unesite adresu podru\u010dja (ili \u0107elije) u polje Reference, a svaku adresu odvojte zarezom. Pritisnite OK i Excel \u0107e izabrati podru\u010dja.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-617 aligncenter\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/celijeipodrucja96.jpg\" alt=\"celijeipodrucja96\" width=\"288\" height=\"269\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>Kada je Excel u re\u017eimu menjanja grupe, neke komande \u0107e biti ispisane sivom bojom i ne\u0107ete mo\u0107i da ih koristite. U prethodnom primeru ne biste mogli da pretvorite sva podru\u010dja u tabele tako \u0161to biste odabrali <strong>Insert \u2192 Tables \u2192 Table<\/strong>.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-620 aligncenter\" src=\"http:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/celijeipodrucja99.jpg\" alt=\"celijeipodrucja99\" width=\"603\" height=\"183\" srcset=\"https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/celijeipodrucja99.jpg 603w, https:\/\/skolarbbos.net\/wp-content\/uploads\/2015\/12\/celijeipodrucja99-300x91.jpg 300w\" sizes=\"auto, (max-width: 603px) 100vw, 603px\" \/><\/p>\n<p>Biranje podru\u010dja na vi\u0161e radnih listova jednostavan je postupak, a sastoji se od samo dva koraka: izaberite podru\u010dje na jednom listu, a zatim izaberite druge listove na kojima \u0107e se ono prostirati. Da biste izabrali neprekidan skup listova, pritisnite taster Shift i jezi\u010dak poslednjeg radnog lista u grupi. Ukoliko ho\u0107ete da izaberete vi\u0161e nesusednih listova, dr\u017eite pritisnut taster Ctrl dok ih birate. Ako radni listovi u svesci ne treba da izgledaju isto, presko\u010dite listove koje ne\u0107ete formatirati. Kada izaberete listove, na njihovim jezi\u010dcima pojavi\u0107e se crn tekst na beloj pozadini, a Excel \u0107e na naslovnoj traci ispisati [Group].<\/p>\n<p>Ako ho\u0107ete da izaberete sve radne listove u svesci, pritisnite desnim tasterom mi\u0161a bilo koji jezi\u010dak lista i iz priru\u010dnog menija izaberite opciju Select All Sheets.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"\u0106elija (engl. cell) osnovni je element radnog lista u koji se upisuju \n<a class=\"moretag\" href=\"https:\/\/skolarbbos.net\/?p=610\"> <\/a>","protected":false},"author":1,"featured_media":611,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-610","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\/610","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=610"}],"version-history":[{"count":2,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/610\/revisions"}],"predecessor-version":[{"id":1541,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/posts\/610\/revisions\/1541"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=\/wp\/v2\/media\/611"}],"wp:attachment":[{"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/skolarbbos.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}