Yadda ake kare sel daga canje-canje a cikin Excel

A wasu lokuta, ya zama dole don kare bayanan da ke cikin sel na takaddar Excel daga canzawa. Kwayoyin da ke da tsari ko sel tare da bayanai akan abin da ake aiwatar da lissafin suna ƙarƙashin irin wannan kariya. Idan an maye gurbin abubuwan da ke cikin irin waɗannan sel, to ana iya keta lissafin a cikin tebur. Hakanan, kariyar bayanai a cikin sel yana da dacewa lokacin canja wurin fayil zuwa wasu mutane. Bari mu kalli wasu hanyoyin gama gari don kare sel daga canje-canje a cikin Excel.

Kunna kariyar tantanin halitta

Wani aikin daban don kare abubuwan da ke cikin sel a cikin ExcelAbin baƙin ciki shine masu haɓaka Excel bai hango ba. Koyaya, zaku iya amfani da hanyoyin da ke ba ku damar kare duk takaddun aikin daga canje-canje. Akwai hanyoyi da yawa don aiwatar da irin wannan kariya, wanda yanzu za mu saba da su.

Hanyar 1: Amfani da Menu na Fayil

A matsayin hanya ta farko, la'akari da ba da damar kariyar takardar Excel ta hanyar menu na Fayil.

1. Da farko, zaɓi abubuwan da ke cikin takardar aikin. Don sauƙaƙe wannan tsari, kawai danna alwatika a mahadar sandunan daidaitawa a kusurwar hagu na sama. Ga waɗanda suke son amfani da maɓallan zafi, akwai haɗin sauri mai dacewa "Ctrl + A". Lokacin da ka danna haɗin sau ɗaya tare da tantanin halitta mai aiki a cikin tebur, tebur kawai za a zaɓa, kuma lokacin da ka sake danna shi, an zaɓi duk takardar aikin.
2. Na gaba, muna kiran menu na pop-up ta danna maɓallin linzamin kwamfuta na dama, kuma kunna siginar "Format Cells".

3. A cikin taga "Format Cells", zaɓi shafin "Kariya" kuma cire alamar akwatin kusa da siginar "Tsarin cell", danna maɓallin "Ok".

4. Yanzu mun zaɓi yankin da ake buƙata na sel waɗanda ke buƙatar kariya daga gyare-gyare maras so, alal misali, ginshiƙi tare da dabaru. Bugu da ƙari, zaɓi "Format Cells" kuma a cikin "Kariya" shafin, mayar da alamar bincike a cikin layi "Ƙaƙƙarfan Ƙaƙƙarfan Ƙirar". Fita taga ta danna Ok.
5. Yanzu bari mu ci gaba zuwa kare takardar aikin. Don yin wannan, je zuwa shafin "File".
6. A cikin ma'auni "Bayani", danna "Kare littafin aiki". Menu mai faɗowa zai bayyana wanda a ciki za mu je sashin "Kare takardar yanzu".

7. Wani ƙaramin taga zai bayyana, inda a gaban ma'aunin "Kare takardar da abinda ke ciki na sel masu kariya", duba akwatin idan babu shi. A ƙasa akwai jerin ma'auni daban-daban waɗanda mai amfani ya cika bisa ga ra'ayinsu.
8. Don kunna kariyar, dole ne ka shigar da kalmar sirri da za a yi amfani da ita don buɗe takaddar aikin Excel.

9. Bayan shigar da kalmar wucewa, taga zai bayyana inda kake buƙatar maimaita kalmar sirri kuma danna "Ok".

Bayan waɗannan magudin, zaku iya buɗe fayil ɗin, amma ba za ku iya yin canje-canje ga sel masu kariya ba, yayin da bayanan da ke cikin sel marasa tsaro za a iya canza su.

Hanyar 2: Bitar Kayan aikin Tab

Wata hanya don kare bayanai a cikin sel na takaddar Excel ita ce amfani da kayan aikin da ke cikin sashin Bita. Jerin ayyuka kamar haka:

1. Da farko kuna buƙatar maimaita maki 5 na farko daga hanyar da ta gabata ta saita kariya, wato, da farko muna cire kariya daga duk bayanan, sannan mu sanya kariya akan sel waɗanda ba za a iya canza su ba.
2. Bayan haka, je zuwa shafin "Review" kuma sami zaɓi na "Kare Sheet" a cikin nau'in "Kare".

3. Lokacin da ka danna maɓallin "Kare Sheet", taga don shigar da kalmar wucewa zai bayyana, kamar yadda aka yi a baya.

A sakamakon haka, muna samun takardar Excel, wanda ya ƙunshi adadin sel waɗanda aka karewa daga canje-canje.

Kula!  Idan kuna aiki a cikin Excel a cikin nau'i mai matsewa a kwance, to, lokacin da kuka danna toshe kayan aikin da ake kira "Kariya", ana buɗe jerin umarni, waɗanda ke ƙunshe da umarni.

Cire kariya

Yanzu bari mu gano yadda ake aiki tare da sel waɗanda aka kiyaye su daga canje-canje.

1. Idan kayi ƙoƙarin shigar da sabbin bayanai a cikin tantanin halitta mai kariya, za a gargaɗe ku cewa tantanin halitta yana da kariya kuma kuna buƙatar cire kariya.

2. Don cire kariya, je zuwa shafin "Bita" kuma a cikin toshe "Kariya" muna samun maballin "Ba tare da kariya ba".
3. Lokacin da ka danna wannan zaɓi, ƙaramin taga yana bayyana tare da filin shigar da kalmar wucewa.

4. A cikin wannan taga, shigar da kalmar wucewa da aka yi amfani da ita don kare sel kuma danna "Ok".

Yanzu za ku iya fara yin canje-canje masu dacewa ga kowane sel a cikin takaddar.

Muhimmin! Zaɓi kalmar sirri mai sauƙi don tunawa amma mai wuya ga sauran masu amfani su yi tsammani.

Kammalawa

Kamar yadda muka gani a baya, babu wani aiki na musamman a cikin Excel don kare zaɓaɓɓun sel daga canje-canje maras so. Duk da haka, akwai hanyoyi masu aminci da yawa waɗanda ke ba ku damar ƙuntata damar yin amfani da bayanan da ke cikin fayil ɗin, ko aƙalla kare takaddun daga gyara, wanda zai iya lalata aikin da aka kashe lokaci mai yawa da ƙoƙari.