Yadda ake saka kalmar wucewa a cikin fayil mai kyau

Tsaro da kariya na bayanai sune ɗayan manyan hanyoyin don haɓaka fasahar bayanan sirri na zamani. Ba a rage yanayin wannan matsalar ba, amma yana girma kawai. Musamman mahimman kariya na bayanai don fayilolin tebur a cikin abin da mahimman bayanai yawanci ana adana su a cikin bayanan kasuwanci. Bari mu gano yadda ake kare fayilolin Excel ta amfani da kalmar sirri.

Shigarwa na kalmar sirri

Shirin masu haɓakawa sun fahimci mahimmancin shigar da kalmar wucewa akan fayilolin Excel, don haka akwai zaɓuɓɓuka da yawa don yin wannan hanyar a lokaci ɗaya. A lokaci guda, yana yiwuwa a kafa maɓallin, duka a buɗe littafin kuma akan canjin sa.

Hanyar 1: Saita kalmar sirri yayin da ceta fayil

Hanya daya ya hadu da kafa kalmar sirri kai tsaye yayin ceton littafin Excel.

1. Je zuwa shafin "fayil" shafin Excel Shirin.



2. Danna "Ajiye AS".



3. A cikin taga da ke buɗe, muna danna maɓallin "sabis", wanda yake a ƙasan. A cikin menu wanda ya bayyana, zaɓi "babban sigogi ...".



4. Wani karamin taga yana buɗewa. Kawai a ciki, zaku iya tantance kalmar wucewa zuwa fayil ɗin. A cikin "kalmar sirri don buɗe" filin, muna shigar da keyword wanda zai buƙaci tantance lokacin buɗe littafi. A cikin "kalmar sirri don canzawa" filin, shigar da maɓallin don shigar idan kuna buƙatar shirya wannan fayil ɗin.

   Idan kuna son fayil ɗinku ya sami damar shirya mutane ba tare da izini ba, amma kuna son barin damar yin la'akari da free, to, a wannan yanayin, shigar da kalmar sirri ta farko. Idan aka ƙayyade maɓallan biyu, to lokacin da ka buɗe fayil ɗin, za a sa ka shigar da duka biyu. Idan mai amfani ya san kawai farkon ɗayansu, to, zai kasance kawai don karanta, ba tare da ikon shirya bayanai ba. Maimakon haka, zai iya shirya komai, amma ba zai yiwu a adana waɗannan canje-canje ba. Zai iya samun ceto ne kawai ta hanyar kwafa ba tare da canza takaddar farawa ba.

   Bugu da kari, zaka iya saka alama nan da nan game da "bayar da shawarar karanta-kawai".

   A lokaci guda, har ma ga mai amfani wanda ya san su duka kalmar sirri, fayil ɗin tsoho zai buɗe ba tare da kayan aiki ba. Amma, idan ana so, koyaushe zai iya buɗe wannan kwamitin ta latsa maɓallin da ya dace.

   Bayan duk saiti a cikin jerin sigar gama gari ana yi, danna maɓallin "Ok".



5. A taga yana buɗewa inda kake son sake shigar da maɓallin. Ana yin wannan ne don tabbatar da cewa mai amfani bashi da kuskure a farkon shigar da hankula. Latsa maɓallin "Ok". Idan akwai rashin yarda da kalmomin shiga, shirin zai bayar don shigar da kalmar wucewa.



6. Bayan haka, mun dawo cikin taga ajiye ajiyar fayil. Anan, idan kuna so, canza sunan sa da kuma ƙayyade directory inda zai kasance. Lokacin da aka gama wannan, danna maɓallin "Ajiye".

Don haka muka kare fayil ɗin Five. Yanzu zai ɗauki kalmomin shiga da suka dace don buɗe da shirya ta.

Hanyar 2: Saita kalmar sirri a cikin "cikakkun bayanai"

Hanya ta biyu tana nuna shigarwa na kalmar sirri a cikin Excel "sashe na sashe.

