Njira 6 zochotsera mawu achinsinsi pafayilo ya Excel [2023 Guide]

Chimodzi mwazinthu zabwino kwambiri za Excel ndikutha kuteteza mafayilo anu pamilingo yonse. Mukhoza kusankha kuteteza Buku la Ntchito kuti lisasinthe kamangidwe, kutanthauza kuti anthu osaloledwa sangasinthe chiwerengero kapena dongosolo la mapepala mu bukhuli. Mukhozanso kukhazikitsa mawu achinsinsi kuti mulepheretse aliyense kusintha mapepala, zomwe zikutanthauza kuti sangathe kukopera, kusintha kapena kuchotsa zilizonse zomwe zili pamasamba. Ndipo mutha kukhazikitsanso mawu achinsinsi otsegulira omwe angalepheretse wina kutsegula chikalatacho pokhapokha ali ndi mawu achinsinsi.

Ngakhale mawu achinsinsiwa amatha kukhala othandiza, amathanso kukulepheretsani kupeza kapena kusintha chikalatacho mukafuna. Ngati simungathe kupeza chikalata cha Excel kapena spreadsheet chifukwa simudziwa mawu achinsinsi kapena mwaiwala, nkhaniyi ikuthandizani kwambiri. Mmenemo, tiwona njira zina zomwe mungachotsere mawu achinsinsi pa chikalata cha Excel.

Gawo 1: Kodi pali mwayi wochotsa mawu achinsinsi ku Excel

Tisanakambirane momwe mungachotsere mawu achinsinsi pa pepala la Excel, tikuganiza kuti tikuyenera kuthana ndi lingaliro lachinsinsi lotsegula ndi kuthekera kotsegula achinsinsi a Excel.

Kutsegula mawu achinsinsi ndi njira yomwe imagwiritsa ntchito njira zosiyanasiyana kuti mubwezeretse kapena kuchotsa mawu achinsinsi ku data yosungidwa kapena yofalitsidwa kudzera pakompyuta. Imodzi mwa njira zomwe zimagwiritsidwa ntchito kwambiri kuchotsa mawu achinsinsi ndi njira ya brute force attack. Njirayi imagwiritsa ntchito njira yongoyerekeza yomwe imangoyerekeza mobwerezabwereza mawu achinsinsi osiyanasiyana mpaka mawu achinsinsi olondola apezeka. Ndiye zotheka kuchotsa mawu achinsinsi a Excel ndi chiyani? Kunena zoona, palibe pulogalamu yomwe ingatsimikizire kuti 100% yapambana pamsika. Koma pulogalamu yabwino kwambiri yosateteza masamba a Excel imatha kufupikitsa nthawi. Choncho, mwayi wochotsa fungulo ukhoza kuwonjezeka kwambiri.

Kwa anthu omwe si aukadaulo, tikukulimbikitsani kuti muyese chotsegula achinsinsi cha Excel kukuthandizani kuchotsa mawu achinsinsi pamafayilo a Excel.

Gawo 2: Kodi kuchotsa achinsinsi mwamsanga

Ngati simungathe kutsegula chikalata cha Excel popanda mawu achinsinsi, izi ndi zina mwazosankha zomwe mungayesere.

Njira 1: Chotsani Mawu Achinsinsi pa Fayilo ya Excel yokhala ndi Passper ya Excel

Kuti mukhale ndi mwayi wopambana, mungafune kugwiritsa ntchito pulogalamu yamphamvu: Passper kwa Excel . Iyi ndi pulogalamu yotsegula mawu achinsinsi yomwe ingakhale yothandiza kukuthandizani kudutsa mawu achinsinsi otsegulira muzolemba zilizonse za Excel, ngakhale mtundu waposachedwa. Iwo ali angapo mbali lakonzedwa kuti achinsinsi kuchira mosavuta. Iwo akuphatikizapo zotsatirazi:

