Kev nyab xeeb thiab tiv thaiv ntaub ntawv yog ib qho ntawm lub ntsiab lus ntawm kev txhim kho ntawm cov ntaub ntawv siv thev naus laus zis. Qhov tseeb ntawm cov teeb meem no tsis txo qis, tab sis tsuas yog nce zuj zus. Cov ntaub ntawv tiv thaiv yog qhov tshwj xeeb tshaj yog rau cov ntaub ntawv cov ntaub ntawv, uas feem ntau khaws cov ntaub ntawv ua lag luam tseem ceeb. Cia peb kawm paub yuav tiv thaiv Excel cov ntaub ntawv nrog tus password.
Chaw rau tus password
Cov neeg tsim tawm ntawm txoj haujlwm tau nkag siab meej txog qhov tseem ceeb ntawm kev muaj peev xwm los tsim tus password rau Excel cov ntaub ntawv, yog li ntawd, lawv tau siv ntau txoj hauv kev rau kev ua cov txheej txheem no ib zaug. Nyob rau tib lub sijhawm, nws muaj peev xwm muab tus yuam sij, ob qho tib si rau kev qhib phau ntawv thiab rau kev hloov pauv.
Txoj Kev 1: teev tus password thaum txuag ntawv
Ib txoj hauv kev yog los tsim tus password ncaj qha thaum txuag Excel phau ntawv.
- Mus rau hauv lub tab Cov ntaub ntawv Cov kev pab cuam Excel.
- Nyem rau ntawm yam khoom ntawd Txuag Raws Li.
- Hauv qhov rai uas qhib, khaws cov phau ntawv, nyem rau lub pob "Kev pabcuam"nyob rau hauv qab heev. Hauv cov ntawv qhia zaub mov uas tshwm, xaiv "Kev xaiv dav dav ...".
- Lwm lub qhov rais me me qhib. Tsuas yog hauv nws koj tuaj yeem sau tus password rau cov ntawv. Hauv dab teb "Tus lej qhib rau" sau cov lo lus tseem ceeb uas koj yuav tsum tau qhia kom meej thaum qhib phau ntawv. Hauv dab teb "Lo lus zais hloov" sau tus yuam sij uas yuav nkag mus yog tias koj xav tau hloov cov ntaub ntawv no.
Yog tias koj xav tiv thaiv cov neeg sab nraud los kho koj cov ntawv, tab sis xav kom tawm mus saib dawb, tom qab ntawv no, nkag rau thawj tus password xwb. Yog tias ob tus yuam sij tau teev tseg, tom qab ntawd thaum koj qhib lub ntawv, koj yuav xav kom nkag mus rau ob qho tib si. Yog tias tus neeg siv paub thawj zaug ntawm lawv, tsuas yog nyeem ntawv thiaj li muaj rau nws, yam tsis muaj peev xwm hloov kho cov ntaub ntawv. Es nws tuaj yeem hloov kho ib qho twg, tab sis txuag cov kev hloov no yuav tsis ua haujlwm. Koj tsuas tuaj yeem khaws ua daim ntawv theej xwb tsis hloov daim tseem.
Ntxiv rau, koj tuaj yeem tshawb xyuas lub npov nyob ze "Xav kom nyeem nkaus xwb".
Hauv qhov no, txawm tias tus neeg siv uas paub ob lo lus zais, cov ntawv yuav qhib los ntawm lub neej ntawd yam tsis muaj daim ntawv qhia. Tab sis, yog tias xav tau, nws yuav ib txwm muaj peev xwm qhib tau lub vaj huam sib luag no los ntawm nias lub pob khawm kom raug.
Tom qab tag nrho cov chaw nyob hauv cov chaw teeb tsa dav dav tau ua tiav, nyem rau ntawm lub pob "OK".
- Lub qhov rais qhib qhov twg koj xav tau nkag mus rau tus yuam sij dua. Qhov no ua tiav kom tus neeg siv tsis ua txhaum thawj thawj zaug ntaus ntawv yuam kev tshwm sim. Nyem rau feem khawm "OK"Cov. Yog tias cov ntsiab lus tsis sib thooj, cov phiaj xwm yuav ua rau koj nkag mus nkag tus password dua.
- Tom qab ntawd, peb rov qab mus rau hauv cov ntaub ntawv txuag qhov rai. Ntawm no koj tuaj yeem tuaj yeem hloov nws lub npe thiab txiav txim siab qhov chaw nws yuav nyob qhov twg. Thaum tag nrho cov no ua tiav, nyem rau ntawm lub pob Txuag.
Yog li, peb tiv thaiv Excel daim ntawv. Tam sim no, los qhib thiab kho nws, koj yuav tsum sau tus password kom tsim nyog.
Txoj Kev 2: teev tus lej cim hauv seem "Cov Lus Qhia"
Qhov txheej txheem thib ob cuam tshuam kev teeb tus password hauv Excel ntu "Cov ntsiab lus".
- Zoo li lub sijhawm dhau los, mus rau ntawm lub tab Cov ntaub ntawv.
- Hauv seem "Cov ntsiab lus" nyem rau ntawm lub pob Tiv Thaiv Cov Ntaub NtawvCov. Cov npe ntawm cov kev tiv thaiv tau xaiv nrog ib tus yuam sij ua ntawv qhib. Raws li koj tuaj yeem pom, ntawm no koj tuaj yeem tiv thaiv password tsis tsuas yog cov ntaub ntawv tag nrho, tab sis kuj tseem cais lwm daim ntawv, nrog rau tsim kev tiv thaiv rau kev hloov cov qauv ntawm phau ntawv.
- Yog peb tsum hauv "Encrypt nrog lo lus zais", lub qhov rai yuav qhib uas koj yuav tsum sau cov ntsiab lus. Lo lus zais no sib raug nrog tus yuam sij rau kev qhib phau ntawv, uas peb tau siv hauv cov qauv dhau los thaum txuag cov ntaub ntawv. Tom qab nkag mus rau cov ntaub ntawv, nyem rau ntawm lub pob "OK"Cov. Tam sim no, yam tsis paub txog tus yuam sij, tsis muaj leej twg tuaj yeem qhib cov ntaub ntawv.
- Thaum xaiv ib yam Tiv Thaiv Daim Ntawv Tam Sim No lub qhov rai uas muaj ntau lub chaw yuav qhib. Tseem muaj qhov rais rau kev nkag tus password. Cov cuab yeej no tso cai rau koj los tiv thaiv ib daim ntawv tshwj xeeb los ntawm kho kom raug. Nyob rau tib lub sijhawm, hauv kev sib piv rau kev tiv thaiv los tiv thaiv kev hloov pauv los ntawm txuag, hom no tsis tseem muaj peev xwm los tsim daim ntawv hloov ntawm daim ntawv. Txhua yam kev ua ntawm nws tau sim, txawm hais tias feem ntau ib phau ntawv tuaj yeem raug cawm.
Tus neeg siv tau tuaj yeem teeb tsa qib siab ntawm kev tiv thaiv nws tus kheej los ntawm kev zuam cov khoom sib xws. Los ntawm lub neej ntawd, ntawm txhua qhov haujlwm rau tus neeg siv uas tsis muaj tus password, tsuas yog xaiv cov hlwb muaj nyob rau ntawm daim ntawv xwb. Tab sis, tus sau daim ntawv tuaj yeem tso cai rau hom, ntxig thiab tshem tawm cov kab thiab cov kab, cais tawm, thov ib qho autofilter, hloov cov khoom thiab cov ntawv sau, thiab lwm yam. Koj tuaj yeem tshem tawm kev tiv thaiv los ntawm yuav luag txhua qhov haujlwm. Tom qab teeb tsa lub chaw, nyem rau lub pob "OK".
- Thaum koj nyem rau ntawm ib yam khoom "Tiv thaiv cov qauv ntawm phau ntawv" Koj tuaj yeem tsim kev tiv thaiv ntawm cov ntawv sau qauv. Cov chaw muab rau thaiv cov qauv hloov, ob leeg nrog tus password thiab tsis muaj nws. Hauv thawj kis, qhov no yog qhov hu ua "kev tiv thaiv los ntawm lub ruam," uas yog, los ntawm qhov tsis ua raws li kev ua. Hauv rooj plaub thib ob, qhov no yog kev tiv thaiv tiv thaiv txhob txwm hloov rau daim ntawv los ntawm lwm tus neeg siv.
Txoj Kev 3: Teev tus password thiab muab nws tshem tawm hauv "Rov Xyuas"
Lub peev xwm los teev tus password tseem muaj nyob hauv lub tab "Ntsuam Xyuas".
- Mus rau saum toj no tab.
- Peb tab tom nrhiav lub cuab yeej thaiv "Hloov" ntawm daim kab xev Nyem rau feem khawm Tiv Thaiv Cov Ntawv, lossis Tiv Thaiv Phau NtawvCov. Cov khawm no zoo ib yam nkaus nrog cov khoom Tiv Thaiv Daim Ntawv Tam Sim No thiab "Tiv thaiv cov qauv ntawm phau ntawv" hauv seem "Cov ntsiab lus"uas peb tau hais los saum no. Cov kev nqis tes ua ntxiv los kuj tseem zoo sib xws.
- Txhawm rau tshem tawm tus password, koj yuav tsum nias rau pob "Tshem tawm kev tiv thaiv los ntawm cov ntawv" ntawm txoj hlua thiab sau cov ntsiab lus tsim nyog.
Raws li koj tuaj yeem pom, Microsoft Excel muaj ntau txoj hauv kev los tiv thaiv cov ntawv nrog tus password, ob qho tib si los ntawm kev txhob txwm ua txhaum thiab los ntawm kev ua txhaum yam tsis tau xav txog. Koj muaj peev xwm lo lus zais tiv thaiv ob qho tib si qhib phau ntawv thiab kho los yog hloov nws ib tug yam ntxwv yam ntxwv. Hauv qhov xwm txheej no, tus kws sau ntawv tuaj yeem txiav txim siab rau nws tus kheej tias nws xav hloov dab tsi los tiv thaiv daim ntawv los ntawm.
