Txhawm rau tiv thaiv kev tsis sib haum xeeb lossis txhob txwm hloov pauv rau cov ntaub ntawv muaj nyob hauv cov hlwb ntawm daim ntawv ua haujlwm lossis phau ntawv ua haujlwm, Excel muaj cov cuab yeej rau kev xauv qee cov ntawv ua haujlwm nrog lossis tsis muaj tus password.
Tiv thaiv cov ntaub ntawv los ntawm kev hloov pauv hauv Excel daim ntawv ua haujlwm yog txheej txheem ob kauj ruam.
- Kev xauv lossis qhib lub hlwb lossis cov khoom tshwj xeeb, xws li kab kos lossis duab, hauv daim ntawv ua haujlwm.
- Thov kev xaiv daim ntawv tiv thaiv; tag nrho cov ntawv ua haujlwm thiab cov ntaub ntawv yog qhov yooj yim hloov mus txog thaum koj ua qhov no.
Tiv thaiv cov ntawv ua haujlwm yuav tsum tsis txhob cuam tshuam nrog kev ruaj ntseg ntawm phau ntawv ua haujlwm, uas txwv tsis pub cov neeg siv qhib cov ntaub ntawv txhua.
Cov lus qhia hauv kab lus no siv rau Excel 2019, 2016, 2013, 2010, thiab 2007.
Xaiv thiab Xauv Cells
Los ntawm lub neej ntawd, txhua lub hlwb hauv Excel daim ntawv ua haujlwm raug kaw, uas ua rau nws yooj yim rau kev ruaj ntseg tag nrho cov ntaub ntawv thiab formatting hauv ib daim ntawv los ntawm kev siv cov ntawv tiv thaiv kev xaiv.
Txhawm rau tiv thaiv cov ntaub ntawv hauv txhua nplooj ntawv hauv phau ntawv ua haujlwm, koj yuav tsum siv daim ntawv tiv thaiv tus kheej. Xauv cov hlwb tshwj xeeb tso cai rau kev hloov pauv rau cov hlwb tsuas yog tom qab koj tau siv daim ntawv tiv thaiv / ntawv ua haujlwm xaiv.
Ib leeg lub hlwb tuaj yeem kaw lossis xauv siv Lock Cell toggle. Qhov kev xaiv no ua haujlwm zoo li hloov pauv, kaw lossis qhib lub xovtooj. Txij li thaum tag nrho cov hlwb tau pib kaw rau hauv daim ntawv ua haujlwm, nyem Xauv Cell yuav qhib tag nrho cov cell xaiv.
Cov hlwb hauv ib daim ntawv ua haujlwm yuav raug kaw kom cov neeg siv tuaj yeem ntxiv cov ntsiab lus tshiab lossis hloov kho cov ntaub ntawv uas twb muaj lawm. Cells uas muaj cov qauv los yog lwm cov ntaub ntawv tseem ceeb raug kaw kom ib zaug koj tau siv cov ntawv tiv thaiv / phau ntawv xaiv, tsis muaj leej twg tuaj yeem hloov cov hlwb no.
- Raws li piv txwv hauv Excel daim ntawv ua haujlwm, xaiv cov hlwb I6 rau J10.
- Click the Hometab.
- Click Format hauv Cells pab pawg kom qhib cov npe poob.
- Click Lock Cell nyob rau hauv qab ntawm daim ntawv teev npe.
- Lub hlwb tseem ceeb I6 rau J10 tau qhib tam sim no.
Xauv kab kos, Cov thawv ntawv, thiab cov duab
Los ntawm lub neej ntawd, tag nrho cov kab kos, lub thawv ntawv, thiab cov khoom siv duab xws li cov duab, kos duab, duab, thiab Smart Art, hauv daim ntawv ua haujlwm raug kaw thiab, yog li, tiv thaiv thaum xaiv daim ntawv tiv thaiv raug siv.
Kom tso cov khoom no xauv kom cov neeg siv tuaj yeem hloov kho lawv ib zaug koj tau tiv thaiv daim ntawv:
- Xaiv qhov khoom koj xav qhib.
-
Click the Format tab.
Image IMAGE CALLOUT: MENYUAM QAB NTAWM QHOV TSEEB NTAWM LUB SIJ HAWM NTAWM LUB SIJ HAWM NTAWM LUB NTAWV
-
In the Size pab pawg nyob rau sab xis ntawm txoj kab, nyem lub dialog box launcher khawm (me down xub rau sab xis hauv qab) ntawm lo lus Size txhawm rau qhib lub hom phiaj ua haujlwm pane (Format Picture dialog box hauv Excel 2010 thiab 2007)
Image IMAGE CALLOUT: LOCKED CHECKBOX ntawm hauv qab txoj cai
- Nyob rau hauv Properties ntu ntawm lub luag haujlwm pane, uncheck lub Locked kos lub thawv, thiab yog tias nquag uncheck lub Xauv ntawvcheck box.
Thov Kev Tiv Thaiv Daim Ntawv Xaiv
Kauj ruam thib ob hauv cov txheej txheem, tiv thaiv tag nrho cov ntawv ua haujlwm, siv lub thawv tiv thaiv daim ntawv, uas muaj cov kev xaiv uas txiav txim siab seb cov ntsiab lus twg cov neeg siv tuaj yeem hloov pauv hauv daim ntawv nthuav qhia.
Cov ntsiab lus no suav nrog:
- Ntxiv tus password kom tswj tau leej twg tuaj yeem tua daim ntawv tiv thaiv tawm.
- Xaiv xauv thiab xauv lub hlwb.
- Editing, txav lossis tshem tawm cov ntaub ntawv.
- Ntxiv / tshem tawm kab thiab kab.
- Nkag los tsis nkaum kab thiab kab.
- Hloov tus lej formatting, xws li cov cim txiaj, cov cim feem pua, tus lej lej, thiab lwm yam.
- Hloov cell formatting, xws li hloov cell lossis font xim, hloov cov ntawv wrapping, ntxiv thiab tshem ciam teb, thiab lwm yam.
Ntxiv tus password ntawm no tsis txwv cov neeg siv los qhib daim ntawv ua haujlwm thiab saib cov ntsiab lus.
Yog tias cov kev xaiv uas tso cai rau tus neeg siv los qhia txog lub kaw lus kaw thiab kaw lub hlwb raug kaw, cov neeg siv yuav tsis tuaj yeem hloov pauv rau daim ntawv ua haujlwm, txawm tias nws muaj cov cell xauv.
Txoj kev xaiv ntxiv, xws li formatting cell thiab txheeb cov ntaub ntawv, tsis yog txhua yam ua haujlwm zoo ib yam. Piv txwv li, yog tias qhov hom kab mobkev xaiv raug kuaj tawm thaum koj tiv thaiv ib daim ntawv, tag nrho cov hlwb tuaj yeem tsim tau.
The sort kev xaiv, ntawm qhov tod tes, tso cai xaiv cov hlwb uas tau xauv ua ntej koj tiv thaiv daim ntawv.
- Xaiv lossis xauv lub hlwb xav tau hauv daim ntawv ua haujlwm.
- Click on the Hometab.
- Click Format ntawm tus ribbon qhib cov npe poob.
-
Click Protect Sheet nyob rau hauv qab ntawm daim ntawv los qhib daim ntawv tiv thaiv dialog box.
Image - Kos lossis tshem tawm cov kev xaiv uas xav tau.
- Click OK txhawm rau kaw lub thawv sib tham thiab tiv thaiv daim ntawv ua haujlwm.
Tig tawm daim ntawv tiv thaiv
Nws yooj yim los tiv thaiv daim ntawv ua haujlwm kom koj tuaj yeem hloov kho txhua lub hlwb.
- Click the Hometab.
-
Click Format ntawm tus ribbon qhib cov npe poob.
Image - Click Unprotect Sheet nyob rau hauv qab ntawm daim ntawv kom tsis txhob tiv thaiv daim ntawv.
Kev tiv thaiv daim ntawv ua haujlwm tsis hloov lub xeev ntawm cov xauv lossis xauv lub hlwb.
