Yuav ua li cas los tsim koj tus kheej cov ntaub ntawv hom hauv Excel

Cov ntaub ntawv hom ntawv hauv Microsoft Office Excel yog hom zaub ntawm cov cim hauv cov hlwb ntawm cov lus array. Qhov kev zov me nyuam nws tus kheej muaj ntau yam kev xaiv formatting. Txawm li cas los xij, qee zaum koj yuav tsum tsim ib hom kev cai. Yuav ua li cas thiaj yuav tau tham hauv kab lus no.

Yuav ua li cas hloov cell hom hauv Excel

Ua ntej koj pib tsim koj tus kheej hom, koj yuav tsum paub koj tus kheej nrog cov hauv paus ntsiab lus ntawm kev hloov nws. Koj tuaj yeem hloov ib hom ntaub ntawv tso rau hauv cov lus cell mus rau lwm qhov raws li cov qauv hauv qab no:

1. Nyem rau sab laug nas khawm ntawm qhov xav tau ntawm tes nrog cov ntaub ntawv xaiv nws.
2. Right-click nyob qhov twg hauv qhov chaw xaiv.
3. Hauv cov ntawv qhia zaub mov, nyem rau ntawm kab "Format Cells ...".
4. Hauv lub qhov rai uas qhib, mus rau ntu "Number" thiab hauv "Number formats" thaiv, xaiv ib qho ntawm cov kev xaiv tsim nyog los ntawm nias rau nws ob zaug nrog LMB.

5. Nyem "OK" nyob rau hauv qab ntawm lub qhov rais siv qhov kev txiav txim.

Ua tib zoo mloog! Tom qab hloov cov hom ntawv, cov lej hauv lub rooj cell yuav tshwm sim txawv.

Yuav ua li cas los tsim koj tus kheej hom hauv Excel

Lub hauv paus ntsiab lus ntawm kev ntxiv cov ntaub ntawv kev cai nyob rau hauv qhov kev pab cuam raws li xav tau yuav muab faib ua ob peb theem:

1. Xaiv ib lub xov tooj khoob ntawm daim ntawv ua haujlwm thiab, raws li cov txheej txheem saum toj no, mus rau "Format Cells ..." qhov rai.
2. Txhawm rau tsim koj tus kheej hom ntawv, koj yuav tsum sau qee cov lej hauv kab. Txhawm rau ua qhov no, xaiv cov khoom "Tag nrho cov hom" thiab nyob rau hauv lub qhov rais tom ntej hauv "Hom" teb sau koj tus kheej hom, paub txog nws cov encoding hauv Excel. Hauv qhov no, txhua ntu ntawm cov lej raug cais los ntawm yav dhau los los ntawm ib qho semicolon.

3. Xyuas seb Microsoft Office Excel encodes ib hom ntawv twg. Ua li no, xaiv ib qho kev xaiv encoding los ntawm cov npe muaj nyob rau hauv lub qhov rais thiab nyem rau ntawm "OK".
4. Tam sim no, nyob rau hauv lub cell xaiv, koj yuav tsum sau ib tug xov tooj, piv txwv li, ib tug.

5. Los ntawm kev sib piv, nkag mus rau hauv cov ntawv qhia zaub mov ntawm tes thiab nyem rau ntawm lo lus "Numeric" hauv daim ntawv teev cov txiaj ntsig tau nthuav tawm. Tam sim no, yog tias koj mus rau ntu "Tag nrho cov hom ntawv" dua, tom qab ntawd xaiv "Numeric" formatting yuav twb tshwm sim ua ib qho encoding uas muaj ob ntu: tus cais thiab ib qho semicolon. Cov ntu yuav raug pom nyob rau hauv "Hom" teb, nrog thawj ntawm lawv tus yam ntxwv ntawm tus lej zoo, thiab qhov thib ob yog siv rau qhov tsis zoo.

6. Nyob rau theem no, thaum tus neeg siv twb paub txog lub hauv paus ntsiab lus ntawm coding, nws muaj peev xwm pib tsim nws tus kheej hom. Rau lub hom phiaj no, nws thawj zaug yuav tsum kaw lub Format Cells ntawv qhia zaub mov.
7. Ntawm Excel daim ntawv ua haujlwm, tsim thawj lub rooj array qhia hauv daim duab hauv qab no. Cov lus no suav tias yog piv txwv; hauv kev xyaum, koj tuaj yeem tsim lwm lub phaj.

