Lokacin aiki tare da tebur na Excel, wani lokacin akwai buƙatar hana yin gyare-gyare akan tantanin halitta. Gaskiya ne gaskiya ga jeri inda aka ƙunshi tsarin kwalliya, ko kuma wanda wasu sel suke magana. Bayan haka, canje-canje da ba a yi ba a kansu zai iya rushe tsarin tsarin lissafi gabaɗaya. Abin sani kawai ya zama dole don kare bayanai musamman a cikin tebur masu mahimmanci musamman a kan kwamfutar da sauran mutane banda kuna da damar zuwa. Ayyukan gaggawa na ɗan waje na iya lalata dukkan fruitsa ofan aikinku idan ba a kiyaye wasu bayanai da kyau ba. Bari mu bincika daidai yadda za a iya yin wannan.
Sanya toshewar sel
A cikin Excel babu wani kayan aiki na musamman da aka tsara don kulle ɗayan sel, amma ana iya aiwatar da wannan hanyar ta hanyar kiyaye duk takarda.
Hanyar 1: kunna kulle ta hanyar Fayil
Don kare sel ko kewayo, kuna buƙatar aiwatar da ayyukan da aka bayyana a ƙasa.
- Zaɓi duka takarda ta danna kan maɓallin muƙamin da ke tsakiyar inda yake tsakiyar bangarorin Excel daidaitawa. Danna dama. A cikin menu na mahallin da ke bayyana, je zuwa "Tsarin kwayar halitta ...".
- Taga taga don canza tsarin sel. Je zuwa shafin "Kariya". Cire zaɓi "Kariyar kariya". Latsa maballin "Ok".
- Haskaka kewayon da kake son toshewa. Tafi ta sake taga "Tsarin kwayar halitta ...".
- A cikin shafin "Kariya" duba akwatin "Kariyar kariya". Latsa maballin "Ok".
Amma, gaskiyar ita ce bayan wannan adadin bai sami kariyar ba tukuna. Zai zama irin wannan lokacin da muka kunna kariyar takarda. Amma a lokaci guda, bazai yuwu a canza waɗancan sel kawai ba inda muka bincika akwati a cikin sakin abin da ya dace, kuma waɗanda ayoyin ba'a suttresu ba zasu zama masu gyara.
- Je zuwa shafin Fayiloli.
- A sashen "Cikakkun bayanai" danna maballin Kare Littattafai. Cikin jeri wanda ya bayyana, zaɓi Kare Shege na yanzu.
- Ana buɗe saitunan tsaro na takardar. Tabbatar duba akwatin kusa da sigogi "Ka kiyaye takarda da abinda ke ciki na sel da kariya". Idan ana so, zaku iya saita katange wasu ayyuka ta hanyar sauya saiti a cikin sigogin da ke ƙasa. Amma, a mafi yawan lokuta, saitunan da aka saita ta tsohuwa biyan bukatun masu amfani don toshe jeri. A fagen "Kalmar sirri don hana kariyar takardar kariya" Dole ne ku shigar da kowane kalma wanda za ayi amfani da shi don samun damar fasalin fasalin gyara. Bayan an gama saitunan, danna maballin "Ok".
- Wani taga yana buɗewa wanda ya kamata a maimaita kalmar wucewa. Anyi wannan ne domin idan mai amfani da farko ya shiga kalmar sirri ba ta dace ba, hakanan har abada ba zai toshe hanyar samun damar yiwa kansa gyara ba. Bayan shigar da mabuɗin, danna maɓallin "Ok". Idan kalmomin shiga suka yi daidai, makullin zai cika. Idan ba su daidaita ba, za ku sake shiga.
Yanzu waɗannan jeri waɗanda muka ambata a baya kuma muka sanya kariya ta tsare-tsaren shirya ba za su samu damar yin gyara ba. A wasu yankuna, zaku iya yin kowane aiki kuma ku sami sakamako.
Hanyar 2: kunna tarewa ta hanyar Duba shafin
Akwai wata hanya don toshe kewayon daga canje-canjen da ba'a so. Koyaya, wannan zaɓi ya bambanta da hanyar da ta gabata kawai a cikin cewa ana aiwatar da shi ta wani shafin.
- Muna cirewa da bincika akwatunan da ke kusa da sigar "Kariyar kariya" a cikin taga tsarin samfuran masu dacewa kamar yadda muka yi a cikin hanyar da ta gabata.
- Je zuwa shafin "Duba". Latsa maɓallin "Kare Sheet". Wannan makullin yana cikin akwatin kayan aiki na Gyara.
- Bayan haka, ainihin tsarin saitin kare takarda yana buɗe kamar yadda yake a farkon sigar. Duk sauran matakan gaba daya masu kama daya ne.
Darasi: Yadda za a sanya kalmar sirri a fayil ɗin Excel
Yankin buɗe
Lokacin da ka danna kowane yanki na kewayon kullewa ko kuma lokacin da kake ƙoƙarin canja abin da ke ciki, saƙon zai bayyana yana nuna cewa an kiyaye tantanin halitta daga canje-canje. Idan kun san kalmar sirri kuma da gangan kuna son gyara bayanan, to don buše shi, kuna buƙatar yin wasu ayyuka.
- Je zuwa shafin "Duba".
- A kan kintinkiri a cikin kayan aiki "Canza" danna maballin "Cire kariya daga takarda".
- Wani taga yana buɗewa wanda dole ne shigar da kalmar wucewa da aka saita a baya. Bayan kun shiga, danna maɓallin "Ok".
Bayan waɗannan ayyuka, za a cire kariya daga dukkanin sel.
Kamar yadda kake gani, duk da gaskiyar cewa shirin Excel bashi da kayan aiki mai kima don kare takamaiman kwayar, amma ba duka takarda ko littafin ba, ana iya yin wannan hanyar ta hanyar wasu manian takaddama ta hanyar canza tsarin.
