Zvinogona kuitika kwauriwo.
Paunenge uchishanda nebhuku rebasa rakakura muExcel, pane imwe nguva isingaite inoshamisa iwe unoita chimwe chinhu chisingakuvadzi (kuwedzera mutsara kana kuisa chimedu chikuru chemasero, semuenzaniso) uye kamwe kamwe unowana hwindo rine chikanganiso "Sero rakawanda rakasiyana. mafomu":
Dzimwe nguva dambudziko iri rinoitika mune imwe nzira isingafadzi. Husiku hwapfuura, semazuva ese, wakachengeta uye wakavhara rondedzero yako muExcel, uye mangwanani ano haugone kuivhura - meseji yakafanana inoratidzwa uye chirevo chekubvisa zvese fomati kubva mufaira. Mufaro hauna kukwana, unobvumirana? Ngatitarisei zvikonzero uye nzira dzekugadzirisa mamiriro aya.
Nei izvi zvichiitika
Kukanganisa uku kunoitika kana bhuku rebasa richidarika huwandu hwehuwandu hwemafomati anogona kuchengetwa neExcel:
- yeExcel 2003 nevakuru - aya mafomati mazana mana
- yeExcel 2007 uye nyowani, aya 64000 mafomati
Uyezve, iyo fomati mune iyi kesi inoreva chero yakasarudzika musanganiswa wemafomati sarudzo:
- kuita
- kuzadza
- kugadzirwa kwesero
- nhamba format
- conditional formatting
Saka, semuenzaniso, kana iwe wakanyora chidimbu chidiki chepepa seizvi:
... ipapo Excel ichayeuka 9 akasiyana mafomati emubhuku rekushanda, uye kwete 2, sezvazvinoratidzika pakutanga, nekuti mutsetse wakakora wakatenderedza perimeter uchagadzira, chokwadi, 8 akasiyana mafomati sarudzo. Wedzera kune iyo madhizaini edhizaini nemafonti uye anozadza, uye kuchiva kwerunako mumushumo mukuru kunotungamira kumazana nezviuru zvemisanganiswa yakafanana iyo Excel ichafanira kuyeuka. Iyo saizi yefaira kubva pairi, pachayo, zvakare haina kuderera.
Dambudziko rakafanana rinowanzoitika kana iwe uchidzokorora kukopa zvimedu kubva kune mamwe mafaera kubhuku rako rebasa (semuenzaniso, paunenge uchiunganidza mapepa ane macro kana nemaoko). Kana iyo yakakosha pamendi yemakoshero chete ikasashandiswa, saka mafomati eiyo akakopwa renji anoiswawo mubhuku, izvo zvinokurumidza kutungamira mukudarika muganho.
Maitiro ekuita nazvo
Pane nzira dzakawanda pano:
- Kana iwe uine faira reiyo yekare fomati (xls), wozoichengeta mune imwe nyowani (xlsx kana xlsm). Izvi zvinokurumidza kusimudza bara kubva ku4000 kusvika ku64000 mafomati akasiyana.
- Bvisa redundant cell fomati uye zvimwe "zvakanaka zvinhu" nemurairo Musha - Zvakajeka - Zvakajeka mafomati (Kumba - Zvakajeka - Zvakajeka Maumbirwo). Tarisa kana paine mitsetse kana makoramu pamapepa akafomatidzwa zvachose (kureva, kusvika kumagumo kwebepa). Usakanganwa nezvezvinogona kuvanzwa mitsara uye makoramu.
- Tarisa bhuku racho kune akavanzika uye makuru-akavanzika mapepa - dzimwe nguva "masterpieces" akavanzwa paari.
- Bvisa zvisingadiwe conditional fomati pane tab Musha — Conditional Formatting — Manage Rules — Ratidza Mitemo Yekumisikidza yePepa rose (Kumba - Conditional Formatting - Ratidza mitemo yepepa rebasa rino).
- Tarisa kana iwe wakaunganidza yakawandisa yezvitaera zvisina basa mushure mekukopa data kubva kune mamwe mabhuku ebasa. Kana pane tab Home (Musha) Muchinyorwa Styles (Zvitaera) huwandu hukuru hwe "marara":
... ipapo unogona kuibvisa nediki macro. Dzvanya Alt + F11 kana bhatani Visual Basic Tab yokuvaka (Mugadziri), isa module nyowani kuburikidza nemenyu Pinza – Module uye kopira iyo macro kodhi ipapo:
Sub Reset_Styles() 'bvisa masitayera ese asina kufanira Kune Imwe neimwe objStyle MuActiveWorkbook.Styles On Error Resume Next If Not objStyle.BuiltIn Then objStyle.Delete Pamhosho GoTo 0 Next objStyle 'kopa chiyero chezvitaera kubva mubhuku idzva rebasa = ActiverkWorkMy Seta wbMatsva = Mabhuku ebasa.Wedzera wbMy.Styles.Merge wbItsva wbItsva.Vhara masanjirwo:=Nhema Yekupedzisira Sub
Unogona kuivhura nechidimbu che keyboard. Alt + F8 kana nebhatani macro (Makororo) Tab yokuvaka (Mugadziri). Iyo macro ichabvisa ese asina kushandiswa masitayipi, ichisiya chete yakajairwa seti:
- Maitiro ekusimudza otomatiki maseru ane Conditional Formatting muExcel
- Chii macros, kupi uye sei kukopa iyo macro kodhi muVisual Basic, maitiro ekuamhanyisa
- Bhuku rekushanda reExcel rave kurema uye rinononoka - sei kurigadzirisa?