Abasebenzisi abaninzi baphawula ukuba xa besebenza kwi-Microsoft Excel, kukho iimeko xa kusenziwa kwiseli ngexesha ledatha, i-icon ivela ngendlela yokuzonwabisa (#). Ngokwemvelo, akunakwenzeka ukusebenza ngolwazi ngale fomu. Masijongane nezizathu zengxaki echaziweyo kwaye sifumane isisombululo sayo.
Isisombululo
I-Lagece Sayina (#) okanye, indlela yokuyibiza ngendlela efanelekileyo, i-octourcep ivela kwezi seli kwiphepha elikhethekileyo, apho idatha ingahambelani kwimida. Ke ngoko, zityalwa zityalwa zizimpawu zezi mpawu, nangona ziyinyani xa kubalwa le nkqubo iza kusebenza emva kwawo onke amaxabiso, hayi ezo zibonisa kwiscreen. Ngaphandle koku, idatha yomsebenzisi ayichongwanga, kodwa, kuthetha ukuba ingxaki yokuphelisa ingxaki ifanelekile. Ewe kunjalo, unokuyibona idatha yokwenyani kwaye wenze imisebenzi kunye nabo ngentambo yefomula, kodwa kubasebenzisi abaninzi ayisiyomveliso.
Ukongeza, iinguqulelo ezindala zenkqubo ye-lattice yavela ukuba kukho oonobumba abangaphezu kwe-1024 kwifomathi ye-imeyile kwiseli kuno-1024. Kodwa, isuswe e-Excel ka-2010, esi sithintelo sisusiwe.
Masifumanise ukuba ungayisombulula njani ingxaki echaziweyo ngesibonisi.
Indlela yoku-1: Ukwandiswa kwezandla kwemida
Eyona ndlela ilula kunye neyomdla yabasebenzisi abaninzi ukuba bandise imida yeeseli, kwaye, kuthetha, kwaye basombulule ingxaki ngokuboniswa kwenani, kukutsala ngesandla imida yekholamu.
Kwenziwa lula kakhulu. Sisomeleza isikhombisi kumda phakathi kweekholamu kwiphaneli yokulungelelanisa. Silinde isikhombisi sokungaguquli itolo ibe ziindlela ezimbini. Ngeqhosha lasekhohlo le mouse kwaye, liyivale, tsala imida de ubone ukuba yonke idatha iqulethe.
Emva kokwenza le nkqubo, iseli iya kunyuka, kwaye endaweni ye-tices, amanani aya kuvela.
Indlela 2: Ukuncitshiswa kwefonti
Ewe kunjalo, ukuba kukho iikholamu okanye ezimbini kuphela okanye ezimbini, apho idatha ingahambelaniyo kwiiseli, imeko igqitywe ngendlela echazwe apha ngasentla. Kodwa mandenze ntoni ukuba zininzi iikholamu ezinjalo. Kule meko, ukusombulula ingxaki, unokusebenzisa ukwehla kwifonti.
- Sibonisa indawo esifuna ukuyinciphisa kuyo ifonti.
- Xa "kwikhaya" ithebhu kwiteyiphu yesixhobo sefonti, vula indlela yokutshintsha kwefonti. Sibeka isalathiso singaphantsi kweyona ichaziweyo okwangoku. Ukuba idatha ayiyonto yonke indawo yokuhlala kwiiseli, useta iiparameter kancinci de kufikelelwe iziphumo ozifunayo.
Indlela 3: Ububanzi
Ikho enye indlela yokutshintsha ifonti kwiiseli. Yenziwa ngokufota. Ubungakanani babalinganiswa abuyi kuba njalo kubo bonke uluhlu, kwaye ikholamu nganye iya kuba nexabiso elaneleyo lokuhlala idatha kwiseli.
- Khetha uluhlu lwedatha esiya kuvelisa mali kuyo. Cofa iqhosha lemouse lasekunene. Kwimenyu yokujonga umxholo, khetha Imo yeXabiso "".
- Ifestile yokufomatha ivuliwe. Yiya kwi "thungelwano" ithebhu. Faka intaka kufutshane "neparamitha yobubanzi. Ukukhusela utshintsho, cofa kwiqhosha "Kulungile".
Njengoko ubona, emva kwale, ifonti kwiiseli zehlile kanye ukuze idatha yabo ngokupheleleyo.
Indlela 4: Ukutshintsha kwefomathi yenani
Kwasekuqaleni, kukho incoko eya kwiinguqulelo ezindala ze-Excel kumda kwinani labalinganiswa kwiseli enye ngexesha lokufakwa kwefomathi yokubhaliweyo kusekwe. Kuba inani elikhulu labasebenzisi liyaqhubeka nokusebenza le software, siya kuyeka kwaye sisombulule ingxaki echaziweyo. Ukuthintela esi sithintelo, kuya kufuneka utshintshe ifomathi kunye nokutsho kwesicatshulwa.
- Khetha indawo ekufomefti. Cofa iqhosha lemouse lasekunene. Kwimenyu ebonakala, cofa kwinto ethi "Ifomati yeseli ...".
- Kwifestile yokufomatha, yiya kwi-"nenombolo" ithebhu. Kwindlela "ye-formats yamanani", sitshintsha "itekisi" "eqhelekileyo". Cofa kwiqhosha "Kulungile".
Ngoku isithintelo sisusiwe kwaye iselfowuni siya kuboniswa ngokuchanekileyo naliphi na inani labalinganiswa.
Ungayitshintsha ifomathi kwiteyiphu kwithebhu yasekhaya kwibhokisi yebhokisi yekhaya ngokukhetha ixabiso elihambelanayo kwiwindows ekhethekileyo.
Njengoko ubona, faka i-octourp kwiinombolo okanye enye idatha echanekileyo kwiNkqubo ye-Microsoft Excel akunzima kangako. Ukwenza oku, kuya kufuneka ukwandise iikholamu, okanye ukunciphisa ifonti. Kwiinguqulelo ezindala zenkqubo, ifomathi yesiqhelo ifanelekile.