Indlela Yokunquma Inani Lemigqa Kuthebula le-Excel - Izindlela ezi-3

Akuvamile ukuthi umsebenzisi we-Excel abhekane nokunquma ukuthi itafula liqukethe imigqa emingaki. Ukuze wenze lokhu, ungasebenzisa ezinye izindlela. Ziningi zazo, ngakho-ke ukukhetha okuqondile kuncike ngokuphelele kumgomo umsebenzisi afuna ukuwufinyelela. Namuhla sizochaza ezinye zazo. Angasetshenziselwa ama-athikili anamazinga ahlukahlukene wokuqukethwe, kanye nakwezinye izimo.

Kungani unquma inani lemigqa ku-Excel

Okokuqala, kungani unquma inani lemigqa ku-Excel nhlobo? Kungase kube nezinketho eziningi. Isibonelo, kuyadingeka ukulinganisa inani lezimpahla, ngayinye etholakala emgqeni ohlukile futhi ngesikhathi esifanayo inombolo ethile ayihambisani nenombolo yomugqa kudokhumenti ngokwayo. Noma udinga ukunquma inombolo yemigqa ehambisana nesimo esithile. Ake siqhubekele ngqo ekucutshungulweni kwezindlela zokuqonda ukuthi zingaki imigqa equkethe ithebula le-Excel.

Ukunquma inani lemigqa kuthebula le-Excel

Ngakho-ke, kunezindlela ezimbalwa eziyisisekelo zokunquma inani lemigqa:

1. Buka ulwazi oluqukethwe kubha yesimo.
2. Kusetshenziswa umsebenzi okhethekile onganquma inani lemigqa ngokwawo noma usetshenziselwe ezinye izibalo.
3. Ukusebenzisa ithuluzi lokufometha elinemibandela nezihlungi.

Lezi zindlela kufanele zicatshangelwe kabanzi.

Ukufometha Okunemibandela Nokuhlunga

Kukusiphi isimo le ndlela efaneleka ngayo? Okokuqala, uma sidinga ukunquma inani lemigqa kububanzi obuthile, obuhambisana nesibaluli esithile. Okusho ukuthi, kulesi simo, leyo migqa kuphela ewela ngaphansi kwesimo esicacisiwe somsebenzisi esizocatshangelwa. Isebenza kanjani ekusebenzeni?

1. Sikhetha ububanzi bedatha ezosetshenziselwa ukubala.
2. Ngemva kwalokho sithola kuthebhu ethi “Ekhaya” iqembu elithi “Izitayela”. Kukhona ithuluzi elibizwa nge-Conditional Formatting.
3. Ngemva kokuchofoza inkinobho efanelekile, kuzovela imenyu ye-pop-up enombhalo othi “Imithetho Yokukhetha Amaseli”.
4. Okulandelayo, kuvela iwindi elisha lapho sidinga ukukhetha into ethi "Umbhalo uqukethe". Kodwa lokhu kuqondile esibonelweni sethu, ngoba isethi yamaseli asetshenziswa esimweni sethu iqukethe amanani ombhalo kuphela. Udinga futhi ukukhetha into elungele isimo sakho. Sichaza oomakhenikha kuphela.
5. Ngemuva kwalokho, kuzovela iwindi lapho sibeka khona imithetho yokufometha. Okokuqala, sidinga ukucacisa amanani lapho amaseli azopendwe ngombala othile. Esigabeni sokunxele, isibonelo, sizobhala uhlamvu A, futhi endaweni efanele sikhetha ukufometha okusethwe ngokuzenzakalelayo. Futhi, ungashintsha lezi zilungiselelo ngendlela othanda ngayo. Isibonelo, khetha isikimu sombala esihlukile. Kudingeka sikhethe wonke amaseli aqukethe uhlamvu A futhi siwenze abebomvu. Ngemva kokufaka lezi zilungiselelo, chofoza inkinobho ethi KULUNGILE.
6. Okulandelayo, senza isheke. Uma wonke amaseli ahlangabezana nalesi simiso abenombala obomvu, lokhu kusho ukuthi senze konke ngendlela efanele.
7. Okulandelayo, sidinga ukusebenzisa ithuluzi Lokuhlunga, elizosiza ukunquma inani lemigqa ebomvu. Ukuze wenze lokhu, khetha futhi ububanzi esibudingayo. Bese uye kuthebhu ethi “Ekhaya” bese uvula isithonjana esithi “Hlunga” lapho. Ungabona ukuthi ibukeka kanjani kulesi sithombe-skrini. Sichofoza kukho.
8. Uphawu luzovela phezulu kwekholomu ekhethiwe, ebonisa isihlungi esingasebenzi. Kubukeka njengomcibisholo oya phansi. Sichofoza kukho.
9. Ngemuva kwalokho, sicinga into ethi "Hlunga ngombala" bese uchofoza umbala esiwusebenzise ngaphambili.
10. Ngemuva kokuthi isihlungi sisetshenziswe kuthebula, leyo migqa kuphela equkethe amaseli abomvu azobonakala kuyo. Ngemva kwalokho, kwanele ukukhetha kubo ukuze uqonde inombolo yokugcina. Kwenziwa kanjani? Lokhu kwenziwa ngebha yesimo. Izokhombisa inani eliphelele lemigqa obekufanele siyibale enkingeni esiyibeke ekuqaleni kwalesi sigaba.

