Bayanin da'ira a cikin Excel. Yadda ake nemo da sharewa - hanyoyi 2

A mafi yawan lokuta, masu amfani suna ganin nassoshi madauwari azaman maganganun kuskure. Wannan shi ne saboda gaskiyar cewa shirin da kansa ya yi yawa daga gabansu, yana gargadi game da wannan tare da faɗakarwa na musamman. Don cire nauyin da ba dole ba daga hanyoyin software da kuma kawar da yanayin rikici tsakanin sel, ya zama dole a nemo wuraren matsala kuma cire su.

Menene ma'anar madauwari

Maganar madauwari magana ce wadda, ta hanyar dabarun da ke cikin wasu sel, tana nufin ainihin farkon magana. A lokaci guda, a cikin wannan sarkar za a iya samun adadi mai yawa na haɗin gwiwa, daga abin da aka kafa da'irar mugu. Mafi sau da yawa, wannan furcin kuskure ne wanda ya cika tsarin, yana hana shirin yin aiki daidai. Koyaya, a wasu yanayi, masu amfani da gangan suna ƙara nassoshi madauwari don yin wasu ayyukan lissafi.

Idan ma'anar madauwari kuskure kuskure ne wanda mai amfani ya yi ta hanyar haɗari lokacin cika tebur, gabatar da wasu ayyuka, dabaru, kuna buƙatar nemo shi kuma share shi. A wannan yanayin, akwai hanyoyi masu tasiri da yawa. Yana da daraja yin la'akari daki-daki 2 mafi sauƙi da tabbatarwa a aikace.

Muhimmin! Yin tunani game da ko akwai nassoshi madauwari a cikin tebur ko a'a ba lallai ba ne. Idan irin waɗannan rikice-rikice sun kasance, nau'ikan Excel na zamani nan da nan suna sanar da mai amfani game da wannan tare da taga gargadi tare da bayanan da suka dace.

Bincike na gani

Hanyar bincike mafi sauƙi, wanda ya dace lokacin duba kananan tebur. Tsari:

1. Lokacin da taga gargadi ya bayyana, rufe shi ta latsa maɓallin Ok.
2. Shirin zai zayyana waɗancan sel ta atomatik waɗanda yanayin rikici ya taso a tsakanin su. Za a haskaka su da kibiya ta musamman.

3. Don cire cyclicity, kuna buƙatar zuwa tantanin halitta da aka nuna kuma gyara dabarar. Don yin wannan, ya zama dole don cire haɗin gwiwar tantanin halitta daga tsarin gaba ɗaya.
4. Ya rage don matsar da siginan linzamin kwamfuta zuwa kowane tantanin halitta kyauta a cikin tebur, danna LMB. Za a cire bayanin madauwari.

Amfani da kayan aikin shirin

A lokuta inda kibau ba su nuna matsala a cikin tebur ba, dole ne ka yi amfani da ginanniyar kayan aikin Excel don nemo da cire nassoshi madauwari. Tsari:

1. Da farko, kuna buƙatar rufe taga gargadi.
2. Je zuwa shafin "Formulas" akan babban kayan aiki.
3. Je zuwa sashin Dogaran Formula.
4. Nemo maɓallin "Duba Kurakurai". Idan taga shirin yana cikin tsari mai matsewa, wannan maballin za a yi masa alama da ma'anar motsin rai. Kusa da shi yakamata ya kasance ƙaramin alwatika wanda ke nuna ƙasa. Danna kan shi don kawo jerin umarni.

5. Zaɓi "Haɗin da'ira" daga lissafin.
6. Bayan kammala duk matakan da aka bayyana a sama, mai amfani zai ga cikakken jeri tare da sel waɗanda ke ɗauke da nassoshi madauwari. Domin fahimtar ainihin inda wannan tantanin halitta yake, kuna buƙatar nemo shi a cikin jerin, danna shi tare da maɓallin linzamin kwamfuta na hagu. Shirin zai tura mai amfani ta atomatik zuwa wurin da rikici ya faru.
7. Na gaba, kuna buƙatar gyara kuskure don kowane tantanin halitta mai matsala, kamar yadda aka bayyana a hanya ta farko. Lokacin da aka cire haɗin kai masu cin karo da juna daga duk dabarun da ke cikin lissafin kuskure, dole ne a yi rajistan karshe. Don yin wannan, kusa da maɓallin "Duba kurakurai", kuna buƙatar buɗe jerin umarni. Idan ba a nuna abun "Circular Links" yana aiki ba, babu kurakurai.

Kashe kullewa da ƙirƙirar bayanan madauwari

Yanzu da kun gano yadda ake nemo da gyara nassoshi madauwari a cikin maƙunsar rubutu na Excel, lokaci ya yi da za ku kalli yanayin da za a iya amfani da waɗannan maganganun don amfanin ku. Koyaya, kafin wannan, kuna buƙatar koyon yadda ake kashe toshewa ta atomatik na irin waɗannan hanyoyin haɗin gwiwa.

Mafi sau da yawa, ana amfani da nassoshi madauwari da gangan yayin ginin ƙirar tattalin arziki, don yin ƙididdige ƙididdiga. Duk da haka, ko da an yi amfani da irin wannan magana a hankali, shirin zai toshe shi ta atomatik. Don gudanar da magana, dole ne ku kashe makullin. Don yin wannan, kuna buƙatar aiwatar da ayyuka da yawa:

1. Je zuwa shafin "File" a kan babban panel.
2. Zaɓi "Saituna".
3. Ya kamata taga saitin Excel ya bayyana a gaban mai amfani. Daga menu na hagu, zaɓi shafin "Formulas".
4. Jeka sashin Zaɓuɓɓukan Lissafi. Duba akwatin da ke kusa da aikin "Kuna Ƙirar lissafi". Bugu da ƙari, a cikin filayen kyauta da ke ƙasa za ku iya saita matsakaicin adadin irin waɗannan ƙididdiga, kuskuren halatta.

Muhimmin! Yana da kyau kada a canza matsakaicin adadin ƙididdige ƙididdiga sai dai idan ya zama dole. Idan sun yi yawa, shirin zai yi yawa, za a iya samun gazawa tare da aikinsa.

5. Domin canje-canje su yi tasiri, dole ne ku danna maɓallin "Ok". Bayan haka, shirin ba zai daina toshe ƙididdiga ta atomatik a cikin sel waɗanda ke da alaƙa da nassoshi madauwari ba.

Hanya mafi sauƙi don ƙirƙirar hanyar haɗi shine zaɓi kowane tantanin halitta a cikin tebur, shigar da alamar "=" a ciki, nan da nan bayan haka ƙara haɗin haɗin tantanin halitta ɗaya. Don rikitar da ɗawainiyar, don ƙaddamar da ma'anar madauwari zuwa sel da yawa, kuna buƙatar bin hanya mai zuwa:

1. A cikin cell A1 ƙara lamba "2".
2. A cikin cell B1, shigar da darajar "= C1".
3. A cikin cell C1 ƙara dabara "= A1".
4. Ya rage don komawa cikin tantanin halitta na farko, ta hanyar shi koma zuwa tantanin halitta B1. Bayan haka, jerin sel guda 3 zasu rufe.

Kammalawa

Nemo nassoshi madauwari a cikin maƙunsar bayanai na Excel yana da sauƙi isa. Wannan aikin yana sauƙaƙa sosai ta hanyar sanarwa ta atomatik na shirin kanta game da kasancewar maganganu masu karo da juna. Bayan haka, ya rage kawai don amfani da ɗaya daga cikin hanyoyin biyu da aka bayyana a sama don kawar da kurakurai.