Kev tiv thaiv tsis tau daim ntawv Excel

Txhim kho qhov kev tiv thaiv ntawm cov ntaub ntawv Excel yog qhov zoo rau kev tiv thaiv koj tus kheej, ob leeg los ntawm kev nkag los thiab los ntawm koj tus kheej ua txhaum. Qhov teeb meem yog tias tsis yog txhua tus neeg siv paub yuav ua li cas qhib, yog tias tsim nyog, tuaj yeem hloov kho phau ntawv lossis txawm tias tsuas yog saib nws cov ntsiab lus. Cov lus nug tseem ceeb dua yog tias lo lus zais tsis tau tsim los ntawm tus neeg siv nws tus kheej, tab sis los ntawm lwm tus neeg uas kis tau tus lej lus, tab sis tus neeg siv tsis paub yuav tsis paub siv nws li cas. Ib qho ntxiv, muaj mob ntawm lo lus zais poob. Cia peb kawm seb koj tuaj yeem tshem tawm kev tiv thaiv los ntawm daim ntawv Excel yog tias tsim nyog.

Tshooj: Yuav ua li cas tshem tawm kev tiv thaiv los ntawm Microsoft Word cov ntaub ntawv

Cov Tswv Yim Xauv

Muaj ob hom Excel cov ntaub ntawv lub npe: phau ntawv tiv thaiv thiab cov ntawv tiv thaiv. Raws li, qhov kev xauv lub ntsiab lus tseem ceeb yog nyob ntawm hom kev tiv thaiv twg tau xaiv.

Txoj Kev 1: qhib phau ntawv

Ua ntej tshaj plaws, nrhiav kom paub tshem cov kev tiv thaiv los ntawm phau ntawv.

1. Thaum koj sim khiav lub Excel tiv thaiv cov ntaub ntawv, lub qhov rais me me qhib kev nkag mus rau ib lo lus code. Peb tsis tuaj yeem qhib phau ntawv kom txog thaum peb taw tes nws. Yog li, sau tus password rau hauv daim ntawv tsim nyog. Nyem rau khawm "OK".



2. Tom qab ntawv, phau ntawv qhib. Yog tias koj xav tshem tawm kev tiv thaiv suav daws, tom qab ntawd mus rau ntawm lub tab Cov ntaub ntawv.



3. Peb hloov mus rau ntu "Cov ntsiab lus"Cov. Hauv nruab nrab ntawm lub qhov rais, nias kom khawm Tiv Thaiv Phau NtawvCov. Hauv daim ntawv qhia zaub mov xaiv, xaiv "Encrypt nrog lo lus zais".



4. Ib zaug ntxiv lub qhov rais qhib nrog txoj cai hais lus. Tsuas yog muab lwv tawm lo lus zais los ntawm cov chaw nkag mus thiab nyem rau khawm "OK"



5. Khaws cov ntaub ntawv pauv hloov los ntawm kev mus rau ntawm lub tab "Tsev" los ntawm txhaj rau lub pob Txuag nyob rau hauv daim ntawv ntawm diskette nyob rau sab saud sab sauv ntawm lub qhov rais.

Tam sim no thaum koj qhib phau ntawv, koj yuav tsis tas sau tus password thiab nws yuav tsis muaj kev tiv thaiv lawm.

Tshooj: Yuav muab tus password li cas rau hauv Excel

Txoj Kev 2: Txhob Xa Ntawv

Ib qho ntxiv, koj tuaj yeem tsim tus password rau lwm daim ntawv. Tib lub sijhawm, koj tuaj yeem qhib phau ntawv thiab txawm pom cov ntaub ntawv ntawm lub hnab ntawv kaw, tab sis koj yuav tsis tuaj yeem hloov kho cov hlwb nyob hauv. Thaum koj sim kho, cov lus pom hauv lub thawv ntawv qhia koj tias lub xovtooj ntawm tiv thaiv los ntawm kev hloov pauv.

Txhawm rau txhawm rau kho tau thiab kom tshem tawm kev tiv thaiv tawm ntawm daim ntawv, koj yuav tsum tau ua yeeb yaj kiab.

1. Mus rau hauv lub tab "Ntsuam Xyuas"Cov. Ntawm txoj hlua rau ntawm pob khawm "Hloov" nyem rau ntawm lub pob "Tshem tawm cov ntawv tiv thaiv".



2. Lub qhov rais qhib hauv qhov chaw uas koj xav sau nkag mus lo lus zais. Nyem ntawd tag khawm "OK".

Tom qab ntawd, kev tiv thaiv yuav raug tshem tawm thiab tus neeg siv yuav tuaj yeem hloov kho ntawm cov ntawv. Txhawm rau tiv thaiv daim ntawv ntxiv, koj yuav tsum teeb tsa nws tiv thaiv dua.

