Abasebenzisi abaningi baqaphele ukuthi lapho besebenza kuMicrosoft Excel, kunezimo lapho kumaseli ngesikhathi sesethi yedatha esikhundleni sezinombolo, izithonjana zivela ngendlela yokugcwaliswa (#). Ngokwemvelo, akunakwenzeka ukusebenza ngolwazi kuleli fomu. Masibhekane nezizathu zenkinga ebekiwe futhi sithole isixazululo saso.
Isixazululo
I-Lattice Sign (#) noma, ukuthi ungayibiza kanjani kahle, i-Octotorp ivela kulawo maseli ekhasini elikhethekile, lapho imininingwane ingangeni emingceleni. Ngakho-ke, zitholwa ngokubonakalayo yilezi zimpawu, yize empeleni ngesikhathi sokubala uhlelo zizosebenza ngemuva kwawo wonke amanani afanayo, hhayi lokho okuboniswa esikrinini. Ngaphandle kwalokhu, idatha yomsebenzisi ayikhonjwanga, kodwa, kusho ukuthi inkinga yokuqeda inkinga iyasebenza. Vele, ungabona idatha yangempela futhi ufeze ukusebenza nabo ngentambo yefomula, kepha kubasebenzisi abaningi akuwona umphumela.
Ngaphezu kwalokho, izinguqulo ezindala zoHlelo lweLatice zivele uma kunezinhlamvu ezingaphezu kuka-1024 kwifomethi yombhalo weseli esitokisini kune-1024. Kepha, kusukela ku-Excel 2010, lokhu kuvinjelwa.
Ake sibheke ukuthi ungayixazulula kanjani inkinga ecacisiwe ngesibonisi.
Indlela 1: Ukunwetshwa kwesandla kwemingcele
Indlela elula futhi enembile yabasebenzisi abaningi ukwandisa imingcele yamaseli, futhi, kusho futhi, futhi uxazulule inkinga ngokuboniswa kwe-lattice esikhundleni sezinombolo, ngesandla ukudonsela imingcele yekholomu.
Kwenziwa elula kakhulu. Sisungula isikhombisi emngceleni phakathi kwamakholomu kwiphaneli yokuxhumanisa. Silinde isikhombisi ukuthi singaphenduli umcibisholo ube yimibhalo emibili. Ngenkinobho yegundane kwesobunxele futhi, uyivala, donsa imingcele uze ubone ukuthi yonke imininingwane iqukethe.
Ngemuva kokwenza le nqubo, iseli lizokhuphuka, futhi esikhundleni sama-lattices, izibalo zizovela.
Indlela 2: Ukuncishiswa kwefonti
Vele, uma kunesinye kuphela amakholomu noma amabili, lapho imininingwane ingangeni khona kumaseli, isimo sihlelwe nje yindlela echazwe ngenhla. Kepha okufanele ukwenze uma kunamakholomu amaningi anjalo. Kulokhu, ukuxazulula inkinga, ungasebenzisa ukwehla kwefonti.
- Sigqamisa le ndawo lapho sifuna ukunciphisa khona ifonti.
- Ngenkathi usethebhu "Yasekhaya" ethepheni ku-Font Tool Block, vula uhlobo loshintsho lwefonti. Sibeka inkomba engaphansi kwaleyo echazwe njengamanje. Uma idatha ingahlali wonke amaseli, ubeka amapharamitha ngisho nangaphansi kwaze kwafinyelelwa umphumela ofiselekayo.
Indlela 3: Ububanzi
Kunenye indlela yokushintsha ifonti kumaseli. Kwenziwa ngokufometha. Ubukhulu babalingiswa ngeke bufane nalo lonke uhla, futhi ikholomu ngayinye izoba nenani elanele lokuthola idatha esitokisini.
- Khetha uhla lwedatha lapho sizokhiqiza khona ukusebenza. Chofoza inkinobho yegundane kwesokudla. Kumenyu yokuqukethwe, khetha Inani "Ifomethi Yeseli ...".
- Iwindi lokufometha livula. Iya kuthebhu ethi "Alignment". Faka inyoni eduze nepharamitha "Yound". Ukuvikela izinguquko, chofoza inkinobho ethi "Kulungile".
Njengoba ubona, ngemuva kwalokhu, ifonti kumaseli sehle kakhulu ukuze idatha ikube ikutholele ngokuphelele.
Indlela 4: Ukushintshwa kwefomethi yezinombolo
Ekuqaleni, bekukhona ingxoxo engnguqulweni yakudala yokudlula umkhawulo ngenani lezinhlamvu esitokisini esisodwa ngesikhathi sokufakwa kwefomethi yombhalo kwasungulwa. Njengoba inani elikhulu labasebenzisi liyaqhubeka nokusebenzisa le software, sizoma futhi sixazulule inkinga ecacisiwe. Ukusola lokhu kuvimbela lokhu, kuzodingeka ushintshe ifomethi ngokubhala ngombhalo.
- Khetha indawo efomethiwe. Chofoza inkinobho yegundane kwesokudla. Kumenyu evelayo, chofoza entweni ethi "Ifomethi Yeseli ...".
- Ewindini lokufomatha, iya kuthebhu ethi "Numbe,". Ku- "Numeric forms" ipharamitha, sishintsha inani "elithile" liye "okuvamile". Chofoza inkinobho ethi "KULUNGILE".
Manje umkhawulo uyasuswa futhi esitokisini kuzokhonjiswa kahle noma iyiphi inombolo yezinhlamvu.
Ungashintsha futhi ifomethi ethepheni kuthebhu yasekhaya ku-Tool "Number" ngokukhetha inani elihambisanayo ewindini elikhethekile.
Njengoba ukwazi ukubona, buyisela i-Octotorp ngezinombolo noma eminye imininingwane efanelekile ku-Microsoft Excel Program ayinzima kangako. Ukuze wenze lokhu, udinga ukwandisa amakholomu, noma wehlise ifonti. Okwezinhlobo ezindala zohlelo, ifomethi yombhalo efanelekile.