A yayin da ke aiki tare da furofayil ɗin Excel, akwai wani lokaci wajibi ne don hana izinin tantancewa. Wannan shi ne ainihin gaskiyar ga jeri wanda ya ƙunshi siffofi, ko waɗanda wasu kwayoyin ke nuna su. Bayan haka, canje-canjen da ba daidai ba a gare su zai iya halakar dukan tsarin lissafi. Yana da mahimmanci don kare bayanai a cikin maɗauraran matakai a kan kwamfutar da ke da damar ga wasu ban da ku. Ayyuka marasa galibi da wani mai fita zai iya halakar da dukan 'ya'yan itãcen aikinku idan ba a kiyaye wasu bayanai ba. Bari mu dubi yadda za ayi wannan.
Yi amfani da Tsuntsar Ciki
A Excel, babu kayan aiki na musamman wanda aka tsara don toshe sel guda, amma wannan hanya za a iya cika ta kare dukkan takardun.
Hanyar 1: A kunna kulle ta hanyar "File" shafin
Don kare wani tantanin halitta ko kewayon, dole ne ka yi ayyukan da aka bayyana a kasa.
- Zaɓi duk takardar ta danna kan rectangle wanda ke samuwa a tsaka-tsaki na bangarorin daidaitawa ta Excel. Danna maballin linzamin dama. A cikin mahallin menu wanda ya bayyana, je zuwa "Tsarin tsarin ...".
- Gila don canza tsarin tsarin sel zai bude. Danna shafin "Kariya". Bude wannan zaɓi "Kwayar karewa". Danna maballin "Ok".
- Ganyatar da kewayon da kake son toshewa. Je zuwa taga sake "Tsarin tsarin ...".
- A cikin shafin "Kariya" duba akwatin "Kwayar karewa". Danna maballin "Ok".
Amma gaskiyar ita ce bayan wannan har yanzu ba'a iya kare shi ba. Zai zama irin wannan kawai idan muka juya kan kariya. Amma a lokaci guda, ba zai yiwu a canza kawai waɗannan sutura ba inda muka sanya akwati a cikin siginar daidai, kuma waɗanda aka cire alamun bincike zasu kasance masu dacewa.
- Jeka shafin "Fayil".
- A cikin sashe "Bayanai" danna maballin "Kare littafin". A cikin jerin da aka bayyana, zaɓi abu "Kare shafi na yanzu".
- Saitunan kare kayan budewa. Dole ne akwai alamar dubawa kusa da saiti "Kare takarda da kuma abinda ke ciki na kwayoyin karewa". Idan ana so, za ka iya saita ƙuntata wasu ayyuka ta hanyar canza saitunan cikin sigogi da ke ƙasa. Amma, a mafi yawan lokuta, saitunan tsoho, haɗu da bukatun masu amfani don kulle jeri. A cikin filin "Kalmar wucewa don musayar takardar kariya" Dole ne ku shigar da kowane maballin da za a yi amfani dashi don samun dama ga fasali. Bayan an yi saitunan, danna maɓallin. "Ok".
- Wani taga ya buɗe inda za'a maimaita kalmar wucewa. Anyi haka ne don haka idan mai amfani ya fara shigar da kalmar wucewa mara kyau, bazai taɓa samun damar yin gyare-gyaren kansa ba. Bayan shigar da maballin da kake buƙatar danna "Ok". Idan kalmomin kalmomin sun daidaita, za'a rufe kulle. Idan basu yi daidai ba, dole ne ka sake shiga.
Yanzu waɗannan rukunin da muka zaba a baya kuma a cikin saitunan tsara sa kariya zasu zama m don gyarawa. A wasu wurare, zaka iya yin kowane aiki kuma ajiye sakamakon.
Hanyar Hanyar 2: Yi amfani da kulle ta hanyar Taɓa shafin
Akwai wata hanyar da za a cire layin daga wasu canje-canje maras so. Duk da haka, wannan zaɓi ya bambanta daga hanyar da ta gabata kawai a cikin cewa ana yin ta ta wani shafin.
- Mun cire kuma saita akwati kusa da "Tsararren tantanin halitta" a cikin tsarin tsari na jeri daidai kamar yadda muka yi a cikin hanyar da ta gabata.
- Jeka shafin "Duba". Danna maɓallin "Tsare Shafin". Wannan maɓallin yana cikin "kayan canje-canje".
- Bayan wannan, daidai wannan takardar tsare-tsaren tsare-tsaren takarda yana buɗewa, kamar yadda a cikin maɓallin farko. Dukkan ayyuka na gaba suna kama da juna.
Darasi: Yadda za a sanya kalmar sirri a kan wani takardar Excel
Buɗe iyaka
Lokacin da ka danna kan kowane yanki na kulle kulle ko lokacin da kake kokarin canza abinda ke ciki, saƙo zai bayyana wanda ya ce ana kare lafiyar daga canje-canje. Idan kun san kalmar sirri kuma kuna so ku gyara bayanai, to kuna buƙatar ɗaukar wasu matakai don buɗe kulle.
- Jeka shafin "Binciken".
- A kan tef a cikin ƙungiyar kayan aiki "Canje-canje" danna maballin "Cire kariya daga takardar".
- Fila yana bayyana inda dole ne ku shigar da kalmar sirrin da aka saita a baya. Bayan shigar da buƙatar ka danna maballin "Ok".
Bayan wadannan ayyuka, kariya daga dukkan kwayoyin za a cire.
Kamar yadda kake gani, duk da gaskiyar cewa Excel ba shi da kayan aiki mai mahimmanci don kare wani tantanin halitta, kuma ba dukan takarda ko littafi ba, wannan hanya za a iya yi ta wasu ƙarin manipulations ta hanyar sauya tsarin.
