Xauv cov cell hauv Excel daim ntawv nthuav qhia tuaj yeem tiv thaiv kev hloov pauv los ntawm kev ua rau cov ntaub ntawv lossis cov qauv uas nyob hauv cov cell tshwj xeeb. Cov cell uas tau xauv thiab tiv thaiv tuaj yeem qhib tau txhua lub sijhawm los ntawm tus neeg siv uas pib xauv lub cell. Ua raws cov theem hauv qab no kom paub yuav xauv thiab tiv thaiv cov cell hauv Microsoft Excel versions 2010, 2007, thiab 2003.
Txhawm rau kawm paub yuav qhib lub cell li cas, nyeem kab lus Yuav Ua Li Cas Qhib Tus Password Tiv Thaiv Excel Cov Ntaub Ntawv.
Cov kauj ruam
Txoj Kev 1 ntawm 2: Xauv thiab Tiv Thaiv Cells hauv Excel 2007 thiab Excel 2010
Kauj Ruam 1. Qhib Excel daim ntawv uas muaj cov cell uas koj xav tau xauv
Kauj Ruam 2. Xaiv lub xovtooj lossis lub xovtooj uas koj xav kaw
Kauj Ruam 3. Txoj nyem rau ntawm cov cell, thiab xaiv "Format Cells
Kauj Ruam 4. Nyem rau ntawm lub tab uas sau tias "Kev Tiv Thaiv
Kauj Ruam 5. Tso tus cim rau hauv lub npov ze ntawm qhov kev xaiv uas hais tias "Xauv
Kauj Ruam 6. Nyem "OK
Kauj Ruam 7. Nyem rau ntawm lub tab uas sau tias "Txheeb Xyuas" nyob rau sab saud ntawm koj daim ntawv Excel
Kauj Ruam 8. Nyem rau lub pob ntawv sau tias "Tiv Thaiv Ntawv" los ntawm hauv pab pawg "Hloov"
Kauj Ruam 9. Muab tus cim kos rau ib sab ntawm "Tiv thaiv daim ntawv ua haujlwm thiab cov ntsiab lus ntawm cov xauv cell
Kauj ruam 10. Sau tus password rau hauv kab ntawv sau lo lus "Password to unprotect sheet
Kauj Ruam 11. Nyem rau "OK
Kauj Ruam 12. Rhais koj tus password rau hauv lub thawv ntawv sau tias "Rov nkag tus password nkag mus
Kauj Ruam 13. Nyem "OK
Cov cell uas koj tau xaiv tam sim no yuav raug kaw thiab tiv thaiv, thiab tsuas tuaj yeem qhib tau los ntawm kev xaiv cov cell ib zaug ntxiv, thiab nkag mus rau tus password uas koj tau xaiv.
Txoj Kev 2 ntawm 2: Xauv thiab Tiv Thaiv Cells: Excel 2003
Kauj Ruam 1. Qhib daim ntawv Excel uas muaj cov cell lossis cov cell koj xav kaw
Kauj Ruam 2. Xaiv ib lossis tag nrho cov cell uas koj xav tau xauv
Kauj Ruam 3. Txoj cai-nyem rau ntawm koj cov cell xaiv, thiab xaiv "Format Cells" los ntawm cov ntawv qhia zaub mov nco-down
Kauj Ruam 4. Nyem rau ntawm "Kev Tiv Thaiv" tab
Kauj Ruam 5. Muab tus cim rau ntawm ib sab ntawm daim teb uas hais tias "Xauv
Kauj Ruam 6. Nyem rau lub pob "OK"
Kauj Ruam 7. Nyem rau "Cov cuab yeej" ntawv qhia zaub mov nyob rau sab saum toj ntawm koj daim ntawv Excel
Kauj Ruam 8. Xaiv "Kev Tiv Thaiv" los ntawm cov npe xaiv
Kauj Ruam 9. Nyem rau "Tiv Thaiv Ntawv
Kauj Ruam 10. Muab tus cim kos rau ib sab ntawm qhov xaiv uas hais tias "Tiv thaiv daim ntawv thiab cov ntsiab lus ntawm cov xauv cell
Kauj Ruam 11. Ntaus tus password ntawm qhov hais kom sai rau "Password kom tiv thaiv daim ntawv," ces nyem "OK"
Kauj Ruam 12. Rov qab nkag koj tus password ntawm qhov hais kom sai rau "Rov nkag tus password nkag mus
Kauj Ruam 13. Xaiv "OK
Txhua lub cell uas koj xaiv tam sim no yuav raug xauv thiab tiv thaiv, thiab tsuas tuaj yeem qhib tau rau pem hauv ntej los ntawm kev xaiv lub xauv cell, thiab nkag mus rau tus password uas koj tau teeb tsa thaum pib.
Lub tswv yim
- Yog tias ntau tus neeg siv nkag mus rau koj daim ntawv Excel, 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, txiav txim siab kaw lossis tiv thaiv tag nrho cov ntawv, tom qab ntawd qhib ob peb lub cell uas tau tso cai hloov kho.