Lapho usebenza e-Excel nedatha ende kakhulu esekwe nenamba enkulu yemigqa, akunakuphikiswa ngokwanele ukukhuphuka kusihloko sonke isikhathi ukubona amanani wezinhlaka ezisesitokisini. Kepha, ku-Excel, kungenzeka ukulungisa umugqa ophezulu. Ngaso leso sikhathi, akukhathalekile ukuthi ulinganisa kanjani ibanga ledatha phansi, umugqa ophezulu uhlala uhlala kusikrini. Ake sibheke ukuphina umugqa ophezulu ku-Microsoft Excel.
Phezulu Umugqa Ophezulu
Noma kunjalo, sizocubungula ukuthi singalungisa kanjani ulayini lwamanani wedatha sisebenzisa isibonelo seMicrosoft Excel 2010, kepha i-algorithm echazwe yithi ilungele ukwenza lesi senzo kwezinye izinguqulo zesimanje zalolu hlelo lokusebenza.
Ukuze ulungise umugqa ophezulu, iya kuthebhu ethi "Buka". Kubambo kubha yamathuluzi wewindi, chofoza inkinobho ethi "Izindawo zokukhiya". Ukusuka kumenyu evela, khetha isikhundla se- "Lock top row".
Ngemuva kwalokho, noma ngabe uthatha isinqumo sokwehlela ezansi impela ebangeni ledatha ngenombolo enkulu yemigqa, umugqa ophezulu oqukethe igama ledatha uyohlala uphambi kwamehlo akho.
Kodwa, uma unhlokweni uqukethe umugqa ongaphezu kweyodwa, khona-ke, kuleli cala, indlela engenhla yokulungisa umugqa ophezulu ngeke isebenze. Kuzofanele wenze umsebenzi ngokusebenzisa inkinobho ethi “Izindawo zokukhiya”, ebikade ishiwo ngenhla, kepha ngasikhathi sinye, ngokukhetha hhayi into ethi “Lock top line”, kodwa isikhundla esithi “Izindawo zokukhiya”, ngemuva kokukhetha iseli elingakwesokunxele ngaphansi kwendawo yokubopha.
Okungenani umugqa ophezulu
Ukuvula i-line ephezulu futhi kulula. Futhi, chofoza inkinobho "Izindawo zokukhiya", futhi kusuka kuhlu oluvelayo, khetha indawo ethi "Unpin libakeng."
Ukulandela lokhu, umugqa ophezulu uzodilizwa, futhi idatha ye-tabular izothatha ifomu elijwayelekile.
Ukudonsa noma ukuvula i-line ephezulu ku-Microsoft Excel kulula kakhulu. Kunzima kakhulu ukulungisa unhlokweni ohlanganisa imigqa eminingana kuhla lwedatha, kepha futhi akunzima ikakhulukazi.
