Tshem tawm kev tiv thaiv los ntawm cov ntaub ntawv Excel

Txhim kho kev tiv thaiv ntawm Excel cov ntaub ntawv yog ib txoj kev zoo los tiv thaiv koj tus kheej ntawm ob qho tib si cuam tshuam thiab koj tus kheej ua txhaum kev ua haujlwm. Qhov teeb meem yog tias tsis tag nrho cov neeg paub paub yuav ua li cas tawm lub xauv, yog li ntawd yog tias tsim nyog, yuav hloov tau phau ntawv los yog tsuas pom nws cov ntsiab lus. Lo lus nug tseem muaj ntau yam yog tias tus password tau teem tsis tau los ntawm tus neeg siv nws tus kheej, tab sis los ntawm lwm tus neeg uas kis tau lo lus code, tab sis ib tus neeg tsis paub siv nws tsis paub siv nws li cas. Tsis tas li ntawd, muaj cov xwm txheej ntawm tus password. Cia peb saib seb yuav ua li cas, yog tias tsim nyog, tshem tawm kev tiv thaiv los ntawm Excel daim ntawv.

Tshooj: Yuav ua li cas rau unprotect ib tsab ntawv Microsoft Word

Txoj kev rau qhib

Muaj ob hom Excel tuav: kev tiv thaiv rau ib phau ntawv thiab kev tiv thaiv rau ib daim ntawv. Raws li, txoj cai tsis tau txais kev pom zoo nyob ntawm seb txoj kev tiv thaiv tau xaiv tau li cas.

Method 1: qhib cov phau ntawv

Ua ntej tshaj, paub tias yuav tshem tawm kev tiv thaiv hauv phau ntawv li cas.

  1. Thaum koj sim khiav cov ntaub ntawv muaj kev tiv thaiv Excel, lub qhov rais qhib me nkag rau lo lus code. Peb yuav tsis muaj peev xwm qhib tau phau ntawv kom txog rau thaum peb qhia nws. Yog li, nkag mus rau lo lus zais rau hauv qhov chaw uas tsim nyog. Nias rau ntawm "OK" khawm.
  2. Tom qab ntawd phau ntawv qhib. Yog tias koj xav kom tshem tawm kev tiv thaiv txhua, mus rau lub tab "Cov Ntaub Ntawv".
  3. Tsiv mus rau seem "Cov ntsiab lus". Hauv nruab nrab ntawm lub qhov rais nyem rau ntawm lub pob. "Tiv thaiv phau ntawv". Hauv daim ntawv qhia zaub mov nco, xaiv qhov khoom "Encrypt nrog tus password".
  4. Dua lub qhov rais qhib nrog lo lus code. Cia li tshem tus password los ntawm lub thawv tawm thiab nyem rau ntawm "OK" khawm
  5. Txuag cov ntaub ntawv hloov los ntawm kev mus rau tab "Tsev" nias lub khawm "Txuag" nyob rau hauv daim ntawv ntawm lub tshuab floppy nyob rau sab qaum sab laug ntawm lub qhov rais.

Tam sim no, thaum qhib ib phau ntawv, koj tsis tas yuav nkag rau ib lo lus zais thiab nws yuav tsum tsis muaj kev tiv thaiv.

Tshooj: Yuav ua li cas muab ib lo lus zais rau ntawm Excel

Txoj kev 2: qhib daim ntawv

Tsis tas li, koj tuaj yeem teem ib lo lus zais rau hauv ib daim ntawv ntxiv. Hauv qhov no, koj tuaj yeem tuaj yeem qhib ib phau ntawv thiab txawm pom cov ntaub ntawv ntawm xauv khoom, tab sis hloov cov qe ntshav hauv nws yuav tsis ua haujlwm ntxiv lawm. Thaum koj sim kho kom raug, cov lus tshwm nyob rau hauv lub thawv ntawv qhia koj tias lub xovtooj ntawm kev tiv thaiv los ntawm kev hloov.

Yuav kom kho tau thiab tshem tag nrho cov kev tiv thaiv hauv daim ntawv, koj yuav tau ua cov yeeb yam.

  1. Mus rau lub tab "Kev Tshawb Xyuas". Rau daim kab xev hauv lub nras cov cuab yeej "Hloov" nias lub khawm "Cov ntawv pov thawj".
  2. Lub qhov rais qhib hauv thaj teb uas koj yuav tsum nkag mus rau hauv lub zauv qhib. Ces nyem rau ntawm lub pob "OK".

