Izindlela ezi-6 zokususa iphasiwedi efayeleni le-Excel [2023 Guide]

Enye yezinto ezinhle kakhulu nge-Excel yikhono lokuvikela amafayela akho kuwo wonke amazinga. Ungakhetha ukuvikela Ibhuku Lokusebenzela ezinguqukweni zesakhiwo, okusho ukuthi abantu abangagunyaziwe abakwazi ukushintsha inombolo noma ukuhleleka kwamakhasi encwadini yokusebenzela. Ungase futhi usethe iphasiwedi ukuze uvimbele noma ubani ekuguquleni amaphepha okusebenza, okusho ukuthi ngeke akwazi ukukopisha, ukuhlela noma ukususa noma yikuphi okuqukethwe kumakhasi okusebenzela. Futhi ungasetha nephasiwedi yokuvula ezovimbela othile ukuthi avule idokhumenti ngaphandle uma enephasiwedi.

Nakuba lawa magama ayimfihlo esebenza kahle, angaphinde akuvimbele ukuthi ufinyelele noma uguqule idokhumenti uma uyidinga. Uma ungakwazi ukufinyelela idokhumenti ye-Excel noma isipredishithi ngenxa yokuthi awuyazi iphasiwedi noma uyikhohliwe, lesi sihloko sizosiza kakhulu. Kuyo, sizobheka ezinye zezindlela ongasusa ngazo iphasiwedi kudokhumenti ye-Excel.

Ingxenye 1: Ayini amathuba okukhipha iphasiwedi ku-Excel

Ngaphambi kokuxoxa ngokuthi ungayisusa kanjani iphasiwedi eshidini le-Excel, sicabanga ukuthi sidinga ukubhekana nomqondo ojwayelekile wokuvula iphasiwedi kanye nethuba lokuvula iphasiwedi ye-Excel.

Ukuvula iphasiwedi kuyinqubo esebenzisa izindlela ezihlukene zokubuyisela noma ukususa iphasiwedi kudatha egcinwe noma edluliswa ngesistimu yekhompyutha. Enye yezindlela ezisetshenziswa kakhulu ukususa iphasiwedi yindlela yokuhlasela ye-brute force. Le ndlela isebenzisa indlela yokuqagela eqagela ngokuphindaphindiwe amagama ayimfihlo ahlukene kuze kutholakale igama-mfihlo elilungile. Ngakho-ke kungenzeka yini ukususa iphasiwedi ye-Excel? Iqiniso liyatshelwa, alukho uhlelo olungaqinisekisa izinga lempumelelo elingu-100% emakethe. Kodwa uhlelo oluhle kakhulu lokungavikeli amashidi e-Excel lunganciphisa kakhulu isikhathi. Ngakho-ke, ithuba lokukhipha ukhiye lingakhula kakhulu.

Kubantu abangebona abezobuchwepheshe, sincoma kakhulu ukuthi uzame isivula iphasiwedi se-Excel ukuze sikusize ususe iphasiwedi kumafayela e-Excel.

Ingxenye 2: Indlela ukususa iphasiwedi ngokushesha

Uma ungakwazi ukuvula idokhumenti ye-Excel ngaphandle kwephasiwedi, okulandelayo ngezinye zezinketho ongazizama.

Indlela 1: Khipha Iphasiwedi Efayeleni le-Excel nge-Passer ye-Excel

Ukuze ube sethubeni elingcono kakhulu lempumelelo, ungase ufune ukusebenzisa uhlelo olunamandla: I-Passer ye-Excel . Lolu wuhlelo lokuvula iphasiwedi olungaba usizo ekukusizeni udlule iphasiwedi evulayo kunoma iyiphi idokhumenti ye-Excel, ngisho nenguqulo yakamuva. Inezici eziningi ezidizayinelwe ukwenza ukutholwa kwephasiwedi kube lula kakhulu. Zihlanganisa okulandelayo:

