Excel

Momwe mungasinthire password ya Excel popanda pulogalamu

Ndili ndi fayilo ya Excel yotetezedwa ndi mawu achinsinsi, koma ndayiwala mawu achinsinsi kuti ndiyipeze. Kodi ndingawononge bwanji mawu achinsinsi popanda kugwiritsa ntchito pulogalamu iliyonse?

Zitha kukhala gehena pamene simungathe kupeza kapena kusintha fayilo ya Excel yachangu komanso yofunika chifukwa cha mawu achinsinsi oiwalika. Musanavomereze kugonja, ndiroleni ndikufotokozereni njira zina zabwino zowonongera mawu achinsinsi a Excel popanda pulogalamu ndikupezanso fayilo yanu.

Gawo 1: Kodi Mng'alu Kupambana Achinsinsi popanda mapulogalamu

Momwe mungasokonezere mawu achinsinsi a Excel popanda mapulogalamu kungakhale ntchito yovuta, koma chifukwa chakuti palibe chofunikira chokhazikitsa chimapangitsa kukhala njira yabwino. Pali njira zambiri zosokoneza mapasiwedi a Excel popanda kugwiritsa ntchito mapulogalamu, koma amasiyana movutikira komanso amapambana. Komabe, iwo ndi ofunika kuyesera chifukwa akhoza kukupulumutsani masenti ochepa. Izi zanenedwa, tiyeni tifufuze njira zina zomveka zosokoneza mapasiwedi a fayilo ya Excel popanda pulogalamu.

Pangani mawu achinsinsi a Excel pa intaneti

Achinsinsi-Online Kusangalala ndi wathunthu achinsinsi kuchira chida mitundu yosiyanasiyana ya zikalata. Ubwino wa chida ichi ndikuti sichisintha mawonekedwe a fayilo yanu yoyambirira ndipo mumangoyenera kulipira pamene kumasulira kwapambana. Ndi n'zogwirizana ndi zipangizo zonse zazikulu ndi machitidwe opaleshoni, kupanga chida chabwino kung'amba Excel mapasiwedi Intaneti.

Gawo 1: Pitani patsamba lovomerezeka la Password-Online Recovery pogwiritsa ntchito msakatuli aliyense.

Gawo 2: Dinani batani "Kwezani fayilo yanu yosungidwa". Pezani fayilo ya Excel yotetezedwa ndi mawu achinsinsi yomwe mukufuna kuichotsa ndikudina "Tsegulani" kuti muyike.

