Ƙirƙiri hanyar haɗin waje a cikin Excel

• Ƙirƙiri hanyar haɗin waje
• Fadakarwa
• Gyaran hanyar haɗin gwiwa

Bayanin waje a cikin Excel nuni ne ga tantanin halitta (ko kewayon sel) a cikin wani littafin aiki. A kan zane-zane

a kasa za ku ga littattafai daga sassa uku (Arewa, Tsakiya da Kudu).

Ƙirƙiri hanyar haɗin waje

Don ƙirƙirar hanyar haɗin waje, bi umarnin da ke ƙasa:

1. Bude duk takardun guda uku.
2. A cikin littafin "Kamfanin", haskaka tantanin halitta B2 kuma shigar da alamar daidai "=".
3. A kan Babba shafin view (Duba) danna maɓallin Canja Windows (Je zuwa wata taga) kuma zaɓi "Arewa".
4. A cikin littafin "Arewa", haskaka tantanin halitta B2 kuma shigar da "+".
5. Maimaita matakai na 3 da 4 don littattafan "Mid" da "Kudu".
6. Cire alamun "$" a cikin tsarin salula B2 kuma kwafi wannan dabara zuwa wasu sel. Sakamako:

Fadakarwa

Rufe duk takardu. Yi canje-canje ga littattafan sashe. Rufe duk takardun kuma. Bude fayil ɗin "Kamfani".

1. Don sabunta duk hanyoyin haɗin gwiwa, danna maɓallin Sanya Abun ciki (Hada abun ciki).
2. Don hana haɗi daga ɗaukakawa, danna maɓallin X.

Note: Idan ka ga wani faɗakarwa, danna Update (Sabunta) ko Kar a sabunta (Kada a sabunta).

Gyaran hanyar haɗin gwiwa

Don buɗe akwatin maganganu Shirya hanyoyin haɗi (Change Links), akan shafin data (Data) a cikin sashe Ƙungiyar haɗi (Haɗin kai) danna Gyara alamar hanyoyin haɗin gwiwa (Canja hanyoyin haɗin gwiwa).

1. Idan baku sabunta hanyoyin haɗin kai tsaye ba, zaku iya sabunta su anan. Zaɓi littafi kuma danna maɓallin Sabunta Darajoji (Sake sabuntawa) don sabunta hanyoyin haɗin yanar gizon wannan littafin. lura cewa Status (Status) yana canzawa zuwa OK.
2. Idan ba ka son sabunta hanyoyin sadarwa ta atomatik kuma ba ka son a nuna sanarwar, danna maɓallin Saurin Farawa (Nemi don sabunta hanyoyin haɗin gwiwa), zaɓi zaɓi na uku kuma danna OK.