Kare sel daga canje-canje a cikin Excel

Sau da yawa, saboda dalilai daban-daban, masu amfani suna fuskantar aikin kare wasu abubuwa na ma'auni na Excel daga yiwuwar canje-canje. Misali, waɗannan na iya zama sel masu tsari, ko sel waɗanda ke da hannu a cikin lissafin, kuma abubuwan da ke cikin su ba za a iya daidaita su ba. Wannan gaskiya ne musamman lokacin da wasu mutane suka sami damar shiga teburin. A ƙasa za mu ga yadda za ku iya jimre wa aikin.

Kunna kariyar tantanin halitta

Abin takaici, Excel ba ya samar da wani aikin daban wanda ke kulle sel don kare su, duk da haka, don waɗannan dalilai, zaku iya amfani da kariyar duk takardar. Ana iya yin hakan ta hanyoyi daban-daban.

Hanyar 1: Yi amfani da Menu na Fayil

Don ba da damar kariya, yi abubuwa masu zuwa:

1. Da farko kuna buƙatar zaɓar duk abubuwan da ke cikin takardar. Don yin wannan, danna kan rectangle a tsakar mahaɗin mahaɗar. Hakanan zaka iya danna haɗin maɓallin Ctrl + A ( sau ɗaya idan an zaɓi tantanin halitta a waje da tebur mai cika, sau biyu idan an zaɓi tantanin halitta a cikinsa).
2. Danna-dama a ko'ina a cikin yankin da aka zaɓa kuma zaɓi daga jerin abubuwan da aka saukar "Format Cell".
3. A cikin taga tsarin salula da ke buɗewa, a cikin shafin "Kariya" cire alamar zaɓi "Tantanin halitta mai kariya", sannan latsa OK.
4. Yanzu, a kowace hanya mai dacewa (alal misali, tare da maɓallin linzamin kwamfuta na hagu), zaɓi yanki na sel waɗanda muke son karewa daga canje-canje. A cikin yanayinmu, wannan ginshiƙi ne mai tsari. Bayan haka, danna-dama akan kewayon da aka zaɓa don kiran menu na mahallin kuma zaɓi abu kuma "Format Cell".
5. Ta hanyar zuwa shafin "Kariya" duba akwatin kusa da zabin "Tantanin halitta mai kariya" kuma danna OK.
6. Yanzu kuna buƙatar kunna kariyar takardar. Bayan haka, za mu sami damar daidaita duk sel na takardar, sai dai waɗanda aka haɗa a cikin kewayon da aka zaɓa. Don yin wannan, buɗe menu "Fayil".
7. A gefen dama na abun cikin sashin "Haskaka" tura maɓallin "Kare Littafin". Jerin umarni zai buɗe, daga cikinsu kuna buƙatar zaɓi - "Kare takardar yanzu".
8. Zaɓuɓɓukan kariyar takardar ana nuna su akan allon. Zabin kishiya "Kare takardar da abubuwan da ke cikin sel masu kariya" dole ne a duba akwati. Zaɓuɓɓukan da suka rage a ƙasa an zaɓi su bisa ga burin mai amfani (a mafi yawan lokuta, sigogin sun kasance ba a taɓa su ba). Don kare takardar, kuna buƙatar shigar da kalmar sirri a cikin filin da aka tsara musamman don wannan (za a buƙaci daga baya don buɗe shi), bayan haka kuna iya dannawa. OKAYA.
9. A cikin ƙaramin taga na gaba, kuna buƙatar maimaita kalmar sirri da aka shigar a baya kuma danna maɓallin sake OK. Wannan ma'aunin zai taimaka wajen kare mai amfani daga rubutun nasu lokacin saita kalmar sirri.
10. Duk a shirye. Yanzu ba za ku iya shirya abubuwan da ke cikin sel waɗanda muka ba da damar kariya don zaɓin tsarawa ba. Za a iya canza ragowar abubuwan da ke cikin takardar bisa ga ra'ayinmu.

Hanyar 2: Aiwatar da kayan aikin shafin Bita

Hanya ta biyu don ba da damar kariyar tantanin halitta ta ƙunshi amfani da kayan aikin tab "Bita". Ga yadda ake yi:

1. Muna bin matakai 1-5 da aka kwatanta a hanya ta 1, watau cire kariya daga dukkan takardar kuma saita baya don zaɓaɓɓun sel.
2. A cikin rukunin kayan aiki "Kariya" shafuka "Bita" danna maɓallin "Takardar Kariya".
3. Wani sanannen taga tare da zaɓuɓɓukan kariyar takarda zai bayyana. Sa'an nan kuma mu bi matakai iri ɗaya kamar yadda ake aiwatar da hanyar da aka bayyana a sama.

lura: Lokacin da taga shirin yana matsawa (a kwance), akwatin kayan aiki "Kariya" maɓalli ne, danna wanda zai buɗe jerin umarni da ake da su.

Cire kariya

Idan muka yi ƙoƙarin yin canje-canje ga kowane ɗayan sel masu kariya, shirin zai ba da saƙon bayanin da ya dace.

Don buše makullin, dole ne ka shigar da kalmar sirri:

1. Shafin "Bita" a cikin rukunin kayan aiki "Kariya" danna maɓallin "Takarda mara tsaro".
2. Wani ƙaramin taga zai buɗe tare da filin guda ɗaya wanda yakamata ku shigar da kalmar sirri da aka ƙayyade lokacin toshe sel. Tura maballi OK za mu cire kariya.

Kammalawa

Duk da cewa Excel ba shi da wani aiki na musamman da aka tsara don kare wasu sel daga gyarawa, zaku iya yin hakan ta hanyar kunna kariyar dukkan takardar, bayan saita sigogin da ake buƙata don sel da aka zaɓa.