{"id":4362,"date":"2024-09-30T13:47:16","date_gmt":"2024-09-30T13:47:16","guid":{"rendered":"https:\/\/howtogeek.blog\/lt\/?p=4362"},"modified":"2024-09-30T13:47:16","modified_gmt":"2024-09-30T13:47:16","slug":"disabling-autoformatting-in-excel-a-stepbystep-guide","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/lt\/disabling-autoformatting-in-excel-a-stepbystep-guide\/","title":{"rendered":"Automatinio formatavimo i\u0161jungimas programoje \u201eExcel\u201c: nuoseklus vadovas"},"content":{"rendered":"<p>Automatinis formatavimas yra labai naudinga funkcija, kuri automati\u0161kai formatuoja duomenis, kuriuos \u012fvedate \u012f skai\u010diuokles, pagerindama skaitomum\u0105 ir supratim\u0105. Ta\u010diau gali b\u016bti atvej\u0173, kai nenorite, kad j\u016bs\u0173 duomenys b\u016bt\u0173 formatuojami automati\u0161kai. Tokiais atvejais \u0161i\u0105 funkcij\u0105 i\u0161jungti yra paprasta. Be to, galite tinkinti automatinio formatavimo nustatymus, kad i\u0161jungtum\u0117te tik konkre\u010dius aspektus, o funkcija i\u0161likt\u0173 aktyvi.<\/p>\n<h2 id=\"option-1-turn-off-auto-formatting-for-a-range-or-a-cell\">1 parinktis: i\u0161junkite automatin\u012f konkre\u010di\u0173 langeli\u0173 arba diapazon\u0173 formatavim\u0105<\/h2>\n<p>Nor\u0117dami sustabdyti Excel automatin\u012f duomen\u0173 formatavim\u0105 konkre\u010diame langelyje arba diapazone, formatuokite langel\u012f kaip tekst\u0105. Tai i\u0161saugos j\u016bs\u0173 \u012fvest\u0105 informacij\u0105 nepaveikdamas viso lapo automatinio formatavimo.<\/p>\n<ul>\n<li>Atidarykite \u201eExcel\u201c skai\u010diuokl\u0119 ir pasirinkite langel\u012f arba diapazon\u0105, kuriame norite i\u0161jungti automatin\u012f formatavim\u0105. Galite pasirinkti kelet\u0105 langeli\u0173, vilkdami per juos.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Pasirinkite langelius programoje \u201eExcel\u201c.\" class=\"wp-image\" decoding=\"async\" height=\"496\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-741-1.webp\" title=\"Pasirinkite langelius programoje \u201eExcel\u201c.\" width=\"882\"\/><\/figure>\n<ul>\n<li>Pasirink\u0119 norimus langelius, de\u0161iniuoju pel\u0117s mygtuku spustel\u0117kite savo pasirinkim\u0105 ir kontekstiniame meniu pasirinkite \u201eFormat Cells\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Langeli\u0173 formatavimo parinktis\" class=\"wp-image\" decoding=\"async\" height=\"485\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-742-1.webp\" title=\"Langeli\u0173 formatavimo parinktis\" width=\"863\"\/><\/figure>\n<ul>\n<li>Dialogo lange \u201eL\u0105steli\u0173 formatavimas\u201c skirtuke \u201eSkai\u010dius\u201c pasirinkite parinkt\u012f \u201eTekstas\u201c, tada spustel\u0117kite mygtuk\u0105 \u201eGerai\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Langeli\u0173 formatavimo dialogas\" class=\"wp-image\" decoding=\"async\" height=\"500\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-743-1.webp\" title=\"Langeli\u0173 formatavimo dialogas\" width=\"889\"\/><\/figure>\n<ul>\n<li>Dabar, jei \u012fvedate specialiuosius simbolius arba skai\u010dius su nuliais priekyje, formatavimas i\u0161liks nepakit\u0119s. Tas pats pasakytina apie tekst\u0105, \u012fvest\u0105 kaip datas, pvz., \u201e03-24\u201c, kuris nebus konvertuojamas \u012f datos format\u0105.<\/li>\n<\/ul>\n<h2 id=\"option-2-turn-off-auto-formatting-permanently\">2 parinktis: visam laikui i\u0161junkite automatin\u012f formatavim\u0105<\/h2>\n<p>Taip pat galite visam laikui i\u0161jungti vis\u0173 savo skai\u010diuokli\u0173 automatin\u012f formatavim\u0105 programoje \u201eMicrosoft Excel\u201c.<\/p>\n<ul>\n<li>Paleiskite \u201eMicrosoft Excel\u201c ir spustel\u0117kite meniu \u201eFailas\u201c, esant\u012f vir\u0161utiniame kairiajame kampe.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\u201eExcel\u201c fail\u0173 meniu\" class=\"wp-image\" decoding=\"async\" height=\"443\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-744-1.webp\" title=\"\u201eExcel\u201c fail\u0173 meniu\" width=\"787\"\/><\/figure>\n<ul>\n<li>Tada spustel\u0117kite \u201eParinktys\u201c apatiniame kairiajame meniu.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\u201eExcel\u201c parinktys\" class=\"wp-image\" decoding=\"async\" height=\"502\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-745-1.webp\" title=\"\u201eExcel\u201c parinktys\" width=\"892\"\/><\/figure>\n<ul>\n<li>Dialogo lange Parinktys kair\u0117je esan\u010diame s\u0105ra\u0161e spustel\u0117kite \u201eDuomenys\u201c.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\u201eExcel\u201c duomen\u0173 parinktys\" class=\"wp-image\" decoding=\"async\" height=\"543\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-746-1.webp\" title=\"\u201eExcel\u201c duomen\u0173 parinktys\" width=\"965\"\/><\/figure>\n<ul>\n<li>Skiltyje \u201eAutomatinis duomen\u0173 konvertavimas\u201c \u012fsitikinkite, kad nepa\u017eym\u0117tas \u017eymimasis laukelis \u0161alia \u201e\u012egalinti visas numatyt\u0105sias duomen\u0173 konversijas\u2026\u201c. Jei jis pa\u017eym\u0117tas, spustel\u0117kite j\u012f, kad i\u0161jungtum\u0117te.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Duomen\u0173 konvertavimo parinktys\" class=\"wp-image\" decoding=\"async\" height=\"508\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-747-1.webp\" title=\"Duomen\u0173 konvertavimo parinktys\" width=\"903\"\/><\/figure>\n<ul>\n<li>Spustel\u0117kite mygtuk\u0105 \u201eGerai\u201c, kad u\u017edarytum\u0117te dialogo lang\u0105. Nuo \u0161iol \u201eExcel\u201c automati\u0161kai neformatuos duomen\u0173, \u012fvest\u0173 \u012f j\u016bs\u0173 skai\u010diuokles.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Patvirtinkite pakeitimus programoje \u201eExcel\u201c.\" class=\"wp-image\" decoding=\"async\" height=\"473\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-748-1.webp\" title=\"Patvirtinkite pakeitimus programoje \u201eExcel\u201c.\" width=\"841\"\/><\/figure>\n<ul>\n<li>Jei pageidaujate, galite i\u0161laikyti bendr\u0105 nustatym\u0105 ir pasirinktinai i\u0161jungti tam tikras automatinio formatavimo parinktis.<\/li>\n<\/ul>\n<h3 id=\"things-to-know\">Svarbios pastabos<\/h3>\n<ul>\n<li>Taip pat galite i\u0161vengti automatinio formatavimo, langelyje prie\u0161 vertes \u012fvesdami apostrof\u0105, tod\u0117l duomenys bus nepa\u017eeisti.<\/li>\n<li>Patyrusiems vartotojams, naudojant \u201eVisual Basic for Applications\u201c (VBA) kod\u0105, galima i\u0161vengti automatinio formatavimo programoje \u201eExcel\u201c. Tam reikia \u012fjungti skirtuk\u0105 K\u016br\u0117jas ir \u012fterpti modul\u012f, tod\u0117l jis ma\u017eiau tinkamas pradedantiesiems.<\/li>\n<li>I\u0161jung\u0119 automatin\u012f formatavim\u0105, galite bet kada i\u0161 naujo j\u012f \u012fjungti, meniu Failas atidar\u0119 Parink\u010di\u0173 meniu.<\/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\">\u0160altinis<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Automatinis formatavimas yra labai naudinga funkcija, kuri automati\u0161kai formatuoja duomenis, kuriuos \u012fvedate \u012f skai\u010diuokles, pagerindama skaitomum\u0105 ir supratim\u0105. Ta\u010diau gali b\u016bti atvej\u0173, kai nenorite, kad j\u016bs\u0173 duomenys b\u016bt\u0173 formatuojami automati\u0161kai. Tokiais atvejais \u0161i\u0105 funkcij\u0105 i\u0161jungti yra paprasta. Be to, galite tinkinti automatinio formatavimo nustatymus, kad i\u0161jungtum\u0117te tik konkre\u010dius aspektus, o funkcija i\u0161likt\u0173 aktyvi. 1 parinktis: [&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":[56,123,282],"class_list":["post-4362","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\/lt\/wp-json\/wp\/v2\/posts\/4362","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/comments?post=4362"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/posts\/4362\/revisions"}],"predecessor-version":[{"id":4363,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/posts\/4362\/revisions\/4363"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/media?parent=4362"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/categories?post=4362"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/lt\/wp-json\/wp\/v2\/tags?post=4362"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}