Hanyoyi 3 don saita kalmar wucewa don Kare Takardun Excel

Wasu maƙunsar bayanai na Microsoft Excel ya kamata a kiyaye su daga idanu masu zazzagewa, alal misali, wannan yana da amfani ga takardu tare da bayanan kasafin kuɗi. Akwai haɗarin asarar bayanan bazata a cikin allunan da mutane da yawa ke sarrafawa, kuma don hana hakan faruwa, zaku iya amfani da kariyar da aka gina a ciki. Bari mu bincika duk yuwuwar toshe damar yin amfani da takardu.

Saita kalmar sirri don zanen gado da littattafai

Akwai hanyoyi da yawa don kare duk takaddun ko sassanta - zanen gado. Bari mu yi la’akari da kowannensu mataki-mataki. Idan kana so ka yi ta yadda kalmar sirri ta bayyana lokacin da ka buɗe takarda, dole ne ka saita lambar lokacin da kake ajiye fayil ɗin.

1. Bude menu na "File" kuma sami sashin "Ajiye As". Yana da zaɓin “Browse”, kuma za a buƙaci saita kalmar sirri. A cikin tsofaffin nau'ikan, danna kan "Ajiye As" nan da nan ya buɗe taga binciken.
2. Lokacin da taga ajiyewa ya bayyana akan allon, kuna buƙatar nemo sashin "Kayan aiki" a ƙasa. Bude shi kuma zaɓi zaɓi "General Options".

3. Tagar Zaɓuɓɓuka Gabaɗaya yana ba ka damar ƙuntata samun dama ga takaddar. Kuna iya saita kalmomin shiga guda biyu - don duba fayil ɗin da canza abinda ke ciki. An saita damar karanta Kawai azaman hanyar da aka fi so ta wannan taga. Cika filayen shigarwar kalmar sirri kuma danna maɓallin "Ok" don adana canje-canje.

4. Na gaba, dole ne ku tabbatar da kalmomin shiga - sake shigar da su a cikin hanyar da ta dace bi da bi. Bayan danna maɓallin "Ok" a cikin taga na ƙarshe, za a kare daftarin aiki.

5. Ya rage kawai don adana fayil ɗin, bayan saita kalmomin shiga shirin ya dawo da mai amfani zuwa taga adanawa.

Lokaci na gaba da ka buɗe littafin aikin Excel, taga shigar kalmar sirri zata bayyana. Idan an saita lambobi biyu - don dubawa da canzawa - ƙofar tana faruwa a matakai biyu. Ba lallai ba ne a shigar da kalmar sirri ta biyu idan kawai kuna son karanta takaddar.

Wata hanyar da za ta kare daftarin aiki ita ce amfani da fasalulluka a cikin sashin Bayani.

1. Bude shafin "Fayil" kuma sami sashin "Bayanai" a ciki. Ɗaya daga cikin zaɓuɓɓukan sashe shine "Izini".
2. Ana buɗe menu na izini ta danna maɓallin "Kare Littafin". Ana buƙatar abu na biyu a cikin jerin - "Encrypt tare da kalmar sirri". Zaɓi shi don saita lambar shiga.

3. Shigar da sabon kalmar sirri a cikin akwatin ɓoyewa. Na gaba, kuna buƙatar tabbatar da shi a cikin wannan taga. A ƙarshe, danna maɓallin "Ok".

Kula! Kuna iya fahimtar cewa an kunna zaɓi ta hanyar firam ɗin orange wanda ke kewaye da sashin "Izini".

Saita kalmar sirri don sel guda ɗaya

Idan kana buƙatar kare wasu sel daga canza ko share bayanai, ɓoye kalmar sirri zai taimaka. Saita kariya ta amfani da aikin "Kare Sheet". Yana aiki a kan dukan takardar ta tsohuwa, amma bayan ƙananan canje-canje a cikin saitunan zai mayar da hankali kawai akan kewayon sel da ake so.