• Isivinini sokuvula iphasiwedi esisheshayo : Inesinye sezivinini zokuvula amaphasiwedi ezisheshayo emakethe, ekwazi ukuqinisekisa cishe amaphasiwedi angu-3,000,000 ngomzuzwana.
• Amathuba amaningi okuthola iphasiwedi - Ikunikeza inketho yokukhetha ezindleleni ezi-4 zokuhlasela kanye nesichazamazwi sezigidi zamaphasiwedi asetshenziswa njalo, kukhulise kakhulu amathuba okuthola kabusha iphasiwedi futhi kunciphisa kakhulu isikhathi sokuphinda uthole.
• Akukho ukulahleka kwedatha : Ayikho idatha kudokhumenti yakho ye-Excel ezothintwa nganoma iyiphi indlela inqubo yokuphinda uthole.
• Ukuphepha kwedatha : Awudingi ukulayisha ifayela lakho kuseva yabo, ngakho-ke, ubumfihlo bedatha yakho buthenjisiwe ngo-100%.
• Akukho mkhawulo : Uhlelo luhambisana nazo zonke izinguqulo ze-Windows nezinguqulo ze-Excel. Ukwengeza, awukho umkhawulo kusayizi wefayela.

Yizame mahhala

Le yindlela ongasebenzisa ngayo i-Passer ye-Excel ukuze uvule ifayela le-Excel elivikelwe ngephasiwedi.

Isinyathelo 1 : Faka i-Passer ye-Excel kukhompyutha yakho bese uyivula. Ewindini elikhulu, chofoza "Phinda kabusha Amagama-mfihlo".

Isinyathelo sesi-2 : Chofoza inkinobho ethi “+” ukuze ukhethe idokhumenti ye-Excel ofuna ukungayivikeli. Uma idokhumenti yengezwe kuhlelo, khetha imodi yokuhlasela ongathanda ukuyisebenzisa bese uchofoza okuthi "Buyisa." Imodi yokuhlasela oyikhethayo izoncika ebunzimeni bephasiwedi kanye nokuthi unawo yini umbono wokuthi ingaba yini.

Isinyathelo sesi-3 : Ngokushesha nje lapho ukhetha imodi yokuhlasela, cindezela inkinobho ethi “Buyisa” futhi Iphaseji le-Excel lizoqala ngokushesha ukusebenza ukuze libuyisele iphasiwedi. Ngemva kwemizuzu embalwa, inqubo izoqeda futhi kufanele ubone iphasiwedi esikrinini.

Ungasebenzisa iphasiwedi etholiwe ukuze uvule idokhumenti ye-Excel evikelwe manje.

Yizame mahhala

Indlela 2: Susa iphasiwedi kufayela le-Excel ku-inthanethi

Asikho isidingo sokufaka noma iyiphi isofthiwe kukhompuyutha yakho ukuze uguqule igama eliyimfihlo lokuvula kudokhumenti yakho ye-Excel. Ungasebenzisa elinye lamathuluzi aku-inthanethi amaningi aklanyelwe lowo msebenzi. Ukusebenzisa ithuluzi eliku-inthanethi kungase kukulungele uma ifayela lingenalo ulwazi olubalulekile futhi nephasiwedi okukhulunywa ngayo ibuthakathaka. Amathuluzi amaningi aku-inthanethi asebenzisa indlela yokuhlasela kwe-brute force futhi asebenza kuphela cishe ngama-21% esikhathi. Kunamathuluzi athile aku-inthanethi anezinga lempumelelo elingu-61%, kodwa angamathuluzi eprimiyamu, okusho ukuthi kufanele ukhokhe ukuze uwasebenzise.

Kepha mhlawumbe okubi kakhulu kokusebenzisa amathuluzi aku-inthanethi ukuthi kufanele ulayishe ifayela le-Excel endaweni yesikhulumi esiku-inthanethi. Lokhu kubangela ingozi kudatha esefayelini le-Excel njengoba ungazi ukuthi abanikazi bethuluzi eliku-inthanethi bazokwenzani ngedokhumenti yakho uma iphasiwedi isisusiwe.

Ububi bale ndlela:

• Izinga lempumelelo eliphansi : Izinga lokutakula liphansi kakhulu, lingaphansi kwezinga lempumelelo elingu-100%.
• Umkhawulo kasayizi wefayela : Abavuleli bephasiwedi be-Excel eku-inthanethi bahlale banomkhawulo kusayizi wefayela. Kwabanye abavula amaphasiwedi, usayizi wefayela awukwazi ukudlula u-10 MB.
• Isivinini sokutakula esinensayo : Uma usebenzisa iphasiwedi ye-Excel yokuvula ku-inthanethi, kufanele ube noxhumano lwe-inthanethi oluzinzile nolunamandla. Uma kungenjalo, inqubo yokutakula izohamba kancane noma ibambeke.

