Microsoft Office Excel muab cov ntaub ntawv tiv thaiv kev muaj peev xwm. Nws tuaj yeem siv rau phau ntawv, ntawv, hlwb, tswj kav. Txhawm rau tiv thaiv lub cell los ntawm kev hloov pauv lossis nkag mus ntawm cov ntaub ntawv tsis raug rau nws, koj yuav tsum tig mus rau cov cuab yeej ntawm cov phiaj xwm.
Cov Lus Qhia
Kauj ruam 1
Txhawm rau tiv thaiv lub cell los ntawm nkag mus rau cov ntaub ntawv tsis raug, xaiv lub xov tooj ntawm koj xav tau lossis ntau hom. Mus rau ntawm Cov Ntaub Ntawv tab. Hauv seem "Ua haujlwm nrog cov ntaub ntawv", nyem rau ntawm khawm "Cov ntaub ntawv siv". Lub thawv "Tshaj Tawm Tswv Yim Tus Tsim Nyog Tshiab" qhib tshiab.
Kauj ruam 2
Ua kom "Parameters" tab ua kom nquag plias thiab teeb tsa cov hom ntaub ntawv uas raug tso cai nkag mus rau hauv lub xov tooj ntawm tes siv daim ntawv teev npe poob qis hauv pawg "Tshawb Xyuas". Yog tias tsim nyog, teeb tsa cov kev ntsuas ntxiv uas cov txiaj ntsig nkag mus rau hauv lub cell yuav raug ntsuas.
Kauj ruam 3
Ntawm Daim Ntawv Input Message thiab Error Message tabs, koj tuaj yeem nkag rau cov lus qhia los pab cov neeg siv kom nkag siab txog hom ntawv twg raug tso cai ntxiv cov ntaub ntawv rau hauv hlwb thiab sau cov ntawv qhia kom ceeb toom txog kev ua tsis raug. Tom qab ua tag nrho cov kev hloov tsim nyog, nyem rau lub khawm OK rau cov kev teeb tsa tshiab kom txais txiaj ntsig, "Qhov tseem ceeb ntawm nkag mus rau qhov tseem ceeb" qhov rai yuav kaw tau.
Kauj ruam 4
Txhawm rau tiv thaiv lub cell los ntawm kev hloov pauv, xaiv cov ntau yam koj xav tau thiab qhib lub "Tsev" tab. Hauv seem "ntawm tes", nyem rau ntawm pob "Format". Hloov mus, txoj nyem rau ntawm tus raug xaiv thiab xaiv hom Cell los ntawm cov ntawv qhia zaub mov. Lub thawv tshiab yuav qhib.
Kauj ruam 5
Txav mus rau "Kev Tiv Thaiv" tab thiab teeb tus cim rau hauv "Tiv Thaiv cell". Siv cov kev teeb tsa tshiab los ntawm nias lub khawm OK. Kev tiv thaiv ntawm tes yuav tsuas qhib yog tias txhua daim ntawv tau tiv thaiv.
Kauj Ruam 6
Kev tiv thaiv cov ntawv puas tau muab tso rau ntawm Tshab tab. Txav mus rau nws thiab nyem rau ntawm "Pov npav" khawm hauv seem "Hloov". Lub thawv tshiab yuav tshwm sim. Tso cov cim rau sab xub ntiag ntawm cov khoom uas koj pom zoo.
Kauj Ruam 7
Yog tias tsim nyog, sau tus password rau hauv kab sau rau qhov no thiab nyem khawm OK. Ib lub qhov rai ntxiv yuav tshwm, paub meej tus password uas koj nyuam qhuav nkag mus thiab nyem rau ntawm OK. Tom qab ntawd, thaum koj sim hloov lub cell, qhov kev zov me nyuam yuav ceeb toom rau tus neeg siv tias nws muaj kev tiv thaiv los ntawm kev hloov pauv.
