Ukuhlunga nge-Excel - ulwazi oluyisisekelo

Ukuhlunga idatha ku-Excel kuyithuluzi eliwusizo kakhulu elikuvumela ukuthi uthuthukise umbono wolwazi, ikakhulukazi ngamavolumu amakhulu. Kulesi sifundo, sizofunda indlela yokusebenzisa ukuhlunga, ukufunda imiyalo eyisisekelo, futhi sijwayelane nezinhlobo zokuhlunga ku-Excel.

Lapho wengeza idatha ku-Excel, kubaluleke kakhulu ukuhlela kahle imininingwane eseshidini. Ithuluzi elilodwa elikuvumela ukuthi wenze lokhu ukuhlunga. Ngosizo lokuhlunga, ungakha uhlu lwemininingwane yokuxhumana nesibongo, uhlele okuqukethwe kwethebula ngokulandelana kwezinhlamvu noma ngokulandelana okwehlayo.

Hlunga Izinhlobo ku-Excel

Lapho uhlunga idatha ku-Excel, into yokuqala okudingeka uyinqume ukuthi usebenzise uhlobo kulo lonke ishidi lomsebenzi (ithebula) noma kuhlu oluthile lwamaseli kuphela.

• Ukuhlunga ishidi (ithebula) hlela yonke idatha kukholamu eyodwa. Lapho ukuhlunga kusetshenziswa eshidini, ulwazi oluhlobene kumugqa ngamunye luhlelwa ndawonye. Esibonelweni esilandelayo, ikholomu Igama longaxhumana naye (ikholomu A) ihlelwa ngama-alfabhethi.
• Ukuhlunga kobubanzi hlela idatha ebangeni lamaseli. Lokhu kuhlunga kungaba usizo lapho usebenza namashidi e-Excel aqukethe amathebula amaningana olwazi abekwe eduze kwelinye. Ukuhlunga okusetshenziswe kububanzi ayithinti enye idatha kushidi lokusebenza.

Uhlunga kanjani ishidi (ithebula, uhlu) ku-Excel

Esibonelweni esilandelayo, sizohlunga ifomu le-oda le-T-shirt ngokuthi Isibongo sami (Ikholomu C) futhi uwahlele ngokulandelana kwezinhlamvu.

1. Khetha iseli kukholamu ofuna ukuhlela ngayo. Esibonelweni sethu, sizokhetha iseli C2.
2. Chofoza Idatha ku-Ribbon, bese uchofoza umyalo Ihlunga ukusuka ku-A kuye ku-Zukuhlela ngohlelo olukhuphukayo, noma umyalo Hlunga ukusuka ku-Z kuye ku-Aukuhlela ngohlelo olwehlayo. Esibonelweni sethu, sizokhetha umyalo Ihlunga ukusuka ku-A kuye ku-Z.
3. Ithebula lizohlungwa ngekholomu ekhethiwe, okungukuthi ngesibongo.

Lapho uhlunga ithebula noma uhlu ku-Excel, kufanele lihlukaniswe nedatha engaphandle ekhasini lokusebenzela okungenani ngomugqa owodwa noma ikholomu. Uma kungenjalo, idatha yangaphandle izobandakanyeka ekuhlungeni.

Ungahlunga kanjani ububanzi ku-Excel

Esibonelweni esilandelayo, sizokhetha ithebula elincane elihlukile ekhasini lokusebenzela le-Excel ukuze sihlele inani lezikibha ezi-odwe ngezinsuku ezithile.

1. Khetha ububanzi bamaseli ofuna ukuwahlunga. Esibonelweni sethu, sizokhetha ububanzi A13:B17.
2. Chofoza Idatha ku-Ribbon, bese uchofoza umyalo Ukuhlunga.
3. Ibhokisi lengxoxo lizovuleka Ukuhlunga. Khetha ikholomu ofuna ukuhlela ngayo. Kulesi sibonelo, sifuna ukuhlunga idatha ngenani lama-oda, ngakho sizokhetha ikholomu Order.
4. Setha uhlelo lokuhlunga (ukwenyuka noma ukwehla). Esibonelweni sethu, sizokhetha Ukwenyuka.
5. Uma wonke amapharamitha elungile, chofoza OK.
6. Ububanzi buzohlungwa ngekholomu Order kusukela kwencane kuya kwenkulu. Qaphela ukuthi okunye okuqukethwe kweshidi akuhlungiwe.

Uma ukuhlunga ku-Excel kungenziwanga kahle, khona-ke okokuqala bheka ukuthi amanani afakwe ngendlela efanele yini. Ngisho ne-typo encane ingaholela ezinkingeni lapho uhlela amatafula amakhulu. Esibonelweni esilandelayo, sikhohlwe ukufaka i-hyphen kuseli A18, okuholela ohlotsheni olungalungile.