Qhov wikiHow qhia koj li cas los tiv thaiv ib nplooj ntawv hauv Microsoft Excel phau ntawv ua haujlwm hauv Windows lossis macOS. Yog tias daim ntawv tau tiv thaiv los ntawm tus lej nkag thiab koj tsis paub meej tias nws yog dab tsi, koj tuaj yeem siv Google Ntawv lossis VBA tsab ntawv (hauv Excel ua ntej ua ntej) kom tshem kev tiv thaiv.
Yog tias koj phau ntawv Excel tseem raug tiv thaiv thiab koj tsis tuaj yeem qhib nws, kab lus Rov pib dua, Tshem tawm thiab Rov Qab Lo Lus zais ntawm Excel Cov Ntaub Ntawv yuav pab koj.
Cov kauj ruam
Txoj Kev 1 ntawm 4: Siv Microsoft Excel
Kauj Ruam 1. Qhib phau ntawv ua haujlwm nrog daim ntawv tiv thaiv hauv Microsoft Excel
Feem ntau koj tuaj yeem ua qhov no los ntawm ob npaug nyem rau ntawm lub npe ntawm koj lub computer.
Kauj Ruam 2. Txoj cai-nias lub tab rau daim ntawv tiv thaiv
Txhua daim ntawv tab pom nyob hauv qab ntawm Excel. Cov ntawv tiv thaiv feem ntau muaj lub cim ntsuas phoo hauv qee qhov hloov pauv ntawm Excel. Right-click lub tab (lossis lub cim xauv) kom qhib cov ntawv qhia zaub mov.
Yog tias muaj ntau daim ntawv raug tiv thaiv, koj yuav tsum tshem kev tiv thaiv ntawm txhua daim ntawv cais
Kauj Ruam 3. Nyem Unprotect Sheet
Yog tias daim ntawv tsis tiv thaiv tus password, nws yuav qhib tam sim. Yog tias tsis yog, koj yuav raug hais kom nkag mus rau tus password rau hauv lub qhov rai pop-up.
Kauj Ruam 4. Sau tus password thiab nyem OK
Yog tias lo lus zais raug, daim ntawv yuav dhau los tiv thaiv.
- Yog tias koj tsis paub tus password, saib Siv Txoj Cai Google Sheets. Txoj hauv kev no cia koj rub cov ntawv mus rau Google Ntawv, uas tshem tawm txhua qhov kev tiv thaiv ntxiv hauv Excel.
- Yog tias koj siv Excel 2010 lossis ua ntej thiab xav kom tsis txhob upload rau Google Sheets, saib Kev Siv VBA Code hauv Excel 2010 thiab Txheej Txheem Ua Ntej.
Txoj Kev 2 ntawm 4: Tshaj Tawm rau Google Cov Ntawv
Kauj Ruam 1. Mus rau https://drive.google.com hauv lub vev xaib
Yog tias koj muaj Google tus lej, koj tuaj yeem siv Google Cov Ntawv (pub dawb online app uas zoo ib yam li Excel) tshem tawm kev tiv thaiv los ntawm txhua nplooj ntawv hauv phau ntawv ua haujlwm-txawm tias koj tsis paub tus password.
- Yog tias koj tseem tsis tau kos npe rau hauv koj tus lej Google, ua raws li cov lus qhia ntawm lub vijtsam kom nkag mus tam sim no.
- Yog tias koj tsis muaj Google account, saib Yuav Ua Li Cas Rau Google Account.
Kauj ruam 2. Nyem + Tshiab
Nws nyob ntawm kaum sab laug saum toj ntawm nplooj ntawv.
Kauj Ruam 3. Nyem File Upload
Qhov no qhib koj lub computer's Open panel.
Kauj Ruam 4. Xaiv Excel cov ntaub ntawv koj xav kho thiab nyem Qhib
Qhov no uploads cov ntaub ntawv rau koj Google Drive.
Kauj Ruam 5. Nyem ob npaug rau Excel cov ntawv hauv koj Google Drive
Koj yuav zaum tau nqes los nrhiav nws. Qhov no qhib qhov saib ua ntej ntawm cov ntawv.
Kauj Ruam 6. Nyem Qhib nrog cov ntawv qhia zaub mov
Nws nyob rau sab saum toj ntawm kev saib ua ntej. Cov ntawv qhia zaub mov yuav nthuav dav.
Kauj Ruam 7. Nyem Google Ntawv
Tam sim no cov ntaub ntawv tau qhib rau kev kho hauv Google Sheets, ib daim ntawv tiv thaiv ntxiv hauv Excel tau raug tshem tawm.
Kauj Ruam 8. Rov rub cov ntawv rau hauv koj lub computer
Yog tias koj xav khaws ua haujlwm ntawm cov ntawv hauv Microsoft Excel ntau dua li Google Ntawv, koj tuaj yeem rub tawm qhov tshiab uas tsis muaj kev tiv thaiv ntawm koj phau ntawv ua haujlwm siv cov theem hauv qab no:
- Nyem rau Cov ntawv qhia zaub mov ntawm lub ces kaum sab saud sab saud ntawm koj daim ntawv.
-
Nyem Download Raws li.
- Nyem Microsoft Excel (.xlsx).
- Xaiv ib daim nplaub tshev kom txuag cov ntawv. Yog tias koj xav khaws cov ntawv qub ntawm cov ntawv (ib qho uas muaj daim ntawv tiv thaiv) zoo, ntaus lub npe tshiab rau cov ntawv ib yam.
- Nyem Txuag mus download tau cov ntaub ntawv.
Txoj Kev 3 ntawm 4: Siv kev pabcuam online
Kauj Ruam 1. Tshawb nrhiav "tus password nrhiav hauv online" thiab nrhiav kev pabcuam tshem tus password online
Kauj ruam 2. Nyem rau "Unprotect your file"
Kauj Ruam 3. Nyem "Xauj" thiab xaiv cov ntawv tiv thaiv
Kauj Ruam 4. Xaiv "Tshem tus password" khawm xov tooj cua
Kauj Ruam 5. Tos thaum qhov kev pabcuam tshem koj tus password
Kauj Ruam 6. Rub tawm cov ntawv uas tsis muaj kev tiv thaiv, yog tias koj cov ntaub ntawv me me
Kauj Ruam 7. Rub tawm qhov demo-file yog tias koj cov ntaub ntawv loj
Txhawm rau kom tau txais tag nrho cov ntawv, koj yuav tsum nkag mus rau daim ntawv tso cai.
Txoj Kev 4 ntawm 4: Siv VBA Code hauv Excel 2010 thiab Yav dhau los
Kauj Ruam 1. Qhib phau ntawv ua haujlwm uas muaj daim ntawv tiv thaiv hauv Excel
Feem ntau koj tuaj yeem ua qhov no los ntawm ob npaug nyem rau ntawm lub npe ntawm koj lub computer. Cov ntaub ntawv Excel feem ntau xaus nrog cov ntawv txuas ntxiv.xls lossis.xlsx.
- Siv txoj hauv kev no yog tias koj twb tau sim qhib ib daim ntawv tab sis pom tias nws tau tiv thaiv tus password (thiab koj tsis paub tus password).
- Txoj kev no yuav tsis ua haujlwm hauv Excel 2013 lossis tom qab.
Kauj ruam 2. Rov khaws cov ntaub ntawv hauv xls hom
Yog tias cov ntawv koj tab tom ua haujlwm muaj qhov ".xlsx" txuas ntxiv (ntau yog tias nws tau tsim lossis kho dua tshiab hauv Excel), koj tsuas yog tuaj yeem siv txoj hauv kev no yog tias koj xub hloov nws mus rau Excel 97- 2003 (.xls) hom ntawv. Nov yog yuav ua li cas:
- Nyem rau Cov ntaub ntawv cov ntawv qhia zaub mov ntawm kaum sab xis saum toj.
- Nyem Txuag As.
- Mus rau daim nplaub tshev uas koj xav khaws cov ntawv.
- Xaiv Excel 97-2003 (.xls) los ntawm "Txuag raws li hom" lossis "Cov Qauv Ntawv" cov ntawv qhia zaub mov.
-
Nyem Txuag.
Ua raws li cov lus qhia ntawm lub vijtsam kom hloov pauv qhov tsim nyog.
Kauj Ruam 3. Nias Alt+F11 txhawm rau qhib Visual Basic Editor
Kauj Ruam 4. Nyem rau ntawm phau ntawv ua haujlwm lub npe cov ntaub ntawv hauv "Project - VBAProject" vaj huam sib luag
Nws nyob saum lub vaj huam sib luag sab laug. Xyuas kom tseeb tias koj nyem rau qhov xaiv uas muaj cov ntaub ntawv lub npe (xaus nrog ".xls"), uas yuav tsum nyob rau saum. Cov ntawv qhia zaub mov yuav nthuav dav.
Kauj Ruam 5. Nyem Ntxig rau ntawm cov ntawv qhia zaub mov
Lwm cov ntawv qhia zaub mov yuav nthuav dav.
Kauj Ruam 6. Nyem Module
Qhov no ntxig ib qho qauv tshiab uas koj yuav muab qee qhov chaws.
Kauj Ruam 7. Luam cov cai
Nyeem cov cai uas ua raws cov ntawv no, tom qab ntawd nyem Ctrl+C (PC) lossis ⌘ Command+C kom luam nws:
Sub PasswordBreaker () 'Ua txhaum daim ntawv ua haujlwm tiv thaiv tus password. Dim li As Integer, j As Integer, k As Integer Dim l As Integer, m As Integer, n As Integer Dim i1 As Integer, i2 As Integer, i3 As Integer Dim i4 As Integer, i5 As Integer, i6 As Integer On Error Rov Mus Ntxiv Rau Kuv = 65 Rau 66: Rau j = 65 Rau 66: Rau k = 65 Rau 66 Rau l = 65 Rau 66: Rau m = 65 Rau 66: Rau i1 = 65 Rau 66 Rau i2 = 65 Rau 66: Rau i3 = 65 txog 66: Rau i4 = 65 txog 66 Rau i5 = 65 txog 66: Rau i6 = 65 txog 66: Rau n = 32 Rau 126 ActiveSheet. Unprotect Chr (i) & Chr (j) & Chr (k) & _ Chr (l) & Chr (m) & Chr (i1) & Chr (i2) & Chr (i3) & _ Chr (i4) & Chr (i5) & Chr (i6) & Chr (n) Yog ActiveSheet. ProtectContents = Cuav Ces MsgBox "Lo lus zais yog" & Chr (i) & Chr (j) & _ Chr (k) & Chr (l) & Chr (m) & Chr (i1) & Chr (i2) & _ Chr (i3) & Chr (i4) & Chr (i5) & Chr (i6) & Chr (n) Tawm Sub End Yog Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej: Tom ntej kawg
Kauj Ruam 8. Right-click tus qauv tshiab thiab xaiv Paste
Cov cai theej tawm tam sim no tshwm nyob rau hauv lub qhov rai module.
Kauj Ruam 9. Nias F5 kom ua raws txoj cai
Tam sim no Excel yuav ua txoj cai, uas tuaj yeem siv sijhawm ob peb feeb. Thaum cov cai tau ua tiav, tus password tshiab yuav tshwm ntawm lub qhov rai pop-up.
Tus lej tshiab yuav yog tus lej "As" ntau dua li tus lej qub
Kauj ruam 10. Nyem OK ntawm tus Password pop-up
Tus lej tshiab yuav tshwm sim tab sis koj yuav tsis xav sau nws. Nyem OK yuav tshem daim ntawv tiv thaiv cia.