6 siyaabood oo looga saaro erayga sirta ah faylka Excel [2023 Guide]

Mid ka mid ah waxyaabaha ugu wanaagsan ee ku saabsan Excel waa awoodda lagu ilaaliyo faylashaada heer kasta. Waxaad dooran kartaa inaad Buug-hawleedka ka ilaaliso isbeddellada qaab-dhismeedka, taasoo la macno ah in dadka aan la oggolayn aanay beddeli karin tirada ama nidaamka xaashida ee buugga shaqada. Waxa kale oo aad dejin kartaa furaha sirta ah si aad uga ilaaliso qof kasta inuu beddelo xaashida shaqada, taas oo macnaheedu yahay in aanay koobi karin, tafatirin ama tirtiri karin wax kasta oo ku jira xaashida shaqada. Waxa kale oo aad dejin kartaa furaha sirta ah ee ka hortagaya qof inuu furo dukumeentiga ilaa uu haysto erayga sirta ah.

In kasta oo furayaashan sirta ah ay waxtar yeelan karaan, waxay sidoo kale kaa hor istaagi karaan inaad gasho ama wax ka beddesho dukumeentiga marka aad u baahan tahay. Haddii aadan heli karin dukumeenti Excel ah ama xaashida faafinta sababtoo ah ma garanaysid erayga sirta ah ama aad illowday, maqaalkani aad buu u caawin doonaa. Gudaha, waxaan ku eegi doonaa qaar ka mid ah siyaabaha aad uga saari karto erayga sirta ah dukumeenti Excel ah.

Qaybta 1: Waa maxay suurtogalnimada in erayga sirta ah ee Excel laga saaro

Kahor intaanan ka hadlin sida aad uga saari karto erayga sirta ah xaashida Excel, waxaan u maleyneynaa inaan u baahanahay inaan wax ka qabanno fikradda guud ee furaha erayga sirta ah iyo suurtagalnimada furitaanka erayga sirta ah ee Excel.

Furitaanka erayga sirta ah waa hab adeegsada habab kala duwan si uu dib ugu soo ceshado ama looga saaro erayga sirta ah ee lagu kaydiyo ama lagu gudbiyo nidaamka kombayutarka. Mid ka mid ah siyaabaha ugu badan ee loo isticmaalo in meesha laga saaro erayga sirta ah waa habka xoogga weerarka. Habkani waxa uu adeegsadaa hab qiyaaseed kaas oo si isdaba joog ah u qiyaasaya furaha sirta ah ee kala duwan ilaa inta laga helayo erayga sirta ah ee saxda ah. Haddaba waa maxay suurtagalnimada in meesha laga saaro erayga sirta ah ee Excel? Run ahaantii, ma jiro barnaamij dammaanad qaadi kara heerka guusha 100% ee suuqa. Laakiin barnaamij aad u fiican oo aan ilaalin xaashida Excel waxay si weyn u gaabin kartaa waqtiga. Sidaa darteed, fursadda ka saarista furaha ayaa si weyn u kordhin karta.

Dadka aan farsamada ahayn, waxaan aad ugula talineynaa inaad isku daydo furaha sirta ah ee Excel si uu kaaga caawiyo inaad ka saarto erayga sirta ah faylalka Excel.

Qeybta 2: Sida ugu dhakhsaha badan looga saaro erayga sirta ah

Haddii aadan furi karin dukumeentiga Excel la'aanteed furaha sirta ah, kuwan soo socda ayaa ah qaar ka mid ah fursadaha aad isku dayi karto.

Habka 1: Ka saar erayga sirta ah ee Excel File adigoo isticmaalaya Passper for Excel

Fursada ugu wanaagsan ee guusha, waxaa laga yaabaa inaad rabto inaad isticmaasho barnaamij awood leh: Passper ee Excel . Kani waa barnaamij furaha sirta ah oo waxtar u yeelan kara inuu kaa caawiyo inaad dhaafto furaha sirta ah ee dukumeenti kasta oo Excel ah, xitaa nooca ugu dambeeya. Waxay leedahay astaamo badan oo loogu talagalay inay ka dhigaan soo kabashada erayga sirta ah mid aad u fudud. Waxaa ka mid ah kuwan soo socda:

