Qhov wikiHow qhia koj li cas kom tshem tus password los ntawm daim ntawv Excel uas muaj kev tiv thaiv, nrog rau yuav ua li cas txhawm rau lo lus zais rau cov ntaub ntawv Excel encrypted. Feem ntau, tshem tus password los ntawm daim ntawv kho-xauv ua haujlwm sab hauv ntawm Excel cov ntaub ntawv yog nrawm thiab yooj yim! Tab sis yog tias koj xav tau tus password kom txawm tias qhib cov ntaub ntawv, txhua yam tau ua kom yuam kev me ntsis. Tsis muaj txoj hauv kev raug cai los txiav txim siab phau ntawv Excel yam tsis siv tus lej zais, uas tuaj yeem yog txheej txheem siv nyiaj ntau, nyob ntawm qhov nyuaj ntawm tus password. Tseem, nws tsim nyog sim!
Cov kauj ruam
Txoj Kev 1 ntawm 2: Tshem Tawm Kev Tiv Thaiv Tus Kheej los ntawm Daim Ntawv
Kauj Ruam 1. Nkag siab qhov xwm txheej uas koj tuaj yeem ua qhov no
Yog tias tsuas yog ib daim ntawv hauv phau ntawv Excel tau txais kev tiv thaiv-uas yog, yog tias koj tuaj yeem qhib Excel cov ntaub ntawv thiab saib nws cov ntsiab lus tab sis tsis kho nws-ces koj tuaj yeem siv txoj hauv kev no tshem tawm kev tiv thaiv tus password ntawm ob lub Windows thiab Mac khoos phis tawj.
- Yog tias Excel cov ntaub ntawv nws tus kheej tau muab zais thiab xav tau tus password kom pom txawm tias cov ntsiab lus, txoj hauv kev no yuav tsis ua haujlwm. Koj tuaj yeem sim siv tus password cracker, tab sis tsis muaj kev lees paub.
- Muaj txoj hauv kev txoj hauv kev no yuav tsis ua haujlwm yog tias cov ntawv raug tiv thaiv siv Microsoft 365 version ntawm Excel.
Kauj Ruam 2. Txheeb xyuas seb daim ntawv Excel tau muab zais
Qhov yooj yim tshaj plaws los ua qhov no yog los ntawm ob npaug nias rau Excel cov ntawv. Yog tias cov ntawv qhib thiab koj tuaj yeem nyem Nyeem Xwb los saib cov ntawv, lossis yog tias cov ntawv qhib zoo li ib txwm thaum koj nyem ob zaug, cov ntawv tsis raug encrypted.
Yog tias koj tam sim tam sim rau tus password thaum ob-nias cov ntawv thiab tsis muab qhov kev xaiv qhib nws nyeem nkaus xwb, cov ntaub ntawv tau muab zais thiab koj tsis tuaj yeem siv txoj hauv kev no qhib nws
Kauj Ruam 3. Luam ib phau ntawv ua haujlwm
Hauv Finder lossis Windows File Explorer, nyem rau Excel cov ntaub ntawv uas muaj daim ntawv uas koj xav tiv thaiv, tom qab ntawv nyem rau Ctrl + C. (Windows) lub Hais kom ua + C. (Mac) thiab muab tshuaj txhuam rau lwm daim nplaub tshev los ntawm nias Ctrl + V. (Windows) lub Hais kom ua + V. (Mac OS).
Qhov no yog qhov tsim nyog nyob rau hauv rooj plaub koj yuam kev ua txhaum qhov qub version ntawm cov ntawv hauv cov txheej txheem
Kauj Ruam 4. Pab kom cov ntawv txuas ntxiv mus
Hla qhov kauj ruam no ntawm Mac. Yog tias koj siv lub khoos phis tawj Windows, koj yuav tsum paub tseeb tias koj tuaj yeem pom thiab hloov cov ntaub ntawv txuas ntxiv cov npe los ntawm kev ua cov hauv qab no:
- Qhib Cov ntaub ntawv Explorer los ntawm nias Windows yuam sij + E..
- Nyem Saib.
- Khij lub npov "Cov ntaub ntawv npe txuas ntxiv".
Kauj Ruam 5. Hloov cov ntawv Excel rau hauv ZIP nplaub tshev
Ua li ntawd:
- Windows - Right -click Excel file, nyem Hloov npe, rho tawm cov ntawv "xlsx" tom kawg ntawm daim ntawv lub npe, thiab ntaus hauv zip. Nco ntsoov tias koj khaws lub sijhawm nruab nrab ntawm cov ntaub ntawv lub npe thiab "zip". Xovxwm Nkag mus thiab nyem Yog lawm thaum nug.
- Mac - Xaiv cov ntawv Excel, nyem rau Cov ntaub ntawv, xaiv Tau Info, rho tawm cov ntawv "xlsx" tom kawg ntawm daim ntawv lub npe, thiab ntaus hauv zip. Nco ntsoov tias koj khaws lub sijhawm nruab nrab ntawm cov npe ntawv thiab "zip". Xovxwm Rov qab los thiab nyem Siv.zip thaum nug.
Kauj Ruam 6. Extract ZIP nplaub tshev
Cov txheej txheem no yuav txawv nyob ntawm koj lub khoos phis tawj lub operating system:
- Windows - Right -click ZIP folder, nyem Extract Txhua… hauv cov ntawv qhia zaub mov nco-down, thiab nyem rau Extract thaum nug. Cov ntawv rho tawm yuav tsum qhib.
- Mac - Nyem ob npaug rau ZIP nplaub tshev, tom qab ntawd tos rau cov ntawv rho tawm qhib.
Kauj Ruam 7. Nyem ob npaug rau xl nplaub tshev
Qhov no qhib daim nplaub tshev.
Yog tias cov ntawv rho tawm tsis qhib rau qee qhov laj thawj, thawj zaug ob zaug nyem rau daim nplaub tshev ib txwm nrog tib lub npe zoo li koj li ZIP nplaub tshev
Kauj Ruam 8. Muab ob npaug rau nyem rau ntawm daim ntawv ua haujlwm
Nws nyob ze rau sab saum toj ntawm daim ntawv "xl".
Kauj Ruam 9. Qhib daim ntawv hauv kab ntawv nyeem
Nyob ntawm koj lub khoos phis tawj lub operating system, ua ib qho ntawm cov hauv qab no:
- Windows - Txoj cai -nias rau ntawm daim ntawv uas koj xav qhib (piv txwv li, "Sheet1"), xaiv Qhib nrog hauv cov ntawv qhia zaub mov nco-down, thiab nyem rau Notepad hauv qhov tshwm sim pop-out menu.
- Mac - Nyem rau daim ntawv uas koj xav qhib (piv txwv li, "Sheet1"), nyem Cov ntaub ntawv, xaiv Qhib Nrog, thiab nyem TextEdit.
Kauj ruam 10. Tshem tus password tiv thaiv tus lej
Nrhiav qhov "sheetProtection" ntu uas nyob hauv "" brackets, tom qab ntawd tshem tawm txhua yam los ntawm "") ntawm lwm sab ntawm daim ntawv tiv thaiv txheej txheem.
Kauj Ruam 11. Txuag koj cov kev hloov pauv thiab kaw cov ntawv sau
Nias ib yam Ctrl + S. (Windows) lub Hais kom ua + S. (Mac), tom qab ntawd nyem rau X (lossis lub voj voog liab ntawm Mac) nyob rau ntawm kaum ntawm kab ntawv sau.
Yog tias muaj ntau nplooj ntawv hauv phau ntawv ua haujlwm raug tiv thaiv, koj yuav tsum tshem kev tiv thaiv los ntawm txhua tus ntawm lawv ib leeg. Qhib lwm daim ntawv tiv thaiv hauv koj cov ntawv sau thiab tshem tib txoj kab, txuag txhua qhov thaum koj mus
Kauj Ruam 12. Luam daim "workheets" nplaub tshev
Nyem rau "Rov qab" khawm kom rov qab mus rau "xl" nplaub tshev, tom qab ntawv xaiv "cov ntawv ua haujlwm" nplaub tshev thiab nias ob qho tib si Ctrl + C. (Windows) lub Hais kom ua + C. (Mac) los theej nws.
Kauj Ruam 13. Qhib ZIP cov ntaub ntawv (Windows) lossis daim nplaub tshev tshiab (Mac)
Nov yog cov ntawv koj tau hloov npe thiab tom qab ntawd rho tawm ua ntej (ib qho xaus hauv. Zip, yog tias koj siv Windows). Yog tias koj siv Mac, tsuas yog ob npaug nyem rau daim nplaub tshev tshiab uas muaj tib lub npe zoo li ZIP cov ntaub ntawv.
Kauj Ruam 14. Hloov daim ntawv "ua haujlwm" nrog koj cov ntawv theej
Nkag mus rau "daim ntawv ua haujlwm" nplaub tshev los ntawm ob npaug nias rau "xl" nplaub tshev, thiab tom qab ntawd rho tawm "cov ntawv ua haujlwm" nplaub tshev sab hauv. Tom ntej no, right-click qhov chaw seem hauv lub qhov rais thiab xaiv Muab tshuaj txhuam muab tshuaj txhuam cov ntawv theej.
- Yog tias koj siv Windows, tam sim no koj tau ntxiv cov ntawv theej rov qab rau hauv cov ntawv ZIP uas twb muaj lawm.
- Yog tias koj siv Mac, koj tau ntxiv cov ntawv theej rau hauv cov ntawv rho tawm.
Kauj Ruam 15. (Mac nkaus xwb) Tig daim nplaub tshev rov qab rau hauv ZIP cov ntaub ntawv
Yog tias koj siv Mac, nyem Tswj raws li koj nyem rau daim nplaub tshev uas koj tau muab rho tawm ua ntej-nws yog daim nplaub tshev uas muaj lub npe zoo ib yam li koj daim ntawv nthuav tawm. Tom qab ntawd, xaiv Nyem los ntawm cov ntawv qhia zaub mov. Tam sim no daim nplaub tshev yog ZIP cov ntaub ntawv dua.
Kauj Ruam 16. Hloov ZIP nplaub tshev rov qab rau hauv daim ntawv Excel
Kaw cov ntawv ZIP, tom qab ntawd ua ib qho ntawm cov hauv qab no:
- Windows - Right -click ZIP folder, nyem Hloov npe, hloov cov ntawv "zip" nrog "xlsx", thiab nias Nkag mus. Nyem Yog lawm thaum nug.
- Mac - Nyem rau ZIP nplaub tshev, nyem Cov ntaub ntawv, nyem Tau Info, hloov cov ntawv "zip" hauv lub npe nrog "xlsx", thiab nias Rov qab los. Nyem Siv.xlsx thaum nug.
Kauj Ruam 17. Ob npaug nias rau daim ntawv Excel kom qhib nws
Tam sim no koj tau tshem tus password tiv thaiv los ntawm daim ntawv, koj yuav tuaj yeem kho nws raws li xav tau.
Yog tias koj tau txais qhov yuam kev uas daim ntawv Excel raug puas tsuaj, tej zaum koj yuav tshem tawm cov lej ntxiv thaum koj tau sim tshem qhov kev tiv thaiv tus lej zais. Rov ua cov kauj ruam saum toj no, ua kom ntseeg tau tias tsuas yog tshem cov ntawv nruab nrab ntawm kab zauv () thiab cov kab zauv lawv tus kheej
Txoj Kev 2 ntawm 2: Qhib Phau Ntawv Qhia Tus Kheej
Kauj Ruam 1. Nkag siab tias nws yuav ua tsis tau kom tawg tus password
Cov khoos phis tawj niaj hnub no ntawm Excel, xws li Excel 2019 thiab Microsoft 365, siv cov txheej txheem kev nkag siab zoo uas ua rau cov txheej txheem siv los ntawm lo lus zais crackers zoo siv tsis tau vim ntev npaum li cas tus password tuaj yeem tawg. Koj yuav muaj lub sijhawm yooj yim dua txhawm rau lo lus zais luv dua yam tsis muaj cov cim tshwj xeeb, txawm hais tias nws tseem tuaj yeem tuaj yeem ua rau lo lus zais nyuaj dua siv txoj cai app.
- Nws tsis yooj yim sua kom tawg Excel cov ntaub ntawv yam tsis tau xaj tus password cracker, raws li cov dawb version ntawm lub npe nrov npe crackers feem ntau tsuas yog npog txog Excel 2010.
- Yog tias koj cov ntaub ntawv Excel tiag tiag yog encrypted, ob npaug nias rau Excel cov ntaub ntawv yuav qhia koj rau tus lej zais ua ntej koj tuaj yeem saib cov ntaub ntawv cov ntsiab lus. Yog tias qhov no yog (thiab koj tsis paub tus password), koj yuav xav tau tus password txhawm rau txhawm rau saib nws cov ntsiab lus.
Kauj Ruam 2. Rub tawm thiab teeb tsa PassFab rau Excel
Koj tuaj yeem tau txais nws los ntawm https://www.passfab.com/products/excel-password-recovery.html. Txawm hais tias ntau daim ntawv thov tuaj yeem thov tshem tus lej nkag los ntawm lo lus tiv thaiv Excel phau ntawv ua haujlwm, PassFab paub tias muaj kev nyab xeeb thiab siv tau yooj yim. Nws kuj tseem tuaj yeem txiav txim siab Excel cov ntaub ntawv ua hauv txhua lub khoos phis tawj ntawm Excel, suav nrog 2019 thiab Microsoft 365. Muaj ob qhov tsis zoo, txawm hais tias:
- Ib qho yog tias lub app tsuas ua haujlwm ntawm Windows, yog li Mac cov neeg siv yuav xav tau nkag mus rau lub PC. Tej zaum yuav muaj Mac lwm txoj hauv kev, tab sis tsis muaj ib qho tau ua pov thawj kom ntseeg tau. Yog tias koj tsis muaj kev nkag mus rau Windows, sim tshawb nrhiav lwm Excel lo lus zais-cracking app. Tsuas yog nco ntsoov tshawb xyuas lub app kom zoo ua ntej rub tawm thiab teeb tsa, raws li muaj ntau lub apps tsis zoo tawm muaj.
- Lwm qhov yog qhov software tsis pub dawb-muaj qee qhov yam ntxwv tseem ceeb hauv kev sim uas tuaj yeem pab txhawm rau txhawm rau koj tus password, tab sis koj yuav tsum tau them rau daim ntawv tso cai yog tias tus password yog txhua yam nyuaj. Yog tias koj tsuas xav tau tsoo ib phau ntawv ua haujlwm, koj tuaj yeem mus rau qhov kev xaiv ib hlis uas tsuas yog $ 15.95. Tsuas yog nco ntsoov thim qhov kev tso npe ua ntej lub hli xaus yog li koj tsis tau sau nqi yav tom ntej.
Kauj Ruam 3. Qhib PassFab
Tom qab teeb tsa lub app, koj yuav pom nws hauv koj lub Windows Start menu.
Kauj Ruam 4. Nyem Rov Qab Excel Qhib Tus Kheej
Nws yog thawj ntawm ob txoj kev xaiv. Nov yog qhov kev xaiv uas koj yuav tsum xaiv yog tias koj yuav tsum nkag mus rau tus password thaum qhib phau ntawv ua haujlwm.
Yog tias koj tsuas xav tshem tus password los ntawm daim ntawv tiv thaiv sab hauv phau ntawv ua haujlwm thiab tsis tuaj yeem ua los ntawm kev kho cov ntaub ntawv XML, koj tuaj yeem xaiv Tshem tawm Excel Kev Txwv Tus Kheej hloov thiab ua raws li cov lus qhia ntawm lub vijtsam.
Kauj Ruam 5. Nyem rau + thiab xaiv koj cov ntaub ntawv Excel
Qhov no qhia PassFab cov ntaub ntawv twg uas yuav tawg.
Kauj Ruam 6. Xaiv hom rov qab lo lus zais
Nco ntsoov tias tsis muaj teeb meem twg uas koj xaiv, tsoo tus password siv sijhawm. Lub app yuav tsum sim txhua qhov sib txawv ua ke ntawm cov tsiaj ntawv, tus lej, thiab cov cim. Qhov no tuaj yeem siv qhov twg los ntawm ob peb feeb mus rau ob peb hlis! Muaj peb qho kev xaiv uas koj tuaj yeem xaiv los ntawm:
-
Phau ntawv txhais lus nres yog qhov kev xaiv zoo yog tias koj xav tias tus password yog lo lus yooj yim los ntawm phau ntawv txhais lus. Koj tseem tuaj yeem muab koj tus kheej cov npe cov lus los ntxiv rau hauv phau ntawv txhais lus, xws li cov lej nkag los siv los ntawm koj lub koom haum. Tsuas yog ntxiv cov peev txheej tus lej nkag mus rau cov ntawv xa ntawv, khaws nws, nyem Chaw nyob ib sab ntawm "Dictionary Attack," thiab xaiv cov ntawv ntawd.
Nov yog qhov kev xaiv dawb xwb, thiab nws tsuas suav nrog phau ntawv txhais lus txwv. Yog tias koj xav tau txais kev nkag mus rau ntau txoj kev xaiv, nyem Txhim Kho Tam Sim No mus yuav daim ntawv tso cai.
- Brute Force nrog Mask Attack yog qhov kev xaiv zoo yog tias koj paub ib feem ntawm tus password, lossis xav kom suav qee cov tsiaj ntawv, tus lej, lossis cov cim hauv koj qhov kev sim ua kom tawg. Yog koj xaiv qhov kev xaiv no, nyem Chaw ib sab nws txhawm rau kho qhov ntev ntawm tus lej nkag mus sim, yam cim siv, thiab cov ntawv ua ntej thiab/lossis cov ntawv txuas ntxiv. Nyob ntawm qhov ntev thiab qhov nyuaj ntawm tus password, qhov kev xaiv no tuaj yeem siv sijhawm ntev-teev, hnub, txawm tias lub lis piam!
- Brute Force Attack tsuas yog zoo li qhov kev xaiv yav dhau los, tshwj tsis yog nws zoo tshaj rau thaum koj tsis muaj lub tswv yim dab tsi tus lej nkag tuaj yeem yog. Nws pib ua txhua qhov ua tau ua ke kom txog thaum nws tuaj yeem txheeb xyuas tus lej zais, uas tuaj yeem siv sijhawm ntev nyob ntawm nws qhov ntev.
Kauj Ruam 7. Nyem rau xiav Rov Qab khawm
Cia tus password tawg pib! PassFab yuav sim txhua qhov ua tau ua ke ua ke nrog qhov kev xaiv tawg uas koj tau xaiv. Lub app yuav txuas ntxiv sim ua ke kom txog thaum nws kwv yees tus password lossis tsis muaj kev xaiv los sim.
- Qhov no tuaj yeem siv sijhawm me ntsis, thiab tuaj yeem siv cov peev txheej ntau ntawm koj lub khoos phis tawj. Yog tias koj xav tau ncua kev tawg, nyem lub pob nres (lub xwmfab) kom txog thaum koj npaj rov pib dua, thiab tom qab ntawd nyem lub pob ua si kom rov pib dua.
- Thaum PassFab pom tus password, nws yuav tso nws rau koj hauv cov ntawv yooj yim-koj tuaj yeem luam lossis ntaus tus password rau hauv Excel thaum qhib cov ntaub ntawv los saib nws cov ntsiab lus.
- Nyob ntawm cov ntsiab lus ntawm Excel cov ntaub ntawv, nws yuav tsim nyog tso tseg koj kev siv zog yog tias koj tsis pom tus password nyob rau lub sijhawm tsim nyog.
Yees duab - Los ntawm kev siv qhov kev pabcuam no, qee cov ntaub ntawv yuav raug muab qhia rau YouTube
Lub tswv yim
- Tsuas yog siv cov txheej txheem no yog tias koj yog tus tswv cov ntaub ntawv lossis tus neeg siv tso cai. Kev tawg tus password rau cov ntaub ntawv uas tsis yog koj li tsis yog tsuas yog tsis ncaj ncees, tab sis kuj tseem tuaj yeem ua txhaum cai, nyob ntawm cov ntaub ntawv cov ntsiab lus thiab koj qhov chaw nyob.
- Feem ntau, koj yuav tsis tuaj yeem tawg tus password rau ntawm encrypted Excel cov ntaub ntawv.
- Microsoft tsis tuaj yeem rov qab Excel lo lus zais poob rau koj.