1. Kamar yadda lokacin ƙarshe, je zuwa shafin "fayil".
2. A cikin "cikakkun bayanai", danna maɓallin "Kare fayil ɗin". Jerin yiwuwar zaɓuɓɓukan don kare maɓallin fayil. Kamar yadda kake gani, zaku iya kare kalmar sirri ba fayil ɗin ba kawai fayil ɗin gaba ɗaya ba ne, amma kuma wani takarda daban, har ma da kafa kariya ga canje-canje a tsarin littafin.



3. Idan muka dakatar da zaba a "Losipat kalmar sirri", taga zai bude wanda ya kamata a shigar da key. Wannan kalmar sirri ta cika mabuɗin don buɗe littafin da muka yi amfani da shi a hanyar da ta gabata yayin adana fayil. Bayan shigar da bayanai, danna maɓallin "Ok". Yanzu, ba tare da sanin mabuɗin ba, fayil ɗin ba wanda zai iya buɗe.



4. Lokacin da ka zaɓi "Kare kayan" na yanzu, taga zai buɗe tare da babban adadin saiti. Hakanan akwai taga shigarwar kalmar sirri. Wannan kayan aikin yana ba ku damar kare takamaiman takardar daga gyara. A lokaci guda, da bambanci don kariya daga canje-canje ta hanyar adana, wannan hanyar ba ta samar da ikon har ma ƙirƙirar kwatancen takardar. Dukkanin ayyukan an toshe su a kai, kodayake a gaba ɗaya Littafi Mai Tsarki zasu iya samun ceto.

   Saiti don digiri na kariya Mai amfani zai iya kafe kansa, fallasa akwatunan a cikin abubuwan da suka faru. Ta hanyar tsoho, daga duk ayyuka don mai amfani wanda ba ya mallaki kalmar sirri, akwai a kan takardar kawai zaɓi na sel kawai. Amma, marubucin takardu na iya ba da izinin tsarawa, saka da cire layuka da ginshiƙai, canji, da amfani da autofilter, canji a cikin abubuwa da rubutun, da sauransu. Kuna iya cire kariya tare da kusan kowane aiki. Bayan saita saitunan, danna maɓallin "Ok".



5. Lokacin da ka danna maballin "kare tsarin littafin" abu, zaka iya saita tsaron gida na tsarin. Saitunan suna ba da katange canji a cikin tsari, duka tare da kalmar sirri kuma ba tare da shi ba. A cikin farkon shari'ar, wannan shine abin da ake kira "wawa kariya", wato, daga ayyukan da ba a yi ba. A cikin lamarin na biyu, an riga an kare wannan daga canza takaddun da aka yi niyya ta wasu masu amfani.

Hanyar 3: Shigarwa na kalmar sirri da kuma cire shi a cikin "bita" shafin

Ikon shigar da kalmar sirri kuma a cikin "bita" shafin.

1. Je zuwa shafin da ke sama.



2. Muna neman toshe kayan canji a kan tef. Danna maɓallin "kare ganye", ko "kare littafin". Wadannan maballin suna da cikakken daidaito tare da abubuwan "suna kare tsarin na yanzu" da "kare tsarin littafin" a cikin "bayanin" sashe na sashe, wanda muka riga mun faɗi a sama. Gaba da ayyuka ma sunyi kama da juna.



3. Don cire kalmar sirri, kuna buƙatar danna maɓallin 'Cire ganye na ganye "a kan tef kuma shigar da key ɗin da ya dace.

Kamar yadda kake gani, Microsoft Excel yana ba da hanyoyi da yawa don kare fayil da kalmar sirri, da da gangan ba shi da izini, kuma daga ayyukan da ba a yi ba. Kuna iya wucewa ta buɗe littafin da gyara ko canza abubuwan da ke tattare da mutum. A lokaci guda, marubucin zai iya sanin kansa, daga abin da canje-canje da yake so ya kare daftarin.