Abasebenzisi abaningi be-Excel bahlangabezana nobunzima obukhulu lapho bezama ukubeka ideshi ekhasini lokusebenzela. Iqiniso ngukuthi uhlelo luqonda ideshi njengophawu lokususa, futhi ngokushesha luguqula amanani asesisele abe yifomula. Ngakho-ke, le nkinga iphuthumayo impela. Ake sibheke ukufaka ideshi ku-Excel.
Dash ku-Excel
Imvamisa lapho ugcwalisa imibhalo ehlukahlukene, imibiko, izimemezelo, kuyadingeka ukukhombisa ukuthi iseli elihambisana nenkomba ethile alinawo amanani. Ngalezi zinhloso, ideshi kuyinto ejwayelekile. Ohlelweni lwe-Excel, lesi sici sikhona, kepha ukusisebenzisa kumsebenzisi ongalungiselelwe kuyinkinga impela, ngoba ideshi lishintshwa ngokushesha ifomula. Ukugwema lokhu kuguqulwa, udinga ukwenza isenzo esithile.
Indlela 1: fometha ububanzi
Indlela edume kunazo zonke yokubeka udeshi kuseli ukuyinikeza ifomethi yombhalo. Kuyiqiniso, le ndlela ayisebenzi ngaso sonke isikhathi.
- Khetha iseli ofuna ukubeka kuso udeshi. Sichofoza kukho inkinobho yegundane elifanele. Kumenyu yokuqukethwe evela, khetha Uhlobo Lweseli. Esikhundleni salezi zenzo, ungacindezela isinqamuleli sekhibhodi kwikhibhodi I-Ctrl + 1.
- Ukuqalisa ukufometha kuqala. Iya kuthebhu "Inombolo"uma ivulwe kwelinye ithebhu. Ebhulokini lamapharamitha "Amafomethi ezinombolo" khetha into "Umbhalo". Chofoza inkinobho "Kulungile".
Ngemuva kwalokho, iseli elikhethiwe lizonikezwa impahla yohlobo lombhalo. Onke amanani afakwe kuwo ngeke athathwe njengezinto zokubala, kodwa njengombhalo osobala. Manje kule ndawo ungafaka uphawu "-" kusuka kukhibhodi futhi luzokhonjiswa ngokufana nedeshi, futhi ngeke lubonwe yilolo hlelo njengophawu lokususa.
Kukhona enye inketho yokuguqula iseli ekubukeni kombhalo. Ukuze wenze lokhu, kokuba kuthebhu "Ikhaya", udinga uchofoze ohlwini olwehliswayo lwefomethi yedatha, ebekwe iribhoni kubhulokhi yamathuluzi "Inombolo". Uhlu lokukhethwa kukho kokufomatha luyatholakala. Kulolu hlu udinga nje ukukhetha "Umbhalo".
Isifundo: Ungashintsha kanjani ifomethi yeseli ku-Excel
Indlela 2: Cindezela Ngena
Kepha le ndlela ayisebenzi kuzo zonke izimo. Imvamisa, ngisho nangemva kwale nqubo, uma ufaka uphawu "-", izixhumanisi ezifanayo eziya kwezinye izikhala ziyavela esikhundleni somlingiswa omfunayo. Ngaphezu kwalokho, lokhu akuhambelani kahle njalo, ikakhulukazi uma kumatafula etafula enama-dashes ehlukile ngamaseli agcwele imininingwane. Okokuqala, kuleli cala kuzodingeka ukuthi ufomethi ngalinye lazo, futhi okwesibili, amaseli akulethebula azoba nefomethi ehlukile, futhi engamukeleki ngaso sonke isikhathi. Kepha kungenziwa ngendlela ehlukile.
- Khetha iseli ofuna ukubeka kuso udeshi. Chofoza inkinobho Hlela i-Centeretholakala kubambo kuthebhu "Ikhaya" eqenjini lamathuluzi Ukuqondanisa. Futhi chofoza inkinobho "Hlela phakathi"etholakala endaweni efanayo. Lokhu kuyadingeka ukuze ideshi litholakala ngqo enkabeni yeseli, njengoba kufanele ibe njalo, hhayi ngakwesokunxele.
- Sithayipha esitokisini ngophawu lekhibhodi "-". Ngemuva kwalokho, asenzi ukunyakaza ngegundane, bese uchofoza inkinobho ngokushesha Ngenaukuya kulayini olandelayo. Uma esikhundleni salokho umsebenzisi achofoza igundane, khona-ke ifomula ivela futhi esitokisini lapho ideshi kufanele ibe khona.
Le ndlela yinhle ngokulula kwayo nokuthi iqiniso lisebenza nganoma yiluphi uhlobo lokufomatha. Kepha, ngasikhathi sinye, ukuyisebenzisa, udinga ukuqaphela ukuhlela okuqukethwe kuseli, ngoba ngesenzo esisodwa esingalungile, esikhundleni sedeshi, ifomula ingabuye iboniswe futhi.
Indlela 3: faka umlingiswa
Enye indlela yokubhala udeshi ku-Excel ukufaka umlingiswa.
- Khetha iseli lapho ufuna ukufaka udeshi. Iya kuthebhu Faka. Kubambo olubekwe ebhokisini lamathuluzi "Izimpawu" chofoza inkinobho "Symbol".
- Ukuba kuthebhu "Izimpawu", setha amasimu ewindini "Setha" ipharamitha Izimpawu zohlaka. Engxenyeni emaphakathi yewindi, funa uphawu " Bese uchofoza inkinobho Namathisela.
Ngemuva kwalokho, ideshi lizokhonjiswa kuseli elikhethiwe.
Kukhona enye inketho ohlakeni lwale ndlela. Ukuba efasiteleni "Symbol"iya kuthebhu "Izinhlamvu ezikhethekile". Kuluhlu oluvulayo, khetha Ideshi Elide. Chofoza inkinobho Namathisela. Umphumela uzofana nakuhlobo lwangaphambilini.
Le ndlela yinhle ngoba ngeke kudingeke wesabe ukunyakaza kwegundane okungalungile. Isimboli asiguquki kwifomula. Ngaphezu kwalokho, i-dash ebonakalayo ebekwe ngale ndlela ibukeka ingcono kunenhlamvu emfushane ethayishwe kwikhibhodi. Ububi obukhulu bale nketho yisidingo sokwenza izinto eziningi ngasikhathi sinye, okubandakanya ukulahleka kwesikhashana.
Indlela 4: engeza uhlamvu olwengeziwe
Ngaphezu kwalokho, kunenye indlela yokubeka udeshi. Kuliqiniso, ngokweqiniso le ndlela ngeke yamukeleke kubo bonke abasebenzisi, ngoba ithatha ubukhona esitokisini, ngaphandle kophawu langempela "-", nolunye uphawu.
- Khetha iseli ofuna ukufaka kuso ideshi, bese ubeka uphawu "'" kuyo ikhibhodi. Itholakala enkombeni efanayo nencwadi ethi "E" ekuhlelweni kweCyrillic. Ngemuva kwalokho, ngaphandle kwesikhala, setha uphawu "-".
- Chofoza inkinobho Ngena noma khetha noma isiphi esinye iseli ngesikhombisi segundane. Lapho usebenzisa le ndlela, lokhu akubalulekile ngokuyisisekelo. Njengoba ukwazi ukubona, ngemuva kwalezi zenzo kubekwe ideshi eshidini, futhi uphawu olungeziwe "" "lubonakala kuphela kulayini wezindlela lapho kukhethwa iseli.
Kunezindlela eziningi zokusetha ideshi esitokisini, ukukhetha phakathi komsebenzisi ongakwenza ngenhloso yokusebenzisa idokhumenti ethile. Iningi labantu emzamweni wokuqala ongaphumelelanga wokubeka uhlamvu olifunayo lizama ukuguqula isimo samaseli. Ngeshwa, lokhu akusebenzi ngaso sonke isikhathi. Ngenhlanhla, kukhona ezinye izinketho zalo msebenzi: iya komunye umugqa usebenzisa inkinobho Ngena, ukusetshenziswa kwezinhlamvu ngenkinobho kubambo, ukusetshenziswa kohlamvu olwengeziwe "" ". Ngayinye yalezi zindlela inezinzuzo zayo nobubi bayo, obuchazwe ngenhla. Inketho yendawo yonke efanelekile kakhulu yokufaka ideshi ku-Excel kuzo zonke izimo ezingakhona ayikho.
