Makulan Hars Yadda Ake Hada Sells A ERCELELE

Anonim

Makulan Hars Yadda Ake Hada Sells A ERCELELE

Hanyar 1: Multi Button

Bari mu fara da hanyar gargajiya na hada sel a Excel ta amfani da aiki tare da sunan da ya dace. Koyaya, wannan lokacin ya canza Hanyar kiran shi, aka fada game da daidaitattun makullin makullin da akayi niyya don motsawa cikin kayan aikin shirin. Kuna buƙatar aiwatar da wurare da yawa, amma idan kun tuna su, an yi kunna maɓallin maɓallin da sauri fiye da zaɓin da aka zaɓi tare da zaɓin.

  1. Zaɓi ƙwayoyin da kuke so haɗuwa.
  2. Zaɓin ƙwayoyin sel don haɗuwa tare da maɓallin da ya dace a Fore Fim

  3. Latsa maɓallin Alt don bayyana menu tare da zaɓi na ayyuka da maɓallin bayan gida. Zaɓi shafin "gida" na J.
  4. Je zuwa shafin gida ta amfani da maballin kewayawa don haɗe sel a fice

  5. Mai zuwa zai nuna wani kwamiti tare da ayyuka, inda kake buƙatar tura tura wuraren zaɓuɓɓukan jeri ta hanyar shch key.
  6. Zaɓi menu don haɗe da sel ta amfani da maɓallan kewayawa zuwa fice

  7. A cikin sabon menu down, da yawa zaɓuɓɓuka don hada sel zai bayyana. Yi amfani da kowane daga gare su ta hanyar godiya da bukatunku.
  8. Zabi sel na sel suna amfani da maɓallan kewayawa zuwa Fovice

  9. Bayan kunna maɓallin, haɗe zai faru ta atomatik cewa zaku ga dawowa zuwa teburin.
  10. Nasara capting celled infref amfani da maɓallan kewayawa

  11. Lura cewa hade da sel biyu ko fiye, a cikin kowane tamanin, yana faruwa ne tare da cika darajar kwarewar da ta faru, wato kawai, kuma an share ragowar bayanan kawai. Ari ga haka, wannan zai sanar da sanarwar shirin da ya bayyana.
  12. Tabbatar da Cibiyar Cell Areaukaka ta fifita a gaban kewayon da aka zaɓa a cikin sel

  13. Sakamakon irin wannan ƙungiyar da kuka ga masu hoto mai zuwa.
  14. Nasara pell capeding in fifita a gaban kewayon kewayon da aka zaɓa

Hanyar 2: Button a cikin Softungiyar shiga cikin sauri

Amfani da makullin zafi kuma yana ɗaukar lokaci, saboda haka idan kun haɗu da sel a Forevel, galibi yana da mahimmanci, me zai hana maye gurbinsu da maɓallin gajere akan fannoni ɗaya. Don yin wannan, kuna buƙatar yin ƙaramin saiti.

  1. Fadada da digo-saukar da dama Benu damar dama ta latsa maɓallin kibiya da ke inda ka zaɓi wasu dokokin.
  2. Je zuwa kafa kwamiti mai sauri damar ƙara sel na sel don fixo

  3. A cikin jerin dokokin da ke samarwa, gano "haɗe da wuri a cikin cibiyar", bayan wanda ka danna maɓallin "ƙara".
  4. Zaɓi maɓallin ƙwallon tantanin halitta don ƙarawa zuwa cikin hanzari mai sauri don ficewa

  5. Maɓallin mai dacewa zai bayyana a cikin jerin a hannun dama, wanda ke nufin cewa an yi nasarar ƙara shi a cikin kwamiti mai sauri kuma zaka iya rufe wannan menu.
  6. Sanya maɓallin sel zuwa cikin sauri mai shiga cikin sauri don ficewa

  7. Kamar yadda za a iya gani, maballin yana hannun hagu sama, koyaushe yana cikin fili kuma an kashe mafi girman akan kunnawa.
  8. Yin amfani da maɓallin haɗin gwiwar tantanin halitta a cikin sauri panel ɗin zuwa Excel shine

  9. Zaɓi Kwayoyin kuma latsa maɓallin don samun canje-canje da ake buƙata nan da nan.
  10. Sakamakon amfani da maɓallin haɗin gwiwar tantanin halitta a cikin sauri panel panel don ficewa

Hanyar 3: Aiki "Cika" - "Daidaita"

Tare da taimakon kewayawa tare da makullin mai zafi, kamar yadda aka nuna a cikin hanyar 1, zaku iya haɗa abubuwan da ke cikin sel da kuma cika waɗancan wuraren da rubutattun sel ya dace. Wannan fasalin ba da wuya ya dace ba lokacin aiki tare da tebur, amma inda akwai rubutu kawai, zai iya zama da amfani. Ka'idar ayyukansa za ta gani a cikin koyarwar masu zuwa.

  1. Select da shafi tare da rubutun da kake son cika da kuma a daidaita don ƙarin nuni daidai.
  2. Zaɓi kewayon bayanan rubutu don cikawa da kuma daidaita sel a fice

  3. Kira kewayawa ta hanyar Alt kuma latsa Ina sauya zuwa babban shafin.
  4. Je zuwa shafin gida don cika kuma a daidaita sel a fice

  5. Da farko, latsa Yu, sannan don zuwa menu na "Gyara".
  6. Sake zaɓi Zabi Menu na cika da kuma a daidaita sel a fice

  7. Madadin haka, danna kuma don buɗe jerin zaɓuka na ƙasa "Cika".
  8. Bude menu da jeri menu a Excel lokacin hade

  9. Zabi a can mataki "amfani da" amfani da maɓallin s.
  10. Zabi wani sabon abu na sel lokacin cika masu kyau

  11. Koma zuwa kewayon da aka keɓe ka duba sakamakon cika da jeri.
  12. Sakamakon jeri da kuma cika sel da aka zaɓa tare da rubutu a Excel

Kara karantawa