Ireferensi yangaphandle ku-Excel iyireferensi yeseli (noma uhla lwamaseli) kwenye incwadi yokusebenzela. Emidwebeni
ngezansi ubona izincwadi ezivela eminyangweni emithathu (eNyakatho, Maphakathi naseNingizimu).
Dala isixhumanisi sangaphandle
Ukuze udale isixhumanisi sangaphandle, landela imiyalelo engezansi:
- Vula womathathu amadokhumenti.
- Encwadini ethi "Inkampani", gqamisa iseli B2 bese ufaka uphawu olulinganayo “=".
- Kuthebhu ethuthukisiwe Buka (Buka) chofoza inkinobho Shintsha iWindows (Hamba kwelinye iwindi) bese ukhetha "North".
- Encwadini ethi “North”, gqamisa iseli B2 bese ufaka u-“+”.
- Phinda izinyathelo 3 no-4 ezincwadini “Maphakathi” kanye “neNingizimu”.
- Susa izimpawu ze-“$” kufomula yeseli B2 bese ukopishela le fomula kwamanye amaseli. Umphumela:
Izaziso
Vala wonke amadokhumenti. Yenza izinguquko ezincwadini zomnyango. Vala wonke amadokhumenti futhi. Vula ifayela elithi "Inkampani".
- Ukuze ubuyekeze zonke izixhumanisi, chofoza inkinobho Nika amandla okuqukethwe (Faka nokuqukethwe).
- Ukuze uvimbele izixhumanisi ekubuyekezweni, chofoza inkinobho X.
Note: Uma ubona esinye isexwayiso, chofoza Update (Buyekeza) noma Ungabuyekezi (Ungabuyekezi).
Ukuhlela isixhumanisi
Ukuze uvule ibhokisi lengxoxo Hlela Izixhumanisi (Shintsha Izixhumanisi), kuthebhu Idatha (Idatha) esigabeni Iqembu lokuxhumana (Izixhumanisi) chofoza Hlela uphawu lwezixhumanisi (Shintsha izixhumanisi).
- Uma ungazange ubuyekeze izixhumanisi zisuka nje, ungazibuyekeza lapha. Khetha incwadi bese uchofoza inkinobho Buyekeza Amanani (Vuselela) ukuze ubuyekeze izixhumanisi zaleli bhuku. Qaphela ukuthi Isimo (Isimo) sishintshela ku- OK.
- Uma ungafuni ukubuyekeza izixhumanisi ngokuzenzakalelayo futhi ungafuni ukuthi izaziso ziboniswe, chofoza inkinobho Umlayezo Wokuqalisa (Isicelo sokubuyekeza izixhumanisi), khetha inketho yesithathu bese uchofoza OK.