Yadda za a hada salula a cikin Excel da Googlereadsheets

01 na 01

Haɗa Siffofin a cikin Excel da Shafukan Lissafin Google

A cikin Excel da Shafukan Ɗab'in Google, sel mai haɗuwa shine kwayar halitta guda ɗaya da aka haɓaka ta haɗuwa ko hada haɗari biyu ko fiye da kwayoyin halitta tare.

Dukansu shirye-shirye suna da zaɓi don:

• hade Kwayoyin a fili
• hade Kwayoyin a tsaye
• hade sassan biyu a tsaye da kuma a tsaye.

Bugu da ƙari, Excel yana da zaɓi don Haɗa & Data Cibiyar wanda shine siffar tsarawa da aka saba amfani dashi lokacin ƙirƙirar lakabi ko shafuka.

Hadawa da kuma tsakiyar yana sa sauƙaƙe don sanya shafuka a kan ginshiƙai masu mahimman rubutu.

Haɗa Ɗaya daga cikin Bayanan Bayanai kawai

Hada Kwayoyin a cikin Excel da Fuskar Shafukan Google yana da iyakance ɗaya - ba za su iya haɗa bayanai daga kwayoyin halitta ba.

Idan yawancin bayanan bayanai sun haɗu, kawai bayanan da ke cikin hagu na hagu mafi yawa - duk sauran bayanai zasu rasa lokacin da haɗin ya faru.

Tambayar tantanin halitta don tantanin tantanin halitta shine tantanin halitta a cikin kusurwar hagu na gefen hagu na ainihi ko ƙungiyar sel.

Inda za a hada

A cikin Excel, an sami zaɓi na haɗin a kan shafin shafin shafin rubutun. Alamar don alama tana mai suna Merge & Cibiyar, amma ta latsa maɓallin ƙasa zuwa dama na sunan kamar yadda aka nuna a cikin hoton da ke sama, wani jerin sauƙi na dukkanin haɗin zaɓuka ya buɗe.

A cikin Shafukan Lissafi na Google, ana samun siginar Kwayoyin Hadawa a ƙarƙashin Menu na Tsarin . An kunna yanayin kawai idan an zaɓi maɓuɓɓuka masu yawa da aka zaɓa.

A Excel, idan Haɗa & Cibiyar aka kunna lokacin da aka zaɓa kawai tantanin tantanin halitta, kawai sakamako shi ne don canja wannan tantanin halitta zuwa cibiyar.

Yadda za a hada salula

A cikin Excel,

1. Zaɓi sel masu yawa don haɗawa;
2. Danna kan Ƙungiya & Cibiyar Cibiyar a kan shafin shafin rubutun don haɗin kwayoyin da kuma bayanan cibiyar bayanan da aka zaba;
3. Don amfani da ɗaya daga cikin sauran zaɓuɓɓukan haɓaka, danna kan arrow kusa kusa da Ƙungiya & Cibiyar Cibiyar kuma zaɓi daga zaɓuɓɓukan da aka samo:
   • Haɗa & Cibiyar;
   • Daidaita Kwayoyin (jigilar halitta a fili - a fadin ginshikan);
   • Haɗa Cells (haɗuwa Kwayoyin a fili, tsaye, ko duka biyu);
   • Zamarar Cells.

A cikin Shafukan Lissafin Google:

1. Zaɓi sel masu yawa don haɗawa;
2. Danna Tsarin> Haɗa Kwayoyin a cikin menus don buɗe mahallin mahallin mahaɗin zabin;
3. Zaɓa daga zaɓuɓɓuka masu samuwa:
   • Hada dukkanin (haɗa sel a tsaye, tsaye, ko biyu);
   • Haɗa kai tsaye;
   • Haɗa kai tsaye;
   • Ba da izinin shiga ba.

Ƙungiyar Excel da Cibiyar Tsarin

Wani zabin don zartar da bayanai a fadin ginshiƙan ginshiƙai shine amfani da Zaɓin Cibiyar Ƙarƙashin Ƙira wanda ke cikin akwatin maganin Siffofin Siffofin .

Amfanin yin amfani da wannan fasalin maimakon Fassara & Cibiyar shine cewa ba ya hada da sassan da aka zaba.

Bugu da ƙari, idan fiye da ɗaya cell ya ƙunshi bayanai lokacin da ake amfani da fasalin, bayanai a cikin kwayoyin suna aukuwa ne daban-daban kamar canza canje-canje na cell.

Kamar yadda aka hada da Cibiyar & Cibiyar, zartar da rubutun a kan ginshiƙan ginshiƙai sau da yawa ya sa ya fi sauƙi don ganin cewa taken ya shafi dukkanin layi.

Don ci gaba da zane ko rubutu na rubutu a cikin ginshiƙai ginshiƙai, yi waɗannan abubuwa masu zuwa:

1. Zaži kewayon Kwayoyin dake dauke da rubutun don a tsakiya;
2. Danna kan shafin shafin shafin rubutun;
3. A cikin Ƙungiyar Haɓaka , danna zanen maganganun magana don buɗe akwatin maganganun Siffofin Siffofin;
4. A cikin akwatin maganganu, danna kan Alignment tab;
5. A ƙarƙashin Sigin rubutu , danna akwatin jeri ƙarƙashin Hanya don ganin jerin samfuran da aka samo;
6. Danna kan Cibiyar Tsinkaya don ci gaba da rubutu da aka zaɓa a fadin kewayen sel;
7. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki.

Pre-Excel 2007 Daidaita & Cibiyar Kuskuren

Kafin Excel 2007, amfani da Ƙungiya & Cibiyar na iya haifar da matsalolin yayin yin canje-canje na gaba a yankin da aka haɗu da aikin aiki .

Alal misali, ba zai yiwu a ƙara sababbin ginshiƙai zuwa wurin haɗin gwiwar aikin aiki ba.

Kafin ƙara sabon ginshiƙai, matakan da zasu biyo baya shine:

1. un-hade da halin yanzu haɗuwa kwayoyin dauke da take ko je;
2. Ƙara sabon ginshiƙai zuwa takardar aiki;
3. sake yin amfani da haɗin da zaɓi na tsakiya.

Tun da Excel 2007 duk da haka, yana yiwuwa don ƙara ƙarin ginshiƙai zuwa yankin da aka haɗu kamar yadda sauran wurare na takardun aiki ba tare da bin matakan da ke sama ba.