Tshooj: Yuav ua li cas tiv thaiv ib lub xovtooj ntawm hloov pauv hauv Excel

Txoj Kev 3: tshem tawm kev tiv thaiv los ntawm kev hloov pauv cov ntaub ntawv

Tab sis, qee zaum muaj qee lub sijhawm thaum tus neeg siv tau muab daim ntawv zais nrog tus password, thiaj li tsis yog yuam kev hloov rau nws, tab sis tsis nco qab txog tus cipher. Nws yog doubly poob siab tias, raws li txoj cai, cov ntaub ntawv nrog cov ntaub ntawv muaj txiaj ntsig tau encoded thiab poob ib lo lus zais rau lawv tuaj yeem tsim nqi ntau rau cov neeg siv. Tab sis, muaj ib txoj kev tawm ntawm qhov xwm txheej no. Muaj tseeb, koj yuav tsum tinker nrog cov ntawv sau code.

1. Yog tias koj cov ntawv muaj qhov txuas ntxiv xlsx (Excel ntawv ua haujlwm), tom qab ntawd mus ncaj rau kab lus thib peb ntawm kev qhia. Yog tias nws txuas ntxiv xls (Excel Phau Ntawv 97-2003), tom qab ntawd nws yuav tsum rov nyeem dua. Zoo hmoo, yog tias tsuas yog daim ntawv hloov tawm, thiab tsis yog tag nrho phau ntawv, koj tuaj yeem qhib daim ntawv thiab khaws nws hauv txhua hom kev siv tau. Ua li no, mus rau ntawm lub tab Cov ntaub ntawv thiab nyem rau ntawm qhov khoom "Tseg Raws Li ...".



2. Lub qhov rais qhib. Yuav tsum tau ua hauv qhov ntsuas Hom Ntawv teeb tus nqi Phau ntawv Excel hloov "Excel Phau Ntawv 97-2003"Cov. Nyem rau feem khawm "OK".



3. Phau ntawv xlsx yog qhov yuav tsum tau muaj zip archive. Peb yuav xav tau kho ib ntawm cov ntaub ntawv hauv cov ntawv qub. Tab sis rau qhov no koj yuav tsum tau hloov tam sim ntawd los ntawm xlsx mus rau zip. Txheeb los ntawm tus neeg tshawb nrhiav rau cov npe ntawm lub hard drive nyob rau hauv uas daim ntawv muaj nyob. Yog tias cov ntawv txuas ntxiv tsis pom, ces nyem rau lub pob Txheeb nyob rau sab qaum kev ntawm lub qhov rais, xaiv cov khoom nyob rau hauv daim ntawv qhia xaiv Nplaub tshev thiab Nrhiav Cov Haujlwm.



4. Daim nplaub tshev xaiv xaiv qhov rais qhib. Mus rau hauv lub tab "Saib"Cov. Peb tab tom nrhiav ib yam khoom "Nkaum txuas ntxiv rau hom ntaub ntawv sau npe"Cov. Uncheck nws thiab nyem rau ntawm lub pob "OK".



5. Raws li koj tuaj yeem pom, tom qab cov yeeb yam no, yog tias qhov txuas ntxiv tsis tau tso tawm, ces nws tshwm sim. Txoj cai-nias rau ntawm cov ntaub ntawv thiab xaiv cov khoom hauv cov ntawv qhia zaub mov uas tshwm sim Pauv npe.



6. Hloov pauv txuas nrog xlsx rau zip.



7. Tom qab kev hloov pauv tau ua tiav, lub Windows pom qhov ntawv no ua tus khaws thiab koj tuaj yeem qhib nws siv tus neeg tshawb xyuas tib yam. Peb muab ob npaug rau nyem rau cov ntaub ntawv no.



8. Mus rau qhov chaw nyob:

   file_name / xl / tsab ntawv khom nqi /

   Cov ntaub ntawv nrog txuas ntxiv xml Cov ntawv teev npe no muaj cov ntaub ntawv hais txog cov ntawv txheeb. Peb qhib thawj ntawm lawv nrog kev pab ntawm txhua cov ntawv xov xwm kho kom raug. Koj tuaj yeem siv lub Windows Notepad ua nrog rau cov laj thawj no, lossis koj tuaj yeem siv cov khoos kas ntau dua, piv txwv li, Notepad ++.



