Cire kariya daga takardar aikin Excel da littafin aiki

Don kare bayanai daga mutane marasa izini kuma daga ayyukansu na kuskure, masu amfani zasu iya saita kariya akan takaddun Excel. Kaico, ba kowa ba ne ya san yadda ake cire irin wannan kariya don samun damar samun bayanai, gami da iya gyara su. Kuma idan an karɓi fayil ɗin daga wani mai amfani da ya manta ya ba mu kalmar sirri, ko kuma mun manta (rasa) da gangan? Mu duba a tsanake.

Lura cewa akwai hanyoyi guda biyu don kulle takaddar Excel: kare takardar aiki ko littafin aiki. Saboda haka, waɗanne ayyuka da ake buƙatar ɗauka don buɗe shi zai dogara da wannan.

Cire kariya daga littafi

1. Idan muka yi ƙoƙarin buɗe takarda mai kariya, maimakon abubuwan da ke cikinta, za a nuna taga bayanan da muke buƙatar shigar da kalmar sirri don cire kariya.
2. Bayan shigar da kalmar sirri daidai kuma danna maɓallin OK, za a nuna abubuwan da ke cikin fayil ɗin.
3. Idan kana buƙatar cire kariyar daftarin aiki har abada, buɗe menu "Fayil".
4. Danna kan wani sashe "Haskaka". A cikin ɓangaren dama na taga, danna maɓallin "Kare Littafin", a cikin jerin da ke buɗewa, muna buƙatar umarni - "Encrypt tare da kalmar sirri".
5. Taga don ɓoyewa daftarin aiki tare da kalmar sirri zai bayyana akan allon. Goge shi, sannan danna OK.
6. Danna gunkin floppy diski don adana daftarin aiki. Ko kuna iya amfani da umarnin "Ajiye" menu "Fayil".
7. An cire kalmar sirrin kuma a gaba lokacin buɗe fayil ɗin, ba za a nemi shi ba.

Cire kariyar daga takardar

Za'a iya saita kalmar sirri don kariya ba kawai ga dukkan takaddun ba, har ma da takamaiman takarda. A wannan yanayin, mai amfani zai iya ganin abubuwan da ke cikin takardar, amma ba zai iya gyara bayanin ba.

Don hana takarda, bi waɗannan matakan:

1. Canja zuwa shafin "Bita"… Danna maɓallin "Cire kariyar takarda", wanda ke cikin rukunin kayan aiki "Kariya".
2. Wata karamar taga za ta bayyana, inda muka shigar da kalmar sirri da aka saita a baya sannan mu danna OK.
3. A sakamakon haka, za a kashe kulle takardar, kuma yanzu za mu iya gyara bayanin lafiya.

Canja lambar fayil don cire kariyar takardar

Ana buƙatar wannan hanyar a lokuta inda kalmar sirri ta ɓace ko ba a canza shi tare da fayil ɗin daga wani mai amfani ba. Yana aiki ne kawai dangane da waɗannan takaddun da aka kiyaye a matakin kowane zanen gado, kuma ba duka littafin ba, saboda. muna bukatar mu shiga cikin menu "Fayil", wanda ba zai yiwu ba lokacin da kalmar sirri ke kare duk takaddun.

Don cire kariya, dole ne ku aiwatar da jerin ayyuka masu zuwa:

1. Tafi kai tsaye zuwa mataki na 4 idan tsawo na fayil ɗin ya kasance XLSX (Excel). Idan tsarin daftarin aiki ne XLS (Littafin Aiki na Excel 97-2003), dole ne ka fara sake adana shi tare da tsawo da ake so. Don yin wannan, je zuwa menu "Fayil".
2. Zaɓi daga lissafin hagu "Ajiye azaman", sannan a gefen dama na taga, danna maɓallin "Bita".
3. A cikin taga da ya bayyana, zaɓi kowane wuri mai dacewa don adana fayil ɗin, saita tsari Littafin "Excel" kuma danna OK.
4. Buɗe a ciki Explorer XLSX daftarin aiki babban fayil (sabuwar adanawa ko riga-kafi). Don kunna kari na fayil, je zuwa shafin "Duba", inda muka kunna zaɓin da ake so a cikin rukunin kayan aiki "Nuna ko ɓoye".lura: Matakan tsarin aiki a wannan mataki da ƙasa an bayyana su ta amfani da Windows 10 a matsayin misali.
5. Danna dama akan takarda kuma a cikin jerin da ke buɗewa, danna kan umarnin "Sake suna" (ko kuma za ku iya danna maɓallin kawai F2, bayan zabar fayil).
6. Maimakon kari "xlsx" rubuta "zip" kuma tabbatar da canji.
7. Yanzu tsarin zai gano fayil ɗin azaman rumbun adana bayanai, wanda za'a iya buɗe abinda ke ciki ta danna maɓallin linzamin kwamfuta na hagu sau biyu.
8. A cikin babban fayil da aka buɗe, je zuwa kundin adireshi "xl", sannan - "takardun aiki". Anan muna ganin fayiloli a cikin tsari XML, wanda ya ƙunshi bayanai game da zanen gado. Kuna iya buɗe su tare da na yau da kullun Binciken.lura: a cikin Windows 10, zaku iya sanya tsoho shirin ta nau'in fayil a cikin saitunan tsarin (wanda aka ƙaddamar ta danna maɓallan. Lashe + Ni), A cikin babi "Aikace-aikace", sannan - "Default Apps" - "Zaɓan daidaitattun aikace-aikace don nau'in fayil".
9. Bayan buɗe fayil ɗin cikin nasara, muna buƙatar nemo jimlar a cikin abin da ke ciki "Kariyar takarda". Don yin wannan, za mu yi amfani da bincike, wanda za a iya kaddamar da duka ta hanyar menu "Shirya" (abu "Nemo"), ko ta latsa haɗin maɓalli Ctrl + F.
10. Shigar da kalmar da ake so kuma danna maɓallin "Nemo na gaba".
11. Bayan gano wasan da ake so, ana iya rufe taga binciken.
12. Muna goge jimlar da duk abin da ke da alaƙa da ita (tsakanin alamar buɗewa da rufewa).
13. A kan menu "Fayil" zabi tawagar "Ajiye azaman" (ko danna gajeriyar hanyar keyboard Ctrl + Shift + S).
14. Ajiye daftarin aiki nan da nan a cikin tarihin ba zai yi aiki ba. Saboda haka, muna yin shi a kowane wuri da ya dace a gare mu akan kwamfutar, yayin da ba mu canza sunan da ƙayyade tsawo ba "xml" (dole ne a zaɓi nau'in fayil - "Duk fayiloli").
15. Kwafi sabon fayil ɗin da aka ƙirƙira zuwa babban fayil ɗin "takardun aiki" tarihin mu (tare da maye gurbin na asali).lura: rikodin "Kariyar takarda" samuwa a duk fayilolin da aka kare kalmar sirri. Don haka, ayyukan da aka bayyana a sama don ganowa da share su ana yin su tare da duk sauran fayiloli. XML a cikin babban fayil "takardun aiki".
16. Mu sake zuwa babban fayil ɗin da ke ɗauke da tarihin mu kuma mu canza tsawo daga "zip" on "xlsx" ta sake suna.
17. Yanzu zaku iya buɗe fayil ɗin kuma ku gyara shi cikin aminci. Ba kwa buƙatar shigar da kalmar sirri don rashin tsaro.

Masu cire kalmar sirri ta ɓangare na uku

Kuna iya amfani da shirye-shirye na ɓangare na uku don cire kalmar sirrinku. A lokaci guda, yana da daraja tunawa da yiwuwar haɗarin da ke tattare da saukewa, shigarwa da amfani da kayan aikin da ba daidai ba na tsarin aiki da Excel.

Idan ka, duk da haka, yanke shawarar yin amfani da wannan damar, za ka iya kula da wani fairly shahara shirin. Mayar da kalmar wucewa ta OFFICE.

Hanyar haɗi zuwa shafin hukuma tare da shirin: .

Lura cewa don samun damar yin amfani da duk ayyukan shirin, kuna buƙatar siyan lasisi. Akwai nau'in demo don sanin aikace-aikacen, duk da haka, baya ba ku damar share kalmomin shiga.

Kammalawa

Kare littafin aiki ko takarda ɗaya siffa ce mai matuƙar fa'ida ta shirin Excel lokacin da kake buƙatar kare bayanai daga mutane marasa izini ko, alal misali, kare kanka daga sauye-sauyen bazata zuwa mahimman bayanai masu karantawa kawai. Amma wani lokaci akasin buƙatar ta taso - don cire kariyar da aka shigar a baya. Ana iya yin wannan ta hanyoyi daban-daban, dangane da yadda aka shigar da shi. Kuma ko da kun manta kalmar sirri, za a iya cire makullin, duk da haka, kawai idan an saita lambar don zanen gado ɗaya, kuma ba ga dukan littafin ba.