Ingxenye 3: Yephula iphasiwedi ye-Excel ukuze wenze izinguquko

Njengoba sishilo ngaphambili, akunakwenzeka futhi ukuthola idokhumenti ye-Excel engakwazi ukuguqulwa. Umnikazi wedokhumenti angabeka imikhawulo eyenza kube nzima kubasebenzisi ukuhlela okuqukethwe kwedokhumenti. Kulokhu, ungazama esinye sezisombululo ezilandelayo:

Indlela 1: Sebenzisa i-Passer ye-Excel (Izinga Lokuphumelela elingu-100%)

Ngaphezu kokutholwa kwephasiwedi ye-Excel, I-Passer ye-Excel Futhi iyithuluzi elihle lokuvula amaspredishithi/amashidi okusebenzela/izincwadi zokusebenza ze-Excel. Ngokuchofoza okukodwa, yonke imikhawulo yokuhlela nokufometha ingasuswa ngezinga lempumelelo elingu-100%.

Yizame mahhala

Nansi indlela yokuvula ispredishithi/incwadi yokusebenzela ye-Excel:

Isinyathelo 1 : Vula i-Passer ye-Excel kukhompyutha yakho bese uchofoza okuthi “Susa Imikhawulo.”

Isinyathelo sesi-2 : Chofoza okuthi "Khetha Ifayela" ukuze ungenise idokhumenti kuhlelo.

Isinyathelo sesi-3 : Uma idokhumenti seyengeziwe, chofoza okuthi “Susa” futhi uhlelo luzosusa noma yimiphi imikhawulo kudokhumenti ngemizuzwana emi-2 nje.

Yizame mahhala

Indlela 2: Khipha Amagama Ayimfihlo E-Excel Ngokushintsha Isandiso Sefayela

Uma usebenzisa i-MS Excel 2010 noma ngaphambili, ungavula idokhumenti ngokushintsha isandiso sefayela. Ukwenza kanjena.

Isinyathelo 1 : Qala ngokwenza ikhophi yefayela le-Excel elivikelwe ngephasiwedi, ukuze ube nekhophi uma kwenzeka kukhona okungahambi kahle.

Isinyathelo sesi-2 : Chofoza kwesokudla ifayela bese ukhetha "Qamba kabusha." Shintsha isandiso sefayela sisuke kokuthi “.csv” noma “.xls” siye ku-“.zip”.

Isinyathelo sesi-3 : Khipha okuqukethwe kwefayela le-Zip elisanda kwakhiwa bese uzulazulela kokuthi “xl\worksheets\”. Thola ishidi lomsebenzi ofuna ukulivula. Chofoza kwesokudla kuyo bese ukhetha inketho ethi “Hlela” ukuze uvule ifayela ku-Notepad.

Isinyathelo sesi-4 : Sebenzisa umsebenzi we-“Ctrl + F” ukuze uvule umsebenzi wosesho futhi useshe okuthi “SheetProtection”. Ufuna umugqa wombhalo oqala ngokuthi; «

Isinyathelo sesi-5 : Susa wonke umugqa wombhalo bese ulondoloza ifayela bese ulivala. Manje shintsha isandiso sefayela siye ku-.csv noma .xls.

Ngeke usadinga iphasiwedi uma ufuna ukuhlela noma ukuguqula ishidi lokusebenza.

Ububi bale ndlela:

• Le ndlela isebenza kuphela ku-Excel 2010 nezinguqulo zangaphambili.
• Ungakwazi ukuvula ishidi lokusebenza elilodwa kuphela ngesikhathi. Uma unamakhasi okusebenzela avikelwe ngephasiwedi amaningi kufayela le-Excel, kufanele uphinde izinyathelo ezingenhla eshidini ngalinye.

Indlela 3: Thola Iphasiwedi ye-Excel nge-Google AmaSpredishithi

I-Google Drayivu ikhiphe isibuyekezo esisha sokusekela amadokhumenti e-MS Office avikelwe ngephasiwedi. I-Google Drayivu ihlinzeka ngendlela engeyona inkimbinkimbi yokuvula noma iyiphi idokhumenti ye-Excel uma ufuna ukuyilungisa. Izinyathelo ezilandelayo zizokutshela ukuthi ungavula kanjani ifayela le-Excel elivikelwe ngephasiwedi ku-Google AmaSpredishithi.

