Nws tuaj yeem tshwm sim rau koj thiab.
Thaum ua haujlwm nrog phau ntawv loj hauv Excel, ntawm ib qho tsis yog txhua lub sijhawm zoo koj ua ib yam dab tsi tsis zoo (ntxiv rau kab lossis ntxig ib feem loj ntawm cov hlwb, piv txwv li) thiab mam li nco dheev koj tau txais lub qhov rais nrog qhov yuam kev "ntau ntau lub xov tooj sib txawv. formats":
Qee lub sij hawm qhov teeb meem no tshwm sim hauv daim ntawv tsis txaus siab ntau dua. Nag hmo, raws li niaj zaus, koj khaws thiab kaw koj daim ntawv tshaj tawm hauv Excel, thiab tag kis no koj tsis tuaj yeem qhib nws - cov lus zoo sib xws tau tshwm sim thiab cov lus pom zoo kom tshem tawm tag nrho cov formatting ntawm cov ntaub ntawv. Kev xyiv fab tsis txaus, pom zoo? Cia peb saib cov laj thawj thiab txoj hauv kev los kho qhov xwm txheej no.
Vim li cas qhov no tshwm sim
Qhov kev ua yuam kev no tshwm sim thaum phau ntawv ua haujlwm tshaj qhov siab tshaj plaws ntawm cov qauv uas Excel tuaj yeem khaws cia:
- rau Excel 2003 thiab laus dua - cov no yog 4000 hom
- rau Excel 2007 thiab tshiab dua, cov no yog 64000 hom
Ntxiv mus, hom ntawv nyob rau hauv cov ntaub ntawv no txhais tau tias ib tug tshwj xeeb ua ke ntawm formatting xaiv:
- font
- sib sau
- cell framing
- tus lej format
- xwm txheej formatting
Yog li, piv txwv li, yog tias koj styled ib daim me me ntawm ib daim ntawv zoo li no:
... tom qab ntawd Excel yuav nco ntsoov 9 hom xov tooj sib txawv hauv phau ntawv ua haujlwm, thiab tsis yog 2, raws li nws zoo nkaus li thaum xub thawj siab ib muag, vim hais tias ib txoj kab tuab nyob ib ncig ntawm ib puag ncig yuav tsim, qhov tseeb, 8 ntau hom kev xaiv. Ntxiv rau tus neeg tsim qauv ua las voos nrog cov ntawv sau thiab sau, thiab qhov kev ntshaw rau kev zoo nkauj hauv daim ntawv tshaj tawm loj yuav ua rau ntau pua thiab txhiab qhov sib xyaw ua ke uas Excel yuav tsum nco ntsoov. Cov ntaub ntawv loj los ntawm nws, los ntawm nws tus kheej, ib yam nkaus thiab tsis txo.
Ib qho teeb meem zoo sib xws kuj feem ntau tshwm sim thaum koj rov luam cov seem ntawm lwm cov ntaub ntawv rau hauv koj phau ntawv ua haujlwm (piv txwv li, thaum sib sau cov nplooj ntawv nrog macro lossis manually). Yog hais tias ib qho tshwj xeeb muab tshuaj txhuam ntawm cov nqi tsuas yog tsis siv, ces cov qauv ntawm cov thev naus laus zis kuj tau muab tso rau hauv phau ntawv, uas sai heev ua rau dhau qhov txwv.
Yuav ua li cas nrog nws
Muaj ntau cov lus qhia ntawm no:
- Yog tias koj muaj cov ntaub ntawv ntawm hom qub (xls), ces khaws cia rau hauv ib qho tshiab (xlsx lossis xlsm). Qhov no yuav tam sim ntawd tsa lub bar ntawm 4000 rau 64000 ntau hom ntawv.
- Tshem tawm cov xov tooj ntawm tes tsis tu ncua thiab ntxiv "cov khoom zoo nkauj" nrog cov lus txib Tsev — Clear — Clear formats (Lub Tsev — Clear — Clear Formatting). Xyuas seb puas muaj kab los yog kab ntawm cov nplooj ntawv uas tau formatted nkaus (piv txwv li, mus rau qhov kawg ntawm daim ntawv). Tsis txhob hnov qab txog qhov ua tau zais kab thiab kab.
- Tshawb xyuas phau ntawv rau cov ntawv zais thiab zais zais - qee zaum "cov tswv yim" tau muab zais rau ntawm lawv.
- Tshem tawm qhov tsis xav tau formatting ntawm ib lub tab Tsev — Conditional Formatting — Tswj cov cai — Qhia formatting txoj cai rau tag nrho cov ntawv (Lub Tsev — Conditional Formatting — Qhia cov cai rau daim ntawv no).
- Txheeb xyuas yog tias koj tau sau ntau ntau ntawm cov qauv tsis tsim nyog tom qab luam cov ntaub ntawv los ntawm lwm phau ntawv ua haujlwm. Yog nyob ntawm tab Tsev (Tsev) Hauv daim ntawv yeej (Styles) ib tug loj npaum li cas ntawm "khoom khib nyiab":
... tom qab ntawd koj tuaj yeem tshem nws nrog lub macro me me. Nyem Alt + F11 los yog khawm Visual Basic tab tsim tawm (Tus tsim tawm), ntxig ib qho tshiab los ntawm cov ntawv qhia zaub mov Ntxig - Module thiab luam theej macro code nyob ntawd:
Sub Reset_Styles() ' tshem tawm txhua yam tsis tsim nyog rau Txhua objStyle Hauv ActiveWorkbook.Styles Ntawm qhov yuam kev Resume Next Yog tias Tsis yog objStyle.BuiltIn Ces objStyle.Delete On yuam kev GoTo 0 Next objStyle 'copy cov txheej txheem txheej txheem ntawm cov ntawv ua haujlwm tshiab teeb wbWork = Active Set wbNew = Workbooks.Add wbMy.Styles.Merge wbNew wbNew.Close savechanges:=False End Sub
Koj tuaj yeem tso nws nrog keyboard shortcut. Alt + F8 los yog khawm Ntsig (Macros) tab tsim tawm (Tus tsim tawm). Lub macro yuav tshem tawm txhua yam tsis siv, tawm hauv cov txheej txheem nkaus xwb:
- Yuav Ua Li Cas Tsis Siv Neeg Taw Qhia Cells nrog Kev Hloov Kho hauv Excel
- Dab tsi yog macro, qhov twg thiab yuav ua li cas luam cov macro code hauv Visual Basic, yuav ua li cas khiav lawv
- Excel phau ntawv ua haujlwm tau dhau los hnyav thiab qeeb - yuav kho li cas?