[{"@context":"https:\/\/schema.org\/","@type":"Article","@id":"https:\/\/www.bittova.cz\/moznosti-pri-praci-v-excelu\/#Article","mainEntityOfPage":"https:\/\/www.bittova.cz\/moznosti-pri-praci-v-excelu\/","headline":"Mo\u017enosti p\u0159i pr\u00e1ci v Excelu","name":"Mo\u017enosti p\u0159i pr\u00e1ci v Excelu","description":"EXCEL \u2013 z\u00e1m\u011bna v\u00a0po\u0159ad\u00ed sloupc\u016f –\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Pokud pracujete v\u00a0Excelu a pot\u0159ebujete zkop\u00edrovat nebo p\u0159esunout sloupec tabulky, tento sloupec ozna\u010dte tak, \u017ee my\u0161\u00ed kliknete na jeho … \u010c\u00edst d\u00e1le ›<\/a><\/span>","datePublished":"2025-02-27","dateModified":"2023-04-29","author":{"@type":"Person","@id":"https:\/\/www.bittova.cz\/author\/#Person","name":"bittova.cz\n","url":"https:\/\/www.bittova.cz\/author\/","identifier":1,"image":{"@type":"ImageObject","@id":"https:\/\/secure.gravatar.com\/avatar\/df9d3e7f7fe4622e291ec02ac46f5f76755ddc91019a65e783baee3892394402?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/df9d3e7f7fe4622e291ec02ac46f5f76755ddc91019a65e783baee3892394402?s=96&d=mm&r=g","height":96,"width":96}},"publisher":{"@type":"Organization","name":"bittova.cz","logo":{"@type":"ImageObject","@id":"\/logo.png","url":"\/logo.png","width":600,"height":60}},"image":{"@type":"ImageObject","@id":"https:\/\/www.bittova.cz\/wp-content\/uploads\/img_a301549_w2017_t1511628202.jpg","url":"https:\/\/www.bittova.cz\/wp-content\/uploads\/img_a301549_w2017_t1511628202.jpg","height":0,"width":0},"url":"https:\/\/www.bittova.cz\/moznosti-pri-praci-v-excelu\/","about":["Internet"],"wordCount":399,"articleBody":"EXCEL \u2013 z\u00e1m\u011bna v\u00a0po\u0159ad\u00ed sloupc\u016f\t–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Pokud pracujete v\u00a0Excelu a pot\u0159ebujete zkop\u00edrovat nebo p\u0159esunout sloupec tabulky, tento sloupec ozna\u010dte tak, \u017ee my\u0161\u00ed kliknete na jeho p\u00edsmeno naho\u0159e v\u00a0z\u00e1hlav\u00ed.\t\t–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Ozna\u010den\u00fd sloupec vlo\u017e\u00edte do schr\u00e1nky, pro kop\u00edrov\u00e1n\u00ed pou\u017eijete kombinaci kl\u00e1ves CTRL + C, chcete-li ho p\u0159esunout, tak kombinaci CTRL + X.\t–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Prav\u00fdm tla\u010d\u00edtkem my\u0161i pak klikn\u011bte na z\u00e1hlav\u00ed sloupce, na jeho\u017e pozici chcete ozna\u010den\u00fd sloupec vlo\u017eit, a z\u00a0m\u00edstn\u00ed nab\u00eddky vyberte bu\u010f p\u0159\u00edkaz \u201evlo\u017eit kop\u00edrovan\u00e9 bu\u0148ky\u201c nebo p\u0159\u00edkaz \u201evlo\u017eit vyjmut\u00e9 bu\u0148ky\u201c, podle toho jak\u00fdm zp\u016fsobem jste sloupec do kop\u00edrovac\u00ed schr\u00e1nky vlo\u017eili.\t\tEXCEL \u2013 \u00faprava hypertextov\u00e9ho odkazu\t–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Chcete-li editovat obsah bu\u0148ky, kter\u00e1 obsahuje hypertextov\u00fd odkaz, na dan\u00e9 pole nastavte my\u0161 a lev\u00fdm tla\u010d\u00edtkem my\u0161i vyvolejte, po del\u0161\u00edm stisku, k\u0159\u00ed\u017eek. Pak tla\u010d\u00edtko uvoln\u011bte a m\u016f\u017eete obsah upravit.\t–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Chcete-li odkaz \u00fapln\u011b odstranit, z\u00a0t\u00e9\u017ee m\u00edstn\u00ed nab\u00eddky vyberte \u201eodebrat hypertextov\u00fd odkaz\u201c. Chcete-li ale nap\u0159\u00edklad jen zm\u011bnit c\u00edl odkazu, vyberte p\u0159\u00edkaz \u201eupravit hypertextov\u00fd odkaz\u201c.\t\u00a0\tEXCEL \u2013 automatick\u00fd v\u00fdpo\u010det\t–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 U velmi slo\u017eit\u00fdch a rozs\u00e1hl\u00fdch tabulek m\u016f\u017ee doj\u00edt k\u00a0tomu, \u017ee automatick\u00fd p\u0159epo\u010det v\u0161ech aktu\u00e1ln\u00edch bun\u011bk velmi zpomal\u00ed pr\u00e1ci.\t–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Chcete-li automatick\u00fd p\u0159epo\u010det z\u00a0tohoto d\u016fvodu vypnout, klikn\u011bte na z\u00e1lo\u017eku \u201evzorce\u201c a z\u00a0nab\u00eddky vyberte polo\u017eku \u201eru\u010dn\u011b\u201c, to v\u00a0p\u0159\u00edpad\u011b, \u017ee chcete aktualizovat v\u00fdpo\u010dty na z\u00e1klad\u011b va\u0161\u00ed ru\u010dn\u00ed volby. Polo\u017eku \u201eautomaticky\u201c zapn\u011bte potom v\u00a0tom p\u0159\u00edpad\u011b, kdy\u017e chcete, aby Excel p\u0159epo\u010d\u00edtal tabulku, p\u0159i ka\u017ed\u00e9 zm\u011bn\u011b d\u00edl\u010d\u00edch hodnot v\u00a0tabulce.\t–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Po\u017eadujete-li aby program Excel p\u0159epo\u010d\u00edtal pouze aktu\u00e1ln\u00ed list programu, vyberte nab\u00eddku \u201ep\u0159epo\u010d\u00edtat list\u201c.\t\tEXCEL \u2013 zobrazen\u00ed vzorc\u016f\t–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Pro zobrazen\u00ed vzorc\u016f, zapsan\u00fdch v\u00a0jednotliv\u00fdch bu\u0148k\u00e1ch programu, klikn\u011bte na z\u00e1lo\u017eku karty \u201evzorce\u201c a vyberte nab\u00eddku \u201ezobrazit vzorce\u201c. Excel uprav\u00ed s\u00e1m \u0161\u00ed\u0159ku sloupc\u016f a zobraz\u00ed vzorce tam, kde je bu\u0148ky obsahuj\u00ed.\t–\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Dal\u0161\u00edm kliknut\u00edm v\u00a0nab\u00eddce \u201ezobrazit vzorce\u201c se lze vr\u00e1tit do p\u016fvodn\u00edho nastaven\u00ed, zobrazen\u00ed hodnoty bu\u0148ky. 4.2\/5 - (10 votes) "},{"@context":"https:\/\/schema.org\/","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Mo\u017enosti p\u0159i pr\u00e1ci v Excelu","item":"https:\/\/www.bittova.cz\/moznosti-pri-praci-v-excelu\/#breadcrumbitem"}]}]