1. Zaɓi takardar kuma danna-dama akan ta. Menu zai bayyana a cikin abin da kuke buƙatar nemo aikin "Format Cells" kuma zaɓi shi. Tagan saitunan zai buɗe.
2. Zaɓi shafin "Kariya" a cikin taga da ke buɗewa, akwai akwatuna biyu. Wajibi ne a soke babban taga - "Tsarin Kariya". Tantanin halitta a halin yanzu ba shi da tsaro, amma ba za a iya canza shi da zarar an saita kalmar wucewa ba. Na gaba, danna "Ok".

3. Muna zaɓar sel waɗanda ke buƙatar kariya, kuma muna yin aikin baya. Kuna buƙatar sake buɗe “Tsarin sel” kuma duba akwatin “Tantanin halitta mai kariya”.
4. A cikin shafin "Bita" akwai maɓallin "Kare takardar" - danna kan shi. Wani taga zai buɗe tare da kalmar sirri da jerin izini. Mun zaɓi izini masu dacewa - kuna buƙatar duba akwatunan kusa da su. Na gaba, kuna buƙatar fito da kalmar sirri don kashe kariya. Lokacin da duk abin da aka yi, danna "Ok".

Lokacin ƙoƙarin canza abinda ke cikin tantanin halitta, mai amfani zai ga gargaɗin kariya da umarnin yadda ake cire kariya. Wadanda ba su da kalmar sirri ba za su iya yin canje-canje ba.

Hankali! Hakanan zaka iya nemo aikin "Kare Sheet" a cikin shafin "Fayil". Kuna buƙatar zuwa sashin bayanai kuma sami maɓallin "Izini" tare da maɓalli da kulle.

Saita kalmar sirri akan tsarin littafin

Idan an saita kariyar tsari, akwai hani da yawa akan aiki tare da takaddar. Ba za ku iya yin waɗannan abubuwan da littafi ba:

• kwafi, sake suna, share zanen gado a cikin littafin;
• ƙirƙirar zanen gado;
• buɗaɗɗen zanen gado;
• kwafi ko matsar da zanen gado zuwa wasu littattafan aiki.

Bari mu ɗauki ƴan matakai don toshe canje-canjen tsari.

1. Bude shafin "Bita" kuma nemo zabin "Littafin Kare". Hakanan za'a iya samun wannan zaɓi a cikin shafin "Fayil" - sashin "Bayyanawa", aikin "Izinin".

2. Za a buɗe taga tare da zaɓin zaɓi na kariya da filin shigar da kalmar wucewa. Sanya alamar kusa da kalmar "Tsarin" kuma fito da kalmar wucewa. Bayan haka, kuna buƙatar danna maɓallin "Ok".

3. Muna tabbatar da kalmar sirri, kuma tsarin littafin ya zama kariya.

Yadda ake cire kalmar sirri a cikin takardar Excel

Kuna iya soke kariyar daftarin aiki, sel ko littafin aiki a wuri guda da aka shigar dashi. Misali, don cire kalmar sirri daga takaddar kuma soke ƙuntatawa na canje-canje, buɗe taga adanawa ko ɓoyewa kuma share layukan tare da ƙayyadaddun kalmomin shiga. Don cire kalmomin shiga daga zanen gado da littattafai, kuna buƙatar buɗe shafin “Review” kuma danna maɓallan da suka dace. Wani taga mai suna "Cire kariya" zai bayyana, yana buƙatar ka shigar da kalmar sirri. Idan lambar ta yi daidai, kariyar za ta ragu kuma ayyuka tare da sel da zanen gado za su buɗe.

Muhimmin! Idan kalmar sirri ta ɓace, ba za a iya dawo da shi ba. Shirin koyaushe yana yin kashedi game da wannan lokacin shigar da lambobin. A wannan yanayin, sabis na ɓangare na uku zai taimaka, amma amfani da su ba koyaushe bane mai aminci.

Kammalawa

Kariyar da aka gina a cikin takaddun Excel daga gyare-gyare yana da aminci sosai - ba shi yiwuwa a dawo da kalmar wucewa, an canja shi zuwa ga amintattun mutane ko ya kasance tare da mahaliccin tebur. Sauƙaƙan ayyukan kariya shine mai amfani zai iya ƙuntata samun dama ba kawai ga teburin duka ba, har ma ga sel guda ɗaya ko don gyara tsarin littafin.