• Liwiro lotsegula mwachangu achinsinsi : Iwo ali mmodzi wa yachangu achinsinsi Tsegulani liwiro pa msika, kutsimikizira pafupifupi 3,000,000 mapasiwedi pa sekondi.
• Kuthekera kwakukulu kobwezeretsa mawu achinsinsi - Imakupatsirani mwayi wosankha pamitundu 4 yowukira ndi mtanthauzira mawu mamiliyoni ambiri achinsinsi omwe amagwiritsidwa ntchito pafupipafupi, kukulitsa mwayi wobwezeretsa mawu achinsinsi ndikuchepetsa kwambiri nthawi yochira.
• Palibe kutaya deta : Palibe chidziwitso mu chikalata chanu cha Excel chomwe chidzakhudzidwe mwanjira iliyonse ndi kuchira.
• Chitetezo cha data : Simufunikanso kukweza fayilo yanu ku seva yawo, chifukwa chake, zinsinsi zanu zachinsinsi ndizolonjezedwa 100%.
• Palibe malire : Pulogalamuyi imagwirizana ndi mitundu yonse ya Windows ndi mitundu ya Excel. Kuphatikiza apo, palibe malire pa kukula kwa fayilo.

Yesani kwaulere

Umu ndi momwe mungagwiritsire ntchito Passper for Excel kuti mutsegule fayilo ya Excel yotetezedwa ndi mawu achinsinsi.

Gawo 1 : Ikani Passper ya Excel pa kompyuta yanu ndikuyiyambitsa. Mu zenera lalikulu, alemba "Yamba Achinsinsi".

Gawo 2 : Dinani batani la "+" kuti musankhe chikalata cha Excel chomwe mukufuna kuti musachiteteze. Pamene chikalata anawonjezera pulogalamu, kusankha kuukira akafuna mukufuna kugwiritsa ntchito ndi kumadula "Yamba." Njira yowukira yomwe mumasankha idzatengera zovuta zachinsinsi komanso ngati mulibe lingaliro lililonse kuti lingakhale chiyani.

Gawo 3 : Mwamsanga pamene inu kusankha kuukira akafuna, dinani pa "Yamba" batani ndi Passper kwa Excel yomweyo kuyamba ntchito kuti achire achinsinsi. Patapita mphindi zingapo, ndondomeko adzamaliza ndipo muyenera kuona achinsinsi pa zenera.

Mutha kugwiritsa ntchito mawu achinsinsi omwe adachira kuti mutsegule chikalata chotetezedwa cha Excel tsopano.

Yesani kwaulere

Njira 2: Chotsani mawu achinsinsi ku fayilo ya Excel pa intaneti

Palibe chifukwa choyika pulogalamu iliyonse pakompyuta yanu kuti musinthe mawu achinsinsi otsegulira muzolemba zanu za Excel. Mutha kugwiritsa ntchito imodzi mwa zida zambiri zapaintaneti zomwe zidapangidwira ntchitoyi. Kugwiritsa ntchito chida chapaintaneti kungakhale koyenera kwa inu ngati fayilo ilibe chidziwitso chofunikira komanso mawu achinsinsi omwe akufunsidwa ndi ofooka. Zida zambiri zapaintaneti zimagwiritsa ntchito njira yopulumutsira mwankhanza ndipo zimangogwira ntchito pafupifupi 21% yanthawiyo. Pali zida zina zapaintaneti zomwe zimapambana 61%, koma ndi zida zoyambira, kutanthauza kuti muyenera kulipira kuti muzigwiritsa ntchito.

Koma mwina choyipa chachikulu chogwiritsa ntchito zida zapaintaneti ndikuti muyenera kukweza fayilo ya Excel papulatifomu yapaintaneti. Izi zimabweretsa chiwopsezo ku data yomwe ili mufayilo ya Excel popeza simudziwa zomwe eni ake chida chapaintaneti angachite ndi chikalata chanu mawu achinsinsi atachotsedwa.

Kuipa kwa njira iyi:

