Ungawasusa kanjani amaseli angenalutho ku-Excel. 3 Izindlela Zokukhipha Amaseli Angenalutho ku-Excel

Lapho udlulisela ithebula lisuka emthonjeni wangaphandle liye ku-Excel, izimo zivame ukuvela ngokushintshwa kwamaseli ngolwazi kanye nokwakheka kwama-voids. Uma usebenzisa amafomula, umsebenzi owengeziwe awunakwenzeka. Kulokhu, umbuzo uphakama: ungasusa kanjani ngokushesha amaseli angenalutho?

Izimo lapho kungenzeka khona ukususa amaseli angenalutho

Ngesikhathi sokusebenza, ukushintsha idatha kungase kwenzeke, okuyinto engathandeki. Ukususwa kwenziwa kuphela kwezinye izimo, isibonelo:

• Alukho ulwazi kuwo wonke umugqa noma ikholomu.
• Akukho ukuxhumana okunengqondo phakathi kwamaseli.

Indlela yakudala yokukhipha ama-voids iyisici esisodwa ngesikhathi. Le ndlela ingenzeka uma usebenza nezindawo ezidinga ukulungiswa okuncane. Ukuba khona kwenani elikhulu lamaseli angenalutho kuholela esidingweni sokusebenzisa indlela yokususa inqwaba.

Isixazululo 1: susa ngokukhetha iqembu lamaseli

Indlela elula ukusebenzisa ithuluzi elikhethekile lokukhetha amaqembu amaseli. Inqubo yokwenza:

1. Khetha indawo yenkinga lapho amaseli angenalutho enqwabelene khona, bese ucindezela inkinobho ethi F5.

2. Isikrini kufanele sivule iwindi lomyalo olandelayo. Chofoza inkinobho ethi Khetha esebenzisanayo.
3. Uhlelo luzovula elinye iwindi. Khetha "Amaseli Angenalutho". Hlola ibhokisi bese uchofoza KULUNGILE.
4. Kukhona ukukhetha okuzenzakalelayo kwezindawo ezingagcwalisiwe. Ukuchofoza kwesokudla kunoma iyiphi indawo engeyona eyolwazi kwenza kusebenze ukuvuleka kwewindi lapho udinga ukuchofoza u-“Susa”.
5. Okulandelayo, "Susa Amaseli" kuzovuleka. Faka uphawu eduze kokuthi “Amaseli aneshift up.” Siyavuma ngokucindezela inkinobho ethi "KULUNGILE".

6. Njengomphumela, uhlelo luzosusa ngokuzenzakalelayo izindawo ezidinga ukulungiswa.
7. Ukuze ususe okukhethiwe, chofoza i-LMB noma yikuphi kuthebula.

Qaphela! Indlela yokususa ene-shift ikhethwa kuphela ezimeni lapho ingekho imigqa ngemva kwendawo yokukhetha ephethe noma yiluphi ulwazi.

Isixazululo 2: Faka Ukuhlunga Nokufometha Okunemibandela

Le ndlela iyinkimbinkimbi kakhulu, ngakho-ke, ngaphambi kokuqhubeka nokuqaliswa, kunconywa ukuthi uqale uzijwayeze ngohlelo oluningiliziwe lokuqaliswa kwesenzo ngasinye.

Qaphela! Ububi obukhulu bale ndlela ukuthi isetshenziselwa ukusebenza ngekholomu eyodwa engenawo amafomula.

Cabangela incazelo elandelanayo yokuhlunga idatha:

1. Khetha indawo yekholomu eyodwa. Thola into ethi "Ukuhlela" kubha yamathuluzi. Ngokuchofoza kuyo, kuzovela iwindi elinohlu lwezilungiselelo. Iya kuthebhu "Hlunga futhi Hlunga".

2. Khetha isihlungi bese wenza i-LMB isebenze.

3. Ngenxa yalokho, iseli ephezulu iyasebenza. Isithonjana esimise okwesikwele esinomcibisholo oya phansi sizovela eceleni. Lokhu kubonisa ukuthi kungenzeka ukuvula iwindi ngemisebenzi eyengeziwe.
4. Chofoza inkinobho futhi kuthebhu evulayo, susa ukumaka ibhokisi eliseduze nendawo ethi "(Akunalutho)", chofoza okuthi "KULUNGILE".

5. Ngemva kokuguqulwa okwenziwe, amaseli agcwalisiwe kuphela azohlala kukholamu.

Iseluleko sochwepheshe! Ukukhipha i-voids usebenzisa ukuhlunga kufanelekile kuphela uma kungekho amaseli agcwalisiwe eduze, ngaphandle kwalokho, lapho wenza le ndlela, yonke idatha izolahleka.

