Hanyar tsari shine ɗayan manyan abubuwan da aikace-aikacen Excel yake. Tare da taimakonsa, zaku iya aiwatar da lissafi kuma shirya abubuwan da ke cikin sel. Bugu da kari, lokacin zabar wata kwala inda kawai ake iya ganin kimar, ana lissafin abin da aka samu wannan kimar a cikin masarar dabara. Amma wani lokacin, wannan kayan aikin na Axel yana ɓacewa. Bari mu ga abin da ya sa wannan ya faru da abin da za a yi a wannan yanayin.
Rashin layi
A zahiri, masarar dabara tana iya ɓacewa saboda manyan dalilai guda biyu: canza saitunan aikace-aikace da ɓarna shirin. A lokaci guda, waɗannan dalilai sun kasu zuwa ƙarin takamaiman lokuta.
Dalili 1: canza saitunan akan tef
A mafi yawancin halayen, ɓacewar masarar dabara shine saboda gaskiyar cewa mai amfani ba da kulawa ya buɗe akwatin da alhakin aikin sa akan tef. Gano yadda za a gyara lamarin.
- Je zuwa shafin "Duba". A kan kintinkiri a cikin akwatin kayan aiki Nuna kusa da siga "Layin dabaru" duba akwatin idan ba a kulle shi ba.
- Bayan waɗannan ayyuka, layin tsarin zai dawo zuwa matsayinsa na asali. Ba kwa buƙatar sake kunna shirin ko aiwatar da wasu ƙarin ayyukan.
Dalili 2: Tsarin sigogi na kwarai
Wani dalili na bacewar tef na iya kasancewa cire haɗin shi a cikin saitunan Excel. A wannan yanayin, ana iya kunna shi ta wannan hanyar kamar yadda aka bayyana a sama, ko kuma kuna iya kunna shi ta wannan hanyar da aka kashe, watau, ta ɓangaren sigogi. Don haka, mai amfani yana da zaɓi.
- Je zuwa shafin Fayiloli. Danna kan kayan "Zaɓuɓɓuka".
- A cikin bude zaɓuɓɓukan Excel na bude, matsa zuwa sashin "Ci gaba". A ɓangaren dama na taga wannan sashin muna neman rukuni na saiti Allon allo. Abu mai adawa Nuna Hanyar Bariki saita alamar. Ba kamar hanyar da ta gabata ba, a wannan yanayin, kuna buƙatar tabbatar da canji a cikin saitunan. Don yin wannan, danna maballin "Ok" a kasan taga. Bayan haka, za'a sake haɗa mashin dabara.
Dalili 3: cin hanci da rashawa na shirin
Kamar yadda kake gani, idan dalilin ya kasance a cikin saitunan, to ana gyara sosai. Yana da matukar muni lokacin da ɓacewar layin dabarun binciken ya kasance sakamakon lalacewa ko lalacewar shirin da kansa, kuma hanyoyin da ke sama ba su taimaka ba. A wannan yanayin, yana da ma'ana don yin aikin murmurewa na Excel.
- Ta hanyar maɓallin Fara je zuwa Gudanarwa.
- Bayan haka za mu matsa zuwa sashin "Cire shirye-shiryen".
- Bayan haka, taga don cirewa da canza shirye-shirye tare da cikakken jerin aikace-aikacen da aka sanya akan PC yana farawa. Nemo rikodin "Microsoft Excel", zaɓi shi kuma danna maballin "Canza"dake kan layin kwance.
- Window Microsoft Change Suite Change yana buɗewa. Saita canji zuwa wuri Maido kuma danna maballin Ci gaba.
- Bayan wannan, ana aiwatar da tsari don maido da shirye-shiryen babban taron Microsoft Office, gami da Excel. Bayan an kammala shi, bai kamata a sami matsala tare da nuna layin ƙirar ba.
Kamar yadda kake gani, layin tsari zai iya bacewa saboda manyan dalilai guda biyu. Idan waɗannan saitunan ba daidai bane (a kan kintinkiri ko a cikin saitunan Excel), to, an warware batun cikin sauƙi da sauri. Idan matsalar ta kasance saboda lalacewa ko mummunan aiki na shirin, dole ne ku bi hanyoyin dawo da su.
