Yuav ua li cas muab tus password rau ntawm cov ntaub ntawv Excel

Kev Nyab Xeeb thiab Kev Tiv Thaiv Cov Ntaub Ntawv yog ib qho ntawm cov lus qhia tseem ceeb rau kev txhim kho cov ntaub ntawv tam sim no. Qhov tseeb ntawm cov teeb meem no tsis raug txo, tab sis tsuas yog loj hlob. Tshwj xeeb tshaj cov ntaub ntawv tseem ceeb cov ntaub ntawv rau cov ntaub ntawv cov ntaub ntawv nyob rau hauv uas cov ntaub ntawv tseem ceeb feem ntau khaws cia hauv cov ntaub ntawv lag luam. Cia peb paub yuav ua li cas tiv thaiv Excel cov ntaub ntawv siv tus password.

Txhim kho tus password

Cov program tsim tau txig qhov tseem ceeb ntawm kev txhim kho tus password rau cov ntaub ntawv Excel, yog li muaj ntau txoj kev xaiv rau ua cov txheej txheem no ib zaug. Nyob rau tib lub sijhawm, nws yog qhov ua tau los tsim tus yuam sij, ob qho tib si ntawm qhib phau ntawv thiab ntawm nws hloov.

Txoj kev 1: Teeb tus password thaum txuag cov ntaub ntawv

Ib txoj kev cuam tshuam nrog teeb lo lus zais ncaj qha thaum txuag Excel phau ntawv.

1. Mus rau "File" tab ntawm Excel Program.



2. Nyem rau "Txuag li".



3. Nyob rau hauv lub qhov rais uas qhib, peb nyem rau ntawm "Kev Pabcuam" khawm, nyob rau hauv qab heev. Hauv cov zaub mov uas pom, xaiv "cov kev tsis sib xws ...".



4. Lwm qhov chaw me me qhib. Tsuas yog hauv nws, koj tuaj yeem qhia tau ib tus password rau cov ntaub ntawv. Hauv "lo lus zais rau qhib" teb, peb sau cov lus tseem ceeb uas yuav xav paub thaum qhib phau ntawv. Hauv "password los hloov" teb, sau tus yuam sij kom nkag mus yog tias koj xav tau hloov cov ntaub ntawv no.

   Yog tias koj xav kom koj cov ntaub ntawv yuav tau kho cov neeg tsis tau muab kev cai, tab sis koj xav kom tawm mus saib dawb, nkag mus rau qhov no password. Yog tias ob tus yuam sij tau teev tseg, tom qab ntawd thaum koj qhib cov ntaub ntawv, koj yuav tau kev tshoov siab kom nkag mus ob qho tib si. Yog tias tus neeg siv tsuas paub thawj ntawm ib qho ntawm lawv, tom qab ntawd nws yuav muaj tsuas yog nyeem xwb, yam tsis muaj peev xwm hloov cov ntaub ntawv. Theej, nws yuav muaj peev xwm hloov kho txhua yam, tab sis nws yuav tsis muaj peev xwm txuag cov kev hloov pauv no. Nws tsuas yog tau txais kev cawmdim nyob rau hauv daim ntawv ntawm ib daim theej yam tsis tau hloov cov ntaub ntawv pib.

   Ib qho ntxiv, koj tuaj yeem muab tus zuam hais txog qhov "pom zoo nyeem nkaus xwb" yam khoom.

   Nyob rau tib lub sijhawm, txawm tias rau tus neeg siv uas paub ob tus password, cov ntaub ntawv ua ntej yuav qhib tsis muaj cuab yeej. Tab sis, yog tias xav tau, nws yuav tsum qhib lub vaj huam sib luag no los ntawm nias lub khawm uas tsim nyog.

   Tom qab txhua qhov chaw nyob hauv qhov chaw nres tsheb uas ib txwm muaj, nyem rau ntawm "OK" khawm.



5. Lub qhov rai qhib qhov twg koj xav nkag mus rau qhov tseem ceeb dua. Qhov no yog ua kom ntseeg tau tias tus neeg siv tau yuam kev thaum xub thawj nkag mus. Nyem rau ntawm "OK" khawm. Thaum tsis nkag ntawm cov ntsiab lus tseem ceeb, qhov kev zov me nyuam yuav muaj los sau tus password dua.



6. Tom qab ntawd, peb rov qab los rau cov ntaub ntawv txuag lub qhov rai dua. Ntawm no, yog tias koj xav tau, hloov nws lub npe thiab txiav txim siab cov ntawv sau tseg uas nws yuav yog. Thaum txhua yam no ua tiav, nyem rau ntawm "Tseg" khawm.

Yog li peb tiv thaiv cov ntaub ntawv Excel. Tam sim no nws yuav siv tus password uas tsim nyog qhib thiab kho nws.

Txoj kev 2: Teeb tus password hauv "cov ntsiab lus"

Qhov thib ob txoj kev cuam tshuam cov kev teeb tsa ntawm tus password nyob rau hauv Excel "cov ntsiab lus" ".

