I-Excel inikeza amathuluzi amaningi okulawula ukubukeka kwencwadi yokusebenzela. Esifundweni sokugcina, sesifunde kakade ukuthi imiswa kanjani imigqa namakholomu. Kulokhu, sizocubungula amathuluzi amaningana akuvumela ukuthi uhlukanise ishidi libe izingxenye eziningana, futhi ubuke idokhumenti kumafasitela ahlukene.
Uma incwadi yokusebenzela ye-Excel iqukethe inani elikhulu ledatha, kungase kube nzima ukwenza imephu yezigaba ezahlukene. I-Excel iqukethe izinketho ezengeziwe ezenza kube lula ukuqonda nokuqhathanisa idatha. Isibonelo, ungavula incwadi efasiteleni elisha noma uhlukanise ishidi ezindaweni ezihlukene.
Ivula ibhuku lamanje efasiteleni elisha
I-Excel ikuvumela ukuthi uvule incwadi yokusebenzela efanayo kumawindi amaningi ngesikhathi esisodwa. Esibonelweni sethu, sizosebenzisa lesi sici ukuze siqhathanise amaphepha okusebenzela amabili ahlukene encwadini yokusebenzela efanayo.
- Chofoza Buka ku-Ribbon, bese ukhetha umyalo Iwindi elisha.
- Iwindi elisha lizovulelwa ibhuku lamanje.
- Manje usungakwazi ukuqhathanisa amashidi encwadi efanayo kumafasitela ahlukene. Esibonelweni sethu, sizokhetha umbiko wokuthengisa wango-2013 ukuze uqhathanise ukuthengisa ngo-2012 no-2013.
Uma unamawindi amaningana avuliwe, ungasebenzisa umyalo Hlela Konke ngokuqoqa ngokushesha amawindi.
Ukuhlukanisa ishidi ezindaweni ezihlukene
I-Excel ikuvumela ukuthi uqhathanise izigaba zeshidi lokusebenza elifanayo ngaphandle kokudala amawindi angeziwe. Ithimba Ukuhlukanisa ikuvumela ukuthi uhlukanise ishidi ezindaweni ezihlukene ezingaskrolwa ngokuzimela.
- Khetha iseli lapho ofuna ukuhlukanisa khona ishidi. Uma ukhetha iseli kukholamu yokuqala noma umugqa wokuqala, ishidi lizohlukaniswa libe izingxenye ezi-2, kungenjalo lizohlukaniswa libe ngu-4. Esibonelweni sethu, sizokhetha iseli C7.
- Chofoza Buka ku-Ribbon, bese uchofoza umyalo Ukuhlukanisa.
- Ishidi lizohlukaniswa ezindaweni eziningana. Ungakwazi ukupheqa endaweni ngayinye ngokuhlukana usebenzisa amabha okuskrola. Lokhu kuzokuvumela ukuthi uqhathanise izigaba ezihlukene zeshidi elifanayo.
Ungakwazi ukuhudula izihlukanisi eziqondile nezivundlile ukuze ushintshe usayizi wesigaba ngasinye. Ukuze ususe ukuhlukanisa, cindezela umyalo futhi Ukuhlukanisa.