9. Tom qab qhov kev zov me nyuam tau qhib, peb ntaus rau ntawm txoj kab ntawv luv luv Ctrl + Fdua li hu rau kev nrhiav sab hauv. Peb tsav hauv lub thawv tshawb ntawv qhia:

   sheetProtection

   Peb tab tom nrhiav nws hauv cov ntawv nyeem. Yog tias peb tsis pom nws, tom qab ntawd qhib daim ntawv thib ob, thiab lwm yam. Peb ua qhov no kom txog thaum pom qhov xwm txheej. Yog tias ob peb daim ntawv ua haujlwm Excel muaj kev tiv thaiv, tom qab ntawd lub ntsiab yuav nyob hauv ntau cov ntaub ntawv.



10. Tom qab pom lub ntsiab no, muab nws lwv nrog txhua cov ntaub ntawv los ntawm daim pib qhib mus rau kev kaw. Khaws cov ntaub ntawv thiab kaw qhov program.



11. Peb rov qab mus rau cov npe hauv phau ntawv qhia chaw thiab rov hloov nws qhov txuas ntxiv ntawm zip mus rau xlsx.

Tam sim no, txhawm rau kho daim ntawv ua haujlwm Excel, koj tsis tas yuav paub tus password uas koj tsis nco qab.

Txoj Kev 4: siv cov ntawv thov thib peb

Ntxiv rau, yog tias koj tsis nco qab lo lus code, tom qab lub xauv yuav raug tshem tawm siv daim ntaub ntawv thib peb tshwj xeeb. Nyob rau tib lub sijhawm, koj tuaj yeem tshem lo lus zais ob leeg los ntawm daim ntawv tiv thaiv thiab ntawm tag nrho cov ntawv. Ib qho ntawm cov nyiam tshaj plaws hauv cheeb tsam no yog Kev Ntseg Hauv Chaw Ua Haujlwm Tsis Rov Qab PasswordCov. Xav txog cov txheej txheem rov ua dua kev tiv thaiv uas siv tus piv txwv ntawm cov nqi hluav taws xob no.

Download Accent OFFICE Password Rov qab los ntawm cov xaib raug cai

1. Peb tso rau daim ntawv thov. Nyem rau ntawm cov khoom ntawv qhia zaub mov Cov ntaub ntawvCov. Hauv daim ntawv teev nco-xaiv, xaiv txoj haujlwm "Qhib"Cov. Hloov ntawm cov haujlwm no, koj kuj tuaj yeem sau cov kab ntawv hla ntawm keyboard Ctrl + O.



2. Cov ntaub ntawv tshawb qhov rai qhib. Nrog nws, peb mus rau phau ntawv sau npe qhov twg Excel phau ntawv peb xav tau nyob rau, uas tus password poob lawm. Xaiv nws thiab nyem rau ntawm lub pob. "Qhib".



3. Cov Lus Qhia Txog Tus Kheej Rov Qab Nkag Mus qhib, uas tshaj tawm tias cov ntaub ntawv yog kev tiv thaiv password. Nias lub khawm "Tom ntej".



4. Tom qab ntawd daim ntawv qhia qhib nyob rau hauv uas koj yuav tsum xaiv raws li qhov teeb meem kev tiv thaiv yuav raug tshem tawm. Feem ntau, qhov kev xaiv zoo tshaj plaws yog tawm ntawm lub chaw pib thiab tsuas yog thaum tsis ua haujlwm sim hloov lawv ntawm kev sim thib ob. Nyem rau feem khawm Ua li cas.



5. Cov txheej txheem xaiv tus password pib. Nws tuaj yeem siv sijhawm ntev heev, nyob ntawm qhov nyuaj ntawm cov lo lus code. Kev puab ntawm txheej txheem tuaj yeem pom ntawm hauv qab ntawm lub qhov rais.



6. Tom qab suav ntawm cov ntaub ntawv tiav lawm, lub qhov rai yuav tshwm rau hauv uas tus lej siv tau yuav raug kaw. Koj tsuas yog yuav tsum khiav lub Excel cov ntaub ntawv hauv ib txwm hom thiab sau tus lej hauv qhov chaw tsim nyog. Tam sim ntawd tom qab qhov no, Excel daim ntawv yuav tau xauv.

Raws li koj tuaj yeem pom, muaj ob peb txoj hauv kev tshem tawm cov kev tiv thaiv los ntawm daim ntawv Excel. Tus neeg siv yuav tsum xaiv qhov twg siv los siv raws li hom kev thaiv, nrog rau qib ntawm nws lub peev xwm thiab sai npaum li cas nws xav tau txais txiaj ntsig zoo. Txoj hauv kev tshem tawm kev tiv thaiv siv cov lus sau ntawv yog sai dua, tab sis yuav tsum muaj qee qhov kev paub thiab kev rau siab. Siv cov haujlwm tshwj xeeb tej zaum yuav siv sijhawm ntau, tab sis daim ntawv thov yuav luag txhua yam ntawm nws tus kheej.