Momwe mungatetezere pepala la Excel popanda / ndi mawu achinsinsi
Malingana ngati mukugwiritsa ntchito Windows kapena Mac, muyenera kudziwa zolemba za Microsoft Excel. Zingakhale zovuta kuti munthu wina asinthe zikalata zanu, bola zolemba za Excel zasungidwa ndikutetezedwa ndi mawu achinsinsi pa PC yanu.
Komabe, zinthu zachinsinsi zomwe zayiwalika nthawi zina zimachitika mutasunga zikalata zanu ndi mawu achinsinsi. Izi sizikutanthauza kuti mwataya zikalata zonsezi mpaka kalekale. Mutha kuzisonkhanitsabe, koma choyamba muyenera kupeza njira zothetsera Chotsani mawu achinsinsi pa fayilo ya Excel . Nkhaniyi yagawana mayankho onse omwe mungatenge kuti musateteze mapepala / mafayilo / zolemba zanu za Excel zomwe zatetezedwa ndi mawu achinsinsi.
Gawo 1: Kodi Excel ali ndi achinsinsi amtundu wanji?
Pali zinthu zingapo zomangidwira zomwe zimaphatikizidwa mu Excel kwa ogwiritsa ntchito ake ndipo ndi awa:
Kutsegula mawu achinsinsi
Mawu achinsinsi otsegulira ndi mtundu waukulu wa chitetezo chomwe chimagwiritsidwa ntchito ndi ogwiritsa ntchito ambiri. Izi nthawi zambiri zimagwiritsidwa ntchito potsegula chikalata chabwino kwambiri. Ngati chikalata cha Excel chili ndi mawu achinsinsi otsegulira, nthawi iliyonse mukatsegula chikalatachi, mudzafunsidwa kuti mulowetse mawu achinsinsi.
sintha mawu achinsinsi
Sinthani mawu achinsinsi nthawi zambiri amagwiritsidwa ntchito ndi maofesi ndi mabungwe. Popeza dzina lake likupitilirabe, silingalole ogwiritsa ntchito kusintha pepala la Excel kapena buku lantchito nthawi iliyonse yomwe wogwiritsa ntchito akufuna kugwiritsa ntchito chikalatacho. Izi zimadziwikanso kuti zolemba zowerengera zokha chifukwa zimakulolani kuti muwerenge chikalatacho popanda zoletsa zilizonse. Wogwiritsa amayenera kupereka mawu achinsinsi obisika asanasinthe chikalatacho.
Mawu achinsinsi owerengera okha
Izi ndizofanana ndi zolemba za Excel zosintha mawu achinsinsi. Ingolola ogwiritsa ntchito kuwerenga chikalatacho.
Chinsinsi cha kapangidwe ka buku lantchito
Kubisa kwamtunduwu ndikofunikira nthawi iliyonse yomwe simukufuna kuti munthu wina awonjezere, kusuntha, kufufuta, kubisa kapena kutchulanso china chake. Izi zimatchedwanso "kuteteza mawonekedwe a Excel sheet." Chifukwa chake, chilichonse chomwe chili mumpangidwe sichingasinthidwe popanda kulowa mawu achinsinsi.
Mapepala achinsinsi
Mawu achinsinsi amalepheretsa ogwiritsa ntchito kusintha, kusintha, kapena kufufuta zomwe zili patsamba. Izi zitha kulola owerenga kukhala ndi mwayi wosintha gawo latsambalo m'malo mwa tsamba lonse.
Gawo 2: Momwe mungatsegule Excel Yotetezedwa ndi Achinsinsi Odziwika
Imodzi mwa njira zosavuta zotetezera mafayilo a Excel otetezedwa ndi mawu achinsinsi ndikuchita ndi mawu achinsinsi odziwika. Popeza mukudziwa mawu achinsinsi, zomwe muyenera kuchita ndikulowetsa mawu achinsinsi ngati kuli kofunikira ndipo mupeza fayiloyo. Njira zomwe zili pansipa zikutsogolerani kuti mutsegule fayilo ya Excel.
Gawo 1 : Tsegulani fayilo ya Excel yomwe ili ndi mawu achinsinsi.
Gawo 2 : Popeza wapamwamba ndi achinsinsi otetezedwa, mudzaona Pop-mmwamba zenera pa zenera pamene muyesa kutsegula wapamwamba. Zenera lotulukirali likudziwitsani kuti fayilo ya Excel ili ndi mawu achinsinsi omwe muyenera kulowa musanatsegule fayiloyo. Mudzawona gawo lolemba pomwe muyenera kulowa mawu achinsinsi.
Gawo 3 : Lowetsani mawu achinsinsi olondola m'mawu kuti mutsegule fayilo ya Excel.
Gawo 4 : Yesani kutsegula fayilo ndipo muyenera kupatsidwa mwayi.
Njirayi ndiyosavuta chifukwa ndiyofanana m'mitundu yonse ya Excel kuyambira 2007 mpaka 2019.
Gawo 3: Momwe sungani tsamba la Excel popanda mawu achinsinsi
Njira imeneyi ndi yofunika kwambiri kwa 2010 ndi mtundu wakale. Chonde dziwani kuti sizogwirizana ndi mitundu yatsopano.
Gawo 1 : Choyamba, pangani zosunga zobwezeretsera za fayilo ya Excel yomwe ili ndi mawu achinsinsi.
Gawo 2 : Kachiwiri, dinani kumanja pa chikalata cha Excel ndikudina batani losinthanso.
Gawo 3 : Sinthani fayilo yowonjezera kukhala ".zip" kuchokera ku ".сsv" kapena ".xls".
Gawo 4 : Decompress nkhani za wothinikizidwa wapamwamba tsopano.
Gawo 5 : Pezani fayilo yomwe imathera mumtundu wa ".xml".
Gawo 6 : Kenako, dinani kawiri fayilo ya XML ndikutsegula fayiloyo ndi XML mkonzi.
Gawo 7 : Press "Ctrl + F" ndi kufufuza "Sheet Protection". Pezani mzere womwe umayamba ndi »
Gawo 8 : Chotsani dzinalo mufayilo ndikudina Sungani.
Gawo 9 : Kenako sinthani fayilo ya “.zip” kukhala “.сsv” kapena “.xls” ndikudina Enter. Tsopano tsamba lanu silidzatetezedwa ndipo tsopano mutha kutsegula chikalata chanu popanda mawu achinsinsi. Izi zikuthandizani kuti mupeze chikalata chanu cha Excel.
Zoyipa:
- Ingogwirizana ndi 2007 kapena mtundu wakale.
- Si njira yodalirika.
- Zovuta kwambiri.
Gawo 3: Momwe Mungatetezere Mapepala a Excel okhala ndi Mawu Achinsinsi Obwezeredwa
Njirayi ndiyomwe imaperekedwa bwino kuti mutsegule fayilo/chikalata chotetezedwa ndi mawu achinsinsi mukataya mawu achinsinsi kapena mulibe mawu achinsinsi. Chida champhamvu komanso chodalirika chomwe timapereka apa ndi Passper kwa Excel . Gwiritsani ntchito bwino Passer for Excel kuti mupeze ndikutsegula zikalata zotetezedwa ndi mawu achinsinsi. Pulogalamuyi yochira achinsinsi ya Excel imakupatsani mwayi wopezanso mafayilo anu a Excel ku mtundu uliwonse wa Microsoft (monga Excel 2003, Excel 2007, 2010, 2013, 2016, 2019, 2021). Mpaka pano, pulogalamuyi wakhala ankaona ngati mmodzi wa zida zabwino ndi owerenga padziko lonse kuti achire mapasiwedi kwa otetezedwa Excel owona.
- Imayang'ana pakubwezeretsanso mawu achinsinsi otsegulira mafayilo anu otetezedwa a Excel, ngakhale achinsinsi ndi ovuta bwanji.
- Chida ichi chitha kugwiritsidwanso ntchito kuchotsa zoletsa ku Excel spreadsheet yotetezedwa ndi mawu achinsinsi ngati mutha kutsegula ndikuwerenga pepala la Excel popanda mwayi wosintha.
- Mitundu 4 yochira imaperekedwa kuti iwonetsetse kuchuluka kwa kuchira.
- CPU ndi GPU luso anatengera, kotero kuchira liwiro ndi 10 nthawi mofulumira kuposa zida zina Excel achinsinsi kuchira.
- Mafayilo onse a Excel amathandizidwa, monga Excel 2019, 2016, 2013, ndi zina.
Nawa masitepe oti mutsegule fayilo ya Excel encrypted ndi Passper ya Excel
Gawo 1 : Yambani ndikuyambitsa pulogalamuyo. Pa waukulu mawonekedwe, izo kukusonyezani 2 kuchira modes. Mwachidule dinani "Yamba Achinsinsi".
Gawo 2 : Dinani batani Onjezani ndikuyika fayilo ya Excel momwe mukufuna kubwezeretsa mawu achinsinsi. Kenako, sankhani mtundu wa mawu achinsinsi omwe mukufuna kukhala nawo pachikalatacho. Pali mitundu inayi yayikulu yowukira chidachi: Brute Force Attack, Combined Attack, Signature Attack, ndi Mask Attack. Sankhani yomwe ili yoyenera kwa inu.
Gawo 3 : Sinthani parameter malinga ndi zomwe mwasankha kuchokera pa zinayi. Mukamaliza kukhazikitsa magawo, dinani Bwezerani. Nthawi yomweyo, chida chobwezeretsa mawu achinsinsi cha Excel chidzakonza fayiloyo ndikukupatsani mawu achinsinsi omwe mungagwiritse ntchito kuti mutsegule fayilo ya Excel.
Gawo 5: Chotsani Zoletsa Kuti Musinthe Tsamba Lantchito/Bukhu Lantchito mu Masekondi atatu
Mutha kugwiritsanso ntchito pulogalamu ya Passer for Excel kuchotsa chitetezo pamapepala ndi mabuku ogwirira ntchito ku Excel, ngakhale opanda mawu achinsinsi.
Gawo 1 : Ingoyikani Passper ya Excel pa kompyuta yanu. Tsegulani ndikusankha njira yachiwiri yomwe ikuwonetsedwa pa mawonekedwe a PC yanu.
Gawo 2 : Dinani batani la Add Fayilo kuti mulowetse fayilo yanu (tsamba la Excel). Tsamba la Excel lidzawonekera mu pulogalamu yomwe ikuwonetsa chizindikiro chokhoma.
Gawo 3 : Nthawi ino choletsa kusintha pa wapamwamba anawonjezera adzachotsedwa 3 masekondi. Zabwino kwambiri! Ndipo chifukwa chake, onjezani chitetezo chachinsinsi pa spreadsheet nthawi ina mukachisunga.
Mapeto
Tangokuwonetsani zida ndi njira zopezera ndikutsegula mafayilo a Excel otetezedwa ndi mawu achinsinsi. Ngati mukufuna mayankho achindunji, mwachitsanzo, momwe mungatetezere pepala la Excel popanda mawu achinsinsi, Passper kwa Excel Idzapitiriza kukhala njira yanu yabwino kwambiri.