8. Ntxig ib kab ntxiv ntawm qhov qub ob.

Tseem ceeb! Txhawm rau tsim kab ntawv khoob, koj yuav tsum tau nyem rau ntawm ib sab ntawm lub rooj array thiab nyem rau ntawm kab "Ntxig" nyob rau hauv lub ntsiab lus teb qhov rais.

9. Hauv kab tsim manually los ntawm PC keyboard, koj yuav tsum nkag mus rau cov ntaub ntawv los ntawm thawj kab ntawm lub rooj.

10. Xaiv cov kab ntxiv thiab right-click rau nws. Mus rau lub cell hom qhov rais raws li lub tswvyim hais saum toj no.
11. Mus rau "Txhua hom ntawv" tab. Thaum pib, lo lus "Main" yuav raug sau rau hauv kab "Hom". Nws yuav tsum tau hloov nrog nws tus kheej tus nqi.
12. Thawj qhov chaw hauv hom code yuav tsum yog tus nqi zoo. Ntawm no peb sau lo lus ""Tsis zoo"". Tag nrho cov lus qhia yuav tsum muab ntim rau hauv cov lus qhia.
13. Tom qab thawj tus nqi, muab ib tug semicolon thiab sau ""tsis xoom"".
14. Ib zaug ntxiv, peb muab ib qho semicolon thiab sau ua ke "" tsis muaj hyphen "".
15. Thaum pib ntawm kab, koj tseem yuav tau sau "Account No.", thiab tom qab ntawd teeb tsa koj tus kheej hom, piv txwv li, "00-000 ″".

16. Txuag cov kev hloov pauv los ntawm nyem rau ntawm "OK" nyob rau hauv qab ntawm lub qhov rais thiab nthuav cov kab ntxiv ua ntej kom pom cov txiaj ntsig tshwj xeeb tsis yog cov cim "####". Cov kab lus los ntawm cov qauv tsim yuav raug sau rau ntawd.

Cov ntaub ntawv ntxiv! Yog tias cov ntaub ntawv hauv cov hlwb tsis tshwm sim, ces tus neeg siv tau ua yuam kev thaum tsim lawv tus kheej hom. Txhawm rau kho qhov teeb meem no, koj yuav tsum rov qab mus rau tabular array element formatting chaw qhov rai thiab xyuas qhov tseeb ntawm cov ntaub ntawv nkag.

Yuav ua li cas tshem tawm cov ntaub ntawv tsis xav tau hauv Microsoft Office Excel

Yog hais tias ib tug neeg tsis xav siv ib los yog lwm yam txheej txheem kev pab cuam hom ntawv, ces nws muaj peev xwm uninstall nws los ntawm cov npe ntawm cov khoom muaj nqis. Txhawm rau tiv nrog txoj haujlwm hauv lub sijhawm luv tshaj plaws, koj tuaj yeem siv cov algorithm hauv qab no:

1. Nyem rau sab laug nas khawm ntawm txhua lub xov tooj ntawm lub rooj array. Koj tuaj yeem nyem rau ntawm daim ntawv ua haujlwm khoob.
2. Nyob rau hauv cov ntsiab lus teb lub thawv, nyem rau ntawm kab "Format Cells".
3. Txav mus rau ntu "Number" nyob rau sab saum toj toolbar ntawm cov ntawv qhia zaub mov uas qhib.
4. Xaiv tus naj npawb tsim nyog los ntawm cov npe ntawm cov thawv rau sab laug thiab xaiv nws los ntawm nias LMB.
5. Nyem rau ntawm "Rho tawm" khawm, uas nyob rau sab xis sab xis ntawm lub qhov rais "Format Cells".
6. Pom zoo nrog lub kaw lus ceeb toom thiab nyem OK kaw lub qhov rais. Cov qauv xaiv los yog hom kev cai yuav tsum raug muab tshem tawm ntawm MS Excel yam tsis muaj kev rov qab los yav tom ntej.

xaus

Yog li, ntxiv kev cai tawm tswv yim rau Microsoft Office Excel yog txheej txheem yooj yim uas koj tuaj yeem ua rau koj tus kheej. Txhawm rau txuag lub sijhawm thiab ua haujlwm yooj yim, nws raug nquahu kom siv cov lus qhia saum toj no.