Ungawahlanganisa kanjani futhi uwasuse kanjani amakholomu ku-Excel?Susa ngokushesha amaseli ahlanganisiwe kudatha yethebula

Uma ufaka inombolo kuseli (ukulandelana kwe-arithmetic), izovela njengeisayensi, kodwa idinga ukuthi iboniswe njengenombolo.Bese, uhlukanise izinombolo zibe amakholomu A no-B, futhi uwahlanganise abe yikholomu C, lapho "=A1&B1".

Ngifuna ukugcina ikholomu C futhi ngisuse ikholomu A no-B, kodwa uma ngisusa ikholomu A noma B ngokungafanele, idatha yekholomu C izonyamalala, yini okufanele ngiyenze?

Ungawahlanganisa kanjani amakholomu amabili etafuleni elilodwa ku-Excel?

Okokuqala, ake sibheke ukuthi i-EXCEL ihlanganisa kanjani idatha,Ungafinyelela ukuhlanganisa ngokuhlanganisa imisebenzi & ▼

Kopisha bese unamathisele "njengamagugu"▼

• Bese ususa amaseli ngaphambi kokuhlanganisa.

Idatha yethebula lekhompyutha ye-EXCEL isusa ngokushesha amaseli ahlanganisiwe

Ngemva kokuhlanganisa ku-EXCEL susa amaseli ngaphambi kokuhlanganisa, kodwa uzogcina idatha ehlanganisiwe.

Izinyathelo ezithile zokusebenza zale ndlela zimi kanje:

1. Vula ithebula le-EXCEL elizosetshenziswa kukhompyutha bese usebenzisa umsebenzi wokuhlanganisa kuseli elingenalutho=B4&C4, bese ucindezela u-Enter ukuze uqedele ukuhlela umsebenzi nokufaka ▼

1. Thayipha iseli elingenalutho=
2. Ngemva kokuchofoza iseli lokuqala ofuna ukulihlanganisa, faka&
3. Ngemva kokuchofoza iseli yesibili ofuna ukuyihlanganisa, cindezelaEnterngena
4. Gcwalisa amaseli aphansi ahlanganiswe ngokudonsela phansi

• (ngeB4KanyeC4Yiseli okufanele lihlanganiswe, elingashintshwa ngokuya ngesimo sangempela)

2. Bese ucindezela u-Ctrl+C ukuze ukopishe iseli yomphumela ehlanganisiwe▼

3. Chofoza kwesokudla kuseli engenalutho bese ukhetha "Namathisela Njengenani" kokuthi "Namathisela Okukhethekile" ▼

• Susa amaseli ngaphambi kokuhlanganisa, futhi uthole ukuthi amaseli ngaphambi kokuhlanganisa ayasuswa ngemva kokuhlanganiswa kwethebula le-EXCEL, nokusebenza kokugcina idatha ehlanganisiwe sekuqediwe.