• Xawaaraha fur furka erayga sirta ah ee ka dheereeya : Waxa ay leedahay mid ka mid ah xawaaraha furista furaha sirta ah ee ugu dhaqsaha badan suuqa, iyada oo awood u leh in ay hubiso ku dhawaad ​​3,000,000 sirta ah ilbiriqsigiiba.
• Itimaalka ugu badan ee soo kabashada erayga sirta ah - Waxay ku siinaysaa ikhtiyaarka ah inaad ka doorato 4 hab oo weerar ah iyo qaamuus malaayiin sirta ah ee inta badan la isticmaalo, taas oo kordhinaysa fursadaha soo kabashada erayga sirta ah waxayna si weyn u yaraynaysaa wakhtiga soo kabashada.
• Wax xog ah oo lumin : Midna xogta ku jirta dukumeentigaaga Excel ma saameyn doonto sinaba habka soo kabashada.
• Badbaadada xogta Uma baahnid inaad faylkaaga geliso server-kooda, sidaa darteed, xogtaada gaarka ah 100% waa la ballanqaaday.
• Ma xadidna : Barnaamijku wuxuu la jaan qaadayaa dhammaan noocyada Windows iyo noocyada Excel. Intaa waxaa dheer, ma jiraan wax xaddidan oo ku saabsan cabbirka faylka.

Isku day bilaash

Tani waa sida aad u isticmaali karto Passper for Excel si aad u furto faylka Excel ee erayga sirta ah ilaaliyo.

Tallaabada 1 Ku rakib Passper for Excel kombuyutarkaaga ka dibna fur. Daaqadda ugu weyn, guji "Ladnaansho Passwords".

Tallaabada 2 : Guji badhanka "+" si aad u dooratid dukumeentiga Excel ee aad rabto inaad ilaaliso. Marka dukumeentiga lagu daro barnaamijka, dooro habka weerarka ee aad rabto inaad isticmaasho oo guji "Ladnaansho." Habka weerarka ee aad doorato waxay ku xirnaan doontaa kakanaanta erayga sirta ah iyo haddii aad wax fikrad ah ka haysato waxa uu noqon karo iyo in kale.

Tallaabada 3 : Isla marka aad doorato habka weerarka, taabo badhanka "Ladnaansho" iyo Passper for Excel isla markiiba wuxuu bilaabi doonaa shaqada si uu u soo ceshado erayga sirta ah. Dhowr daqiiqo ka dib, geeddi-socodku wuu dhammaystirmi doonaa oo waa inaad ku aragtaa erayga sirta ah ee shaashadda.

Waxaad isticmaali kartaa erayga sirta ah ee la soo kabsaday si aad u furto dukumeentiga la ilaaliyo ee Excel hadda.

Isku day bilaash

Habka 2: Ka saar erayga sirta ah faylka Excel online

Looma baahna in lagu rakibo wax software ah kombiyuutarkaaga si loo furfuro furaha sirta ah ee dukumeentigaaga Excel. Waxaad isticmaali kartaa mid ka mid ah aaladaha badan ee khadka tooska ah ee loogu talagalay hawshaas. Isticmaalka qalab online ah ayaa laga yaabaa inay kugu habboon tahay haddii faylka uusan ku jirin macluumaad muhiim ah oo erayga sirta ah ee su'aashu ay tahay mid daciif ah. Inta badan aaladaha khadka tooska ah waxay adeegsadaan habka soo kabashada xoogga weerarka sidaas darteedna waxay wax ku ool u yihiin kaliya 21% wakhtiga. Waxaa jira qaar ka mid ah aaladaha khadka tooska ah oo leh 61% heerka guusha, laakiin waa aalado qaali ah, taasoo la macno ah inaad bixiso si aad u isticmaasho.

Laakiin waxaa laga yaabaa in faa'iido darrada ugu weyn ee isticmaalka aaladaha internetka ay tahay xaqiiqda ah inaad ku dhejiso faylka Excel goobta internetka. Tani waxay khatar ku tahay xogta ku jirta faylka Excel maadaama aadan garanayn waxa mulkiilayaasha aaladda khadka tooska ah ay ku samayn doonaan dukumeentigaaga marka erayga sirta ah la saaro.

Khasaarooyinka habkan:

