Uma usebenzisa ama-spreadsheets e-Excel, ngezinye izikhathi udinga ukufihla izindawo ezithile zeshidi. Ngokuvamile lokhu kwenziwa uma, isibonelo, amafomula atholakala kuwo. Ake sithole indlela yokufihla amakholomu kulolu hlelo.
I-algorithms ukufihla
Kunezinketho eziningi zokwenza le nqubo. Ake sizitholele ukuthi isiphi isimo sabo.
Indlela 1: I-Cell Shift
Inketho enembile kunazo zonke ongayifinyelela kulo mphumela oyifunayo ukushintsha kwamaseli. Ukuze senze le nqubo, sithumela isikhombisi kuphaneli enezingqimba zezixhumanisi endaweni lapho umngcele ukhona khona. Umcibisholo wesici okhomba kuzo zombili izinkomba uvela. Sichofoza inkinobho yesinxele yesinxele bese uhudula imingcele yekholomu eyodwa kuya emingceleni yenye, kuze kube yilapho ingenziwa.
Emva kwalokho, into eyodwa izobe ifihliwe empeleni ngemuva komunye.
Indlela 2: sebenzisa imenyu yesimo
Kuyinto elula kakhulu kulezi zinhloso ukusebenzisa imenyu yokuqukethwe. Okokuqala, kulula kakhulu kunokuthutha imingcele, futhi okwesibili, ngakho-ke, kungenzeka ukufeza ukufihla okuphelele kwamaseli, ngokungafani nenguqulo yangaphambilini.
- Chofoza inkinobho yesokudla yegundane kuphaneli yokuxhumanisa enezingqimba endaweni yeLatini incwadi ebonisa ikholomu ukuthi ifihlwe.
- Emenyu yomongo ebonakalayo, chofoza inkinobho "Fihla".
Emva kwalokho, ikholomu ecacisiwe izofihlwa ngokuphelele. Ukuze uqinisekise lokhu, bheka ukuthi amakholomu abhalwe kanjani. Njengoba ungabona, enye incwadi ayitholakali ku-oda olulandelanayo.
Izinzuzo zale ndlela ngaphezu kwalowo owedlule ukuthi zingasetshenziswa ukufihla amakholomu ambalwa alandelayo ngesikhathi esifanayo. Ukwenza lokhu, kuzodingeka ukhethwe, futhi kwimenyu yokuqukethwe okuzenzekelayo, chofoza entweni "Fihla". Uma ufuna ukwenza le nqubo ngezingxenye ezingezansi komunye nomunye, kodwa zihlakazekile ezungeze ishidi, khona-ke ukukhetha kufanele kwenziwe ngebhokisi eligcinwe phansi Ctrl kwikhibhodi.
Indlela 3: sebenzisa amathuluzi ku-tape
Ngaphezu kwalokho, ungenza le nqubo usebenzisa enye yezinkinobho zebhande ebhokisini lamathuluzi. "Amaseli".
- Khetha amaseli asezindaweni ezizofihlwa. Ukuba ngaphakathi kuthebhu "Ikhaya" chofoza inkinobho "Fometha"okuyinto efakwe kwi-tape ebhodini lamathuluzi "Amaseli". Emenyu evela eqenjini lezilungiselelo "Ukubonakala" chofoza entweni "Fihla noma Bonisa". Olunye uhlu luvuliwe lapho okudingeka ukhethe khona into "Fihla amakholomu".
- Ngemva kwalezi zenzo, amakholomu azofihlwa.
Njengokwesikhashana esidlule, ngale ndlela ungafihla izakhi eziningana ngesikhathi esisodwa, ukhethe njengoba kuchaziwe ngenhla.
Isifundo: Indlela yokubonisa amakholomu afihliwe ku-Excel
Njengoba ubona, kunezindlela eziningana zokufihla amakholomu ku-Excel. Indlela enembile kakhulu ukushintsha amangqamuzana. Kodwa, kunconywa ukuthi usebenzise okunye kokubili okukhethwa kukho (imenyu yesimo noma inkinobho ebhethini), njengoba ziqinisekisa ukuthi amaseli azofihlwa ngokuphelele. Ngaphezu kwalokho, izakhi ezifihliwe ngale ndlela zizoba lula ukubuyisa uma kudingeka.
