Indlela yokudibanisa kunye nokucima iikholamu kwi-Excel?Cima ngokukhawuleza iiseli ezidityanisiweyo kwidatha yetafile

Ukuba ufaka inombolo kwiseli (ulandelelwano lwe-arithmetic), iya kuvela njengeisayensi, kodwa ifuna ukuba iboniswe njengenani.Emva koko, yahlula amanani kwiikholamu A kunye no-B, kwaye udibanise kwikholamu C, apho "=A1&B1Msgstr ".

Ndifuna ukugcina ikholamu C kwaye ndicime ikholamu A kunye no-B, kodwa ukuba ndicima ikholamu A okanye B ngaphandle kwesizathu, idatha yekholamu C iya kunyamalala, ndimele ndenze ntoni?

Ukudibanisa njani iikholamu ezimbini kwitafile enye kwi-Excel?

Okokuqala, makhe sijonge indlela i-EXCEL edibanisa ngayo idatha,Ungafezekisa ukudibanisa ngokudibanisa imisebenzi & ▼

Khuphela kwaye uzincamathisele njenge "values"▼

• Emva koko cima iiseli phambi kokudibanisa.

Ikhompyuter ye-EXCEL idatha yetafile ngokukhawuleza icima iiseli ezidityanisiweyo

Emva kokudibanisa kwi-EXCEL, cima iiseli ngaphambi kokudibanisa, kodwa uya kugcina idatha edibeneyo.

Amanyathelo okusebenza athile ale ndlela alandelayo:

1. Vula itheyibhile ye-EXCEL ukuba iqhutywe ekhompyutheni kwaye usebenzise umsebenzi wokudibanisa kwiseli engenanto.=B4&C4, emva koko ucinezele u-Enter ukugqiba ukuhlela umsebenzi kunye negalelo ▼

1. Chwetheza kwiseli engenanto=
2. Emva kokucofa iseli yokuqala ofuna ukuyidibanisa, ngenisa&
3. Emva kokucofa iseli yesibini ofuna ukuyidibanisa, cofaEnterngena
4. Gcwalisa iiseli ezisezantsi ezidityaniswe ngokuhla

• (kwiB4Kunye kunyeC4Ukuze iiseli zidityaniswe, zinokutshintshwa ngokweyona meko)

2. Emva koko cinezela u-Ctrl+C ukukopa iseli yesiphumo esidityanisiweyo▼

3. Cofa ekunene kwiseli engenanto kwaye ukhethe u-"Cola njengeXabiso" ku-"Cola eKhethekileyo" ▼

• Cima iiseli ngaphambi kokudibanisa, kwaye ufumanise ukuba iiseli ngaphambi kokudibanisa ziyacinywa emva kokuba itheyibhile ye-EXCEL idibaniswe, kwaye ukusebenza kokugcina idatha edibeneyo kugqityiwe.