Amathebula anezintambo ezingenalutho azijabulisi kahle. Ngaphezu kwalokho, ngenxa yemigqa eyengeziwe, ukuhamba ngezinyawo kungase kube nzima nakakhulu, ngoba kufanele uphelele emkhakheni omkhulu wamaseli okuya kusukela ekuqaleni kwetafula kuze kube sekupheleni. Ake sithole ukuthi yiziphi izindlela zokususa imigqa engenalutho ku-Microsoft Excel, nokuthi ungasusa kanjani ngokushesha futhi kulula.
Ukususwa okujwayelekile
Indlela edume kakhulu futhi ethandwayo yokususa imigqa engenalutho ukusebenzisa imenyu yesimo se-Excel. Ukuze ususe imigqa ngale ndlela, khetha uhla lwamaseli angenayo idatha, futhi uchofoze ngakwesokudla. Emenyu yemenyu evulwe, siya kwento ethi "Susa ...". Awukwazi ukubiza imenyu yokuqukethwe, kodwa thayipha isinqamuleli sekhibhodi "Ctrl + -".
Iwindi elincane livela lapho okudingeka ukuthi ucacise ukuthi yini esiyifuna ukususa. Sabeka inkinobho endaweni "string". Chofoza inkinobho ethi "Kulungile".
Emva kwalokho, yonke imigqa yebanga elikhethiwe izosuswa.
Ngaphandle kwalokho, ungakhetha amaseli emigqeni ehambelanayo, kanti ngenkathi kuthebhu yaseKhaya, chofoza inkinobho ye-Delete, etholakala emabhokisini e-Cell ebhebheni. Emva kwalokho, izosuswa masinyane ngaphandle kwamabhokisi ebhokisi eyengeziwe.
Yiqiniso, le ndlela ilula futhi yaziwa kakhulu. Kodwa, ingabe iyona elula kunazo zonke, esheshayo futhi evikelekile?
Hlunga
Uma imigqa engenalutho isendaweni efanayo, ukususa kuzoba lula. Kodwa, uma zihlakazekile kulo lonke itafula, ukusesha nokususwa kwabo kungathatha isikhathi esiningi. Kulesi simo, ukuhlunga kufanele kusize.
Khetha yonke indawo yokubeka ithebula. Chofoza kuso nge inkinobho yesokudla yegundane, futhi kwimenyu yokuqukethwe khetha into ethi "Hlunga". Emva kwalokho, enye imenyu ibonakala. Kulo, udinga ukhethe okukodwa kwezinto ezilandelayo: "Hlunga kusuka ku-A kuya ku-Z", "Kusuka kumancane kuya kokuphezulu", noma "Kusukela okusha kuya endala." Yikuphi kwezinto ezibalulwe kuzoba kwimenyu kuxhomeke kuhlobo lwedatha olubekwa emafetheni etafuleni.
Ngemuva kokusebenza okungenhla kwenziwa, wonke amaseli angenalutho azohambela phansi kwetafula. Manje, singasusa lawa maseli nganoma iyiphi indlela exoxwa ngayo engxenyeni yokuqala yesifundo.
Uma umyalelo wokubeka amangqamuzana etafuleni kubalulekile, ke ngaphambi kokuba senze ukuhlunga, sifaka enye ikholomu phakathi kwetafula.
Wonke amaseli akuleli kholomu abalwa ngokulandelana.
Khona-ke, sihlunga nganoma iyiphi enye ikholomu, futhi susa amaseli ahamba phansi, njengoba kakade kuchaziwe ngenhla.
Ngemuva kwalokho, ukuze ubuyekeze umyalelo wemigqa kulowo owawuvele usuvele ukhetha ukuhlela, sihlela kukholomu ngezinamba zomugqa "Kusuka kokungenani kuya phezulu".
Njengoba ungabona, imigqa ihlanganiswe ku-oda efanayo, ngaphandle kwamandla angenalutho asusiwe. Manje, sidinga nje ukususa ikholomu eyengeziwe ngezinombolo zokulandelana. Khetha le kholomu. Bese uchofoza inkinobho ku-"Susa" itekisi. Emenyu evulekayo, khetha into "Susa amakholomu kushidi." Emva kwalokho, ikholomu oyifunayo izosuswa.
Isifundo: Ukuhlela ku-Microsoft Excel
Isebenzisa isihlungi
Enye indlela yokufihla amaseli angenalutho ukusebenzisa isihlungi.
Khetha yonke indawo yetafula, futhi, esitholakala kuthebhu ethi "Ikhaya", chofoza inkinobho ethi "Hlela nokuhlunga", esitholakala ebhokisini lokuhlela "Ukuhlela". Emenyu ebonakalayo, yenza ushintsho entweni ethi "Hlunga".
Isithonjana esihlukile sitholakala kumaseli wezinhloko zetafula. Chofoza kulesi sithonjana kunoma iyiphi ikholomu ozikhethelayo.
Emenyu evelayo, chaqa ibhokisi elithi "Lutho". Chofoza inkinobho ethi "Kulungile".
Njengoba ungabona, emva kwalokhu, yonke imigqa engenalutho yanyamalala, njengoba ihlungiwe.
Isifundo: Indlela yokusebenzisa isihlungi se-Microsoft ku-Excel
Ukukhethwa kweselula
Enye indlela yokususa isebenzisa ukukhethwa kweqembu lamaseli angenalutho. Ukuze usebenzise le ndlela, khetha kuqala ithebula lonke. Khona-ke, ekubeni kuthebhu "Ekhaya", chofoza inkinobho ethi "Thola futhi uqokomise", etholakala ku-ribbon eqenjini le-"Hlela". Emenyu ebonakalayo, chofoza into ethi "Khetha iqembu lamaseli ...".
Iwindi livula lapho sishukumisela khona ukushintshela "esikhundleni sezingqamuzana" ezingenalutho. Chofoza inkinobho ethi "Kulungile".
Njengoba ungabona, emva kwalokhu, yonke imigqa equkethe amaseli angenalutho ibonakala. Manje chofoza inkinobho ethi "Susa" esivamile kakade kithi, etholakala ku-ribbon eqoqweni lamathuluzi "Amaseli".
Ngemva kwalokho, yonke imigqa engenalutho iyosuswa etafuleni.
Inothi elibalulekile! Indlela yokugcina ayikwazi ukusetshenziselwa amathebula ngamabanga aqoqa, futhi ngamaseli angenalutho asezinhlaleni lapho kutholakala khona idatha. Kulokhu, amangqamuzana angashintsha, futhi itafula lizophuka.
Njengoba ungabona, kunezindlela eziningana zokususa amaseli angenalutho etafuleni. Iyiphi indlela engcono ukuyisebenzisa incike ekubuneni kwetafula, nokuthi imigqa engasenalutho ihlakazekile kanjani nxazonke (ihlelwe ku-block eyodwa, noma ixubene nemigqa egcwala idatha).