• Heerka guusha hoose Heerka soo kabashada aad ayuu u hooseeyaa, in ka yar 100% heerka guusha.
• Xaddidaadda cabbirka faylka Furayaasha sirta ah ee Excel Online waxay had iyo jeer leeyihiin xaddidaadda cabbirka faylka. Qaar ka mid ah furayaasha sirta ah, cabbirka faylka kama badan karo 10 MB.
• Xawaaraha soo kabashada oo gaabis ah : Markaad isticmaalayso furaha sirta ah ee Excel online, waa in aad leedahay internet deggan oo awood leh. Haddii kale, habka soo kabashada ayaa runtii gaabis ah ama xitaa xayiran.

Qeybta 3: jebi furaha sirta ah ee Excel si aad wax uga bedesho

Sidii aan horay u soo sheegnay, sidoo kale lagama yaabo in la helo dukumeenti Excel ah oo aan la beddeli karin. Milkiilaha dukumeentigu wuxuu soo rogi karaa xaddidaadyo ku adkeynaya isticmaalayaasha inay wax ka beddelaan waxa ku jira dukumeentiga. Xaaladdan oo kale, waxaad isku dayi kartaa mid ka mid ah xalalka soo socda:

Habka 1: U isticmaal Passper Excel (Heerka Guusha 100%)

Marka lagu daro soo kabashada erayga sirta ah ee Excel. Passper ee Excel Sidoo kale waa qalab aad u fiican oo lagu furayo xaashida xaashida shaqada/buugaagta shaqada ee Excel. Hal gujin, dhammaan xaddidaadaha tafatirka iyo qaabeynta ayaa laga saari karaa 100% heerka guusha.

Isku day bilaash

Waa kuwan sida loo furo xaashidaada/buugga shaqada ee Excel:

Tallaabada 1 : Ku fur Passper for Excel kombiyuutarkaaga ka dibna dhagsii "Remove Restrictions."

Tallaabada 2 : Guji "Dooro File" si aad u soo dejiso dukumeentiga barnaamijka.

Tallaabada 3 : Marka dukumeentiga lagu daro, dhagsii "Delete" oo barnaamijku wuxuu meesha ka saarayaa wixii xayiraad ah ee dukumeentiga 2 kaliya.

Isku day bilaash

Habka 2: Ka saar furaha sirta ah ee Excel adiga oo bedelaya Fidinta faylka

Haddii aad isticmaalayso MS Excel 2010 ama ka hor, waxaad furi kartaa dukumeentiga adiga oo beddelaya kordhinta faylka. Sidan ayaad yeelaysaa.

Tallaabada 1 Ka bilow inaad abuurto nuqul ka mid ah feylka Excel ee erayga sirta ah lagu ilaaliyo, si aad nuqul u haysato haddii ay wax qaldamaan.

Tallaabada 2 : Midig ku dhufo faylka ka dibna dooro "Rename." Ka beddel kordhinta faylka ".csv" ama ".xls" una beddel ".zip".

Tallaabada 3 : Ka fur waxa ku jira faylka Zip-ka ee dhawaan la sameeyay ka dibna u gudub "xl\worksheets". Soo hel xaashida shaqada ee aad rabto inaad furto. Midig ku dhufo oo dooro "Edit" ikhtiyaarka si aad u furto faylka Notepad.

Tallaabada 4 Isticmaal shaqada "Ctrl + F" si aad u furto hawsha raadinta oo aad u raadiso "Protection SheetProtection". Waxaad raadinaysaa sadar qoraal ah oo ka bilaabma; «

Tallaabada 5 : Tirtir dhammaan xariiqda qoraalka ka dibna kaydi faylka oo xidh. Hadda u beddel kordhinta faylka .csv ama .xls.

Uma baahnid erayga sirta ah marka aad rabto inaad wax ka beddesho ama wax ka beddesho xaashida shaqada.

Khasaarooyinka habkan:

• Habkani wuxuu kaliya u shaqeeyaa Excel 2010 iyo noocyadii hore.
• Waxaad markiiba furi kartaa hal warqad shaqo. Haddii aad haysatid waraaqo shaqo oo dhowr ah oo sirta ah lagu ilaaliyo oo ku jira faylka Excel, waa inaad ku celisaa tillaabooyinka kore xaashi kasta.

Habka 3: Hel Password-ka Excel xaashida Google-ka