[Momwe Mungawonongere Achinsinsi a Excel Popanda Mapulogalamu

Gawo 3: Pulogalamuyo idzachotsa fayiloyo ndipo ikamalizidwa, lipirani ndikudina pa "Pezani Zotsatira" kuti mupeze fayilo yanu ya Excel yosinthidwa.

Zindikirani: Pokhala ntchito yapaintaneti, Kubwezeretsa Kwachinsinsi-Paintaneti kumafuna kuti mukweze fayilo yanu ya Excel yosungidwa kuti muyike mawu achinsinsi. Poganizira zachitetezo cha data yanu, sindikulimbikitsani kuti musankhe ntchito yapaintaneti pomwe fayilo yanu ya Excel ili ndi zidziwitso zachinsinsi.

Pangani mawu achinsinsi a MS Excel kudzera pa Google Sheet

Ngati spreadsheet/bookbook yanu ya Excel yatetezedwa kuti isasinthidwe, mutha kusokoneza mawu achinsinsi a Excel spreadsheet popanda pulogalamu pogwiritsa ntchito Google Sheets. Njirayi ndi yaulere komanso yovomerezeka. Komabe, ndikofunikira kutenga zosunga zobwezeretsera za pepala la Excel kuti mupewe milandu yakutayika kwa data. Zotsatirazi zikuwonetsa momwe mungasweke mosavuta mapasiwedi a MS Excel kudzera pa Google Mapepala.

Gawo 1: Pezani Google Sheets ndikulowa muakaunti yanu ya imelo.

Gawo 2: Yang'anani pa "Fayilo" ndikusankha "Import" kuchokera pamndandanda wotsitsa.

[Momwe Mungawonongere Achinsinsi a Excel Popanda Mapulogalamu

Gawo 3: Bokosi la "Import Fayilo" lidzawonekera pazenera lotsatira. Pezani ndikudina tabu ya "Kwezani" ndikusankha njira yabwino yokwezera fayilo yanu ya Excel.

Gawo 4: Fayilo yotetezedwa ikadzaza, mudzafunsidwa kuti mupange zisankho zina. Sankhani "Bwezerani Spreadsheet" njira ndiyeno akanikizire "Import Data" batani. Tsopano mutha kusintha tsamba lotetezedwa la Excel.

[Momwe Mungawonongere Achinsinsi a Excel Popanda Mapulogalamu

Gawo 5: Pomaliza, muyenera kukopera izi editable wapamwamba pa kompyuta. Kuti muchite izi, ingopita ku "Fayilo" ndiyeno "Koperani ngati" ndikusankha "Microsoft Excel".

Dulani mawu achinsinsi a fayilo ya Excel posintha fayilo yowonjezera

Musanapitirize, ndikofunikira kuti mumvetsetse kuti mafayilo a Excel ndi gulu la mafayilo angapo a XML osungidwa. Izi zikutanthauza kuti fayilo ya Excel ndi fayilo yoponderezedwa chabe. Kuti musinthe mafayilowa monga momwe tingachitire ndi kusokoneza mawu achinsinsi, muyenera kusintha fayilo yowonjezera kuchokera ku XLSX kupita ku ZIP. Mukasintha fayilo, muyenera kuyibwezeretsanso ku .xlsx. Mwanjira imeneyi, mudzakhala mutathyola mawu achinsinsi a fayilo ya Excel mwa kungosintha kuwonjezera fayilo. Choncho tiyeni tione mmene tingachitire zimenezi bwinobwino.

Gawo 1: Tsegulani zenera la File Explorer ndikupeza tsamba lotetezedwa lachinsinsi la Excel.

Gawo 2: Sinthani fayilo yowonjezera kukhala .zip. Pulogalamuyi idzakufunsani ngati mukufuna kusintha. Dinani "Inde" kuti mulole kusintha fayilo yowonjezera.

Gawo 3: Tsopano dinani pa "Chotsani" tabu mkati mwa zenera lofufuzira ndikusankha "Chotsani Zonse". Chotsani fayilo ya ZIP ku foda yomwe mukufuna.

Gawo 4: Mukatulutsa fayilo ya ZIP, tsegulani chikwatu cha "xl" ndikupeza fayilo ya "sheet.xml". Dinani kumanja pa fayilo ndikusankha "Open with." Sankhani Notepad kapena WordPad.

Gawo 5: Pulogalamu yosankhidwa ikatsegula fayilo ya XML, zindikirani gawo la code "sheetProtection" ndikuchotsa monga momwe zilili pansipa.

[Momwe Mungawonongere Achinsinsi a Excel Popanda Mapulogalamu

Gawo 6: Mukachotsa nambala yoteteza, sankhaninso mafayilo onse omwe mudatulutsa mu ZIP. Dinani kumanja pa iwo, kusankha "Tumizani ku" njira ndi kusankha "Wothinikizidwa (zip) chikwatu" monga pansipa. Pomaliza, sinthani zowonjezera za ZIP kubwerera ku .xlsx.

Dziwani izi: Njira imeneyi ndi pang'ono zovuta ngati ndinu novice kompyuta wosuta. Ndipo malinga ndi mayeso anga, amangogwira ntchito ku Excel 2010. Choncho, ngati simungathe kugwiritsa ntchito njirayi, ganizirani zina zomwe mungachite m'nkhaniyi.

Chotsani mawu achinsinsi otetezedwa ku Excel file ndi VBA code

Njirayi ikuphatikizapo kugwiritsa ntchito chinenero cha Visual Basic scripting kuti mulambalale njira zoyang'ana mawu achinsinsi a Excel ndikuphwanya mawu achinsinsi a Excel. Choyenera ndikupusitsa pulogalamuyo pogwiritsa ntchito nambala ya VBA kuti itithandize kusintha. Njirayi imatha kukupatsani mawu achinsinsi osakhalitsa kuti mutsegule fayilo ya Excel yotetezedwa ndi mawu achinsinsi kapena kukulolani kuti musinthe fayiloyo mwachindunji. Ndi yoyenera pamasamba amodzi, chifukwa ngati pali mapepala angapo ogwirira ntchito, code iyenera kuyendetsedwa mobwerezabwereza pa pepala lililonse. Chofunika kwambiri, imatha kungolemba mawu achinsinsi. Zomwe zikunenedwa, tiyeni tilowe mumomwe tingasinthire mafayilo achinsinsi otetezedwa ku Excel ndi VBA code.

Gawo 1: Tsegulani tsamba lotetezedwa la Excel ndikupeza mkonzi wa VBA pogwiritsa ntchito malamulo a Alt + F11 pa kiyibodi yanu.

Gawo 2: Pazida, dinani batani la "Ikani" ndikusankha "Module" kuchokera pamenyu yotsitsa.

[Momwe Mungawonongere Achinsinsi a Excel Popanda Mapulogalamu

Gawo 3: Zenera la gawo la Microsoft Excel Workbook lidzawonetsedwa. Mkati mwa General zenera, lowetsani zotsatirazi VBA script code.

[Momwe Mungawonongere Achinsinsi a Excel Popanda Mapulogalamu

Gawo 4: Tsopano dinani batani la "Thamangani" kapena ingodinani batani la F5 kuti muyambitse njira yosinthira mawu achinsinsi a spreadsheet/bookbook.

Gawo 5: Pulogalamuyo iyenera kumaliza ntchitoyi pakanthawi kochepa ndikuwonetsa mawu achinsinsi pawindo laling'ono lazidziwitso. Dinani "Chabwino" ndipo mukhoza kusintha Excel spreadsheet/workbook.

Gawo 2: Bwanji ngati inu simungakhoze osokoneza Kupambana achinsinsi popanda mapulogalamu?

Monga tawonera pamwambapa, zosankha zambiri zowononga mapasiwedi a Excel popanda mapulogalamu ndizovuta komanso zimakhala ndi zopambana zochepa. Ngati mukuyang'ana njira yothandiza komanso yosavuta, ndikufuna ndikulimbikitseni Passper kwa Excel .

Chifukwa chiyani Passer ya Excel ikuwoneka bwino?

  • Passper for Excel ndi pulogalamu yamphamvu yomwe imapereka 4 Njira Zamphamvu Zosokoneza Mawu Achinsinsi kuti mutsegule mawu achinsinsi a Excel.
  • Ma spreadsheet/workbook/VBA Project passwords akhoza kukhala Kutsitsidwa nthawi yomweyo ndikuchita bwino kwa 100%. .
  • Gulu la Passer limasamala chitetezo cha zawo deta . Lonjezani kuti sipadzakhala kutaya kapena kutayikira kwa deta yanu.
  • Chidacho chiridi Zosavuta kugwiritsa ntchito . Kaya ndinu novice pakompyuta kapena katswiri, mutha kusokoneza password yanu ya Excel ndi njira zitatu zosavuta.

Yesani kwaulere

Gwirani Chinsinsi cha Excel kuti Mutsegule Fayilo

Gawo 1. Thamangani Passper kwa Kupambana pulogalamu pa chipangizo chanu ndi kusankha "Yamba Achinsinsi" njira pa waukulu mawonekedwe.

Kuchotsa mawu achinsinsi a Excel

Gawo 2. Dinani "Add" batani kusankha Excel wapamwamba mukufuna osokoneza achinsinsi ndi kumadula "Open" kutsegula mu pulogalamu. Fayiloyo ikakwezedwa bwino, sankhani njira yobwezeretsa mawu achinsinsi. Mutha kusankha pakati pa kuwukira kwa combo, kuwukira kwa mtanthauzira mawu, kuwukira kwa chigoba kapena kuwukira kwankhanza.

kusankha akafuna kuchira kuti achire kupambana achinsinsi

Gawo 3. Mukasankha njira yoyenera kuchira achinsinsi, dinani "Kenako" kupitiriza. Pazenera lotsatira, dinani batani la "Bwezerani" kuti muyambe kutsitsa mawu achinsinsi a Excel. Kuchira kwatha, pulogalamuyo idzawonetsa mawu achinsinsi kumbuyo. Koperani kapena lembani mawu achinsinsi ndikugwiritsa ntchito kuti mupeze fayilo ya Excel yotetezedwa ndi mawu achinsinsi.

pezani mawu achinsinsi a Excel

Yesani kwaulere

Crack Excel Password Kuti Musinthe Tsamba Lantchito / Buku Lantchito

Gawo 1. Thamangani Passper kwa Excel ndi kusankha "Chotsani zoletsa" njira.

Kuchotsa zoletsa za Excel

Gawo 2. Dinani "Sankhani Fayilo" tabu, ndi kupeza zoletsedwa Excel spreadsheet/workbook mukufuna kusintha, ndi kumadula "Open" kuitanitsa mu pulogalamu.

kusankha wapamwamba wapamwamba

Gawo 3. Tsopano, alemba pa "Chotsani" batani kuchotsa zoletsa zonse masanjidwe ndi kusintha. Zingotenga masekondi angapo kuti pulogalamuyo ichotse zoletsa izi mu Excel pepala/buku lanu lantchito.

chotsani zoletsa za Excel

Mapeto

Njira zonse zomwe tazitchula pamwambapa zothyola mapasiwedi a Excel ndi kapena popanda mapulogalamu ndizothandiza. Komabe, luso wosangalatsa ndi njira imene Passper kwa Excel imathandizira njira yonseyo imapangitsa kukhala mfumu yosatsutsika kuti iwononge password ya Excel. Yesani!

Yesani kwaulere

Zolemba zogwirizana

Siyani yankho

Imelo yanu sisindikizidwa.

Bwererani pamwamba batani
Gawani kudzera
Koperani ulalo
Mothandizidwa ndi Social Snap