• Otsika bwino mlingo : Mlingo wochira ndiwotsika kwambiri, wochepera 100% wopambana.
• Kuchepetsa kukula kwa fayilo : Otsegula achinsinsi pa intaneti a Excel nthawi zonse amakhala ndi malire pakukula kwa fayilo. Kwa ena otsegula achinsinsi, kukula kwa fayilo sikungapitirire 10 MB.
• Kuthamanga kwapang'onopang'ono : Mukamagwiritsa ntchito Excel password Tsegulani pa intaneti, muyenera kukhala ndi intaneti yokhazikika komanso yamphamvu. Kupanda kutero, kuchira kudzakhala pang'onopang'ono kapena kukhazikika.

Gawo 3: Dulani mawu achinsinsi a Excel kuti musinthe

Monga tanena kale, sizingatheke kupeza chikalata cha Excel chomwe sichingasinthidwe. Mwini chikalatacho atha kuyika zoletsa zomwe zimapangitsa kuti zikhale zovuta kwa ogwiritsa ntchito kusintha zomwe zili mu chikalatacho. Pankhaniyi, mukhoza kuyesa imodzi mwa njira zotsatirazi:

Njira 1: Gwiritsani Ntchito Passper ya Excel (100% Kupambana Rate)

Kuphatikiza pa Excel password recovery, Passper kwa Excel Ndi chida chabwino kwambiri chotsegulira Excel spreadsheets/worksheets/workbooks. Ndi kungodina kamodzi, zoletsa zonse zosintha ndi masanjidwe zitha kuchotsedwa ndikuchita bwino kwa 100%.

Yesani kwaulere

Umu ndi momwe mungatsegulire spreadsheet/bookbook ya Excel:

Gawo 1 : Tsegulani Passper ya Excel pa kompyuta yanu ndikudina "Chotsani Zoletsa."

Gawo 2 : Dinani "Sankhani Fayilo" kuitanitsa chikalata mu pulogalamu.

Gawo 3 : Chikalatacho chikawonjezedwa, dinani "Chotsani" ndipo pulogalamuyo idzachotsa zoletsa zilizonse pachikalatacho mumasekondi awiri okha.

Yesani kwaulere

Njira 2: Chotsani Mawu achinsinsi a Excel mwa Kusintha Kukulitsa Fayilo

Ngati mukugwiritsa ntchito MS Excel 2010 kapena m'mbuyomu, mutha kutsegula chikalatacho posintha fayilo yowonjezera. Umu ndi momwe mumachitira.

Gawo 1 : Yambani ndikupanga kopi ya fayilo ya Excel yotetezedwa ndi mawu achinsinsi, kuti mukhale ndi kopi ngati china chake chalakwika.

Gawo 2 : Dinani kumanja wapamwamba ndiyeno kusankha "Rename." Sinthani fayilo yowonjezera kuchoka ku ".csv" kapena ".xls" kukhala ".zip".

Gawo 3 : Tsegulani zomwe zili mu fayilo ya Zip yomwe yangopangidwa kumene ndiyeno pitani ku "xl\worksheets\". Pezani tsamba lantchito lomwe mukufuna kutsegula. Dinani pomwepo ndikusankha "Sinthani" kuti mutsegule fayilo mu Notepad.

Gawo 4 : Gwiritsani ntchito "Ctrl + F" kuti mutsegule ntchito yosaka ndikusaka "SheetProtection". Mukuyang'ana mzere wamawu womwe umayamba ndi; «

Gawo 5 : Chotsani mzere wonse wa zolemba ndikusunga fayilo ndikutseka. Tsopano sinthani fayilo yowonjezera kukhala .csv kapena .xls.

Simudzafunikanso mawu achinsinsi mukafuna kusintha kapena kusintha tsambalo.

Kuipa kwa njira iyi:

• Njirayi imagwira ntchito ku Excel 2010 ndi mitundu yakale.
• Mutha kutsegula tsamba limodzi lokha nthawi imodzi. Ngati muli ndi mapepala ambiri otetezedwa ndi mawu achinsinsi mu fayilo ya Excel, muyenera kubwereza masitepe omwe ali pamwamba pa pepala lililonse.

Njira 3: Pezani Mawu achinsinsi a Excel kudzera pa Google Mapepala

