Izindlela ezintathu zokuhlunga ngombala ku-Excel

01 ka-03

Ukuhlunga ngombala wesigcawu sesigcawu ku-Excel

Ukuhlunga ngombala ku-Excel

Ngaphezu kokuhlunga ngamagugu - njengombhalo noma izinombolo - I-Excel inezinketho zokuhlelwa ngokwezifiso ezivumela ukuhlunga ngombala.

Ukuhlunga ngombala kungasiza uma usebenzisa ukufometha okunemibandela , okungasetshenziswa ukushintsha umbala wangemuva noma umbala wefonti yedatha ehlangabezana nezimo ezithile.

Njengoba kuboniswe esithombeni ngenhla, ukuhlunga ngombala kungasetshenziswa ukuqoqa le datha ndawonye ukuze kuqhathaniswe nokuhlaziywa okulula.

Lolu chungechunge lwamasu luhlanganisa izindlela ezahlukene zokuhlunga idatha ku-Excel usebenzisa umbala. Ukwaziswa okuqondile ngohlobo oluhlukile ngezinketho zombala kungatholakala kumakhasi alandelayo:

1. Hlunga ngombala wesigcawu sesilwane (leli khasi elingezansi)
2. Hlunga ngombala wefonti
3. Hlunga nge-Icons Formatting Icons

Ukukhetha idatha okumele ihlungwe

Ngaphambi kokuba idatha ihlelwe, i-Excel idinga ukwazi ukuthi yikuphi uhla oluzohlungwa, futhi ngokuvamile, i-Excel inhle kakhulu ekukhetheni izindawo ezihlobeneyo - uma nje ingenisiwe,

1. akukho imigqa noma amakholomu angagcini asele ngaphakathi kwendawo ehlobene;
2. futhi imigqa namakholomu angenalutho ashiywe phakathi kwezindawo zedatha ehlobene.

I-Excel izokwazi ngisho nokunquma, ngokunembile, uma indawo yedatha inamagama ensimu futhi ingabandakanyi lo mgca kusuka kumarekhodi azohlungwa.

Ukuvumela i-Excel ukukhetha ububanzi obuzohlungwa kuhle ngemali encane yedatha engabheka ngokubukeka ukuqinisekisa ukuthi:

• ukuthi ibanga elifanele likhethiwe;
• ukuthi azikho izikhala phakathi kobubanzi;
• ukuthi ngemuva kohlobo, amarekhodi wedatha aqinisiwe futhi alungile.

Kwizindawo ezinkulu zedatha, indlela elula yokuqinisekisa ukuthi ibanga elifanele likhethiwe ukuligqamisa ngaphambi kokuqala uhlobo.

Uma ibanga elifanayo lizohlungwa ngokuphindaphindiwe, indlela engcono kakhulu ukuyibeka igama .

Uma igama lichazwa ububanzi obuzohlungwa, thayipha igama ebhokisini legama , noma ukhethe ohlwini oluhlehlisiwe oluhambisana no-Excel luzogqamisa ngokuzenzakalelayo uhla olufanele lwemininingwane ekhasini lokusebenzela.

Ukuhlunga ngeMbala noHlelo lwe-Sort

Ukuhlunga kudinga ukusetshenziswa komyalelo ohlelekile .

Uma uhlunga ngamanani, kunezinhlobo ezimbili zokuhlelwa kohlobo - okwenyuka noma wehla. Uma uhlunga ngemibala, noma kunjalo, akukho myalelo onjalo okhona ngakho-ke umsebenzisi ochaza umbala wokuhlelwa kombala ebhokisini lebhodi lebhodi .

Hlunga ngomfanekiso wesigcawu seselula

Esikhathini esingenhla, ububanzi beseli H2 kuya ku-L12 ukufometha okunemibandela kwasetshenziselwa ukushintsha umbala wangemuva wesitoreji wamarekhodi asekelwe eminyakeni yabafundi.

Esikhundleni sokushintsha umbala weseli wabo bonke amarekhodi abafundi, kuphela labo abaneminyaka engama-20 ubudala noma abancane abathintekayo ukufometha okunemibandela nabanye abasalokhu bengathinteki.

Lezi amarekhodi zahlelwa umbala weseli ukuze ziqoqe amarekhodi ezithakazelo phezulu kobubanzi ukuze kuqhathaniswe nokuhlaziywa kalula.

