Xauv cov cell hauv Excel daim ntawv nthuav qhia (daim ntawv ua haujlwm) tiv thaiv kev hloov pauv ntawm cov ntaub ntawv lossis cov qauv hauv ib lub xovtooj. Lub xauv thiab tiv thaiv xov tooj ntawm tes tuaj yeem qhib tau txhua lub sijhawm los ntawm tus neeg siv uas xub tau xauv nws. Ua raws cov theem hauv qab no kom paub yuav xauv thiab tiv thaiv cov cell hauv Microsoft Excel versions 2010, 2007, thiab 2003.
Kauj ruam
Txoj Kev 1 ntawm 2: Excel 2007 thiab Excel 2010
Kauj Ruam 1. Qhib daim ntawv Excel uas muaj cov cell uas koj xav xauv
Kauj Ruam 2. Xaiv ib lossis ntau lub cell uas koj xav xauv
Kauj Ruam 3. Txoj nyem rau ntawm tes, tom qab ntawd xaiv Hom Ntawv Cells
Kauj Ruam 4. Nyem rau tab uas sau tias Kev Tiv Thaiv
Kauj Ruam 5. Kos rau lub npov uas nyob ib sab ntawm qhov kev xaiv uas sau tias Xauv
Kauj Ruam 6. Nyem OK
Kauj Ruam 7. Nyem rau ntawm daim ntawv sau tshuaj xyuas nyob rau sab saud ntawm daim ntawv Excel
Kauj Ruam 8. Nyem rau lub pob ntawv sau Cov Ntawv Tiv Thaiv los ntawm Pab Pawg Hloov
Kauj Ruam 9. Txheeb xyuas daim ntawv ua haujlwm thiab cov ntsiab lus ntawm cov xauv cell
Kauj Ruam 10. Sau tus password rau hauv lub thawv ntawv sau lo lus zais kom tiv thaiv daim ntawv
Kauj ruam 11. Nyem OK
Kauj Ruam 12. Rhais tus password rau hauv lub npov ntawv sau tias Reenter password nkag mus
Kauj Ruam 13. Nyem OK
Tam sim no cov cell uas tau xaiv yuav raug xauv thiab tiv thaiv, thiab tsuas tuaj yeem qhib tau los ntawm kev xaiv lub cell dua, thiab tom qab ntawd nkag mus rau tus password xaiv.
Txoj kev 2 ntawm 2: Excel 2003
Kauj Ruam 1. Qhib daim ntawv Excel uas muaj ib lossis ntau lub cell uas koj xav xauv
Kauj Ruam 2. Xaiv ib lossis tag nrho cov cell koj xav kaw
Kauj Ruam 3. Txoj cai-nias rau ntawm cov cell xaiv thiab xaiv Format Cells los ntawm cov ntawv qhia zaub mov nco-down
Kauj Ruam 4. Nyem rau Kev Tiv Thaiv tab
Kauj Ruam 5. Zuam ib sab ntawm kab ntawv sau npe Xauv
Kauj Ruam 6. Nyem rau OK khawm
Kauj Ruam 7. Nyem rau Cov cuab yeej ntawv qhia zaub mov nyob rau sab saud ntawm daim ntawv Excel
Kauj Ruam 8. Xaiv Kev Tiv Thaiv los ntawm cov npe xaiv
Kauj Ruam 9. Nyem rau Daim Ntawv Tiv Thaiv
Kauj Ruam 10. Zuam ib sab ntawm qhov xaiv uas hais tias Tiv thaiv daim ntawv ua haujlwm thiab cov ntsiab lus ntawm cov xauv cell
Kauj Ruam 11. Ntaus tus password hauv kab lus "Password to unprotect sheet" uas tshwm, ces nyem OK
Kauj Ruam 12. Nkag mus rau lo lus zais hauv "Reenter password to proceed" teb uas tshwm
Kauj Ruam 13. Xaiv OK. Txhua lub cell xaiv tam sim no yuav raug xauv thiab tiv thaiv, thiab tsuas tuaj yeem qhib tom qab los ntawm kev xaiv lub xauv cell, thiab nkag mus rau tus password uas koj tau teeb tsa ua ntej.
Lub tswv yim
- Yog tias ntau tus neeg siv nkag mus rau Excel daim ntawv, xauv txhua lub cell uas muaj cov ntaub ntawv tseem ceeb lossis cov qauv nyuaj los tiv thaiv cov cell los ntawm kev hloov pauv.
- Yog tias feem ntau ntawm cov cell hauv koj daim ntawv Excel muaj cov ntaub ntawv muaj txiaj ntsig lossis cov qauv nyuaj, nws yog lub tswv yim zoo los xauv lossis tiv thaiv tag nrho cov ntawv, thiab tom qab ntawd qhib qee lub cell uas tau tso cai hloov pauv.