Google Drive ayaa soo saartay casriyeyn cusub oo lagu taageerayo dukumeentiyada MS Office ee erayga sirta ah lagu ilaaliyo. Google Drive wuxuu bixiyaa hab ka dhib yar oo lagu furo dukumeenti kasta oo Excel ah markaad rabto inaad wax ka beddesho. Tallaabooyinka soo socda ayaa kuu sheegi doona sida loo furo faylka Excel ee erayga sirta ah lagu ilaaliyo ee Google Sheets.

Tallaabada 1 : U tag Google Drive browser kasta oo ku jira kumbuyuutarkaaga oo gal haddii aanad hore u lahayn.

Tallaabada 2 : Guji tab "Cusub" oo dooro Google Sheets. Haddii aad horey u dhigtay faylkaaga Excel ee qufulan Drive-kaaga, waxaad dooran kartaa "Fur" si aad u furto faylka si toos ah. Haddii kale, waa inaad gelisaa faylkaaga adigoo gujinaya ikhtiyaarka "Import".

Tallaabada 3 Hadda fur dukumeentiga Excel ee la ilaaliyo ka dibna ku dhufo geeska bidix ee sare si aad u doorato dhammaan unugyada dukumeentigaas.

Tallaabada 4 Guji "Copy" ama riix Ctrl + C.

Tallaabada 5 Hadda socodsii barnaamijkaaga MS Excel oo taabo Ctrl+ V. Dhammaan xogta ku jirta furaha sirta ah ee xafidan ee Excel waxa loo wareejin doonaa buug-shaqeedkan cusub. Waxaad markaas wax ka beddeli kartaa dukumeentiga si kasta oo aad rabto.

Khasaarooyinka habkan:

• Habkani wakhti badan ayuu qaadaa haddii ay jiraan waraaqo shaqo oo badan oo ku xidhan dukumeentigaaga Excel.
• Google Sheets waxay u baahan tahay isku xidh internet oo deggan si loo soo geliyo faylasha. Haddii isku xirka internetkaagu daciif yahay ama faylkaaga Excel uu weyn yahay, habka soo dejinta ayaa noqon doona mid gaabis ah ama xitaa burburaya.

Habka 4. Ka saar erayga sirta ah ee xaashida faafinta ee Excel oo wata code VBA ah

Habka ugu dambeeya ee aan eegi doono waa in la isticmaalo code VBA si loo furo xaashida Excel. Habkani wuxuu kaliya u shaqayn doonaa Excel 2010, 2007, iyo noocyadii hore. Waxaa muhiim ah in la ogaado in habkani uu kaliya ka saari karo erayga sirta ah ee xaashida shaqada. Habka furitaanku waa adag yahay, markaa tillaabooyinka soo socdaa waxay noqon doonaan kuwo waxtar leh.

Tallaabada 1 : Fur xaashida sirta ah ee Excel oo leh MS Excel. Riix "Alt+F11" si aad u dhaqaajiso daaqada VBA.

Tallaabada 2 Guji "Insert" oo dooro "Module" ka dooro.

Tallaabada 3 : Geli furaha soo socda daaqada cusub.

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

Tallaabada 4 : Riix F5 si aad ufuliso amarka.

Tallaabada 5 : hal daqiiqo joog Sanduuqa wada-hadalka oo cusub ayaa ka soo bixi doona erayga sirta ah ee la isticmaali karo. Guji "OK" ka dibna xidh daaqada VBA.

Tallaabada 6 Ku soo celi xaashida xaashida Excel ee la ilaaliyo. Hadda, waxaad ogaan doontaa in xaashida shaqada la hubiyay.

Khasaarooyinka habkan:

• Haddii ay jiraan waraaqo-shaqo oo dhowr ah oo sirta ah lagu ilaaliyo Excel, waa inaad ku celisaa tillaabooyinka kore xaashi kasta oo shaqo.

Gabagabo

Ka saarida erayga sirta ah ee dukumeentiga Excel ma aha inay adagtahay. Xawaaraha soo kabashada ee ugu dhaqsaha badan, habab weerar oo badan iyo heerka soo kabashada sare Passper ee Excel waxay soo bandhigaysaa ikhtiyaarka ugu fiican ee si dhakhso ah looga saaro erayga sirta ah dukumeenti kasta oo Excel ah.

Isku day bilaash