Google Drive yatulutsa zosintha zatsopano zothandizira zolemba za MS Office zotetezedwa ndi mawu achinsinsi. Google Drive imapereka njira yosavuta yotsegulira chikalata chilichonse cha Excel mukafuna kusintha. Njira zotsatirazi zikuuzani momwe mungatsegulire fayilo ya Excel yotetezedwa ndi mawu achinsinsi mu Google Mapepala.

Gawo 1 : Pitani pa Google Drive pa msakatuli uliwonse pa kompyuta yanu ndipo lowani ngati simunalowepo.

Gawo 2 : Dinani tabu "Chatsopano" ndikusankha Mapepala a Google. Ngati mwayika kale fayilo yanu ya Excel yokhoma pa Drive yanu, mutha kusankha "Open" kuti mutsegule fayiloyo mwachindunji. Kupanda kutero, muyenera kukweza fayilo yanu podina "Import" njira.

Gawo 3 : Tsopano tsegulani chikalata chotetezedwa cha Excel ndiyeno dinani pakona yakumanzere kuti musankhe ma cell onse omwe ali mu chikalatacho.

Gawo 4 : Dinani "Matulani" kapena dinani Ctrl + C.

Gawo 5 : Tsopano yendetsani pulogalamu yanu ya MS Excel ndikusindikiza Ctrl+ V. Deta yonse yomwe ili mu password yotetezedwa ya Excel spreadsheet idzasamutsidwa ku bukhu lantchito latsopanoli. Kenako mutha kusintha chikalatacho mwanjira iliyonse yomwe mukufuna.

Kuipa kwa njira iyi:

• Njirayi ikudya nthawi ngati pali masamba ambiri otsekedwa muzolemba zanu za Excel.
• Google Sheets imafuna intaneti yokhazikika kuti ikweze mafayilo. Ngati intaneti yanu ili yofooka kapena fayilo yanu ya Excel ndi yayikulu, njira yolowetsamo imakhala yochedwa kapena kuwonongeka.

Njira 4. Chotsani Mawu achinsinsi a Excel Spreadsheet ndi VBA Code

Njira yomaliza yomwe tiwona ndikugwiritsa ntchito VBA code kuti mutsegule spreadsheet ya Excel. Njirayi idzagwira ntchito ku Excel 2010, 2007, ndi mitundu yoyambirira. Ndikofunika kuzindikira kuti njirayi imatha kuchotsa mawu achinsinsi papepala. Njira yotsegula ndiyovuta, kotero zotsatirazi zidzakhala zothandiza.

Gawo 1 : Tsegulani achinsinsi otetezedwa Excel spreadsheet ndi MS Excel. Press "Alt+F11" kuti yambitsa VBA zenera.

Gawo 2 : Dinani "Ikani" ndikusankha "Module" kuchokera pazosankha.

Gawo 3 : Lowetsani malamulo otsatirawa pawindo latsopano.

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

Gawo 4 : Dinani F5 kuti mupereke lamulo.

Gawo 5 : Khalani pafupi. Bokosi latsopano la zokambirana lidzawoneka ndi mawu achinsinsi ogwiritsidwa ntchito. Dinani "Chabwino" ndiyeno kutseka VBA zenera.

Gawo 6 : Bwererani ku spreadsheet yanu yotetezedwa ya Excel. Tsopano, mupeza kuti tsamba lantchito lafufuzidwa.

Kuipa kwa njira iyi:

• Ngati pali mapepala otetezedwa achinsinsi mu Excel yanu, muyenera kubwereza masitepe omwe ali pamwambapa patsamba lililonse.

Mapeto

Kuchotsa mawu achinsinsi pa chikalata cha Excel sikuyenera kukhala kovuta. Ndi kuthamanga kwachangu kwambiri, njira zambiri zowukira komanso kuchira kwapamwamba, Passper kwa Excel imapereka njira yabwino kwambiri yochotsera mawu achinsinsi pachikalata chilichonse cha Excel.

Yesani kwaulere