{"id":4417,"date":"2024-09-30T13:46:03","date_gmt":"2024-09-30T13:46:03","guid":{"rendered":"https:\/\/howtogeek.blog\/cs\/?p=4417"},"modified":"2024-09-30T13:46:03","modified_gmt":"2024-09-30T13:46:03","slug":"disabling-autoformatting-in-excel-a-stepbystep-guide","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/cs\/disabling-autoformatting-in-excel-a-stepbystep-guide\/","title":{"rendered":"Zak\u00e1z\u00e1n\u00ed automatick\u00e9ho form\u00e1tov\u00e1n\u00ed v Excelu: Podrobn\u00fd pr\u016fvodce"},"content":{"rendered":"<p>Automatick\u00e9 form\u00e1tov\u00e1n\u00ed je velmi u\u017eite\u010dn\u00e1 funkce, kter\u00e1 automaticky form\u00e1tuje data, kter\u00e1 zad\u00e1v\u00e1te do tabulek, a zlep\u0161uje tak \u010ditelnost a porozum\u011bn\u00ed. Mohou v\u0161ak nastat p\u0159\u00edpady, kdy nechcete, aby se va\u0161e data form\u00e1tovala automaticky. V takov\u00fdch p\u0159\u00edpadech je vypnut\u00ed t\u00e9to funkce jednoduch\u00e9. Krom\u011b toho m\u016f\u017eete upravit nastaven\u00ed automatick\u00e9ho form\u00e1tov\u00e1n\u00ed tak, aby byly zak\u00e1z\u00e1ny pouze ur\u010dit\u00e9 aspekty a funkce z\u016fstala aktivn\u00ed.<\/p>\n<h2 id=\"option-1-turn-off-auto-formatting-for-a-range-or-a-cell\">Mo\u017enost 1: Zaka\u017ete automatick\u00e9 form\u00e1tov\u00e1n\u00ed pro konkr\u00e9tn\u00ed bu\u0148ky nebo rozsahy<\/h2>\n<p>Chcete-li aplikaci Excel zabr\u00e1nit v automatick\u00e9m form\u00e1tov\u00e1n\u00ed dat v konkr\u00e9tn\u00ed bu\u0148ce nebo oblasti, naform\u00e1tujte bu\u0148ku jako text. T\u00edm se zachov\u00e1 v\u00e1\u0161 vstup, ani\u017e by to ovlivnilo automatick\u00e9 form\u00e1tov\u00e1n\u00ed cel\u00e9ho listu.<\/p>\n<ul>\n<li>Otev\u0159ete tabulku aplikace Excel a vyberte bu\u0148ku nebo oblast, kde chcete zak\u00e1zat automatick\u00e9 form\u00e1tov\u00e1n\u00ed. P\u0159eta\u017een\u00edm p\u0159es n\u011b m\u016f\u017eete vybrat v\u00edce bun\u011bk.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Vyberte bu\u0148ky v Excelu\" class=\"wp-image\" decoding=\"async\" height=\"496\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-741-1.webp\" title=\"Vyberte bu\u0148ky v Excelu\" width=\"882\"\/><\/figure>\n<ul>\n<li>Po v\u00fdb\u011bru po\u017eadovan\u00fdch bun\u011bk klikn\u011bte prav\u00fdm tla\u010d\u00edtkem na sv\u016fj v\u00fdb\u011br a z kontextov\u00e9 nab\u00eddky vyberte \u201eForm\u00e1tovat bu\u0148ky\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Mo\u017enost Form\u00e1t bun\u011bk\" class=\"wp-image\" decoding=\"async\" height=\"485\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-742-1.webp\" title=\"Mo\u017enost Form\u00e1t bun\u011bk\" width=\"863\"\/><\/figure>\n<ul>\n<li>V dialogov\u00e9m okn\u011b &#8216;Form\u00e1t bun\u011bk&#8217; vyberte mo\u017enost &#8216;Text&#8217; na kart\u011b &#8216;\u010c\u00edslo&#8217; a pot\u00e9 klikn\u011bte na tla\u010d\u00edtko &#8216;OK&#8217;.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Dialogov\u00e9 okno Form\u00e1t bun\u011bk\" class=\"wp-image\" decoding=\"async\" height=\"500\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-743-1.webp\" title=\"Dialogov\u00e9 okno Form\u00e1t bun\u011bk\" width=\"889\"\/><\/figure>\n<ul>\n<li>Pokud nyn\u00ed zad\u00e1te speci\u00e1ln\u00ed znaky nebo \u010d\u00edsla s \u00favodn\u00edmi nulami, form\u00e1tov\u00e1n\u00ed z\u016fstane nezm\u011bn\u011bno. Tot\u00e9\u017e plat\u00ed pro text zadan\u00fd jako data, nap\u0159\u00edklad &#8217;03-24\u2032, kter\u00fd nebude p\u0159eveden do form\u00e1tu data.<\/li>\n<\/ul>\n<h2 id=\"option-2-turn-off-auto-formatting-permanently\">Mo\u017enost 2: Trvale zak\u00e1zat automatick\u00e9 form\u00e1tov\u00e1n\u00ed<\/h2>\n<p>M\u016f\u017eete tak\u00e9 trvale zak\u00e1zat automatick\u00e9 form\u00e1tov\u00e1n\u00ed v aplikaci Microsoft Excel pro v\u0161echny va\u0161e tabulky.<\/p>\n<ul>\n<li>Spus\u0165te Microsoft Excel a klikn\u011bte na nab\u00eddku &#8216;Soubor&#8217; um\u00edst\u011bnou v lev\u00e9m horn\u00edm rohu.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Nab\u00eddka Soubor v Excelu\" class=\"wp-image\" decoding=\"async\" height=\"443\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-744-1.webp\" title=\"Nab\u00eddka Soubor v Excelu\" width=\"787\"\/><\/figure>\n<ul>\n<li>D\u00e1le klikn\u011bte na &#8216;Mo\u017enosti&#8217; v lev\u00e9 doln\u00ed \u010d\u00e1sti nab\u00eddky.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Mo\u017enosti aplikace Excel\" class=\"wp-image\" decoding=\"async\" height=\"502\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-745-1.webp\" title=\"Mo\u017enosti aplikace Excel\" width=\"892\"\/><\/figure>\n<ul>\n<li>V dialogov\u00e9m okn\u011b Mo\u017enosti klikn\u011bte na &#8216;Data&#8217; ze seznamu vlevo.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Mo\u017enosti dat v Excelu\" class=\"wp-image\" decoding=\"async\" height=\"543\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-746-1.webp\" title=\"Mo\u017enosti dat v Excelu\" width=\"965\"\/><\/figure>\n<ul>\n<li>V \u010d\u00e1sti \u201eAutomatick\u00fd p\u0159evod dat\u201c zkontrolujte, zda nen\u00ed za\u0161krtnuto pol\u00ed\u010dko \u201ePovolit v\u0161echny v\u00fdchoz\u00ed p\u0159evody dat\u2026\u201c. Pokud je za\u0161krtnuto, klepnut\u00edm jej deaktivujte.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Mo\u017enosti p\u0159evodu dat\" class=\"wp-image\" decoding=\"async\" height=\"508\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-747-1.webp\" title=\"Mo\u017enosti p\u0159evodu dat\" width=\"903\"\/><\/figure>\n<ul>\n<li>Klepnut\u00edm na tla\u010d\u00edtko &#8216;OK&#8217; zav\u0159ete dialogov\u00e9 okno. Od t\u00e9to chv\u00edle nebude Excel automaticky form\u00e1tovat data zadan\u00e1 do va\u0161ich tabulek.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Potvr\u010fte zm\u011bny v Excelu\" class=\"wp-image\" decoding=\"async\" height=\"473\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-748-1.webp\" title=\"Potvr\u010fte zm\u011bny v Excelu\" width=\"841\"\/><\/figure>\n<ul>\n<li>Pokud chcete, m\u016f\u017eete zachovat celkov\u00e9 nastaven\u00ed a selektivn\u011b deaktivovat ur\u010dit\u00e9 mo\u017enosti automatick\u00e9ho form\u00e1tov\u00e1n\u00ed.<\/li>\n<\/ul>\n<h3 id=\"things-to-know\">D\u016fle\u017eit\u00e9 pozn\u00e1mky<\/h3>\n<ul>\n<li>Automatick\u00e9mu form\u00e1tov\u00e1n\u00ed se tak\u00e9 m\u016f\u017eete vyhnout zad\u00e1n\u00edm apostrofu p\u0159ed sv\u00e9 hodnoty v bu\u0148ce, \u010d\u00edm\u017e z\u016fstanou data nedot\u010den\u00e1.<\/li>\n<li>Pro pokro\u010dilej\u0161\u00ed u\u017eivatele m\u016f\u017ee pou\u017eit\u00ed k\u00f3du Visual Basic for Applications (VBA) zabr\u00e1nit automatick\u00e9mu form\u00e1tov\u00e1n\u00ed v Excelu. To vy\u017eaduje povolen\u00ed karty V\u00fdvoj\u00e1\u0159 a vlo\u017een\u00ed modulu, tak\u017ee je m\u00e9n\u011b vhodn\u00fd pro za\u010d\u00e1te\u010dn\u00edky.<\/li>\n<li>Po deaktivaci automatick\u00e9ho form\u00e1tov\u00e1n\u00ed jej m\u016f\u017eete kdykoli znovu aktivovat v nab\u00eddce Mo\u017enosti z nab\u00eddky Soubor.<\/li>\n<\/ul>\n<p><a class=\"xiaomi\" href=\"https:\/\/allthings.how\/how-to-disable-auto-formatting-in-excel\/\" rel=\"noopener noreferrer nofollow\" target=\"_blank\">Zdroj<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Automatick\u00e9 form\u00e1tov\u00e1n\u00ed je velmi u\u017eite\u010dn\u00e1 funkce, kter\u00e1 automaticky form\u00e1tuje data, kter\u00e1 zad\u00e1v\u00e1te do tabulek, a zlep\u0161uje tak \u010ditelnost a porozum\u011bn\u00ed. Mohou v\u0161ak nastat p\u0159\u00edpady, kdy nechcete, aby se va\u0161e data form\u00e1tovala automaticky. V takov\u00fdch p\u0159\u00edpadech je vypnut\u00ed t\u00e9to funkce jednoduch\u00e9. Krom\u011b toho m\u016f\u017eete upravit nastaven\u00ed automatick\u00e9ho form\u00e1tov\u00e1n\u00ed tak, aby byly zak\u00e1z\u00e1ny pouze ur\u010dit\u00e9 aspekty a [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[57,126,283],"class_list":["post-4417","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-apps","tag-microsoft","tag-microsoft-excel"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/4417","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/comments?post=4417"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/4417\/revisions"}],"predecessor-version":[{"id":4418,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/4417\/revisions\/4418"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/media?parent=4417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/categories?post=4417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/tags?post=4417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}