Abasebenzisi abaningi baye baqaphela ukuthi uma usebenza ku-Microsoft Excel kunamacala lapho amangqamuzana ekuthayipha idatha esikhundleni sezinombolo, imifanekiso ivela ngendlela yamagridi (#). Ngokuvamile, akunakwenzeka ukusebenza ngolwazi kuleli fomu. Ake siqonde izimbangela zalesi nkinga bese sithole isisombululo saso.
Ukuxazulula izinkinga
Uphawu lwe-Lattice (#) noma, njengoba kulungile nakakhulu ukuyibiza, i-oktotorp ivela kulawo maseli ekhondweni le-Excel, lapho idatha engahambisani nemingcele. Ngakho-ke, zibuyiselwa ngokuzenzekelayo lezi zimpawu, nakuba empeleni, ngesikhathi sokubala, uhlelo lusebenza namanani wangempela, hhayi ngelokho olubonisa esibukweni. Naphezu kwalokhu, kumsebenzisi idatha ayibonakali, ngakho-ke, inkinga yokuqeda inkinga iyadingeka. Yiqiniso, idatha yangempela ingabhekwa futhi yenziwe nabo kubha yefomula, kodwa kubasebenzisi abaningi lokhu akuyona inketho.
Ngaphezu kwalokho, izinguqulo ezindala zohlelo lwe-lattice zivele uma, uma usebenzisa ifomethi yombhalo, izinhlamvu ezisesitokisini zazingaphezu kuka-1024. Kodwa, kusukela ngenguqulo ye-Excel 2010, lo mkhawulo ususiwe.
Ake sibone indlela yokuxazulula le nkinga yemephu.
Indlela 1: Ukwandiswa Kwamagama
Indlela elula futhi enembile kakhulu kubasebenzisi abaningi ukukhulisa imingcele yeseli, futhi ngenxa yalokho, ukuxazulula inkinga yokubonisa ama-gridi kunezinombolo, ukudweba ngesandla imingcele yekholomu.
Lokhu kwenziwa ngokumane kakhulu. Beka isikhombisi emngceleni phakathi kwamakholomu kuphaneli yokuxhumanisa. Silinde kuze kube isikhombisi siphenduke umcibisholo oqondisayo. Sichofoza inkinobho yegundane lesokunxele futhi, sikubambe, donsela imingcele uze ubone ukuthi yonke idatha ifanelekile.
Ngemva kokuqedela le nqubo, iseli lizokhula, futhi izibalo zizovela esikhundleni sezinhlamvu.
Indlela 2: Ukunciphisa amagama
Yiqiniso, uma kunamakholomu owodwa noma amabili lapho idatha ingahambisani namaseli, kulula kakhulu ukulungisa isimo ngendlela echazwe ngenhla. Kodwa yini okufanele uyenze uma kukhona amakholomu amaningi kangaka. Kulokhu, ungasebenzisa ukunciphisa kwefonti ukuxazulula inkinga.
- Khetha indawo esifuna ukunciphisa ifonti.
- Ukuba ngaphakathi kuthebhu "Ikhaya" kwi-tape ebhodini lamathuluzi "Ifonti" vula ifomu lokushintsha ifonti. Sabeka isibonakaliso sibe ngaphansi kwaleyo ekhonjisiwe njengamanje. Uma le data ingangeneli kumaseli, bese usetha imingcele ngisho nangaphansi kuze kube nomphumela oyifunayo.
Indlela 3: Ububanzi be-Auto
Kukhona enye indlela yokushintsha ifonti kumaseli. Kufezwa ngokufometha. Ngesikhathi esifanayo, ubukhulu bezinhlamvu ngeke kube okufanayo kulo lonke uhla, futhi kukholomu ngayinye kuyoba ne-eigenvalue eyanele ukuvumelanisa idatha kuseli.
- Khetha ububanzi bwedatha lapho sizokwenza khona ukusebenza. Chofoza inkinobho yesokudla yegundane. Kumenyu yomongo, khetha inani "Fometha amaseli ...".
- Iwindi yokufometha ivula. Iya kuthebhu "Ukuqondanisa". Beka inyoni eduze kwepharamitha "Ububanzi Bokuzenzakalela". Ukulungisa izinguquko, chofoza inkinobho. "Kulungile".
Njengoba ungabona, emva kwalokhu, ifonti emasethini yehlile ngokwanele ukuze idatha ivumelane ngokuphelele.
Indlela 4: shintsha ifomethi yenombolo
Ekuqaleni, kwakukhona ingxoxo ekusetshenzisweni kokudala kwe-Excel umkhawulo obekwe kwinani labalingiswa esitokisini esisodwa uma ufaka ifomethi yombhalo. Njengoba inani elikhulu labasebenzisi liqhubeka nokusebenzisa le software, ake sihlale esixazululweni sale nkinga. Ukuze uhambisane nalokhu kunciphisa, kuzodingeka ushintshe ifomethi kusuka kumbhalo kuya jikelele.
- Khetha indawo efomethiwe. Chofoza inkinobho yesokudla yegundane. Emenyu ebonakalayo, chofoza ku-intwana "Fometha amaseli ...".
- Ewindini lokufometha iya kuthebhu "Inombolo". Kupharamitha "Amafomu Amanani" ukushintsha inani "Umbhalo" kuqhubeke "Jikelele". Sicindezela inkinobho "Kulungile".
Manje umkhawulo ususiwe futhi noma iyiphi inombolo yabalingiswa izoboniswa ngokufanele esitokisini.
Ungashintsha futhi ifomethi kwi-Ribbon kuthebhu "Ikhaya" ebhodini lamathuluzi "Inombolo"ngokukhetha inani elifanele efasiteleni elikhethekile.
Njengoba ungabona, ukufaka i-oktotorp ngezinombolo noma enye idatha efanelekile ku-Microsoft Excel akuyona inzima kakhulu. Ukuze wenze lokhu, kumele ukhulise amakholomu noma unciphise ifonti. Kuzo izinguqulo ezindala zalolu hlelo, ukushintsha ifomethi yombhalo kuya ovamile kuyadingeka.