Tom qab ntawd, qhov kev tiv thaiv yuav raug tshem tawm thiab tus neeg siv yuav hloov tau cov ntaub ntawv. Txhawm rau tiv thaiv daim ntawv dua, koj yuav tsum nruab nws txoj kev tiv thaiv dua.

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

Method 3: Kev tiv thaiv los ntawm kev hloov cov ntaub ntawv

Tab sis, qee zaus kuj muaj thaum tus neeg siv encrypts ib daim ntawv nrog ib lo lus zais, yog li tsis txhob ua yuam kev rau nws, tab sis tsis nco qab txog tus cipher. Nws yog tu tu siab tias, raws li txoj cai, cov ntaub ntawv muaj nuj nqis yog encoded thiab poob tus password rau lawv tuaj yeem kim rau tus neeg siv. Tab sis muaj ib txoj kev tawm txawm los ntawm txoj hauj lwm no. Tseeb, nws yog ib qhov tsim nyog yuav tsum tau nrog cov ntawv teev.

  1. Yog tias koj cov ntaub ntawv muaj qhov txuas ntxiv xlsx (Excel workbook), tom qab ntawd mus ncaj qha mus rau peb pawg lus qhia. Yog hais tias nws txoj kev ncua xls (Excel 97-2003 workbook), ces nws yuav tsum tau rov qab. Tsi yog, tsuas yog daim ntawv no yog encrypted, tsis yog tag nrho phau ntawv, koj tuaj yeem qhib cov ntawv thiab khaws cia rau hauv txhua hom ntawv. Ua li no, mus rau lub tab "Cov Ntaub Ntawv" thiab nias rau yam khoom ntawd "Txuag Raws Li ...".
  2. Ib qho qhib qhov rais qhib. Yuav tsum muaj nyob rau hauv parameter "Cov Ntaub Ntawv Siv" teev tus nqi "Excel workbook" es tsis txhob "Excel 97-2003 workbook". Peb nias lub khawm "OK".
  3. Phau ntawv xlsx yog ib qho zip archive. Peb yuav tau hloov ib qho ntawm cov ntaub ntawv hauv no archive. Tab sis rau qhov no koj yuav tsum hloov tam sim ntawd hloov ntawm xlsx kom zip. Peb dhau los ntawm tus kws tshawb fawb rau cov npe ntawm cov tawv disk uas daim ntawv nyob hauv. Yog tias cov ntaub ntawv txuas ntxiv tsis pom, ces nias lub khawm. "Tsi" Nyob rau sab saum toj ntawm lub qhov rais, hauv cov ntawv qhia zaub mov, xaiv qhov khoom "Sis thiab kev nrhiav kev xaiv".
  4. Cov ntawv xaiv qhib qhov rai. Mus rau lub tab "Saib". Nrhiav ib yam khoom "Nkaum ncua ntxiv rau cov ntaub ntawv sau tseg". Tshem tawm thiab nyem rau ntawm lub pob. "OK".
  5. Raws li koj tau pom, tom qab cov kev ua no, yog qhov ncua ntxiv tsis tau tso tawm, nws tshwm sim. Peb nyem rau ntawm cov ntaub ntawv nrog tus nas khawm thiab nyob hauv lub ntsiab lus teb cov ntsiab lus peb xaiv qhov khoom Rename.
  6. Hloov kev txuas nrog xlsx on zip.
  7. Tom qab kev hloov dua siab tshiab, Windows tau pom cov ntaub ntawv no ua ib qho kev sib tw thiab tuaj yeem qhib siv tib tus neeg tshawb nrhiav. Ob-nias cov ntaub ntawv no.
  8. Mus rau qhov chaw nyob:

    filename / xl / cov ntawv ua haujlwm /

    Cov ntaub ntawv txuas ntxiv xml hauv phau ntawv no muaj cov lus qhia txog cov ntawv txheeb. Qhib tus thawj zaug nrog rau cov ntawv nyeem. Koj tuaj yeem siv lub Windows Notepad built-in rau cov laj thawj no, los yog koj siv tau cov kev pab cuam ntau tshaj, piv txwv, Notepad ++.

  9. Tom qab qhov kev zov me nyuam tau qhib, peb ntaus kev sib koom ua ke ntawm cov keyboard Ctrl + FDab tsi ua rau kev tshawb nrhiav nrog rau daim ntawv thov. Peb tsav nyob rau hauv qhov kev tshawb pom lub thawv qhia:

    sheetProtection

    Peb tab tom nrhiav nws nyob hauv cov ntawv nyeem. Yog tias tsis pom, ces qhib qhov thib ob cov ntaub ntawv, thiab lwm yam. Ua li no kom txog rau thaum cov khoom nrhiav pom. Yog muaj ntau daim ntawv txheeb npe (Excel) muaj kev tiv thaiv, cov khoom yuav muaj ntau yam ntaub ntawv.

  10. Tom qab no, nws rho tawm nrog rau tag nrho cov lus qhia los ntawm kev pib qhib rau tom qab xaus. Txuag cov ntaub ntawv thiab kaw qhov program.
  11. Rov qab mus rau qhov chaw qub chaw directory thiab rov hloov nws cov zauv ntxiv mus rau xlsx.

