Amafomula ku-Excel awusizo kakhulu, ikakhulukazi uma udinga ukucubungula idatha ngokushesha. Amafomula akuvumela ukuthi uxazulule izinkinga eziningi. Ubudlelwano babo nedatha buthi noma nini lapho idatha ishintsha, ifomula ibonisa lolo shintsho, ibuyisele umphumela obuyekeziwe.
Kwezinye izimo, ungase ufune ukuthi ifomula ingaveli kubha yefomula lapho ukhetha iseli eliqukethe ifomula. Isibonelo, uma uthumela umsebenzi wakho kwabanye abantu. Yebo, kunenketho ekhethekile ku-Excel ekuvumela ukuthi ufihle amafomula kumaseli.
Ungawafihla kanjani amafomula ku-Excel
Ungakwazi ukufihla amafomula akhethiwe kuphela noma ufihle wonke amafomula eshidini ngesikhathi esisodwa.
- Chofoza kwesokudla kuseli ngefomula ongafuni ukuyibonisa. Uma ufuna ukufihla wonke amafomula eshidini, cindezela inhlanganisela Ctrl + A.
- Ukusuka kumenyu yokuqukethwe, khetha Fometha amaseli (Fometha Amaseli) ukuze uvule ibhokisi lengxoxo legama elifanayo.
- Iya kuthebhu Protection (Ukuvikela) bese uqoka ibhokisi eliseduze kokuthi Afihliwe (Fihla amafomula).
- Cindezela OKukuqinisekisa ukukhetha kwakho.
Indlela yokuvikela ishidi
- Chofoza Buyekeza (Buyekeza) bese uchofoza inkinobho Vikela ishidi (Vikela ishidi).
- Faka iphasiwedi ukuze uvikele ishidi.
Ngale ndlela amafomula akho azofihlwa. Ukuze uzibonise futhi uzenze zibonakale futhi, vula ithebhu Buyekeza (Buyekeza), chofoza Ishidi elingavinjelwe (Ishidi elingavikeli), bese ufaka iphasiwedi.
Ngethemba ukuthi lawa macebiso awusizo kuwe. Ngikufisela usuku oluhle!