Amathebula aqukethe izintambo ezingenalutho abukeki aesthetically aesthetically. Ngaphezu kwalokho, ngenxa yemigqa eyengeziwe, ukuzulazula kuyo kungaba yinkimbinkimbi kakhulu, ngoba kuzodingeka ukuthi udlulele ebangeni elikhudlwana lamaseli ukusuka ekuqaleni kwetafula kuze kube sekupheleni. Ake sibheke ukuthi yiziphi izindlela zokususa imigqa engenalutho ku-Microsoft Excel, nokuthi ungabasusa kanjani ngokushesha futhi kube lula.
Ukususwa okujwayelekile
Indlela eyaziwa kakhulu neyaziwayo yokususa imigqa engenalutho ukusebenzisa imenyu ye-Excel kumenyu yokuqukethwe. Ukususa imigqa ngale ndlela, khetha ibanga lamaseli angenayo idatha, bese uchofoza ngakwesokudla. Kumenyu yokuqukethwe evulayo, iya entweni ethi "Delete ...". Awukwazi ukubiza imenyu yokuqukethwe, kepha uthayiphe isinqamuleli sekhibhodi "Ctrl + -".
Kuvele iwindi elincane lapho udinga ukucacisa khona ukuthi yini ngempela esifuna ukuyicisha. Sibeka switch in the "isikhundla" isikhundla. Chofoza inkinobho ethi "Kulungile".
Ngemuva kwalokho, yonke imigqa yobubanzi ekhethiwe izosuswa.
Enye indlela, ungakhetha amaseli emigqeni ehambisanayo, futhi kuthebhu ethi "Ikhaya", chofoza inkinobho ethi "Delete", ebekwe kubha yamathuluzi "Amaseli" kubambo. Ngemuva kwalokho, ukususwa kuzokwenzeka ngokushesha ngaphandle kwamabhokisi engxoxo angezekile.
Vele, indlela ilula kakhulu futhi yaziwa kahle. Kepha ingabe yiyona elula kunazo zonke, esheshayo futhi ephephe kunazo zonke?
Ukuhlunga
Uma imigqa engenalutho itholakala endaweni eyodwa, khona-ke ukususwa kwabo kuzoba lula impela. Kepha, uma behlakazeke etafuleni, ukusesha nokususa kwabo kungathatha isikhathi esikhulu. Kulokhu, ukuhlunga kufanele kusize.
Khetha yonke indawo ethebula. Sichofoza kukho inkinobho yegundane elifanele, bese ukhetha into ethi "Hlunga" kumenyu yokuqukethwe. Ngemuva kwalokho, kuvela enye imenyu. Kuyo udinga ukukhetha eyodwa yalezi zinto ezilandelayo: "Hlunga ukusuka ku-A uye ku-Z", "Ukusuka ubuncane kuya phezulu", noma "Ukusuka kokusha kuya kokudala." Yikuphi kwezinto ezifakwe kuhlu ezizoba kumenyu kuya ngohlobo lwedatha ebekwe kumaseli etafula.
Ngemuva kokuthi kusetshenzwe ngenhla, wonke amaseli angenalutho azohanjiswa ezansi etafuleni. Manje, singasusa la maseli nganoma yiziphi izindlela okwaxoxwa ngazo engxenyeni yokuqala yesifundo.
Uma i-oda lokufaka amaseli etafuleni libucayi, ngaphambi kokuhlela, faka enye ikholamu phakathi kwetafula.
Onke amaseli ale kholamu abalwa ngokulandelana.
Ngemuva kwalokho, hlunga nganoma iyiphi enye ikholomu, bese ususa amangqamuzana ahanjiselwe phansi, njengoba sekuchaziwe ngenhla.
Ngemuva kwalokho, ukuze sibuyisele i-oda lomugqa kulokho ebelivele likhona ngaphambi kokuhlunga, sihlela ikholomu ngezinombolo zemigqa “Ukusukela ubuncane kuya phezulu”.
Njengoba ukwazi ukubona, imigqa ihlanganiswe ngokulandelana okufanayo, ngaphandle kokungenalutho okususiwe. Manje, kufanele nje sisuse ikholomu engeziwe ngezinombolo ezi-serial. Khetha le kholamu. Bese uqhafaza inkinobho ekhasini le-ribbon "Delete". Kumenyu evulayo, khetha "Susa amakholomu kweshidi" entweni. Ngemuva kwalokho, ikholomu oyifunayo izosuswa.
Isifundo: Ukuhlunga kuMicrosoft Excel
Uhlelo lokuhlunga
Enye indlela yokufihla amaseli angenalutho ukusebenzisa isihlungi.
Khetha yonke indawo yetafula, futhi, esethebhu ethi "Ikhaya", chofoza inkinobho ethi "Hlunga nesihlungi", ebekwe endaweni yokulungisa "Hlela". Kumenyu evelayo, iya entweni ethi "Hlunga".
Isithonjana esivelayo siyavela kumaseli unhlokweni wethebula. Chofoza kulesi sithonjana kunoma iyiphi ikholomu oyithandayo.
Kumenyu evelayo, ungahloli into "engenalutho". Chofoza inkinobho ethi "Kulungile".
Njengoba ubona, emva kwalokho, yonke imigqa engenalutho yanyamalala, ngoba yayihlungiwe.
Isifundo: Ungayisebenzisa kanjani i-autofilter ku-Microsoft Excel
Isikhethi Seseli
Enye indlela yokususa isebenzisa ukukhetha kweqembu lamaseli angenalutho. Ukuze usebenzise le ndlela, qala ukhethe itafula lonke. Ngemuva kwalokho, ekubeni kuthebhu ethi "Ikhaya", chofoza inkinobho ethi "Thola bese ukhetha", ebekwe iribhoni eqenjini le-"Editing" ithuluzi. Kumenyu evelayo, chofoza entweni "Khetha iqembu lamaseli ...".
Kuvulwa iwindi lapho sishintsha khona switch siye esikhaleni "seseli ezingenalutho". Chofoza inkinobho ethi "Kulungile".
Njengoba ukwazi ukubona, ngemuva kwalokho, yonke imigqa equkethe amaseli angenalutho iyaqokonyiswa. Manje chofoza inkinobho ethi "Delete", esivele siyijwayele, etholakala kwi-ribbon eqenjini le-"Amaseli" ithuluzi.
Ngemuva kwalokho, yonke imigqa engenalutho izosuswa etafuleni.
Isaziso esibalulekile! Izindlela zokugcina azikwazi ukusetshenziswa kumatafula anebanga eligqagqene, nangamaseli angenalutho akumugqa lapho idatha itholakala khona. Kulokhu, ukuguquguquka kweseli kungenzeka futhi kwetafula kuqhume.
Njengoba ukwazi ukubona, kunezindlela ezimbalwa zokukhipha amaseli angenalutho etafuleni. Iyiphi indlela engcono ukuyisebenzisa incike ekuthini yinkimbinkimbi yetafula, nokuthi imigqa engenalutho ihlakazeka kanjani nxazonke zayo (etholakala ebhulokini elilodwa, noma ixutshwe imigqa egcwele idatha).