Tam sim no, kom hloov cov ntawv Excel, koj tsis tas yuav tsum paub tus password forgotten los ntawm tus neeg siv.

Method 4: Siv Cov Ntawv Sau Npe Peb

Tsis tas li ntawd xwb, yog tias koj tsis nco qab txog lo lus code, ces lub xauv yuav raug tshem tawm uas siv cov ntawv tshwj xeeb thib peb. Hauv qhov no, koj tuaj yeem rho tawm tus password ntawm ob daim ntawv tiv thaiv thiab tag nrho cov ntaub ntawv. Ib qho ntawm cov ntaub ntawv uas nrov tshaj plaws nyob hauv cheeb tsam no yog SAU UA NTAUB NTAWV NPE Password Recovery. Xav txog cov txheej txheem kev pib dua kev tiv thaiv ntawm tus qauv ntawm lub chaw tso dej.

Download Accent OFFICE Password Recovery los ntawm lub xeem qhov chaw.

  1. Khiav daim ntawv thov. Nias rau ntawm daim ntawv qhia zaub mov "Cov Ntaub Ntawv". Hauv daim ntawv teev npe, xaiv qhov chaw "Qhib". Siv cov kev ua no, koj tsuas tuaj yeem ntaus cov keyboard shortcut Ctrl + O.
  2. Lub chaw nrhiav cov ntaub ntawv qhib opens. Nrog kev pab ntawm nws, mus rau hauv phau ntawv qhov chaw uas yuav tsum tau ua qhov Excel workbook, uas tus password tau poob. Xaiv nws thiab nyem rau ntawm lub pob. "Qhib".
  3. Tus Password Recovery Wizard qhib, uas qhia tias cov ntaub ntawv yog lo lus zais tiv thaiv. Peb nias lub khawm "Tom ntej".
  4. Tom qab ntawd ib daim ntawv qhia qhib uas koj yuav tsum xaiv cov scenario kev tiv thaiv yuav xauv lub. Feem ntau, qhov kev xaiv zoo tshaj plaws yog tawm hauv qhov chaw tso cai thiab tsuas yog thaum tsis ua hauj lwm rau kev sim hloov lawv qhov kev sim thib ob. Peb nias lub khawm "Ua li cas".
  5. Cov txheej txheem xaiv cov passwords pib. Nws tuaj yeem siv sij hawm ntev, nyob ntawm qhov tsis yooj yim ntawm txoj cai lo lus. Cov txheej txheem ntawm tus txheej txheem tuaj yeem tau cai rau hauv qab ntawm qhov rais.
  6. Tom qab cov ntaub ntawv tshawb fawb lawm, lub qhov rai yuav tsum tshwm sim nyob rau hauv uas siv tau lo lus zais siv. Koj cia li xav khiav ntaub ntawv Excel ua hom qis thiab nkag mus rau qhov chaws hauv qhov tsim nyog. Tam sim ntawd tom qab no, cov ntaub ntawv tshaj tawm hauv Excel yuav raug qhib.

Raws li koj tuaj yeem pom, muaj ntau txoj hauv kev los tshem tawm kev tiv thaiv los ntawm Excel. Tus twg ntawm lawv tus neeg siv yuav tsum siv, nyob ntawm seb yam thaiv, nrog rau theem ntawm nws lub peev xwm thiab nws sai npaum li cas nws xav kom tau txais ib qho txiaj ntsig tau. Txoj kev uas tsis muaj kev tiv thaiv siv cov ntawv nyeem yooj yim dua, tab sis nws yuav tsum muaj kev paub thiab kev mob siab. Kev siv cov khoos kas tshwj xeeb tej zaum yuav xav tau lub sij hawm tseem ceeb, tab sis daim ntawv thov ua txhua yam los ntawm nws tus kheej.