Manje ake sibheke indlela yokwenza ukufometha okunemibandela kanye nokuhlunga:

1. Ukuze wenze lokhu, khetha indawo yenkinga futhi, ngemva kokuthola ibha yamathuluzi ethi "Izitayela", vula inkinobho ethi "Ukufometha Okunemibandela".

2. Ewindini elivulayo, thola umugqa "Okwengeziwe" bese ulandela lesi sixhumanisi.
3. Okulandelayo, efasiteleni elivela endaweni engakwesokunxele, faka inani elithi "0". Kwinkambu engakwesokudla, khetha inketho yokugcwalisa umbala oyithandayo noma shiya amanani azenzakalelayo. Sichofoza "OK". Ngenxa yalokho, wonke amaseli anolwazi azopendwe ngombala owukhethayo.
4. Uma uhlelo lususa ukukhetha okwenziwe ngaphambilini, siyakwenza futhi bese sivula ithuluzi elithi "Hlunga". Hambisa phezulu kwevelu ethi “Hlunga ngombala weseli” noma ngefonti bese wenza enye yezindawo isebenze.
5. Ngenxa yalokho, amaseli kuphela anombala onemibala, futhi ngenxa yalokho agcwele idatha, azohlala.

6. Khetha kabusha indawo enombala onemibala bese uthola inkinobho ethi "Kopisha" phezulu kubha yamathuluzi, yicindezele. Imelelwa ngamashidi amabili abekwe phezu kwelinye.
7. Ngokukhetha enye indawo kuleli shidi, senza okunye ukukhetha.
8. Chofoza kwesokudla ukuze uvule imenyu, lapho sithola khona "Amanani". Isithonjana sivezwa ngendlela yethebhulethi enombhalo wedijithali 123, chofoza.

Qaphela! Lapho ukhetha indawo, kuyadingeka ukuthi ingxenye engaphezulu ibe ngaphansi komugqa ophansi wohlu olugqanyisiwe.

9. Njengomphumela, idatha ekopishiwe idluliswa ngaphandle kokufaka isihlungi sombala.

Umsebenzi owengeziwe ngedatha ungenziwa endaweni noma ngokuyidlulisela kwenye indawo yeshidi.

Isixazululo sesi-3: sebenzisa ifomula

Ukukhipha amaseli ethebula angenalutho ngale ndlela kunobunzima obuthile ngakho-ke akudumile kangako. Ubunzima bulele ekusebenziseni ifomula, okumele igcinwe efayeleni elihlukile. Masiqhube inqubo ngokulandelana:

1. Khetha ububanzi bamaseli adinga ukulungiswa.
2. Bese sichofoza kwesokudla bese sithola umyalo othi “Yabela igama.” Nikeza igama kukholamu ekhethiwe, chofoza okuthi KULUNGILE.

4. Kunoma iyiphi indawo eshidini, khetha indawo yamahhala, ehambisana nobukhulu bendawo lapho kulungiswa khona. Chofoza kwesokudla bese ufaka igama elihlukile.

5. Ngemuva kokuthi udinga ukwenza kusebenze iseli ephezulu kakhulu yendawo yamahhala bese ufaka ifomula kuyo: =IF(UMUQWU() -UMUGQA(Ukulungisa)+1>AMA-NOTROWS(LastNames)-COUNTBLLANK(LastNames);””;INDIRECT(IKHELI(IKHELI(LIPHANSI((IF(LastNames<>“),ROW(LastNames);ROW() + IMIGWA(Izibongo)));UMGQWU()-UMGQUBO(Ukulungisa)+1);IKHOLOMU(Izibongo);4))).

Qaphela! Amagama ezindawo akhethwa ngokunganaki. Esibonelweni sethu, lezi "izibongo" kanye "nokulungiswa".

6. Lapho nje lawa mafomula efakiwe, cindezela inhlanganisela yokhiye "Ctrl + Shift + Enter". Lokhu kuyadingeka ngoba kukhona amalungu afanayo kufomula.

Yelula iseli elingaphezulu liye phansi emingceleni yendawo echazwe ngaphambilini. Ikholomu enedatha edlulisiwe kufanele iboniswe, kodwa ngaphandle kwamaseli angenalutho.

Isiphetho

Ukukhipha amaseli angenalutho kungenzeka ngezindlela ezimbalwa, ngayinye yazo ihluke ngezinga lobunkimbinkimbi, ukuze kokubili umsebenzisi wespredishithi ongenalwazi kanye noseqophelweni eliphezulu angazikhethela inketho efaneleka kakhulu.