{"id":2242,"date":"2024-07-22T13:54:46","date_gmt":"2024-07-22T13:54:46","guid":{"rendered":"https:\/\/tech-lib.eu\/tech\/?p=2242"},"modified":"2024-07-22T13:54:46","modified_gmt":"2024-07-22T13:54:46","slug":"jak-udelat-caru-pres-text-v-aplikaci-excel","status":"publish","type":"post","link":"https:\/\/tech-lib.eu\/tech\/jak-udelat-caru-pres-text-v-aplikaci-excel\/","title":{"rendered":"Jak ud\u011blat \u010d\u00e1ru p\u0159es text v aplikaci Excel"},"content":{"rendered":"
\n
Jak vlo\u017eit \u010d\u00e1ru do Excelu?<\/div>\n
Klikn\u011bte na Add Chart Element (P\u0159idat prvek grafu)a potom na Gridlines (M\u0159\u00ed\u017eka). Zvolte po\u017eadovanou mo\u017enost \u010d\u00e1ry nebo klikn\u011bte na Dal\u0161\u00ed mo\u017enosti m\u0159\u00ed\u017eky. V z\u00e1vislosti na typu grafu nemus\u00ed b\u00fdt n\u011bkter\u00e9 mo\u017enosti dostupn\u00e9.<\/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

Siln\u00fdm n\u00e1strojem pro spr\u00e1vu a vyhodnocov\u00e1n\u00ed dat je aplikace Microsoft Excel. A\u010dkoli se v\u011bt\u0161inou pou\u017e\u00edv\u00e1 k organizaci a prov\u00e1d\u011bn\u00ed numerick\u00fdch v\u00fdpo\u010dt\u016f, nab\u00edz\u00ed tak\u00e9 mo\u017enosti form\u00e1tov\u00e1n\u00ed textu, kter\u00e9 zlep\u0161uj\u00ed vizu\u00e1ln\u00ed vzhled va\u0161ich tabulek. \u010c\u00e1ra p\u0159es text je standardn\u00ed mo\u017enost form\u00e1tov\u00e1n\u00ed, kterou lze pou\u017e\u00edt ke zv\u00fdrazn\u011bn\u00ed ur\u010dit\u00fdch bun\u011bk nebo k ozna\u010den\u00ed odstran\u011bn\u00fdch \u010di neaktivn\u00edch informac\u00ed. Tento \u010dl\u00e1nek se zab\u00fdv\u00e1 r\u016fzn\u00fdmi technikami vkl\u00e1d\u00e1n\u00ed \u010d\u00e1ry p\u0159es text v aplikaci Excel a \u0159e\u0161\u00ed ot\u00e1zky t\u00fdkaj\u00edc\u00ed se vkl\u00e1d\u00e1n\u00ed \u010dern\u00fdch \u010dar, p\u0159id\u00e1v\u00e1n\u00ed vodorovn\u00fdch \u010dar a vkl\u00e1d\u00e1n\u00ed \u010dar nad a pod text. <\/p>\n

Pou\u017eit\u00ed mo\u017enosti form\u00e1tov\u00e1n\u00ed „P\u0159e\u0161krtnout“ jako metoda 1 <\/div>\n

Pou\u017eit\u00ed mo\u017enosti form\u00e1tov\u00e1n\u00ed „P\u0159e\u0161krtnout“ je nejjednodu\u0161\u0161\u00ed zp\u016fsob vlo\u017een\u00ed \u010d\u00e1ry p\u0159es text v aplikaci Excel. Zde je uveden postup, jak na to: <\/p>\n

<\/div>\n

1. Vyberte bu\u0148ku nebo rozsah bun\u011bk, ve kter\u00fdch se nach\u00e1z\u00ed text, kter\u00fd chcete p\u0159e\u0161krtnout. 2. V kontextov\u00e9 nab\u00eddce vyberte mo\u017enost „Form\u00e1tovat bu\u0148ky“ klepnut\u00edm prav\u00fdm tla\u010d\u00edtkem my\u0161i na vybran\u00e9 bu\u0148ky. 3. V dialogov\u00e9m okn\u011b Form\u00e1tovat bu\u0148ky vyberte kartu P\u00edsmo. <\/p>\n

<\/div>\n

4. V \u010d\u00e1sti Efekty vyberte mo\u017enost „P\u0159e\u0161krtnout“ za\u0161krtnut\u00edm pol\u00ed\u010dka vedle n\u00ed. 5. Chcete-li pou\u017e\u00edt form\u00e1tov\u00e1n\u00ed a ukon\u010dit dialogov\u00e9 okno, vyberte mo\u017enost OK. P\u0159es vybran\u00fd text nyn\u00ed povede \u010d\u00e1ra. <\/p>\n

Pou\u017eit\u00ed podm\u00edn\u011bn\u00e9ho form\u00e1tov\u00e1n\u00ed je druhou technikou. <\/div>\n

Bu\u0148ky m\u016f\u017eete automaticky form\u00e1tovat pomoc\u00ed podm\u00edn\u011bn\u00e9ho form\u00e1tov\u00e1n\u00ed, pokud jsou spln\u011bna ur\u010dit\u00e1 krit\u00e9ria. Tento n\u00e1stroj umo\u017e\u0148uje vlo\u017eit \u010d\u00e1ru p\u0159es text v aplikaci Excel. Postup je n\u00e1sleduj\u00edc\u00ed: <\/p>\n

<\/div>\n

1. Vyberte bu\u0148ku nebo rozsah bun\u011bk, ve kter\u00fdch se nach\u00e1z\u00ed text, kter\u00fd chcete p\u0159e\u0161krtnout. 2. Klepn\u011bte na tla\u010d\u00edtko „Podm\u00edn\u011bn\u00e9 form\u00e1tov\u00e1n\u00ed“ ve skupin\u011b Styly na kart\u011b Dom\u016f na p\u00e1su karet aplikace Excel. <\/p>\n

<\/div>\n

Krok 3: V rozev\u00edrac\u00ed nab\u00eddce vyberte mo\u017enost „Nov\u00e9 pravidlo“. 4. V dialogov\u00e9m okn\u011b Nov\u00e9 pravidlo form\u00e1tov\u00e1n\u00ed vyberte mo\u017enost „Pou\u017e\u00edt vzorec k ur\u010den\u00ed, kter\u00e9 bu\u0148ky form\u00e1tovat“. 5. Do oblasti „Form\u00e1tovat hodnoty, kde je tento vzorec pravdiv\u00fd“ zadejte vzorec =TRUE. 6. Klepnut\u00edm na tla\u010d\u00edtko Form\u00e1t vyberte kartu P\u00edsmo. 7. V \u010d\u00e1sti Efekty vyberte mo\u017enost „P\u0159e\u0161krtnut\u00ed“ a za\u0161krtn\u011bte pol\u00ed\u010dko napravo od n\u00ed. Form\u00e1tov\u00e1n\u00ed se pou\u017eije pot\u00e9, co klepnut\u00edm na tla\u010d\u00edtko OK zav\u0159ete dialogov\u00e1 okna. <\/p>\n

<\/div>\n

P\u0159es zv\u00fdrazn\u011bn\u00fd text bude nyn\u00ed nakreslena \u010d\u00e1ra a bude nakreslena tak\u00e9 p\u0159es v\u0161echny zm\u011bny hodnoty bu\u0148ky, kter\u00e9 spl\u0148uj\u00ed po\u017eadavek. Excelovsk\u00e9 „p\u0159id\u00e1v\u00e1n\u00ed vodorovn\u00fdch a \u010dern\u00fdch \u010dar“ V aplikaci Excel m\u016f\u017eete mezi text vlo\u017eit \u010dernou \u010d\u00e1ru nebo vodorovnou \u010d\u00e1ru s vyu\u017eit\u00edm mo\u017enost\u00ed form\u00e1tov\u00e1n\u00ed r\u00e1me\u010dku. Postup je n\u00e1sleduj\u00edc\u00ed: <\/p>\n

<\/div>\n

1. Vyberte bu\u0148ku (bu\u0148ky), do kter\u00e9 se m\u00e1 vlo\u017eit vodorovn\u00e1 \u010d\u00e1ra. 2. V kontextov\u00e9 nab\u00eddce vyberte mo\u017enost „Form\u00e1tovat bu\u0148ky“ klepnut\u00edm prav\u00fdm tla\u010d\u00edtkem my\u0161i na vybran\u00e9 bu\u0148ky. 3. V dialogov\u00e9m okn\u011b Form\u00e1tovat bu\u0148ky vyberte kartu Ohrani\u010den\u00ed. 4. V \u010d\u00e1sti Ohrani\u010den\u00ed vyberte preferovan\u00fd styl a barvu \u010d\u00e1ry. Z palety vyberte spr\u00e1vnou barvu pro vlo\u017een\u00ed \u010dern\u00e9 \u010d\u00e1ry. 5. Chcete-li vlo\u017eit vodorovnou \u010d\u00e1ru, zvolte pro um\u00edst\u011bn\u00ed okraje mo\u017enost „Dole“. Chcete-li pou\u017e\u00edt form\u00e1tov\u00e1n\u00ed a zav\u0159\u00edt dialogov\u00e9 okno, vyberte v kroku 6 mo\u017enost OK. <\/p>\n

<\/div>\n

Ve spodn\u00ed \u010d\u00e1sti vybran\u00fdch bun\u011bk se nyn\u00ed objev\u00ed vodorovn\u00e1 \u010d\u00e1ra. Podle sv\u00fdch pot\u0159eb m\u016f\u017eete zm\u011bnit styl, barvu a polohu \u010d\u00e1ry. Jak um\u00edstit \u010d\u00e1ru nad a pod text V aplikaci Excel m\u016f\u017eete kombinovat mo\u017enosti form\u00e1tov\u00e1n\u00ed p\u0159e\u0161krtnut\u00ed a ohrani\u010den\u00ed a p\u0159idat \u010d\u00e1ru nad a pod text. Postup je n\u00e1sleduj\u00edc\u00ed: <\/p>\n

<\/div>\n

1. Vyberte bu\u0148ku nebo rozsah bun\u011bk, ve kter\u00fdch se nach\u00e1z\u00ed text, kter\u00fd chcete form\u00e1tovat. <\/p>\n

<\/div>\n

2. K pou\u017eit\u00ed form\u00e1tov\u00e1n\u00ed „P\u0159e\u0161krtnut\u00ed“ pou\u017eijte bu\u010f metodu 1, nebo metodu 2. 3. V kontextov\u00e9 nab\u00eddce vyberte mo\u017enost „Form\u00e1tovat bu\u0148ky“ klepnut\u00edm prav\u00fdm tla\u010d\u00edtkem my\u0161i na vybran\u00e9 bu\u0148ky. <\/p>\n

<\/div>\n

4. V dialogov\u00e9m okn\u011b Form\u00e1tovat bu\u0148ky vyberte kartu Ohrani\u010den\u00ed. 5. V \u010d\u00e1sti Ohrani\u010den\u00ed vyberte preferovan\u00fd styl a barvu \u010d\u00e1ry. 6. Zvolte pozice ohrani\u010den\u00ed „Naho\u0159e“ a „Dole“. 7. Chcete-li pou\u017e\u00edt form\u00e1tov\u00e1n\u00ed a ukon\u010dit dialogov\u00e9 okno, vyberte mo\u017enost OK. Nad a pod vybran\u00fdm textem se nyn\u00ed objev\u00ed \u010d\u00e1ra. <\/p>\n

<\/div>\n

Kone\u010dn\u011b pomoc\u00ed podm\u00edn\u011bn\u00e9ho form\u00e1tov\u00e1n\u00ed nebo mo\u017enosti form\u00e1tov\u00e1n\u00ed p\u0159e\u0161krtnut\u00ed lze v aplikaci Excel jednodu\u0161e vlo\u017eit \u010d\u00e1ru p\u0159es text. Pomoc\u00ed form\u00e1tov\u00e1n\u00ed r\u00e1me\u010dk\u016f m\u016f\u017eete tak\u00e9 p\u0159idat \u010dern\u00e9 \u010d\u00e1ry a vodorovn\u00e9 \u010d\u00e1ry. Kombinac\u00ed nastaven\u00ed p\u0159e\u0161krtnut\u00ed a form\u00e1tov\u00e1n\u00ed r\u00e1me\u010dku m\u016f\u017eete p\u0159idat \u010d\u00e1ru nad a pod text. Pomoc\u00ed t\u011bchto zp\u016fsob\u016f form\u00e1tov\u00e1n\u00ed m\u016f\u017eete esteticky vylep\u0161it tabulky aplikace Excel a zv\u00fdraznit d\u016fle\u017eit\u00e9 informace.<\/p><\/div>\n

\n
FAQ<\/div>\n
\n
Jak zad\u00e1te \u010dernou \u010d\u00e1ru?<\/div>\n

Pomoc\u00ed t\u011bchto krok\u016f lze v aplikaci Excel vlo\u017eit \u010dernou \u010d\u00e1ru p\u0159es text: 1. Rozhodn\u011bte, ve kter\u00e9 bu\u0148ce nebo rozsahu bun\u011bk chcete text pro\u0159\u00edznout. 2. V kontextov\u00e9 nab\u00eddce vyberte mo\u017enost „Form\u00e1tovat bu\u0148ky“ kliknut\u00edm prav\u00fdm tla\u010d\u00edtkem my\u0161i na vybran\u00e9 bu\u0148ky. <\/p>\n

<\/div>\n

3. V dialogov\u00e9m okn\u011b Form\u00e1tovat bu\u0148ky vyberte kartu „P\u00edsmo“. <\/p>\n

<\/div>\n

4. V \u010d\u00e1sti „Efekty“ za\u0161krtn\u011bte pol\u00ed\u010dko vedle polo\u017eky „P\u0159e\u0161krtnout“. <\/p>\n

<\/div>\n

5. Chcete-li form\u00e1tov\u00e1n\u00ed pou\u017e\u00edt, klepn\u011bte na tla\u010d\u00edtko „OK“. T\u00edmto postupem bude p\u0159es text ve zvolen\u00fdch bu\u0148k\u00e1ch aplikace Excel p\u0159id\u00e1na \u010dern\u00e1 \u010d\u00e1ra. <\/p>\n<\/div>\n

\n
Jak vlo\u017e\u00edte vodorovnou \u010d\u00e1ru p\u0159es text?<\/div>\n

Pomoc\u00ed t\u011bchto krok\u016f lze v aplikaci Excel vlo\u017eit vodorovnou \u010d\u00e1ru p\u0159es text: <\/p>\n

<\/div>\n

Zvolte bu\u0148ku (bu\u0148ky), ve kter\u00e9 se nach\u00e1z\u00ed text, kter\u00fd chcete pro\u0161krtnout. 2. V kontextov\u00e9 nab\u00eddce vyberte mo\u017enost „Form\u00e1tovat bu\u0148ky“ klepnut\u00edm prav\u00fdm tla\u010d\u00edtkem my\u0161i na vybranou bu\u0148ku nebo bu\u0148ky. 3. V dialogov\u00e9m okn\u011b „Form\u00e1tovat bu\u0148ky“ vyberte kartu „P\u00edsmo“. 4. V \u010d\u00e1sti „Efekty“ vyberte mo\u017enost „P\u0159e\u0161krtnut\u00ed“ za\u0161krtnut\u00edm pol\u00ed\u010dka vedle n\u00ed. <\/p>\n

<\/div>\n

5. Chcete-li zm\u011bny prov\u00e9st, stiskn\u011bte tla\u010d\u00edtko „OK“. <\/p>\n

<\/div>\n

Po dokon\u010den\u00ed t\u011bchto krok\u016f bude text ve vybran\u00e9 bu\u0148ce (bu\u0148k\u00e1ch) p\u0159e\u0161krtnut vodorovnou \u010darou.<\/p>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Jak vlo\u017eit \u010d\u00e1ru do Excelu? Klikn\u011bte na Add Chart Element (P\u0159idat prvek grafu)a potom na Gridlines (M\u0159\u00ed\u017eka). Zvolte po\u017eadovanou mo\u017enost \u010d\u00e1ry nebo klikn\u011bte na Dal\u0161\u00ed mo\u017enosti m\u0159\u00ed\u017eky. V z\u00e1vislosti na typu grafu nemus\u00ed b\u00fdt n\u011bkter\u00e9 mo\u017enosti dostupn\u00e9. Dal\u0161\u00ed informace najdete na support.microsoft.com Siln\u00fdm n\u00e1strojem pro spr\u00e1vu a vyhodnocov\u00e1n\u00ed dat je aplikace Microsoft Excel. A\u010dkoli se … \u010c\u00edst d\u00e1l<\/a><\/p>\n","protected":false},"author":1795,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1026],"tags":[],"class_list":["post-2242","post","type-post","status-publish","format-standard","hentry","category-formatovani-v-aplikaci-excel"],"_links":{"self":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts\/2242","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\/1795"}],"replies":[{"embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/comments?post=2242"}],"version-history":[{"count":1,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts\/2242\/revisions"}],"predecessor-version":[{"id":16269,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/posts\/2242\/revisions\/16269"}],"wp:attachment":[{"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/media?parent=2242"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/categories?post=2242"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tech-lib.eu\/tech\/wp-json\/wp\/v2\/tags?post=2242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}