Kev ruaj ntseg thiab cov ntaub ntawv tiv thaiv yog ib qho ntawm cov lus qhia tseem ceeb ntawm txoj kev nthuav dav cov ntaub ntawv niaj hnub no. Qhov xwm txheej ntawm qhov teeb meem no tsis txo, tab sis tsuas yog hlob. Kev tiv thaiv cov ntaub ntawv tseem ceeb rau cov ntaub ntawv tabular, uas feem ntau khaws cov ntaub ntawv lag luam tseem ceeb. Cia peb kawm kom paub tiv thaiv Excel cov ntaub ntawv nrog ib lo lus zais.
Qhov chaw nyob password
Qhov kev pab cuam cov neeg tsim khoom tau paub zoo txog qhov tseem ceeb ntawm kev teeb tsa ib lo lus zais tshwjxeeb rau Excel cov ntaub ntawv, yog li lawv tau siv ntau hom kev hloov ntawm txoj haujlwm no ib zaug. Tib lub sijhawm, nws tseem tuaj yeem tsim teebmeem ob leeg rau kev qhib ib phau ntawv thiab hloov nws.
Method 1: Teem ib lo lus zais thaum txuag tau cov ntaub ntawv
Ib txoj kev yog los teeb ib lo lus zais ncaj qha thaum txuag tau ib qho Excel workbook.
- Mus rau lub tab "Cov Ntaub Ntawv" Excel cov kev pab cuam.
- Nias ntawm yam khoom "Tseg Rau".
- Nyob rau hauv lub qhib qhov rais ntawm txuag cov phau ntawv nias rau ntawm lub pob. "Kev pabcuam"nyob hauv qab. Hauv daim ntawv qhia zaub mov, xaiv qhov khoom "Cov kev xaiv dav ...".
- Lwm lub qhov rais qhib me me. Xwb rau hauv nws koj tuaj yeem qhia ib lo lus zais rau cov ntaub ntawv. Hauv teb "Lo lus zais qhib" Nkag mus rau lo lus tseem ceeb uas koj yuav tsum qhia kom meej thaum koj qhib phau ntawv. Hauv teb "Lo lus zais kom hloov" nkag mus rau qhov tseem ceeb uas yuav tsum nkag mus rau yog tias koj xav hloov cov ntaub ntawv no.
Yog tias koj xav kom koj cov ntaub ntawv tsis raug kho los ntawm cov neeg tsis muaj cai, tab sis koj xav tawm mus saib dawb, ces qhov no, nkag mus rau hauv tus password thawj zaug. Yog tias ob tus yuam sij raug teev, ces thaum qhib cov ntaub ntawv, koj yuav raug kev tso cai nkag mus rau ob qho tib si. Yog hais tias tus neeg siv tsuas paub thawj zaug ntawm lawv, ces tsuas yog nyeem ntawv thiaj muaj rau nws, tsis tas yuav kho cov ntaub ntawv. Theej, nws tuaj yeem kho txhua yam, tab sis tseg cov kev hloov no yuav tsis ua haujlwm. Koj tsuas yog txuag tau ua ib daim luam uas tsis hloov daim tseem ntawv.
Ntxiv mus, koj tuaj yeem zuam lub thawv "Pom zoo kom nyeem ntawv-tsuas nkag".
Tib lub sij hawm, txawm tias ib tug neeg siv leej twg paub ob lo lus password, cov ntaub ntawv tso cai yuav qhib tsis tau ib qhov toolbar. Tab sis, yog tias koj xav, nws tuaj yeem qhib qhov vaj huam sib luag los ntawm nias lub khawm sib thooj.
Tom qab tag nrho cov chaw nyob hauv qhov chaw dav dav tas lawm, nias ntawm lub pob "OK".
- Lub qhov rais qhib qhov chaw koj yuav tsum nkag rau qhov tseem ceeb dua. Qhov no yog ua kom paub tseeb tias tus neeg siv yuam kev ntawm thawj cov tswv yim tsis ua ib hom ntawv. Peb nias lub khawm "OK". Nyob rau hauv cov ntaub ntawv ntawm ib tug mismatch ntawm keywords, qhov kev pab cuam yuav muab nkag rau lo lus zais ntxiv dua.
- Tom qab qhov no, peb rov qab mus rau cov ntaub ntawv txuag qhov rais. Ntawm no koj tuaj yeem, yog tias koj xav, pauv nws lub npe thiab txiav txim xyuas cov npe uas nws yuav tsum tau nyob. Thaum tag nrho cov no ua tiav, nias ntawm lub pob. "Txuag".
Yog li peb tiv thaiv cov ntaub ntawv Excel. Tam sim no, qhib thiab hloov nws, koj yuav tsum nkag mus rau cov passwords sib txawv.
Method 2: Teem ib lo lus zais rau hauv "Cov Lus Qhia"
Qhov thib ob txoj kev yuav tsum teev ib lo lus zais rau hauv seem Excel. "Cov ntsiab lus".
- Zoo li lub sij hawm dhau los, mus rau lub tab "Cov Ntaub Ntawv".
- Hauv seem "Cov ntsiab lus" nyem rau ntawm lub pob "Tiv thaiv cov ntaub ntawv". Ib daim ntawv teev cov kev xaiv tau rau kev tiv thaiv nrog cov ntaub ntawv qhib opens. Raws li koj tuaj yeem pom, ntawm no koj tuaj yeem tiv thaiv tau tus password tsis yog cov ntaub ntawv tag nrho, tab sis kuj yog ib daim ntawv cais, thiab tseem nruab kev tiv thaiv rau cov qauv ntawm phau ntawv.
- Yog tias peb tsis xaiv qhov khoom "Encrypt nrog tus password", ces lub qhov rais yuav qhib rau qhov uas koj yuav tsum nkag mus rau lo lus tseem ceeb. Lo lus zais no sib raug rau qhov tseem ceeb rau kev qhib ib phau ntawv uas peb tau siv yav dhau los thaum khaws cov ntaub ntawv. Tom qab nkag mus rau cov ntaub ntawv nias ntawm lub pob "OK". Tam sim no tsis muaj leej twg qhib tau cov ntaub ntawv tsis paub txog qhov tseem ceeb.
- Thaum xaiv "Tiv thaiv daim ntawv tam sim no" Lub qhov rais yuav qhib nrog ntau qhov chaw. Kuj tseem muaj lub qhov rais nkag mus rau ib lo lus zais. Qhov cuab yeej no tso cai rau koj los tiv thaiv ib daim ntawv los ntawm kev kho. Nyob rau tib lub sijhawm, tsis zoo li tiv thaiv kev hloov ntawm kev txuag, qhov no nws tsis muab rau lub sijhawm txawm los tsim ib daim ntawv hloov ntawm daim ntawv. Tag nrho cov yeeb yam ntawm nws yog blocked, tab sis feem ntau cov phau ntawv yuav raug cawm dim.
Tus neeg siv yuav tuaj yeem tsim qhov teeb meem kev ruaj ntseg los ntawm kev kuaj lub checkboxes. Yog vim li cas, ntawm tag nrho cov kev ua rau ib tus neeg siv uas tsis muaj ib lo lus zais, tsuas yog xaiv ntawm tes yog muaj nyob rau hauv ib daim ntawv. Tab sis, tus neeg sau daim ntawv tuaj yeem tso cai, kev tso tawm thiab rho tawm cov kab thiab cov kab, kev cais, kev siv lub tshuab txiav, hloov cov khoom thiab cov ntawv sau, thiab lwm yam. Koj tuaj yeem tshem tawm kev tiv thaiv ntawm txhua qhov kev txiav txim. Tom qab teeb tsa lub tsev kawm ntawv khawm "OK".
- Thaum koj nias ntawm ib yam khoom "Tiv thaiv tus qauv ntawm phau ntawv" Koj tuaj yeem tsim tsa txoj kev ruaj ntseg ntawm daim ntawv. Cov chaw muab kev thaiv cov kev hloov hauv tus qauv, ob qho tib si nrog ib lo lus zais thiab tsis muaj nws. Hauv thawj rooj plaub, qhov no yog kev sib tiv thaiv tus neeg ruam, uas yog, los ntawm kev ua tsis tau. Nyob rau hauv rooj plaub thib ob, qhov no yog ib qho kev tiv thaiv tawm tsam kev hloov ntawm daim ntawv los ntawm lwm cov neeg siv.
Method 3: Teem ib lo lus zais thiab tshem tawm hauv "Kev Ntsuam Xyuas" tab
Lub peev xwm los tsim ib lo lus zais kuj muaj nyob rau hauv tab "Kev Tshawb Xyuas".
- Mus rau saum toj sau.
- Peb tab tom nrhiav ib ntu ntawm cov cuab yeej "Hloov" ntawm daim kab xev. Ndliv lub khawm "Tiv thaiv daim ntawv"los yog "Tiv thaiv phau ntawv". Cov nyees khawm no zoo ib yam li cov khoom. "Tiv thaiv daim ntawv tam sim no" thiab "Tiv thaiv tus qauv ntawm phau ntawv" hauv seem "Cov ntsiab lus", uas peb twb tau hais los saum no. Cov kev coj ua ntxiv kuj zoo ib yam.
- Kom tshem tawm ib lo lus zais, koj yuav tsum nias ntawm lub pob. "Tshem tawm kev tiv thaiv los ntawm daim ntawv" ntawm txoj kab thiab sau cov ntsiab lus tseem ceeb.
Raws li koj tau pom, Microsoft Excel muaj ob peb txoj kev los tiv thaiv cov ntaub ntawv nrog ib lo lus zais, ob qho tib si los ntawm kev txhob txwm ua hacking thiab kev ua txhaum kev ua haujlwm. Koj tuaj yeem tiv thaiv lo lus qhib ob phau ntawv thiab kev kho lossis hloov kho ntawm nws tus kheej cov khoom ua. Tib lub sijhawm, tus sau tau txiav txim rau nws tus kheej los ntawm qhov hloov nws xav kom pov hwm daim ntawv.