Ukusebenzisa umsebenzi we-LINE

Lesi sici sinenzuzo eyodwa enkulu. Kwenza kube nokwenzeka hhayi kuphela ukuqonda ukuthi bangaki imigqa egcwalisiwe, kodwa futhi nokubonisa leli nani kuseli. Nokho, ungakwazi ukulawula ukuthi yimiphi imigqa ongayifaka esibalweni usebenzisa eminye imisebenzi. Kokubili lezo eziqukethe amanani nalezo ezingaqukethe idatha zizocatshangelwa.

I-syntax evamile yalo msebenzi imi kanje: = STRING(uhlu). Manje ake sicabange ukuthi singawusebenzisa kanjani lo msebenzi ekusebenzeni. Ukuze wenze lokhu, sidinga ukuvula ithuluzi elibizwa ngokuthi i-Function Wizard.

1. Khetha noma yiliphi iseli elingenawo amanani. Kunconywa ukuthi uqale uqinisekise ukuthi ayiqukethe izinhlamvu ezingaphrinteki noma amanye amafomula anikeza inani elingenalutho. Leli seli lizobonisa umphumela womsebenzi.
2. Ngemuva kwalokho, sichofoza inkinobho ethi "Faka Umsebenzi", etholakala kancane kwesokunxele sebha yefomula.
3. Manje sinebhokisi lengxoxo lapho singakhetha khona isigaba somsebenzi kanye nomsebenzi ngokwawo. Ukwenza kube lula ukusesha, sidinga ukukhetha isigaba "Uhlu olugcwele lwama-alfabhethi". Lapho sikhetha umsebenzi I-CHSTROK, setha uhlu lwedatha futhi uqinisekise izenzo zethu ngenkinobho ethi KULUNGILE.

Ngokuzenzakalelayo, yonke imigqa ibhekwa njengaleyo equkethe ulwazi kanye naleyo engaqukethe. Kodwa uma kuhlanganiswe nabanye opharetha, ungakwazi ukumisa ngokuguquguqukayo.

Ulwazi kubha yesimo

Futhi ekugcineni, indlela elula yokubona inombolo yemigqa ekhethiwe lapha futhi manje ukusebenzisa ibha yesimo. Ukuze wenze lokhu, udinga ukukhetha ububanzi obufunekayo noma amaseli ngamanye, bese ubona inani kubha yesimo (egqanyiswe ngonxande obomvu kusithombe-skrini).

Ngakho-ke, akukho lutho olunzima ekuboneni inani lemigqa.