Kafa kalmar sirri don fayiloli a Microsoft Excel

Tsaro da kariya ta bayanai suna daga cikin manyan hanyoyin bunkasa fasahar sadarwar zamani. Mahimmancin wannan matsalar ba raguwa bane, amma girma ne kawai. Kariyar bayanai yana da mahimmanci musamman ga fayilolin tebur, wanda galibi yana adana mahimman bayanan kasuwanci. Bari mu koyi yadda za a kare fayilolin Excel tare da kalmar sirri.

Saitin kalmar sirri

Masu haɓaka wannan shirin sun fahimci mahimmancin ikon saita kalmar sirri akan fayilolin Excel, sabili da haka, sun aiwatar da zaɓuɓɓuka da yawa don aiwatar da wannan hanya lokaci guda. A lokaci guda, yana yiwuwa a saita mabuɗin, duka don buɗe littafin da kuma canza shi.

Hanyar 1: saita kalmar wucewa lokacin ajiye fayil

Hanya guda ita ce saita kalmar sirri kai tsaye lokacin da kake ajiye littafin aikin Excel.

1. Je zuwa shafin Fayiloli Shirye-shirye masu kyau.



2. Danna kan kayan Ajiye As.



3. A cikin taga da ke buɗe, adana littafin, danna maballin "Sabis"located a sosai kasa. A cikin menu wanda ya bayyana, zaɓi "Zaɓuɓɓuka gabaɗaya ...".



4. Wani karamin taga yana budewa. Kawai a ciki zaku iya tantance kalmar sirri don fayil ɗin. A fagen "Kalmar sirri don buɗe" shigar da maballin da zaka bukaci tantance lokacin bude littafin. A fagen "Kalmar sirri don canzawa" shigar da mabuɗin wanda zai buƙaci shigar dashi idan kuna buƙatar shirya wannan fayil.

   Idan kuna son hana ɓangare na uku daga gyara fayil ɗinku, amma kuna so ku bar damar dubawa kyauta, to a wannan yanayin, shigar da kalmar wucewa ta farko kawai. Idan an katange makullin guda biyu, to idan kun buɗe fayil ɗin, za a nuna muku shigar da duka biyun. Idan mai amfani ya san kawai farkon su, to karatun kawai zai ishe shi, ba tare da damar yin bayanai ba. Maimakon haka, yana iya shirya komai, amma ajiye waɗannan canje-canje ba za su yi aiki ba. Zaka iya ajiyewa azaman kwafin ba tare da canza ainihin takaddar ba.

   Bugu da kari, zaku iya duba akwatin nan da nan kusa "Nemi damar karanta kawai".

   A wannan yanayin, har ma ga mai amfani wanda ya san kalmomin shiga biyu, fayil ɗin zai buɗe ta hanyar tsohuwa ba tare da kayan aiki ba. Amma, idan ana so, koyaushe zai iya buɗe wannan kwamitin ta latsa maɓallin m.

   Bayan an gama dukkan saiti a cikin taga babban tsarin, sai a danna maballin "Ok".



5. Wani taga yana buɗewa inda ake buƙatar sake shigar da mabuɗin. Anyi wannan ne saboda mai amfani bai yi kuskure ba lokacin farko da aka rubuta kuskuren rubutu. Latsa maballin "Ok". Idan kalmomin basu dace ba, shirin zai baka damar shigar da kalmar wucewa.



6. Bayan haka, mun sake komawa taga ajiye fayil. Anan zaka iya canza sunan shi kuma ka tantance kundin inda zai kasance. Lokacin da aka gama wannan duka, danna maballin Ajiye.

Don haka, mun kare fayil ɗin Excel. Yanzu, don buɗewa da shirya shi, kuna buƙatar shigar da kalmomin shiga da suka dace.

Hanyar 2: saita kalmar sirri a cikin “cikakkun bayanai”

Hanya ta biyu ta ƙunshi saita kalmar sirri a cikin ɓangaren Excel "Cikakkun bayanai".

