Lapho usebenza nama-spredishithi e-Excel, kwesinye isikhathi udinga ukufihla izindawo ezithile zekhasi lokusebenza. Ngokuvamile lokhu kwenziwa uma, ngokwesibonelo, equkethe amafomula. Ake sibheke ukuthi ungawafihla kanjani amakholomu kulolu hlelo.
Fihla ama-Algorithms
Kunezindlela eziningi zokukhetha ukwenza le nqubo. Ake sibheke ukuthi uyini umongo wabo.
Indlela yoku-1: ukuguquka kweseli
Inketho enembile kunazo zonke ongathola ngayo umphumela oyifunayo ukushintshwa kweseli. Ukuze senze le nqubo, sigoqa phezu kwephaneli eqondile evundlile endaweni lapho umngcele ukhona. Umcibisholo obonakalayo uvela kuzo zombili izinkomba. Qhafaza kwesobunxele bese uhudula imingcele yekholamu eyodwa emingceleni yolunye, kuze kufike lokhu.
Ngemuva kwalokho, into eyodwa empeleni izofihlwa ngemuva kwenye.
Indlela 2: sebenzisa imenyu yokuqukethwe
Kuyinto elula kakhulu ukusebenzisa imenyu yokuqukethwe ngalezi zinhloso. Okokuqala, kulula kunokudlula kwemingcele, futhi okwesibili, ngale ndlela, kungenzeka ukufezekisa ukucasha okuphelele kwamaseli, ngokungafani nohlobo lwangaphambilini.
- Sichofoza ngakwesokudla kuphaneli yokuqondisa evundlile endaweni yaleyo ncwadi yesiLatin, ekhombisa ukuthi ikholomu ifihlekile.
- Kumenyu yokuqukethwe evela, chofoza inkinobho Fihla.
Ngemuva kwalokho, ikholomu ebekiwe izofihlwa ngokuphelele. Ukuqinisekisa lokhu, bhekisisa ukuthi amakholomu ahlelwe kanjani. Njengoba ukwazi ukubona, uhlamvu olulodwa lushoda ngokulandelana.
Izinzuzo zale ndlela ngaphezulu kweyedlule zilele eqinisweni lokuthi ngayo ungafihla amakholomu ambalwa alandelanayo ngasikhathi sinye. Ukuze wenze lokhu, khetha kubo, futhi kumenyu ebizwa ngokuthi imenyu, chofoza entweni Fihla. Uma ufuna ukwenza le nqubo ngezakhi ezingekho eduze komunye nomunye, kepha zihlakazeke ngaphesheya kweshidi, khona-ke ukukhetha kufanele kwenziwe ngenkinobho ecindezelwe Ctrl kwikhibhodi.
Indlela 3: sebenzisa amathuluzi wetheyiphu
Ngaphezu kwalokho, ungayenza le nqubo usebenzisa enye yezinkinobho ezisekelweni ebhulokhi lamathuluzi "Amaseli".
- Khetha amaseli akhona kukholamu ofuna ukuwafihla. Ukuba kuthebhu "Ikhaya" chofoza inkinobho "Ifomathi", ebekwe etheyiphu kwibhulokhi yamathuluzi "Amaseli". Kumenyu ebonakala eqenjini lezilungiselelo "Ukubonakala" chofoza entweni Fihla noma ubonise. Olunye uhlu luyasebenza, lapho udinga ukukhetha into Fihla Amakholamu.
- Ngemuva kwalezi zinyathelo, amakholomu azofihlwa.
Njengasesimweni esedlule, ngale ndlela ungafihla izinto eziningana ngasikhathi sinye, uziqokomise, njengoba kuchazwe ngenhla.
Isifundo: Ungawakhombisa kanjani amakholomu afihliwe ku-Excel
Njengoba ukwazi ukubona, kunezindlela eziningi zokufihla amakholomu ku-Excel. Indlela enembile kunazo zonke ukuguqula amaseli. Kepha, kunconyelwa ukuthi noma kunjalo usebenzise enye yezinketho ezimbili ezilandelayo (imenyu yokuqukethwe noma inkinobho kubambo), ngoba ziqinisekisa ukuthi amaseli azofihlwa ngokuphelele. Ngaphezu kwalokho, izinto ezifihliwe ngale ndlela zizoba lula ukubonisa emuva uma kunesidingo.