Izinyathelo ezilandelayo zalandelwa ukuhlunga idatha ngombala wangemuva weseli.

1. Qinisekisa ububanzi bamaseli okuhlungwa - H2 kuya ku-L12
2. Chofoza kuthebhu yaseKhaya ye- ribbon
3. Chofoza ku- Hlunga & Isihlungi isithonjana ku-ribbon ukuvula uhlu lokudonsa phansi
4. Chofoza ku- Custom Sort ohlwini lwamaconsi phansi ukuze ukhiphe ibhokisi le-dialog box
5. Ngaphansi koHlelo Olubhekisele ebhokisini lebhokisi, khetha Umbala Wamabala kusuka kuhlu lokudonsa phansi
6. Uma i-Excel ithola imibala engemuva yangaphandle yeselula kwimininingwane ekhethiwe yanezela leyo mibala kukho okukhethwa kukho ngaphansi kwe- oda ebeka ebhokisini lengxoxo
7. Ngaphansi kokuqondisa kwe-oda, khetha umbala obomvu kusuka kuhlu lokudonsa phansi
8. Uma kunesidingo, wakhetha Okuphezulu Phezu kwe-oda lohlobo ukuze idatha ebomvu ibe ngaphezulu kwehlu
9. Chofoza OK ukuze uhlele idatha bese uvala ibhokisi lengxoxo
10. Amarekhodi amane anombala wesibomvu obomvu kufanele ahlanganiswe ndawonye phezulu kwebanga ledatha

02 ka-03

Hlunga Idatha Ngemibala Yefonti ku-Excel

Hlunga ngombala wefonti

Okufana kakhulu nokuhlunga ngombala weselula, ukuhlunga ngombala wefonti kungasetshenziswa ukuhlela ngokushesha idatha ngombhalo ohlukile.

Izinguquko kumbala wefonti zingenziwa ngokusebenzisa ukufometha okunemibandela noma ngenxa yokufometha kwenombolo - njengokungathi ubonisa izinombolo ezimbi ngokubomvu ukuze zenze lula ukuthola.

Hlunga nge-Font Color Example

Esikhathini esingenhla, ububanzi beseli H2 kuya ku-L12 ukufometha okunemibandela kwasetshenziselwa ukuguqula umbala wefonti wamarekhodi omfundi asekelwe ohlelweni lwabo lokutadisha:

• Iphoyisa elibomvu - abafundi ababhalise ohlelweni lokuhlengikaza
• I-blue font - abafundi ababhalisile ohlelweni lwesayensi

Lezi amarekhodi zahlelwa ngombala wefonti ukuze ziqoqe amarekhodi ezithakazelo phezulu kobubanzi ukuze kuqhathaniswe nokuhlaziywa kalula.

Ukuhlelwa kohlobo lombala wefonti kwakubomvu okulandelwa ubuluhlaza. Amarekhodi anombala wefonti omnyama azenzakalelayo awahlehlwanga.

Izinyathelo ezilandelayo zalandelwa ukuhlunga idatha ngombala wefonti.

1. Qinisekisa ububanzi bamaseli okuhlungwa - H2 kuya ku-L12
2. Chofoza kuthebhu yaseKhaya ye- ribbon .
3. Chofoza ku- Hlunga & Isihlungi isithonjana ku-ribbon ukuvula uhlu lokudonsa phansi.
4. Chofoza ku- Custom Sort ohlwini lwamaconsi phansi ukuze ukhiphe ibhokisi le-dialog box
5. Ngaphansi koHlelo oluqondayo ebhokisini lebhokisi, khetha Umbala Wefonti ohlwini lokudonsa phansi
6. Uma i-Excel ithola imibala yefonti ehlukile kwimininingwane ekhethiwe ineza leyo mibala kukho okukhethwa kukho ngaphansi kwe- oda eqondisa ebhokisini lengxoxo
7. Ngaphansi kokuqondisa kwe-oda, khetha umbala obomvu kusuka kuhlu lokudonsa phansi
8. Uma kunesidingo, wakhetha Okuphezulu Phezu kwe-oda lohlobo ukuze idatha ebomvu ibe ngaphezulu kwehlu
9. Phezulu kwebhokisi lebhokisi, chofoza inkinobho yokufaka i- Add Level ukwengeza izinga lohlobo lwesibili
10. Ngezinga lesibili, ngaphansi kwesihloko se-oda, khetha umbala ohlaza okwesibhakabhaka kusuka kuhlu lokudonsa phansi
11. Khetha Okuphezulu Ngaphansi kwe-oda lohlobo ukuze idatha eluhlaza okwesibhakabhaka ibe ngaphezu kwala marekhodi ngefonti emnyama ezenzakalelayo
12. Chofoza OK ukuze uhlele idatha bese uvala ibhokisi lengxoxo
13. Amarekhodi amabili anombala obomvu kufanele afakwe ndawonye phezulu kohlu lwamafayela alandelwe amarekhodi amabili amnyama aqoshiwe

