6 mau ala e wehe ai i ka ʻōlelo huna mai kahi faila Excel [2023 Guide]
![6 mau ala e wehe ai i ka ʻōlelo huna mai kahi faila Excel](https://www.passmapa.com/images/quitar-contrasena-excel-780x470.jpg)
ʻO kekahi o nā mea maikaʻi loa e pili ana iā Excel ʻo ka hiki ke pale i kāu mau faila ma nā pae āpau. Hiki iā ʻoe ke koho e pale i ka Buke Haʻawina mai nā hoʻololi ʻana, ʻo ia hoʻi, ʻaʻole hiki i ka poʻe ʻae ʻole ke hoʻololi i ka helu a i ʻole ka papa o nā pepa ma ka puke haʻawina. Hiki iā ʻoe ke hoʻonohonoho i ka ʻōlelo huna no ka pale ʻana i kekahi mai ka hoʻololi ʻana i ka pepa haʻawina, ʻo ia hoʻi ʻaʻole hiki iā lākou ke kope, hoʻoponopono a holoi paha i kekahi ʻike mai nā pepa hana. A hiki iā ʻoe ke hoʻonohonoho i kahi ʻōlelo huna e pale ai i kekahi mai ka wehe ʻana i ka palapala inā ʻaʻole i loaʻa iā lākou ka ʻōlelo huna.
ʻOiai hiki ke kūpono kēia mau ʻōlelo huna, hiki iā lākou ke pale iā ʻoe mai ke komo ʻana a hoʻololi paha i ka palapala inā pono ʻoe. Inā ʻaʻole hiki iā ʻoe ke komo i kahi palapala Excel a i ʻole ka pāpalapala no kou ʻike ʻole i ka ʻōlelo huna a poina paha, e kōkua nui kēia ʻatikala. Ma ia mea, e nānā mākou i kekahi o nā ala e hiki ai iā ʻoe ke wehe i ka ʻōlelo huna mai kahi palapala Excel.
Mahele 1: He aha ke ʻano o ka wehe ʻana i ka ʻōlelo huna mai Excel
Ma mua o ke kūkākūkā ʻana pehea e hiki ai iā ʻoe ke wehe i ka ʻōlelo huna mai ka pepa Excel, manaʻo mākou pono mākou e hoʻoponopono i ka manaʻo nui o ka wehe ʻana i ka ʻōlelo huna a me ka hiki ke wehe i ka ʻōlelo huna Excel.
ʻO ka wehe ʻana i ka huaʻōlelo he kaʻina hana e hoʻohana ai i nā ʻano hana like ʻole e hoʻihoʻi a wehe paha i ka ʻōlelo huna mai ka ʻikepili i mālama ʻia a i hoʻouna ʻia ma o kahi ʻōnaehana kamepiula. ʻO kekahi o nā ala i hoʻohana nui ʻia e wehe i kahi ʻōlelo huna ʻo ke ʻano hoʻouka kaua ʻino. Hoʻohana kēia ʻano hana i ke ʻano koho e koho pinepine i nā ʻōlelo huna like ʻole a loaʻa ka ʻōlelo huna pololei. No laila he aha ka hiki ke wehe i ka ʻōlelo huna Excel? E haʻi ʻia ka ʻoiaʻiʻo, ʻaʻohe papahana e hiki ke hōʻoiaʻiʻo i ka helu kūleʻa 100% ma ka mākeke. Akā ʻo kahi polokalamu maikaʻi loa e wehe i nā pepa Excel hiki ke hōʻemi i ka manawa. No laila, hiki ke hoʻonui nui ka manawa o ka wehe ʻana i ke kī.
No ka poʻe ʻaʻole ʻenehana, makemake nui mākou iā ʻoe e hoʻāʻo i kahi Excel password unlocker e kōkua iā ʻoe e wehe i ka ʻōlelo huna mai nā faila Excel.
Mahele 2: Pehea e wehe koke i ka password
Inā ʻaʻole hiki iā ʻoe ke wehe i ka palapala Excel me ka ʻole o ka ʻōlelo huna, eia kekahi o nā koho āu e hoʻāʻo ai.
Ala 1: Wehe i ka ʻōlelo huna mai Excel File me Passper for Excel
No ka lanakila maikaʻi, makemake paha ʻoe e hoʻohana i kahi polokalamu ikaika: Passper no Excel . He polokalamu wehe ʻōlelo huna kēia i hiki ke kōkua iā ʻoe e kāʻalo i kahi huaʻōlelo wehe ma kekahi palapala Excel, ʻo ka mana hou loa. He nui nā hiʻohiʻona i hoʻolālā ʻia e hana maʻalahi loa ka hoʻihoʻi ʻana i ka ʻōlelo huna. Aia lākou i kēia mau mea:
- ʻOi aku ka wikiwiki o ka wehe ʻana i ka ʻōlelo huna : Loaʻa iā ia kekahi o ka wikiwiki loa o ka wehe ʻana i ka ʻōlelo huna ma ka mākeke, hiki iā ia ke hōʻoia ma kahi o 3,000,000 mau ʻōlelo huna i kēlā me kēia kekona.
- ʻO ka hiki ke loaʻa ka ʻōlelo huna - Hāʻawi iā ʻoe i ke koho e koho mai nā ʻano hoʻouka kaua 4 a me kahi puke wehewehe ʻōlelo o nā miliona o nā huaʻōlelo i hoʻohana pinepine ʻia, e hoʻonui hou i ka manawa o ka hoʻihoʻi ʻana i ka ʻōlelo huna a me ka hōʻemi nui ʻana i ka manawa hoʻihoʻi.
- ʻAʻohe poho ʻikepili : ʻAʻohe o nā ʻikepili i kāu palapala Excel e hoʻopilikia ʻia e ke kaʻina hana hoʻihoʻi.
- Palekana ʻikepili : ʻAʻole pono ʻoe e hoʻouka i kāu faila i kā lākou kikowaena, no laila, ua hoʻohiki ʻia kāu pilikino ʻikepili 100%.
- ʻAʻohe palena : Ua kūpono ka polokalamu me nā mana a pau o Windows a me nā mana o Excel. Eia kekahi, ʻaʻohe palena o ka nui o ka faila.
ʻO kēia pehea e hiki ai iā ʻoe ke hoʻohana iā Passper for Excel e wehe i kahi faila Excel i pale ʻia e ka password.
KaʻAnuʻu 1 : E hoʻouka iā Passper for Excel ma kāu kamepiula a laila hoʻomaka. Ma ka puka makani nui, kaomi "Recover Passwords".
KaʻAnuʻu 2 : Kaomi i ka pihi "+" e koho i ka palapala Excel āu e makemake ai e wehe. Ke hoʻohui ʻia ka palapala i ka papahana, e koho i ke ʻano hoʻouka āu e makemake ai e hoʻohana a kaomi "Recover." ʻO ke ʻano hoʻouka kaua āu e koho ai e hilinaʻi ia i ka paʻakikī o ka ʻōlelo huna a inā paha he manaʻo paha ʻoe.
KaʻAnuʻu 3 : Ke koho koke ʻoe i ke ʻano hoʻouka kaua, e kaomi i ke pihi "Recover" a hoʻomaka koke ʻo Passper for Excel e hana hou i ka ʻōlelo huna. Ma hope o kekahi mau minuke, e pau ke kaʻina hana a ʻike ʻoe i ka ʻōlelo huna ma ka pale.
Hiki iā ʻoe ke hoʻohana i ka ʻōlelo huna e wehe i ka palapala Excel i pale ʻia i kēia manawa.
Ala 2: Wehe i ka ʻōlelo huna mai ka faila Excel ma ka pūnaewele
ʻAʻohe pono e hoʻokomo i kekahi polokalamu ma kāu kamepiula e hoʻokaʻawale i ka ʻōlelo huna ma kāu palapala Excel. Hiki iā ʻoe ke hoʻohana i kekahi o nā mea hana pūnaewele i hoʻolālā ʻia no kēlā hana. He mea maikaʻi paha ka hoʻohana ʻana i kahi hāmeʻa pūnaewele iā ʻoe inā ʻaʻohe ʻike koʻikoʻi i loko o ka faila a nāwaliwali ka ʻōlelo huna i nīnau ʻia. ʻO ka hapa nui o nā mea hana pūnaewele e hoʻohana i kahi ala hoʻōla hoʻouka kaua a no laila ʻoi aku ka maikaʻi ma kahi o 21% o ka manawa. Aia kekahi mau mea hana pūnaewele i loaʻa ka 61% kūleʻa kūleʻa, akā he mau mea hana premium, ʻo ia hoʻi, pono ʻoe e uku no ka hoʻohana ʻana iā lākou.
Akā ʻo ka pōʻino nui loa o ka hoʻohana ʻana i nā mea hana pūnaewele ʻo ia ka mea pono e hoʻouka i ka faila Excel i ka pūnaewele pūnaewele. He pilikia kēia i ka ʻikepili ma ka faila Excel ʻoiai ʻaʻole ʻoe i ʻike i ka mea a nā mea nona ka mea hana pūnaewele e hana ai me kāu palapala ke wehe ʻia ka ʻōlelo huna.
Nā pōʻino o kēia ʻano:
- Haʻahaʻa holomua holomua : He haʻahaʻa loa ka helu hoʻihoʻi, emi iho ma mua o 100% ka nui o ka holomua.
- Ka palena nui o ka waihona : Loaʻa i nā mea wehe ʻōlelo huna Excel Online ka palena i ka nui o ka faila. No kekahi mau mea wehe ʻōlelo huna, ʻaʻole hiki ke ʻoi aku ka nui o ka faila ma mua o 10 MB.
- Hoʻōla lohi ka wikiwiki : I ka hoʻohana ʻana i ka ʻōlelo huna huna Excel ma ka pūnaewele, pono e loaʻa iā ʻoe kahi pilina pūnaewele paʻa a ikaika. A i ʻole, e lohi a paʻa paha ke kaʻina hana hoʻihoʻi.
Mahele 3: Wehe i ka ʻōlelo huna Excel e hana i nā hoʻololi
E like me kā mākou i ʻōlelo ai ma mua, ʻaʻole hiki ke loaʻa kahi palapala Excel ʻaʻole hiki ke hoʻololi ʻia. Hiki i ka mea nona ka palapala ke kau i nā kaohi i mea paʻakikī i nā mea hoʻohana ke hoʻoponopono i ka ʻike o ka palapala. I kēia hihia, hiki iā ʻoe ke hoʻāʻo i kekahi o kēia mau hopena:
Ala 1: E hoʻohana iā Passper no Excel (100% Success Rate)
Ma waho aʻe o ka hoʻihoʻi ʻana i ka ʻōlelo huna Excel, Passper no Excel He mea hana maikaʻi nō hoʻi ia no ka wehe ʻana i nā pāpalapala Excel / pepa hana / puke hana. Me kahi kaomi hoʻokahi, hiki ke hoʻopau ʻia nā palena hoʻoponopono a me ka hoʻopili ʻana me ka 100% kūleʻa.
Eia pehea e wehe ai i kāu papapalapala Excel:
KaʻAnuʻu 1 : E wehe i ka Passper no Excel ma kāu kamepiula a laila kaomi iā "Remove Restrictions."
KaʻAnuʻu 2 : Kaomi "E koho i kahi faila" e hoʻokomo i ka palapala i loko o ka papahana.
KaʻAnuʻu 3 : Ke hoʻohui ʻia ka palapala, kaomi i ka "Delete" a e wehe ka papahana i nā palena o ka palapala i 2 kekona wale nō.
Ala 2: Wehe i nā ʻōlelo huna Excel ma ka hoʻololi ʻana i ka hoʻonui faila
Inā ʻoe e hoʻohana ana iā MS Excel 2010 a i ʻole ma mua, hiki iā ʻoe ke wehe i ka palapala ma ka hoʻololi ʻana i ka hoʻonui faila. Penei ʻoe e hana ai.
KaʻAnuʻu 1 : E hoʻomaka ma ka hana ʻana i kope o ka faila Excel i pale ʻia e ka password, no laila loaʻa iā ʻoe kahi kope inā pilikia kekahi.
KaʻAnuʻu 2 : Kaomi ʻākau i ka faila a laila koho i ka "Rename." E hoʻololi i ka hoʻonui faila mai ".csv" a i ʻole ".xls" i ".zip".
KaʻAnuʻu 3 : Wehe i nā mea o ka waihona Zip i hana hou ʻia a laila hoʻokele i ka "xl\worksheets\". E ʻimi i ka pepa hana āu e makemake ai e wehe. Kaomi pololei ma luna a koho i ke koho "Edit" e wehe i ka faila ma Notepad.
KaʻAnuʻu 4 : E hoʻohana i ka hana "Ctrl + F" no ka wehe ʻana i ka hana ʻimi a huli iā "SheetProtection". Ke ʻimi nei ʻoe i kahi laina kikokikona e hoʻomaka me; «
KaʻAnuʻu 5 : Holoi i ka laina holoʻokoʻa o ka kikokikona a laila mālama i ka faila a pani. I kēia manawa, hoʻololi i ka hoʻonui faila i .csv a i ʻole .xls.
ʻAʻole pono ʻoe i ka ʻōlelo huna inā makemake ʻoe e hoʻoponopono a hoʻololi paha i ka pepa hana.
Nā pōʻino o kēia ʻano:
- Hana wale kēia ala no Excel 2010 a me nā mana mua.
- Hiki iā ʻoe ke wehe i hoʻokahi pepa hana i ka manawa. Inā loaʻa iā ʻoe nā pepa haʻawina mālama ʻōlelo huna ma kahi faila Excel, pono ʻoe e hana hou i nā ʻanuʻu ma luna no kēlā me kēia pepa.
Ala 3: E kiʻi i ka ʻōlelo huna Excel ma o Google Sheets
Ua hoʻokuʻu ʻo Google Drive i kahi mea hou e kākoʻo i nā palapala MS Office i pale ʻia e ka password. Hāʻawi ʻo Google Drive i kahi ala ʻoi aku ka paʻakikī e wehe i kekahi palapala Excel inā makemake ʻoe e hoʻololi. E haʻi aku kēia mau ʻanuʻu iā ʻoe pehea e wehe ai i kahi faila Excel i pale ʻia i ka password ma Google Sheets.
KaʻAnuʻu 1 : E hele i Google Drive ma kekahi polokalamu kele pūnaewele ma kāu kamepiula a e kau inoa inā ʻaʻole ʻoe.
KaʻAnuʻu 2 : Kaomi i ka ʻaoʻao "New" a koho iā Google Sheets. Inā ua kau mua ʻoe i kāu faila Excel i laka ʻia ma kāu Drive, hiki iā ʻoe ke koho "Wehe" e wehe pololei i ka faila. A i ʻole, pono ʻoe e hoʻouka i kāu faila ma ke kaomi ʻana i ke koho "Import".
KaʻAnuʻu 3 : E wehe i ka palapala Excel i pale ʻia a kaomi ma ka ʻaoʻao hema hema e koho i nā cell āpau i kēlā palapala.
KaʻAnuʻu 4 : Kaomi "Kopi" a i ʻole kaomi Ctrl + C.
KaʻAnuʻu 5 : E holo i kāu polokalamu MS Excel a pēhi iā Ctrl+ V. E hoʻoili ʻia nā ʻikepili a pau i ka pāpalapala Excel i mālama ʻia e ka password i kēia puke hana hou. Hiki iā ʻoe ke hoʻololi i ka palapala ma ke ʻano āu e makemake ai.
Nā pōʻino o kēia ʻano:
- Hoʻopau manawa kēia ʻano hana inā he nui nā pepa hana i laka ʻia i kāu palapala Excel.
- Pono ʻo Google Sheets i kahi pilina pūnaewele paʻa e hoʻouka ai i nā faila. Inā nāwaliwali kāu pili pūnaewele a i ʻole nui kāu faila Excel, lohi a hāʻule paha ke kaʻina hoʻoili.
Ke ala 4. Wehe i ka ʻōlelo huna Excel Spreadsheet me VBA Code
ʻO ke ala hope a mākou e nānā ai, ʻo ia ka hoʻohana ʻana i ka code VBA e wehe i ka pāpalapala Excel. E hana wale kēia ʻano hana no Excel 2010, 2007, a me nā mana mua. He mea nui e hoʻomaopopo i kēia ala hiki ke wehe wale i ka ʻōlelo huna mai ka pepa hana. He paʻakikī ke kaʻina hana wehe, no laila e kōkua nā ʻanuʻu aʻe.
KaʻAnuʻu 1 : E wehe i ka laulapalapala Excel i pale ʻia me MS Excel. E kaomi i "Alt+F11" e ho'ā i ka pukaaniani VBA.
KaʻAnuʻu 2 : Kaomi "Insert" a koho i "Module" mai nā koho.
KaʻAnuʻu 3 : E hookomo i keia code ma ka pukaaniani hou.
Sub PasswordBreaker()
'Breaks worksheet password protection.
Dim i 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 Resume Next
For i = 65 To 66: For j = 65 To 66: For k = 65 To 66
For l = 65 To 66: For m = 65 To 66: For i1 = 65 To 66
For i2 = 65 To 66: For i3 = 65 To 66: For i4 = 65 To 66
For i5 = 65 To 66: For i6 = 65 To 66: For n = 32 To 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)
If ActiveSheet.ProtectContents = False Then
MsgBox "One usable password is " & Chr(i) & Chr(j) & _
Chr(k) & Chr(l) & Chr(m) & Chr(i1) & Chr(i2) & _
Chr(i3) & Chr(i4) & Chr(i5) & Chr(i6) & Chr(n)
Exit Sub
End If
Next: Next: Next: Next: Next: Next
Next: Next: Next: Next: Next: Next
End Sub
KaʻAnuʻu 4 : E kaomi i ka F5 e hoʻokō i ke kauoha.
KaʻAnuʻu 5 : E kau ma kahi minuke. E hōʻike ʻia kahi pahu kamaʻilio hou me kahi ʻōlelo huna. Kaomi "OK" a laila pani i ka pukaaniani VBA.
KaʻAnuʻu 6 : E hoʻi i kāu papapalapala Excel i mālama ʻia. I kēia manawa, e ʻike ʻoe ua nānā ʻia ka pepa hana.
Nā pōʻino o kēia ʻano:
- Inā nui nā pepa haʻawina mālama ʻōlelo huna i kāu Excel, pono ʻoe e hana hou i nā ʻanuʻu ma luna no kēlā me kēia pepa haʻawina.
Ka hopena
ʻAʻole paʻakikī ka wehe ʻana i kahi ʻōlelo huna mai kahi palapala Excel. Me ka wikiwiki o ka ho'ōla hou ʻana, ʻoi aku ka nui o nā ʻano hoʻouka kaua a me ka helu hoʻōla kiʻekiʻe, Passper no Excel hāʻawi i ke koho maikaʻi loa e wehe koke i ka ʻōlelo huna mai kekahi palapala Excel.