Abasebenzisi abaningi baqaphele ukuthi lapho kusebenza iMicrosoft Excel, kuba nezimo lapho esikhundleni senombolo kumaseli lapho ufaka idatha, kuvela izithonjana ezisesimweni sama-trellises (#) Ngokwemvelo, akunakwenzeka ukusebenza ngolwazi olukuleli fomu. Ake sibheke izimbangela zale nkinga futhi sithole isisombululo sayo.
Ukuxazululwa kwezinkinga
Isibonakaliso sikaphawundi (#) noma, njengoba ibizwa ngokufanelekile, i-octotorp ivela kulawo maseli kwiphepha le-Excel lapho idatha ingangeni khona emingceleni. Ngakho-ke, zifakwa esikhundleni sokubonakaliswa yilezi zimpawu, noma empeleni, ezibalweni, uhlelo lusebenza ngamanani wangempela, hhayi nalawo olukhombisa esibukweni. Ngaphandle kwalokhu, kumsebenzisi, idatha ihlala ingaziwa, okusho ukuthi udaba lokuxazulula inkinga lufanele. Vele, ungabuka futhi uqhube idatha yangempela ngokusebenzisa umugqa wamafomula, kepha kubasebenzisi abaningi lokhu akuyona inketho.
Ngaphezu kwalokho, kuzinguqulo ezindala zohlelo, ukunqobeka kwavela uma ngabe kunezinhlamvu ezingaphezu kuka-1024 esitokisini ngenkathi kusetshenziswa ifomethi yombhalo weseli. Kepha, kusukela enguqulweni ye-Excel 2010, lo mkhawulo wasuswa.
Ake sibheke ukuthi singayixazulula kanjani inkinga ekhonjisiwe.
Indlela 1: ngesandla wandise imingcele
Indlela elula futhi enembile kunazo zonke yabasebenzisi abaningi yokwandisa imingcele yamaseli, futhi, ngakho-ke, ukuxazulula inkinga yokubonisa ama-grids esikhundleni sezinombolo, ukudonsa ngemingcele yekholamu.
Lokhu kwenziwa kalula. Sibeka isikhombisi emngceleni phakathi kwamakholamu kuphaneli yokuhlanganisa. Silinda kuze kufike ikhesa libe umcibisholo wezindlela ezimbili. Sichofoza inkinobho yegundane kwesobunxele futhi, siyibambe, Hudula imingcele uze ubone ukuthi yonke imininingwane ifanelana.
Ngemuva kokuphothula le nqubo, iseli lizokwenyuka, futhi esikhundleni semigoqo, kuzovezwa izinombolo.
Indlela 2: ukuncishiswa kwefonti
Vele, uma kunekholomu eyodwa noma ezimbili kuphela lapho idatha ingangeni khona emangqamuzaneni, isimo silula ukusilungisa ngendlela echazwe ngenhla. Kepha okufanele ukwenze uma ziningi ikholomu enjalo. Kulokhu, ungasebenzisa ukuncishiswa kwefonti ukuxazulula inkinga.
- Khetha indawo lapho sifuna ukunciphisa ifonti khona.
- Ukuba kuthebhu "Ikhaya" ethepheni elisebhokisini lamathuluzi Ifonti vula ifomu lokushintsha ifonti. Sibeka inkomba ngaphansi kunaleyo ekhonjiswayo njengamanje. Uma idatha ingahambelani kumaseli, khona-ke sibeka amapharamitha amancane ngisho kuze kutholakale umphumela oyifunayo.
Indlela 3: Ububanzi Bokuzenzakalelayo
Kukhona enye indlela yokushintsha ifonti emangqamuzaneni. Kwenziwa ngokufometha. Kulesi simo, ubukhulu bezinhlamvu ngeke bufane kulo lonke uhla, futhi kukholomu ngayinye kuzoba nenani layo elanele ukuqukethe imininingwane esesitokisini.
- Sikhetha ibanga ledatha esizohlinzwa kulo. Qhafaza kwesokudla. Kumenyu yokuqukethwe, khetha inani "Ifomethi yeseli ...".
- Iwindi lokufometha liyavula. Iya kuthebhu Ukuqondanisa. Setha inyoni eduze kwepharamitha "Ububanzi be-Auto Fit". Ukulungisa izinguquko, chofoza inkinobho "Kulungile".
Njengoba ukwazi ukubona, emva kwalokho ifonti emangqamuzaneni inciphile ngokwanele ukulingana nedatha ekuyo ngokuphelele.
Indlela 4: shintsha ifomethi yenombolo
Ekuqaleni, bekunengxoxo yokuthi ezinhlotsheni ezindala ze-Excel beku kunomkhawulo enombolweni yezinhlamvu esitokisini esisodwa lapho kusethwa ifomethi yombhalo. Njengoba inani elikhulu kakhulu labasebenzisi liqhubeka nokusebenzisa le software, masihlale kwikhambi lale nkinga. Ukuthola lo mkhawulo, kuzodingeka ukuthi ushintshe ifomethi ukusuka kumbhalo iye kokujwayelekile.
- Khetha indawo efomethwe. Qhafaza kwesokudla. Kumenyu evelayo, chofoza entweni "Ifomethi yeseli ...".
- Ewindini lokufometha, iya kuthebhu "Inombolo". Ipharamitha "Amafomethi ezinombolo" shintsha inani "Umbhalo" kuvuliwe "Okujwayelekile". Chofoza inkinobho "Kulungile".
Manje umkhawulo ususiwe futhi noma iyiphi inombolo yezinhlamvu izokhonjiswa kahle esitokisini.
Ungaguqula futhi ifomethi ebreyini ethebhu "Ikhaya" ebhokisini lamathuluzi "Inombolo"ngokukhetha inani elifanele efasiteleni elikhethekile.
Njengoba ukwazi ukubona, ukufaka i-octotorp ngezinombolo noma enye idatha efanelekile kwi-Microsoft Excel akunzima kangako. Ukuze wenze lokhu, kungaba ukwandisa amakholomu noma ukunciphisa ifonti. Kumahumusho amadala wohlelo, ukuguqula ifomethi yombhalo ibe yinto evamile kufanelekile.
