{"id":4415,"date":"2024-09-30T13:47:40","date_gmt":"2024-09-30T13:47:40","guid":{"rendered":"https:\/\/howtogeek.blog\/lv\/?p=4415"},"modified":"2024-09-30T13:47:40","modified_gmt":"2024-09-30T13:47:40","slug":"disabling-autoformatting-in-excel-a-stepbystep-guide","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/lv\/disabling-autoformatting-in-excel-a-stepbystep-guide\/","title":{"rendered":"Autom\u0101tisk\u0101s format\u0113\u0161anas atsp\u0113jo\u0161ana programm\u0101 Excel: soli pa solim"},"content":{"rendered":"<p>Autom\u0101tisk\u0101 format\u0113\u0161ana ir \u013coti noder\u012bga funkcija, kas autom\u0101tiski format\u0113 datus, ko ievad\u0101t izkl\u0101jlap\u0101s, uzlabojot las\u0101m\u012bbu un izpratni. Tom\u0113r var b\u016bt gad\u012bjumi, kad nev\u0113laties, lai j\u016bsu dati tiktu format\u0113ti autom\u0101tiski. \u0160\u0101dos gad\u012bjumos \u0161\u012bs funkcijas izsl\u0113g\u0161ana ir vienk\u0101r\u0161a. Turkl\u0101t varat piel\u0101got autom\u0101tisk\u0101s format\u0113\u0161anas iestat\u012bjumus, lai atsp\u0113jotu tikai noteiktus aspektus, vienlaikus saglab\u0101jot funkciju akt\u012bvu.<\/p>\n<h2 id=\"option-1-turn-off-auto-formatting-for-a-range-or-a-cell\">1.\u00a0iesp\u0113ja: atsp\u0113jojiet autom\u0101tisko format\u0113\u0161anu noteikt\u0101m \u0161\u016bn\u0101m vai diapazoniem<\/h2>\n<p>Lai p\u0101rtrauktu programmas Excel datu autom\u0101tisku format\u0113\u0161anu noteikt\u0101 \u0161\u016bn\u0101 vai diapazon\u0101, format\u0113jiet \u0161\u016bnu k\u0101 tekstu. Tas saglab\u0101s j\u016bsu ievad\u012bto inform\u0101ciju, neietekm\u0113jot visas lapas autom\u0101tisko format\u0113\u0161anu.<\/p>\n<ul>\n<li>Atveriet Excel izkl\u0101jlapu un atlasiet \u0161\u016bnu vai diapazonu, kur\u0101 v\u0113laties atsp\u0113jot autom\u0101tisko format\u0113\u0161anu. Varat atlas\u012bt vair\u0101kas \u0161\u016bnas, velkot p\u0101ri t\u0101m.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Programm\u0101 Excel atlasiet \u0161\u016bnas\" class=\"wp-image\" decoding=\"async\" height=\"496\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-741-1.webp\" title=\"Programm\u0101 Excel atlasiet \u0161\u016bnas\" width=\"882\"\/><\/figure>\n<ul>\n<li>P\u0113c vajadz\u012bgo \u0161\u016bnu atlas\u012b\u0161anas ar peles labo pogu noklik\u0161\u0137iniet uz atlases un konteksta izv\u0113ln\u0113 izv\u0113lieties &#8220;Format Cells&#8221;.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\u0160\u016bnu format\u0113\u0161anas opcija\" class=\"wp-image\" decoding=\"async\" height=\"485\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-742-1.webp\" title=\"\u0160\u016bnu format\u0113\u0161anas opcija\" width=\"863\"\/><\/figure>\n<ul>\n<li>Dialoglodzi\u0146\u0101 &#8220;\u0160\u016bnu format\u0113\u0161ana&#8221; ciln\u0113 &#8220;Numurs&#8221; atlasiet opciju &#8220;Teksts&#8221; un p\u0113c tam noklik\u0161\u0137iniet uz pogas &#8220;Labi&#8221;.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"\u0160\u016bnu format\u0113\u0161anas dialoglodzi\u0146\u0161\" class=\"wp-image\" decoding=\"async\" height=\"500\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-743-1.webp\" title=\"\u0160\u016bnu format\u0113\u0161anas dialoglodzi\u0146\u0161\" width=\"889\"\/><\/figure>\n<ul>\n<li>Tagad, ja ievad\u0101t speci\u0101l\u0101s rakstz\u012bmes vai ciparus ar null\u0113m s\u0101kum\u0101, format\u0113jums paliks nemain\u012bgs. Tas pats attiecas uz tekstu, kas ievad\u012bts k\u0101 datumi, piem\u0113ram, &#8220;03-24&#8221;, kas netiks p\u0101rveidots datuma form\u0101t\u0101.<\/li>\n<\/ul>\n<h2 id=\"option-2-turn-off-auto-formatting-permanently\">2.\u00a0iesp\u0113ja: neatgriezeniski atsp\u0113jot autom\u0101tisko format\u0113\u0161anu<\/h2>\n<p>Varat ar\u012b izv\u0113l\u0113ties neatgriezeniski atsp\u0113jot autom\u0101tisko format\u0113\u0161anu programm\u0101 Microsoft Excel vis\u0101m sav\u0101m izkl\u0101jlap\u0101m.<\/p>\n<ul>\n<li>Palaidiet programmu Microsoft Excel un noklik\u0161\u0137iniet uz izv\u0113lnes Fails, kas atrodas aug\u0161\u0113j\u0101 kreisaj\u0101 st\u016br\u012b.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Failu izv\u0113lne programm\u0101 Excel\" class=\"wp-image\" decoding=\"async\" height=\"443\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-744-1.webp\" title=\"Failu izv\u0113lne programm\u0101 Excel\" width=\"787\"\/><\/figure>\n<ul>\n<li>P\u0113c tam noklik\u0161\u0137iniet uz &#8220;Opcijas&#8221; izv\u0113lnes apak\u0161\u0113j\u0101 kreisaj\u0101 st\u016br\u012b.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Excel opcijas\" class=\"wp-image\" decoding=\"async\" height=\"502\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-745-1.webp\" title=\"Excel opcijas\" width=\"892\"\/><\/figure>\n<ul>\n<li>Dialoglodzi\u0146\u0101 Opcijas noklik\u0161\u0137iniet uz &#8220;Dati&#8221; sarakst\u0101 kreisaj\u0101 pus\u0113.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Datu opcijas programm\u0101 Excel\" class=\"wp-image\" decoding=\"async\" height=\"543\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-746-1.webp\" title=\"Datu opcijas programm\u0101 Excel\" width=\"965\"\/><\/figure>\n<ul>\n<li>P\u0101rliecinieties, ka sada\u013c\u0101 \u201cAutom\u0101tisk\u0101 datu konvert\u0113\u0161ana\u201d nav atz\u012bm\u0113ta izv\u0113les r\u016bti\u0146a blakus opcijai \u201cIesp\u0113jot visus noklus\u0113juma datu rekl\u0101mguvumus\u2026\u201d. Ja tas ir atz\u012bm\u0113ts, noklik\u0161\u0137iniet uz t\u0101, lai to atsp\u0113jotu.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Datu konvert\u0113\u0161anas opcijas\" class=\"wp-image\" decoding=\"async\" height=\"508\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-747-1.webp\" title=\"Datu konvert\u0113\u0161anas opcijas\" width=\"903\"\/><\/figure>\n<ul>\n<li>Noklik\u0161\u0137iniet uz pogas Labi, lai aizv\u0113rtu dialoglodzi\u0146u. Turpm\u0101k programma Excel autom\u0101tiski neformat\u0113s izkl\u0101jlap\u0101s ievad\u012btos datus.<\/li>\n<\/ul>\n<figure class=\"wp-block-image\"><img alt=\"Apstipriniet izmai\u0146as programm\u0101 Excel\" class=\"wp-image\" decoding=\"async\" height=\"473\" loading=\"lazy\" src=\"https:\/\/cdn.howtogeek.blog\/wp-content\/uploads\/2024\/09\/image-748-1.webp\" title=\"Apstipriniet izmai\u0146as programm\u0101 Excel\" width=\"841\"\/><\/figure>\n<ul>\n<li>Ja v\u0113laties, varat saglab\u0101t visp\u0101r\u0113jo iestat\u012bjumu, vienlaikus selekt\u012bvi atsp\u0113jojot noteiktas autom\u0101tisk\u0101s format\u0113\u0161anas opcijas.<\/li>\n<\/ul>\n<h3 id=\"things-to-know\">Svar\u012bgas piez\u012bmes<\/h3>\n<ul>\n<li>Varat ar\u012b izvair\u012bties no autom\u0101tisk\u0101s format\u0113\u0161anas, ievadot \u0161\u016bn\u0101 apostrofu pirms v\u0113rt\u012bb\u0101m, t\u0101d\u0113j\u0101di saglab\u0101jot datus neskartus.<\/li>\n<li>Pieredz\u0113ju\u0161iem lietot\u0101jiem, izmantojot Visual Basic for Applications (VBA) kodu, programm\u0101 Excel var tikt nov\u0113rsta autom\u0101tisk\u0101 format\u0113\u0161ana. Tam ir j\u0101iesp\u0113jo cilne Izstr\u0101d\u0101t\u0101js un j\u0101ievieto modulis, padarot to maz\u0101k piem\u0113rotu ies\u0101c\u0113jiem.<\/li>\n<li>P\u0113c autom\u0101tisk\u0101s format\u0113\u0161anas atsp\u0113jo\u0161anas varat to jebkur\u0101 laik\u0101 atk\u0101rtoti iesp\u0113jot, izv\u0113ln\u0113 Fails piek\u013c\u016bstot izv\u0113lnei Opcijas.<\/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\">Avots<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Autom\u0101tisk\u0101 format\u0113\u0161ana ir \u013coti noder\u012bga funkcija, kas autom\u0101tiski format\u0113 datus, ko ievad\u0101t izkl\u0101jlap\u0101s, uzlabojot las\u0101m\u012bbu un izpratni. Tom\u0113r var b\u016bt gad\u012bjumi, kad nev\u0113laties, lai j\u016bsu dati tiktu format\u0113ti autom\u0101tiski. \u0160\u0101dos gad\u012bjumos \u0161\u012bs funkcijas izsl\u0113g\u0161ana ir vienk\u0101r\u0161a. Turkl\u0101t varat piel\u0101got autom\u0101tisk\u0101s format\u0113\u0161anas iestat\u012bjumus, lai atsp\u0113jotu tikai noteiktus aspektus, vienlaikus saglab\u0101jot funkciju akt\u012bvu. 1.\u00a0iesp\u0113ja: atsp\u0113jojiet autom\u0101tisko format\u0113\u0161anu [&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":[62,130,286],"class_list":["post-4415","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\/lv\/wp-json\/wp\/v2\/posts\/4415","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/comments?post=4415"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts\/4415\/revisions"}],"predecessor-version":[{"id":4416,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts\/4415\/revisions\/4416"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/media?parent=4415"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/categories?post=4415"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/tags?post=4415"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}