1. Kamar lokacin ƙarshe, je zuwa shafin Fayiloli.
2. A sashen "Cikakkun bayanai" danna maballin Kare fayil. Lissafin za optionsu protection protectionukan kariya na yiwu tare da maɓallin fayil yana buɗewa. Kamar yadda kake gani, a nan zaka iya kare kalmar sirri ba kawai fayil ɗin gabaɗaya ba, har ma da takarda daban, tare da tabbatar da kariya don canje-canje a tsarin littafin.



3. Idan muka tsaya a "A rufa tare da kalmar sirri", taga zai bude wanda yakamata ka shigar da keyword. Wannan kalmar sirri ta dace da maɓallin buɗe littafin, wanda muka yi amfani da shi a hanyar da ta gabata lokacin da muke adana fayil ɗin. Bayan shigar da bayanai, danna maballin "Ok". Yanzu, ba tare da sanin maɓallin ba, ba wanda zai iya buɗe fayil ɗin.



4. Lokacin zabar abu Kare Shege na yanzu taga tare da saitunan da yawa zasu buɗe. Akwai kuma taga don shigar da kalmar sirri. Wannan kayan aiki yana ba ku damar kare takamaiman takarda daga gyara. A lokaci guda, da bambanci ga kariya daga canje-canje ta hanyar adanawa, wannan hanyar ba ta ba da damar ƙirƙirar kwafin takarda da aka gyara. Dukkanin ayyuka a kai an katange su, kodayake a cikin gabaɗaya za'a iya ajiye littafi.

   Mai amfani zai iya saita matakin kariya da kansa ta hanyar ɗauka abubuwan da suka dace. Ta hanyar tsoho, na dukkan ayyuka don mai amfani wanda bai mallaki kalmar sirri ba, zaɓi na sel kawai ana samunsa akan takardar. Amma, marubucin daftarin aiki na iya ba da damar tsarawa, sakawa da goge layuka da ginshiƙai, rarrabawa, sanya mai sarrafa kansa, canza abubuwa da rubutun, da sauransu. Kuna iya cire kariya daga kusan kowane aiki. Bayan saita saita saiti, danna maballin "Ok".



5. Lokacin da kuka danna abu "Kare tsarin littafin" Zaka iya saita kariyar tsarin aikin. Saitunan suna samar da canje-canje ga tsarin toshewa, duka tare da kalmar sirri kuma ba tare da shi ba. A lamari na farko, wannan shine abin da ake kira "kariya daga wawa," wato, daga ayyukan da ba a sani ba. A lamari na biyu, wannan kariya ne daga musanya da canje-canje ga takaddar da wasu masu amfani suka yi.

Hanyar 3: Saita kalmar sirri kuma cire shi a cikin "Duba" shafin

Ikon saita kalmar sirri shima ya kasance a cikin shafin "Duba".

1. Je zuwa shafin da ke sama.



2. Muna neman toshe kayan aiki "Canza" a kan tef. Latsa maballin Kare Sheet, ko Kare Littattafai. Wadannan Buttons suna da cikakken daidaito da abubuwan Kare Shege na yanzu da "Kare tsarin littafin" a sashen "Cikakkun bayanai"wanda muka ambata a sama. Actionsarin ayyuka ma gaba daya suna da kama.



3. Domin cire kalmar sirri, kuna buƙatar danna maballin "Cire kariya daga takarda" a kan kintinkiri kuma shigar da kalmar da ta dace.

Kamar yadda kake gani, Microsoft Excel yana ba da hanyoyi da yawa don kare fayil ɗin tare da kalmar sirri, duka daga ɓarna da gangan kuma daga ayyukan da gangan. Kuna iya kalmar wucewa ta kare duka buɗe littafi da gyara ko canza abubuwa na tsarinta. A wannan yanayin, marubucin zai iya tantance wa kansa irin canje-canjen da yake so don kare kundin daga.