Yadda ake haɗawa da share ginshiƙai a cikin Excel?Da sauri goge haɗe-haɗe daga bayanan tebur

Idan ka shigar da lamba a cikin tantanin halitta (jerin lissafi), zai bayyana azamanKimiyya, amma yana buƙatar a nuna shi azaman lamba.Bayan haka, raba lambobin zuwa ginshiƙan A da B, kuma ku haɗa su zuwa shafi na C, inda "=A1&B1".

Ina so in ajiye shafi na C kuma in share shafi A da B, amma idan na share shafi A ko B ba da gangan ba, bayanan shafi C za su ɓace, menene zan yi?

Yadda ake haɗa ginshiƙai biyu cikin tebur ɗaya a cikin Excel?

Da farko, bari mu kalli yadda EXCEL ke haɗa bayanai,Kuna iya cimma haɗin kai ta hanyar haɗa ayyuka & ▼

Kwafi da liƙa su azaman "daraja"▼

• Sannan share sel kafin haɗuwa.

Kwamfuta bayanan tebur EXCEL da sauri suna goge sel da suka hade

Bayan haɗawa cikin EXCEL, share sel kafin haɗawa, amma zai adana bayanan da aka haɗa.

Takamaiman matakan aiki na wannan hanyar sune kamar haka:

1. Bude tebur na EXCEL don aiki akan kwamfutar kuma yi amfani da aikin haɗaka a cikin tantanin halitta mara kyau.=B4&C4, sannan danna Shigar don kammala aikin gyara da shigar da ▼

1. Buga a cikin tantanin halitta mara komai=
2. Bayan danna tantanin halitta na farko da kake son haɗawa, shigar&
3. Bayan danna cell na biyu da kake son haɗawa, dannaEntershiga
4. Cika ƙananan sel waɗanda aka haɗa ta hanyar saukewa

• (inB4kumaC4Don haɗuwa da sel, ana iya canza shi bisa ga ainihin halin da ake ciki)

2. Sa'an nan kuma danna Ctrl+C don kwafi merged result cell▼

3. Danna dama akan tantanin halitta mara komai kuma zaɓi "Paste as Value" a cikin "Manna Special" ▼

• Share sel kafin haɗawa, kuma gano cewa sel ɗin kafin haɗawa an goge su bayan an haɗa teburin EXCEL, kuma an kammala aikin riƙe bayanan da aka haɗa.