Isinyathelo 1 : Iya ku-Google Drayivu kunoma yisiphi isiphequluli kukhompuyutha yakho bese ungena ngemvume uma ungakangeni.

Isinyathelo sesi-2 : Chofoza ithebhu “Entsha” bese ukhetha i-Google AmaSpredishithi. Uma usulifakile kakade ifayela lakho le-Excel elikhiyiwe kuDrayivu yakho, ungakhetha okuthi "Vula" ukuze uvule ifayela ngokuqondile. Uma kungenjalo, kufanele ulayishe ifayela lakho ngokuchofoza inketho ethi "Ngenisa".

Isinyathelo sesi-3 : Manje vula idokhumenti ye-Excel evikelwe bese uchofoza ekhoneni eliphezulu kwesokunxele ukuze ukhethe wonke amaseli akulowo mbhalo.

Isinyathelo sesi-4 : Chofoza okuthi "Kopisha" noma cindezela u-Ctrl + C.

Isinyathelo sesi-5 : Manje sebenzisa uhlelo lwakho lwe-MS Excel bese ucindezela u-Ctrl+ V. Yonke idatha kuspredishithi se-Excel esivikelwe ngephasiwedi izodluliselwa kule ncwadi yokusebenzela entsha. Ungabe usushintsha idokhumenti nganoma iyiphi indlela oyifunayo.

Ububi bale ndlela:

• Le ndlela idla isikhathi uma kunamaphepha okusebenzela amaningi akhiyiwe kudokhumenti yakho ye-Excel.
• I-Google AmaSpredishithi idinga uxhumano lwe-inthanethi oluzinzile ukuze ilayishe amafayela. Uma uxhumano lwakho lwe-inthanethi lubuthakathaka noma ifayela lakho le-Excel likhulu, inqubo yokulayisha izohamba kancane noma iphahlazeke.

Indlela 4. Khipha Iphasiwedi Yespredishithi se-Excel ngekhodi ye-VBA

Indlela yokugcina esizoyibheka ukusebenzisa ikhodi ye-VBA ukuze uvule isipredishithi se-Excel. Le ndlela izosebenza kuphela ku-Excel 2010, 2007, nezinguqulo zangaphambili. Kubalulekile ukuqaphela ukuthi le ndlela ingasusa kuphela iphasiwedi ekhasini lokusebenzela. Inqubo yokuvula iyinkimbinkimbi, ngakho-ke izinyathelo ezilandelayo zizoba usizo.

Isinyathelo 1 : Vula isipredishithi se-Excel esivikelwe ngephasiwedi esine-MS Excel. Cindezela okuthi "Alt+F11" ukuze uvule iwindi le-VBA.

Isinyathelo sesi-2 : Chofoza okuthi “Faka” bese ukhetha “Imojula” kokukhethwa kukho.

Isinyathelo sesi-3 : Faka ikhodi elandelayo efasiteleni elisha.

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

Isinyathelo sesi-4 : Cindezela u-F5 ukuze ukhiphe umyalo.

Isinyathelo sesi-5 : Linda kancane. Ibhokisi lengxoxo elisha lizovela elinephasiwedi esebenzisekayo. Chofoza "KULUNGILE" bese uvala iwindi le-VBA.

Isinyathelo sesi-6 : Buyela kusipredishithi sakho se-Excel esivikelwe. Manje, uzothola ukuthi ishidi lokusebenza lihloliwe.

Ububi bale ndlela:

• Uma kunamakhasi okusebenza amaningi avikelwe ngephasiwedi ku-Excel yakho, kufanele uphinde izinyathelo ezingenhla kwiphepha lomsebenzi ngalinye.

Isiphetho

Ukukhipha iphasiwedi kudokhumenti ye-Excel akudingeki kube nzima. Ngezivinini zokutakula ezishesha kakhulu, izindlela zokuhlasela ezengeziwe nezinga eliphezulu lokutakula, I-Passer ye-Excel inikeza inketho engcono kakhulu yokususa iphasiwedi ngokushesha kunoma iyiphi idokhumenti ye-Excel.

Yizame mahhala