Ɗaya daga cikin mafi kyawun abubuwa game da Excel shine ikon kare fayilolinku a kowane matakai. Kuna iya zaɓar don kare littafin Aiki daga canje-canjen tsari, ma'ana cewa mutane marasa izini ba za su iya canza lamba ko tsari na zanen gado a cikin littafin aiki ba. Hakanan zaka iya saita kalmar sirri don hana kowa canza takaddun aikin, wanda ke nufin ba za su iya kwafi, gyara ko share kowane abun ciki daga takaddun aikin ba. Sannan zaku iya saita kalmar sirri ta budewa wanda zai hana wani bude takardar sai dai idan yana da kalmar sirri.
Yayin da waɗannan kalmomin shiga za su iya yin tasiri, kuma suna iya hana ku shiga ko gyara takaddun lokacin da kuke buƙata. Idan ba za ku iya samun dama ga takaddun Excel ko maƙunsar bayanai ba saboda ba ku san kalmar sirri ba ko kuma kun manta da shi, wannan labarin zai taimaka sosai. A ciki, zamu kalli wasu hanyoyin da zaku iya cire kalmar sirri daga takaddar Excel.
Sashe na 1: Menene yuwuwar cire kalmar sirri daga Excel
Kafin mu tattauna yadda zaku iya cire kalmar sirri daga takardar Excel, muna tsammanin muna buƙatar magance babban manufar buɗe kalmar sirri da yuwuwar buɗe kalmar sirri ta Excel.
Buɗe kalmar sirri tsari ne da ke amfani da hanyoyi daban-daban don dawo da ko cire kalmar sirri daga bayanan da aka adana ko aikawa ta hanyar kwamfuta. Ɗaya daga cikin hanyoyin da aka fi amfani da su don cire kalmar sirri ita ce hanyar kai hari. Wannan hanyar tana amfani da hanyar zato wanda ke yawan yin hasashen kalmomin sirri daban-daban har sai an sami kalmar sirri daidai. Don haka menene yiwuwar cire kalmar sirri ta Excel? Gaskiyar magana, babu wani shirin da zai iya ba da tabbacin samun nasara 100% a kasuwa. Amma kyakkyawan shirin don rashin tsaro zanen gadon Excel na iya rage lokaci sosai. Saboda haka, damar cire maɓalli na iya ƙaruwa sosai.
Ga mutanen da ba fasaha ba, muna ba da shawarar ku gwada maɓallan kalmar sirri na Excel don taimaka muku cire kalmar sirri daga fayilolin Excel.
Part 2: Yadda ake cire kalmar sirri da sauri
Idan ba za ku iya buɗe takaddar Excel ba tare da kalmar sirri ba, waɗannan su ne wasu zaɓuɓɓukan da zaku iya gwadawa.
Hanyar 1: Cire Kalmar wucewa daga Fayil na Excel tare da Fasfo don Excel
Don mafi kyawun damar samun nasara, kuna iya amfani da shiri mai ƙarfi: Fasfo don Excel . Wannan shirin buɗe kalmar sirri ne wanda zai iya zama da amfani wajen taimaka muku ketare kalmar sirri ta buɗe kowane takaddar Excel, har ma da sabon sigar. Yana da fasalulluka da dama da aka ƙera don mai da kalmar sirri mai sauƙi. Sun hada da kamar haka:
- Gudun buɗe kalmar sirri mafi sauri : Yana da saurin buɗe kalmar sirri mafi sauri a kasuwa, yana iya tantance kalmar sirri kusan 3,000,000 a sakan daya.
- Matsakaicin yuwuwar dawo da kalmar wucewa - Yana ba ku zaɓi don zaɓar daga yanayin hari guda 4 da ƙamus na miliyoyin kalmomin shiga da ake yawan amfani da su, yana ƙara haɓaka damar dawo da kalmar wucewa da rage lokacin dawowa sosai.
- Babu asarar bayanai : Babu wani daga cikin bayanai a cikin Excel daftarin aiki da za a shafa a kowace hanya da dawo da tsari.
- Tsaron bayanai : Ba kwa buƙatar loda fayil ɗin ku zuwa uwar garken su, don haka, sirrin bayanan ku an yi alkawari 100%.
- Babu iyaka : Shirin ya dace da duk nau'ikan Windows da nau'ikan Excel. Bugu da ƙari, babu iyakance akan girman fayil.
Wannan shine yadda zaku iya amfani da Fasfo don Excel don buɗe fayil ɗin Excel mai kare kalmar sirri.
Mataki na 1 : Sanya Fasfo na Excel akan kwamfutarka sannan ka kaddamar da shi. A cikin babban taga, danna "Maida kalmomin shiga".
Mataki na 2 : Danna maɓallin "+" don zaɓar takaddun Excel da kake son kare shi. Lokacin da aka ƙara daftarin aiki a cikin shirin, zaɓi yanayin harin da kuke son amfani da shi kuma danna "Maida." Yanayin harin da kuka zaɓa zai dogara ne da sarƙaƙƙiyar kalmar sirri da ko kuna da wani ra'ayi ko menene zai kasance.
Mataki na 3 : Da zarar ka zaɓi yanayin harin, danna maɓallin "Maida" kuma Fas ɗin don Excel zai fara aiki nan da nan don dawo da kalmar wucewa. Bayan 'yan mintoci kaɗan, tsarin zai ƙare kuma ya kamata ku ga kalmar sirri akan allon.
Kuna iya amfani da kalmar sirri da aka dawo dasu don buɗe takaddun Excel mai kariya yanzu.
Hanyar 2: Cire kalmar sirri daga fayil na Excel akan layi
Babu buƙatar shigar da kowace software akan kwamfutarka don warware kalmar sirrin buɗewa a cikin takaddar Excel. Kuna iya amfani da ɗayan kayan aikin kan layi da yawa da aka tsara don wannan aikin. Yin amfani da kayan aikin kan layi na iya zama manufa a gare ku idan fayil ɗin bai ƙunshi mahimman bayanai ba kuma kalmar sirrin da ake tambaya tana da rauni sosai. Yawancin kayan aikin kan layi suna amfani da hanyar dawo da farmakin ƙarfi don haka kawai suna da tasiri kusan kashi 21% na lokaci. Akwai wasu kayan aikin kan layi waɗanda ke da ƙimar nasara 61%, amma kayan aikin ƙima ne, ma'ana dole ne ku biya don amfani da su.
Amma watakila babban rashin amfani da kayan aikin kan layi shine gaskiyar cewa dole ne ka loda fayil ɗin Excel zuwa dandalin kan layi. Wannan yana haifar da haɗari ga bayanan da ke cikin fayil ɗin Excel tunda ba ku san abin da masu kayan aikin kan layi za su yi da takaddar ku ba da zarar an cire kalmar sirri.
Fursunoni na wannan hanyar:
- Ƙananan nasara ƙimar : Adadin farfadowa yana da ƙasa sosai, ƙasa da ƙimar nasara 100%.
- Iyakar girman fayil : Masu buɗe kalmar sirri na Excel akan layi koyaushe suna da iyakancewa akan girman fayil. Ga wasu masu buɗe kalmar sirri, girman fayil ɗin ba zai iya wuce 10 MB ba.
- Sannun saurin dawowa : Lokacin amfani da buɗe kalmar sirri ta Excel akan layi, dole ne ku sami kwanciyar hankali da haɗin Intanet mai ƙarfi. In ba haka ba, tsarin dawowa zai kasance da jinkirin gaske ko ma makale.
Sashe na 3: karya kalmar sirri ta Excel don yin gyare-gyare
Kamar yadda muka ambata a baya, kuma ba zai yuwu a sami takaddar Excel wacce ba za a iya gyara ta ba. Mai daftarin aiki zai iya sanya ƙuntatawa waɗanda ke da wahala ga masu amfani don gyara abubuwan cikin takaddar. A wannan yanayin, zaku iya gwada ɗayan mafita masu zuwa:
Hanyar 1: Yi amfani da Fasfo don Excel (Ratin Nasara 100%)
Baya ga dawo da kalmar wucewa ta Excel, Fasfo don Excel Hakanan babban kayan aiki ne don buɗe maƙunsar bayanai na Excel / takaddun aiki / littattafan aiki. Tare da dannawa ɗaya, duk ƙuntatawa na gyarawa da tsarawa za a iya cire su tare da ƙimar nasara 100%.
Anan ga yadda ake buše maƙunsar rubutu/littafin aiki na Excel:
Mataki na 1 : Buɗe Fasfo don Excel akan kwamfutarka sannan danna "Cire ƙuntatawa."
Mataki na 2 : Danna "Zaɓi Fayil" don shigo da daftarin aiki a cikin shirin.
Mataki na 3 : Da zarar an ƙara daftarin aiki, danna "Share" kuma shirin zai cire duk wani ƙuntatawa akan takaddun a cikin dakika 2 kawai.
Hanyar 2: Cire Kalmomin sirri na Excel ta Canza Fayil Fayil
Idan kuna amfani da MS Excel 2010 ko a baya, zaku iya buɗe takaddar ta canza tsawo na fayil. Wannan shine yadda kuke yi.
Mataki na 1 : Fara da ƙirƙirar kwafin fayil ɗin Excel mai kare kalmar sirri, don haka kuna da kwafin idan wani abu ya faru.
Mataki na 2 : Danna-dama akan fayil ɗin sannan zaɓi "Sake suna." Canja tsawo na fayil daga ".csv" ko ".xls" zuwa ".zip".
Mataki na 3 : Cire abubuwan da ke cikin sabon fayil ɗin Zip ɗin da aka ƙirƙira sannan kewaya zuwa "xl\worksheets\". Nemo takardar aikin da kake son buɗewa. Dama danna shi kuma zaɓi zaɓi "Edit" don buɗe fayil ɗin a cikin Notepad.
Mataki na 4 : Yi amfani da aikin "Ctrl + F" don buɗe aikin bincike kuma bincika "SheetProtection". Kuna neman layin rubutu wanda ya fara da; «
Mataki na 5 : Share duk layin rubutu sannan ka ajiye fayil ɗin kuma rufe shi. Yanzu canza tsawo na fayil zuwa .csv ko .xls.
Ba za ku ƙara buƙatar kalmar sirri ba lokacin da kuke son gyara ko gyara takardar aikin.
Fursunoni na wannan hanyar:
- Wannan hanyar tana aiki ne kawai don Excel 2010 da sigogin baya.
- Zaku iya buɗe takaddar aiki ɗaya kawai a lokaci guda. Idan kuna da takaddun aiki masu kariya da kalmar sirri da yawa a cikin fayil ɗin Excel, dole ne ku maimaita matakan da ke sama don kowace takarda.
Hanyar 3: Samun Kalmar wucewa ta Excel ta Google Sheets
Google Drive ya fitar da sabon sabuntawa don tallafawa takaddun MS Office masu kariya da kalmar sirri. Google Drive yana ba da hanyar da ba ta da rikitarwa don buɗe kowane takaddar Excel lokacin da kuke son gyara ta. Matakan da ke biyowa za su gaya muku yadda ake buɗe fayil ɗin Excel mai kare kalmar sirri a cikin Google Sheets.
Mataki na 1 : Jeka Google Drive a kowace browser da ke kan kwamfutarka kuma shiga idan ba ka rigaya ba.
Mataki na 2 : Danna shafin "Sabo" kuma zaɓi Google Sheets. Idan kun riga kun sanya fayil ɗin Excel ɗin ku a kulle akan Drive ɗinku, zaku iya zaɓar "Buɗe" don buɗe fayil ɗin kai tsaye. In ba haka ba, dole ne ka loda fayil ɗinka ta danna kan zaɓin "Import".
Mataki na 3 : Yanzu buɗe takaddun Excel mai kariya sannan danna kan kusurwar hagu na sama don zaɓar duk ƙwayoyin da ke cikin wannan takaddar.
Mataki na 4 : Danna "Copy" ko danna Ctrl + C.
Mataki na 5 : Yanzu gudanar da shirin MS Excel ɗin ku kuma danna Ctrl+ V. Duk bayanan da ke cikin maƙunsar bayanan Excel mai kare kalmar sirri za a canza su zuwa wannan sabon littafin aiki. Sannan zaku iya canza takaddar ta kowace hanya da kuke so.
Fursunoni na wannan hanyar:
- Wannan hanyar tana ɗaukar lokaci idan akwai takaddun aiki da yawa da aka kulle a cikin takaddar Excel.
- Google Sheets yana buƙatar tsayayyen haɗin Intanet don loda fayiloli. Idan haɗin Intanet ɗin ku yana da rauni ko fayil ɗin Excel ɗinku yana da girma, tsarin lodawa zai yi jinkiri ko ma faɗuwa.
Hanya 4. Cire Kalmar wucewa ta Excel tare da lambar VBA
Hanya ta ƙarshe da za mu duba ita ce amfani da lambar VBA don buɗe maƙunsar bayanai na Excel. Wannan hanyar za ta yi aiki ne kawai don Excel 2010, 2007, da sigogin farko. Yana da mahimmanci a lura cewa wannan hanyar za ta iya cire kalmar sirri kawai daga takaddar aiki. Tsarin buɗewa yana da rikitarwa, don haka matakai masu zuwa zasu taimaka.
Mataki na 1 : Bude maƙunsar bayanan Excel mai kare kalmar sirri tare da MS Excel. Danna "Alt+F11" don kunna taga VBA.
Mataki na 2 : Danna "Saka" kuma zaɓi "Module" daga zaɓuɓɓukan.
Mataki na 3 Shigar da lambar mai zuwa a cikin sabuwar taga.
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
Mataki na 4 : Danna F5 don aiwatar da umarnin.
Mataki na 5 : Tsaya a kan minti daya. Sabon akwatin maganganu zai bayyana tare da kalmar sirri mai amfani. Danna "Ok" sannan ku rufe taga VBA.
Mataki na 6 : Koma zuwa maƙunsar bayanan ku na Excel mai kariya. Yanzu, za ku ga cewa an duba takardar aikin.
Fursunoni na wannan hanyar:
- Idan akwai takaddun aiki masu kariya da kalmar sirri da yawa a cikin Excel ɗinku, dole ne ku maimaita matakan da ke sama don kowane takaddar aiki.
Kammalawa
Cire kalmar sirri daga takaddar Excel ba lallai ne ya zama da wahala ba. Tare da mafi saurin murmurewa, ƙarin hanyoyin kai hari da ƙimar farfadowa mafi girma, Fasfo don Excel yana gabatar da mafi kyawun zaɓi don cire kalmar sirri da sauri daga kowace takaddar Excel.
![Yadda ake Cire Kalmar wucewa daga Aikin VBA na Excel [Hanyoyin 4]](https://www.passmapa.com/images/desbloquear-proyecto-vba-excel-390x220.png)