{"id":12220,"date":"2024-04-23T14:07:10","date_gmt":"2024-04-23T14:07:10","guid":{"rendered":"https:\/\/tech-lib.eu\/tech\/?p=12220"},"modified":"2024-04-23T14:07:10","modified_gmt":"2024-04-23T14:07:10","slug":"cislovani-radku-v-ms-excel-komplexni-pruvodce","status":"publish","type":"post","link":"https:\/\/tech-lib.eu\/tech\/cislovani-radku-v-ms-excel-komplexni-pruvodce\/","title":{"rendered":"\u010c\u00edslov\u00e1n\u00ed \u0159\u00e1dk\u016f v MS Excel. Komplexn\u00ed pr\u016fvodce"},"content":{"rendered":"
\n
Jak vlo\u017eit \u010d\u00edsla \u0159\u00e1dk\u016f?<\/div>\n
Na kart\u011b rozlo\u017een\u00ed str\u00e1nky klikn\u011bte ve skupin\u011b Vzhled str\u00e1nky na polo\u017eku \u010d\u00edsla \u0159\u00e1dk\u016f. Klikn\u011bte na mo\u017enosti \u010d\u00edslov\u00e1n\u00ed \u0159\u00e1dk\u016fa potom na kartu rozlo\u017een\u00ed . V seznamu pou\u017e\u00edt na klikn\u011bte na polo\u017eku vybran\u00e9 odd\u00edly. Klikn\u011bte na tla\u010d\u00edtko \u010c\u00edsla \u0159\u00e1dk\u016f.<\/div>\n
\n\t\t\t\t\t Dal\u0161\u00ed informace najdete na<\/span> support.microsoft.com<\/a>\n\t\t\t\t<\/div>\n<\/p><\/div>\n
\n
<\/div>\n

MS Excel je robustn\u00ed tabulkov\u00fd procesor, kter\u00fd se \u010dasto pou\u017e\u00edv\u00e1 pro organizaci a anal\u00fdzu dat. Znalost zp\u016fsobu \u010d\u00edslov\u00e1n\u00ed \u0159\u00e1dk\u016f je jedn\u00edm ze z\u00e1klad\u016f pou\u017e\u00edv\u00e1n\u00ed aplikace Excel. V tomto p\u0159\u00edsp\u011bvku se budeme zab\u00fdvat vzorcem R1C1 v aplikaci Excel a tak\u00e9 specifiky \u010d\u00edslov\u00e1n\u00ed \u0159\u00e1dk\u016f v aplikaci Excel, v\u00fdpo\u010dtem pou\u017e\u00edvan\u00fdm k ur\u010den\u00ed \u010d\u00edsel \u0159\u00e1dk\u016f a zp\u016fsobem automatick\u00e9ho \u010d\u00edslov\u00e1n\u00ed \u0159\u00e1dk\u016f. Projdeme si tak\u00e9 logiku aplikace Excel pro \u010d\u00edslov\u00e1n\u00ed sloupc\u016f i \u0159\u00e1dk\u016f. Jak se ur\u010duje po\u010det \u0159\u00e1dk\u016f? <\/p>\n

<\/div>\n

Excel p\u0159i\u0159azuje \u010d\u00edsla \u0159\u00e1dk\u016fm pomoc\u00ed \u010d\u00edseln\u00e9ho syst\u00e9mu. Prvn\u00edmu \u0159\u00e1dku je p\u0159i\u0159azeno \u010d\u00edslo 1 a po\u010d\u00edt\u00e1n\u00ed prob\u00edh\u00e1 od lev\u00e9ho horn\u00edho rohu listu. Ka\u017ed\u00e9mu dal\u0161\u00edmu \u0159\u00e1dku je p\u0159i\u0159azeno \u010d\u00edslo o 1 v\u011bt\u0161\u00ed, ne\u017e je \u010d\u00edslo p\u0159edchoz\u00edho \u0159\u00e1dku. Nap\u0159\u00edklad druh\u00fd \u0159\u00e1dek m\u00e1 \u010d\u00edslo 2, t\u0159et\u00ed \u0159\u00e1dek m\u00e1 \u010d\u00edslo 3 atd. D\u00edky postupn\u00e9mu \u010d\u00edslov\u00e1n\u00ed mohou u\u017eivatel\u00e9 rychle identifikovat konkr\u00e9tn\u00ed \u0159\u00e1dky uvnit\u0159 tabulky a odkazovat na n\u011b. <\/p>\n

Jak mohu nechat aplikaci Excel automaticky \u010d\u00edslovat \u0159\u00e1dky? <\/div>\n

U\u017eivatel\u00e9 mohou v aplikaci Excel snadno \u010d\u00edslovat \u0159\u00e1dky d\u00edky praktick\u00e9 funkci. M\u016f\u017eete k tomu pou\u017e\u00edt funkci „Automatick\u00e9 vypl\u0148ov\u00e1n\u00ed“. Prvn\u00ed bu\u0148ka v \u0159\u00e1dku, kter\u00fd chcete za\u010d\u00edt \u010d\u00edslovat, by m\u011bla obsahovat po\u017eadovan\u00e9 \u010d\u00edslo. Vyberte bu\u0148ku za n\u00ed a podr\u017ete v n\u00ed kurzor, dokud se nezm\u011bn\u00ed v \u010dern\u00fd symbol plus. Chcete-li vyplnit zb\u00fdvaj\u00edc\u00ed bu\u0148ky ve sloupci po\u017eadovanou posloupnost\u00ed \u010d\u00edslov\u00e1n\u00ed, klikn\u011bte a p\u0159et\u00e1hn\u011bte ukazatel dol\u016f. Excel umo\u017e\u0148uje jednoduch\u00e9 a rychl\u00e9 rychl\u00e9 o\u010d\u00edslov\u00e1n\u00ed velk\u00e9ho po\u010dtu \u0159\u00e1dk\u016f t\u00edm, \u017ee p\u0159i ta\u017een\u00ed dol\u016f automaticky zv\u011bt\u0161uje \u010d\u00edsla. Co znamen\u00e1 vzorec Excel R1C1? <\/p>\n

<\/div>\n

Dal\u0161\u00edm zp\u016fsobem ozna\u010dov\u00e1n\u00ed bun\u011bk v aplikaci Excel je z\u00e1pis vzorce R1C1. K ozna\u010den\u00ed um\u00edst\u011bn\u00ed bu\u0148ky vzhledem k aktivn\u00ed bu\u0148ce se pou\u017e\u00edv\u00e1 kombinace p\u00edsmen a \u010d\u00edslic. P\u00edsmeno „R“ znamen\u00e1 v z\u00e1pisu R1C1 \u010d\u00edslo \u0159\u00e1dku a p\u00edsmeno „C“ \u010d\u00edslo sloupce. Nap\u0159\u00edklad R1C1 ozna\u010duje aktivn\u00ed bu\u0148ku (bu\u0148ku obsahuj\u00edc\u00ed vzorec), R2C1 ozna\u010duje souseda aktivn\u00ed bu\u0148ky ve stejn\u00e9m sloupci a R1C2 ozna\u010duje souseda aktivn\u00ed bu\u0148ky ve stejn\u00e9m \u0159\u00e1dku. Pro n\u011bkter\u00e9 slo\u017eit\u00e9 v\u00fdpo\u010dty a \u00falohy automatizace aplikace Excel m\u016f\u017ee b\u00fdt z\u00e1pis vzorce R1C1 u\u017eite\u010dn\u00fd. <\/p>\n

Pro\u010d jsou \u0159\u00e1dky a sloupce v aplikaci Excel \u010d\u00edslov\u00e1ny? <\/div>\n

M\u0159\u00ed\u017ekov\u00e1 struktura aplikace Excel vedla k rozhodnut\u00ed \u010d\u00edslovat sloupce i \u0159\u00e1dky. D\u00edky \u010d\u00edslov\u00e1n\u00ed sloupc\u016f i \u0159\u00e1dk\u016f poskytuje Excel u\u017eivatel\u016fm snadn\u00fd a p\u0159irozen\u00fd zp\u016fsob odkazov\u00e1n\u00ed na konkr\u00e9tn\u00ed bu\u0148ky ve velk\u00e9m pracovn\u00edm listu a jejich vyhled\u00e1v\u00e1n\u00ed. P\u0159i pr\u00e1ci se slo\u017eit\u00fdmi soubory dat je z\u00e1sadn\u00ed navigace a p\u0159esn\u00e9 odkazov\u00e1n\u00ed na bu\u0148ky, kter\u00e9 tento p\u0159\u00edstup umo\u017e\u0148uje. Krom\u011b toho mohou u\u017eivatel\u00e9 d\u00edky kombinaci \u010d\u00edsel sloupc\u016f a \u0159\u00e1dk\u016f snadno a p\u0159esn\u011b prov\u00e1d\u011bt v\u00fdpo\u010dty, nap\u0159\u00edklad odkazy na bu\u0148ky ve vzorc\u00edch. <\/p>\n

<\/div>\n

Z\u00e1v\u011brem lze \u0159\u00edci, \u017ee dobr\u00e1 pr\u00e1ce s pokro\u010dil\u00fdm tabulkov\u00fdm procesorem Excel vy\u017eaduje znalost zp\u016fsobu \u010d\u00edslov\u00e1n\u00ed \u0159\u00e1dk\u016f. Po\u010d\u00ednaje lev\u00fdm horn\u00edm rohem pracovn\u00edho listu pou\u017e\u00edv\u00e1 aplikace Excel \u010d\u00edseln\u00fd syst\u00e9m, kter\u00fd \u0159\u00e1dk\u016fm p\u0159i\u0159azuje po\u0159adov\u00e1 \u010d\u00edsla. \u0158\u00e1dky mohou u\u017eivatel\u00e9 \u010d\u00edslovat automaticky pomoc\u00ed funkce Automatick\u00e9 vypl\u0148ov\u00e1n\u00ed a alternativn\u00edm z\u00e1pisem pro bu\u0148ky je vzorec R1C1. Excel poskytuje p\u0159esn\u00e9 odkazov\u00e1n\u00ed na bu\u0148ky a usnad\u0148uje orientaci v pracovn\u00edm listu \u010d\u00edslov\u00e1n\u00edm sloupc\u016f i \u0159\u00e1dk\u016f. D\u00edky t\u011bmto informac\u00edm m\u016f\u017eete s jistotou man\u00e9vrovat rozs\u00e1hlou m\u0159\u00ed\u017ekou aplikace Excel a zv\u00fd\u0161it produktivitu.<\/p><\/div>\n

\n
FAQ<\/div>\n
\n
Co vrac\u00ed po\u010det \u0159\u00e1dk\u016f?<\/div>\n

Funkce „\u0158\u00c1DKY“ v aplikaci Microsoft Excel vrac\u00ed po\u010det \u0159\u00e1dk\u016f v pracovn\u00edm listu. Pomoc\u00ed t\u00e9to funkce lze spo\u010d\u00edtat po\u010det \u0159\u00e1dk\u016f v cel\u00e9m listu nebo ve vybran\u00e9m rozsahu. Po\u010det \u0159\u00e1dk\u016f v ur\u010dit\u00e9m rozsahu se \u010dasto pou\u017e\u00edv\u00e1 ve vzorc\u00edch nebo makrech k prov\u00e1d\u011bn\u00ed v\u00fdpo\u010dt\u016f nebo operac\u00ed s daty. <\/p>\n<\/div>\n

\n
Kter\u00e1 funkce slou\u017e\u00ed k po\u010d\u00edt\u00e1n\u00ed po\u010dtu \u0159\u00e1dk\u016f?<\/div>\n

K po\u010d\u00edt\u00e1n\u00ed po\u010dtu \u0159\u00e1dk\u016f v ur\u010dit\u00e9m rozsahu se v aplikaci Microsoft Excel \u010dasto pou\u017e\u00edv\u00e1 funkce COUNTA. Po\u010d\u00edt\u00e1 po\u010det nepr\u00e1zdn\u00fdch bun\u011bk v dan\u00e9m rozsahu. M\u016f\u017eete nap\u0159\u00edklad pou\u017e\u00edt vzorec „=COUNTA(A:A)“ pro spo\u010d\u00edt\u00e1n\u00ed po\u010dtu \u0159\u00e1dk\u016f ve sloupci A. <\/p>\n<\/div>\n

\n
Um\u00ed Excel automaticky \u010d\u00edslovat \u0159\u00e1dky?<\/div>\n

Ano, pomoc\u00ed funkce v aplikaci Excel m\u016f\u017eete automaticky \u010d\u00edslovat \u0159\u00e1dky. K rychl\u00e9mu p\u0159id\u00e1n\u00ed po\u0159adov\u00fdch \u010d\u00edsel do \u0159\u00e1dk\u016f lze pou\u017e\u00edt vestav\u011bnou funkci \u010d\u00edslov\u00e1n\u00ed \u0159\u00e1dk\u016f aplikace Excel nebo jednoduch\u00fd vzorec. <\/p>\n<\/div>\n

\n
Jak se v aplikaci Excel pojmenov\u00e1vaj\u00ed \u0159\u00e1dky?<\/div>\n

\u0158\u00e1dky v aplikaci Microsoft Excel m\u016f\u017eete pojmenovat podle n\u00ed\u017ee uveden\u00fdch postup\u016f: V kroku 1 otev\u0159ete tabulku aplikace Excel a vyberte \u0159\u00e1dek (\u0159\u00e1dky), kter\u00e9 chcete pojmenovat. Toho lze dos\u00e1hnout kliknut\u00edm a p\u0159eta\u017een\u00edm p\u0159es \u010d\u00edsla \u0159\u00e1dk\u016f na lev\u00e9 stran\u011b tabulky. <\/p>\n

<\/div>\n

2. Po kliknut\u00ed prav\u00fdm tla\u010d\u00edtkem my\u0161i na vybran\u00fd(\u00e9) \u0159\u00e1dek(y) vyberte v kontextov\u00e9 nab\u00eddce mo\u017enost „Vlo\u017eit“. T\u00edmto postupem se nad vybran\u00fd \u0159\u00e1dek (vybran\u00e9 \u0159\u00e1dky) p\u0159id\u00e1 nov\u00fd \u0159\u00e1dek. <\/p>\n

<\/div>\n

3. V nov\u011b p\u0159idan\u00e9m \u0159\u00e1dku klikn\u011bte na bu\u0148ku, do kter\u00e9 chcete napsat n\u00e1zev \u0159\u00e1dku. 4. Do zobrazen\u00e9ho textov\u00e9ho pole zadejte po\u017eadovan\u00fd n\u00e1zev \u0159\u00e1dku. Nyn\u00ed m\u00e1 \u0159\u00e1dek n\u00e1zev. N\u00e1zev, kter\u00fd \u0159\u00e1dku v aplikaci Excel p\u0159id\u011bl\u00edte, slou\u017e\u00ed pouze pro referen\u010dn\u00ed \u00fa\u010dely; nem\u00e1 \u017e\u00e1dn\u00fd vliv na v\u00fdpo\u010dty nebo vzorce v tabulce. M\u016f\u017ee b\u00fdt u\u017eite\u010dn\u00fd pro klasifikaci a uspo\u0159\u00e1d\u00e1n\u00ed dat v listu.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Jak vlo\u017eit \u010d\u00edsla \u0159\u00e1dk\u016f? Na kart\u011b rozlo\u017een\u00ed str\u00e1nky klikn\u011bte ve skupin\u011b Vzhled str\u00e1nky na polo\u017eku \u010d\u00edsla \u0159\u00e1dk\u016f. Klikn\u011bte na mo\u017enosti \u010d\u00edslov\u00e1n\u00ed \u0159\u00e1dk\u016fa potom na kartu rozlo\u017een\u00ed . V seznamu pou\u017e\u00edt na klikn\u011bte na polo\u017eku vybran\u00e9 odd\u00edly. Klikn\u011bte na tla\u010d\u00edtko \u010c\u00edsla \u0159\u00e1dk\u016f. Dal\u0161\u00ed informace najdete na support.microsoft.com MS Excel je robustn\u00ed tabulkov\u00fd procesor, kter\u00fd se \u010dasto … \u010c\u00edst d\u00e1l<\/a><\/p>\n","protected":false},"author":2158,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4645],"tags":[],"class_list":["post-12220","post","type-post","status-publish","format-standard","hentry","category-ms-excel"],"_links":{"self":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts\/12220","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/users\/2158"}],"replies":[{"embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/comments?post=12220"}],"version-history":[{"count":1,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts\/12220\/revisions"}],"predecessor-version":[{"id":15574,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts\/12220\/revisions\/15574"}],"wp:attachment":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/media?parent=12220"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/categories?post=12220"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/tags?post=12220"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}