Ungasebenzisa ithuluzi Thola futhi ubeke esikhundleni (Thola bese Ufaka esikhundleni) ku-Excel ukuze uthole ngokushesha umbhalo owufunayo bese ufaka omunye umbhalo esikhundleni sawo. Futhi ungasebenzisa umyalo Iya kokukhethekile (Khetha Iqembu Lamaseli) ukuze ukhethe ngokushesha wonke amaseli anamafomula, amazwana, ukufometha okunemibandela, okungaguquki, nokuningi.
Ukuthola
Ukuze uthole ngokushesha umbhalo othile, landela imiyalelo yethu:
- Kuthebhu ethuthukisiwe Ikhaya (Ekhaya) chofoza Thola & Khetha (Thola bese ugqamisa) bese ukhetha Thola (Thola).
Ibhokisi lengxoxo lizovela Thola futhi ubeke esikhundleni (Thola bese ufaka esikhundleni).
- Faka umbhalo ofuna ukuwucinga, isibonelo “Ferrari”.
- Chofoza inkinobho Thola Okulandelayo (Thola ngezansi).
I-Excel izogqamisa ukwenzeka kokuqala.
- Chofoza inkinobho Thola Okulandelayo (Thola okulandelayo) futhi ukuze ugqamise ukwenzeka kwesibili.
- Ukuze uthole uhlu lwazo zonke izenzakalo, chofoza Thola Konke (Thola konke).
I-Substitute
Ukuze uthole ngokushesha umbhalo othile bese uwushintshanisa nomunye umbhalo, landela lezi zinyathelo:
- Kuthebhu ethuthukisiwe Ikhaya (Ekhaya) chofoza Thola & Khetha (Thola bese ugqamisa) bese ukhetha Faka esikhundleni (Faka esikhundleni).
Ibhokisi lengxoxo legama elifanayo lizovela nethebhu esebenzayo Faka esikhundleni (Faka esikhundleni).
- Faka umbhalo ofuna ukuwucinga (isibonelo, “Veneno”) kanye nombhalo ofuna ukuwushintshanisa (ngokwesibonelo, “Diablo”).
- Chofoza Thola Okulandelayo (Thola ngezansi).
I-Excel izogqamisa ukwenzeka kokuqala. Akukho okushintshiwe okwamanje.
- Chofoza inkinobho Faka esikhundleni (Faka esikhundleni) ukuze wenze omunye esikhundleni.
Qaphela: Sebenzisa Buyisela konke (Faka esikhundleni Konke) ukuze umiselele zonke izehlakalo.
Ukukhetha iqembu lamaseli
Ungasebenzisa ithuluzi Iya kokukhethekile (Ukukhethwa Kweqembu Leseli) ukuze ukhethe ngokushesha wonke amaseli anamafomula, amazwana, ukufometha okunemibandela, okungaguquki, nokuningi. Isibonelo, ukukhetha wonke amaseli anamafomula, yenza okulandelayo:
- Khetha iseli eyodwa.
- Kuthebhu ethuthukisiwe Ikhaya (Ekhaya) chofoza Thola & Khetha (Thola bese ugqamisa) bese ukhetha Iya kokukhethekile (Ukukhetha iqembu lamaseli).
Qaphela: Amafomula, amazwana, ukufometha okunemibandela, ama-constants, nokuqinisekiswa kwedatha konke kungatholakala ngomyalo Iya kokukhethekile (Ukukhetha iqembu lamaseli).
- Hlola ibhokisi eliseduze amafomula (Amafomula) bese uchofoza OK.
Qaphela: Ungasesha amaseli anamafomula abuyisela izinombolo, umbhalo, ama-opharetha anengqondo (TRUE kanye ne-FALSE), kanye namaphutha. Futhi, lezi zinketho zizotholakala uma ukhetha ibhokisi Izikhathi (Izikhathi zonke).
I-Excel izogqamisa wonke amaseli ngamafomula:
Qaphela: Uma ukhetha iseli eyodwa ngaphambi kokuchofoza Thola (Thola), Faka esikhundleni (Faka esikhundleni) noma Iya kokukhethekile (Khetha iqembu lamaseli), i-Excel izobuka lonke ishidi. Ukuze useshe phakathi kwebanga lamaseli, qala ngokukhetha ububanzi obufunayo.