03 ka 03

Hlunga Idatha ngezifanekiso zokufometha okunemibandela ku-Excel

Hlunga nge-Icons Formatting Icons

Enye indlela yokuhlunga ngombala ukusebenzisa imifanekiso yokufometha enemibandela yokuhleleka kokuhlelwa .

Lezi zithonjana zesithonjana zinikeza okunye okukhethwa kukho kokufometha okunemibandela evamile okugxila ekuguqulweni kwefonti kanye nokufometha kwamaseli.

Njengokuhlunga ngombala weseli, uma uhlunga ngombala wesithombe umsebenzisi usetha ukuhleleka kokuhlelwa ebhokisini lebhokisi lezinhlobo.

Hlunga nge-Icon Umbala Isibonelo

Esikhathini esingenhla, ububanzi bamaseli abukethe idatha yokushisa eParis, eFrance lifomatiwe ngokomzimba ngesithonjana se- stop light esekelwe ukushisa okuphezulu kwansuku zonke ngoJulayi 2014.

Lezi zithombe ziye zasetshenziselwa ukuhlunga idatha namarekhodi abonisa izithombe eziluhlaza ezihlanganisiwe kuqala ezilandelwa izithombe ze-amber, bese zibomvu.

Izinyathelo ezilandelayo zalandelwa ukuhlunga idatha ngombala wesithonjana.

1. Qinisekisa ububanzi bamaseli okufanele ahlungwe - I3 kuya ku-J27
2. Chofoza kuthebhu yaseKhaya ye- ribbon .
3. Chofoza ku- Hlunga & Isihlungi isithonjana ku-ribbon ukuvula uhlu lokudonsa phansi.
4. Chofoza ku- Custom Sort ohlwini lwamaconsi phansi ukuze ukhiphe ibhokisi le-dialog box
5. Ngaphansi koHlelo oluqondayo ebhokisini lebhokisi, khetha i- Cell Icon ohlwini lokudonsa phansi
6. Uma i-Excel ithola izithonjana zamaseli kwimininingwane ekhethiwe ifaka lezo zithombe kukho okukhethwa kukho ngaphansi koHlelo oluya ebhokisini lengxoxo
7. Ngaphansi kwesihloko se-oda, khetha isithonjana esiluhlaza ohlwini lokudonsa phansi
8. Uma kunesidingo, ukhethe Okuphezulu Phezu komyalelo wokuhlela ukuze idatha enezithombe eziluhlaza ibe phezulu ohlwini
9. Phezulu kwebhokisi lebhokisi, chofoza inkinobho yokufaka i- Add Level ukwengeza izinga lohlobo lwesibili
10. Ngezinga lesibili, ngaphansi kwesihloko se-oda, khetha isithonjana se-amber noma sephuzi kusuka ohlwini lokudonsa
11. Futhi, wakhetha Okuphezulu Phezu kwe-oda lohlobo uma kunesidingo - lokhu kuzobeka iqembu lesibili lamarekhodi ngaphansi kwalabo abanezimpawu eziluhlaza, kodwa ngaphezu kwazo zonke ezinye amarekhodi ahlelwa
12. Njengoba kukhona izinketho ezintathu kuphela zezithonjana kule setha, asikho isidingo sokwengeza izinga lesithathu ukuhlunga amarekhodi ngezimpawu ezibomvu, ngoba yiwona amarekhodi kuphela asele futhi azobe esezansi ebangeni
13. Chofoza OK ukuze uhlele idatha bese uvala ibhokisi lengxoxo
14. Amarekhodi anesithombe esibomvu kufanele ahlangane ndawonye phezulu kwebanga ledatha elilandelwa amarekhodi ngesithonjana se-amber, bese kuthi labo abanesithonjana esibomvu