1. Raws li lub sijhawm kawg, mus rau "File" tab.
2. Nyob rau hauv "cov ntsiab lus", nyem rau ntawm "tiv thaiv cov ntaub ntawv" khawm. Daim ntawv teev cov kev xaiv muaj peev xwm rau kev tiv thaiv ntawm cov ntaub ntawv tseem ceeb qhib. Raws li koj tuaj yeem pom, koj tuaj yeem tiv thaiv tus password tsis yog cov ntaub ntawv uas yog tag nrho, tab sis kuj tseem tsim kev tiv thaiv los hloov pauv ntawm phau ntawv.



3. Yog tias peb tsum tsis xaiv ntawm "Encipat Password" khoom, lub qhov rai yuav qhib nyob rau hauv uas cov ntsiab lus yuav tsum tau nkag mus. Tus password no tau raws li tus yuam sij qhib phau ntawv uas peb tau siv nyob rau hauv cov txheej txheem dhau los thaum txuag ib cov ntaub ntawv. Tom qab nkag mus rau cov ntaub ntawv, nias lub "OK" khawm. Tam sim no, tsis paub tus yuam sij, cov ntaub ntawv tsis muaj leej twg qhib tau.



4. Thaum koj xaiv "tiv thaiv cov ntawv tam sim no" khoom, lub qhov rais yuav qhib nrog ntau ntawm cov chaw. Kuj tseem muaj tus password nkag lub qhov rai. Cov cuab yeej no tso cai rau koj los tiv thaiv cov ntawv tshwj xeeb los ntawm kev kho kom raug. Nyob rau tib lub sijhawm, nyob rau hauv kev sib piv kom muaj kev tiv thaiv kev hloov pauv, hom no tsis muaj kev muaj peev xwm los tseem tsim cov ntawv hloov kho. Txhua qhov kev ua yog thaiv ntawm nws, txawm tias nyob rau hauv phau ntawv tuaj yeem txuag tau.

   Chaw rau cov qib kev tiv thaiv tus neeg siv tuaj yeem tsim nws tus kheej, ua rau cov checkboxes ntawm cov khoom muaj. Los ntawm lub neej ntawd, los ntawm txhua qhov kev nqis tes ua rau tus neeg siv uas tsis muaj tus password, muaj nyob ntawm ib daim ntawv tsuas yog xaiv cov hlwb xwb. Tab sis, tus sau daim ntawv ntawm daim ntawv tuaj yeem tso cai ua qauv, ntxig kab thiab tshem tawm, txheeb, hloov cov khoom autofilter, hloov pauv ntawm cov khoom thiab cov ntawv sau, thiab lwm yam. Koj tuaj yeem tshem tawm kev tiv thaiv nrog yuav luag txhua yam kev ua. Tom qab teeb tsa cov chaw, nyem rau ntawm "OK" khawm.



5. Thaum koj nyem rau ntawm "tiv thaiv qauv ntawm phau ntawv" Yam khoom, koj tuaj yeem tsim kev tiv thaiv ntawm cov qauv ntawm daim ntawv. Cov chaw muab thaiv ntawm kev hloov pauv ntawm cov qauv, ob qho nrog lo lus zais thiab tsis muaj nws. Hauv thawj kis, qhov no yog qhov thiaj li hu ua "ruam tiv thaiv", uas yog, los ntawm kev ua tsis tau zoo. Hauv qhov rooj plaub thib ob, qhov no twb tau tiv thaiv los ntawm cov ntaub ntawv xaiv tau hloov los ntawm lwm cov neeg siv.

Txujcum 3: Txhim kho ntawm tus password thiab nws qhov kev tshem tawm hauv "Kev Ntsuam Xyuas" Tab

Lub peev xwm los nruab tus password tsis muaj nyob rau hauv "Kev Ntsuam Xyuas" tab.

1. Mus rau saum toj no tab.



2. Peb tab tom nrhiav kev hloov pauv hloov ntawm daim kab xev. Nyem rau ntawm "Tiv thaiv nplooj" khawm, lossis "tiv thaiv phau ntawv". Cov nyees khawm no tau ua tiav nrog cov khoom "tiv thaiv cov ntawv tam sim no" thiab "tiv thaiv tus qauv ntawm phau ntawv" hauv tshooj "" uas peb twb tau hais los saud. Cov kev coj ua txuas ntxiv kuj zoo sib xws.



3. Txhawm rau tshem tawm lo lus zais, koj yuav tsum nyem rau ntawm "hle nplooj tiv thaiv" khawm ntawm daim kab xev thiab sau cov ntsiab lus tsim nyog.

Raws li koj tuaj yeem pom, Microsoft Excel muaj ntau txoj hauv kev los tiv thaiv cov ntaub ntawv nrog tus password, ob qho tib si los ntawm kev ua tsis zoo. Koj tuaj yeem dhau los ntawm kev qhib phau ntawv thiab kho lossis hloov nws cov qauv txheej txheem tus qauv. Nyob rau tib lub sijhawm, tus kws sau ntawv tuaj yeem txiav txim siab nws tus kheej, los ntawm kev hloov uas nws xav tiv thaiv daim ntawv.