Amazwana eseli ku-Excel

Ukusebenza ku-Microsoft Excel, isimo sivame ukuvela lapho udinga ukushiya amazwana kuseli. Isibonelo, nikeza incazelo yefomula eyinkimbinkimbi noma umlayezo onemininingwane kwabanye abafundi bomsebenzi wakho. Vumelana, akulula ngaso sonke isikhathi ukulungisa iseli ngokwalo ngalezi zinhloso noma ukubeka amazwana esitokisini esingumakhelwane. Ngenhlanhla, i-Excel inethuluzi elakhelwe ngaphakathi elikuvumela ukuthi udale amanothi. Yilokho lesi sifundo esiphathelene nakho.

Ezimweni eziningi, kulula kakhulu ukwengeza amazwana kuseli njengenothi, kunokuhlela elikuqukethe. Leli thuluzi liwusizo kakhulu futhi livame ukusetshenziswa ngokuhambisana nokulandela ushintsho ngaphandle kokulivula ukuze wengeze amanothi.

Ungayakha kanjani inothi ku-Excel

1. Khetha iseli ofuna ukwengeza kuyo amazwana. Esibonelweni sethu, sikhethe iseli E6.
2. Kuthebhu ethuthukisiwe Iyabukeza cindezela umyalo Dala inothi.
3. Kuzovela inkambu yokufaka amanothi. Thayipha umbhalo wakho wamazwana, bese uchofoza noma yikuphi ngaphandle kwenkundla ukuze uwuvale.
4. Inothi lizokwengezwa kuseli futhi limakwe ngenkomba ebomvu ekhoneni eliphezulu kwesokudla.
5. Ukuze ubone inothi, hambisa phezulu kweseli.

Ungashintsha kanjani inothi ku-Excel

1. Khetha iseli eliqukethe amazwana ofuna ukuwahlela.
2. Kuthebhu ethuthukisiwe Iyabukeza khetha iqembu Hlela Inothi.
3. Kuzovela inkambu yokufaka amazwana. Hlela amazwana bese uchofoza noma yikuphi ngaphandle kwebhokisi ukuze uwavale.

Ungabonisa noma ufihle kanjani inothi ku-Excel

1. Ukuze ubone wonke amanothi encwadini, khetha Bonisa wonke amanothi ithebhu Iyabukeza.
2. Wonke amanothi asencwadini yakho ye-Excel azovela esibukweni.
3. Ukuze ufihle wonke amanothi, chofoza lo myalo futhi.

Ngaphezu kwalokho, ungabonisa noma ufihle inothi ngalinye ngokukhetha iseli edingekayo bese ucindezela umyalo Bonisa noma fihla inothi.

Isusa amazwana ku-Excel

1. Khetha iseli eliqukethe amazwana ofuna ukuwasusa. Esibonelweni sethu, sikhethe iseli E6.
2. Kuthebhu ethuthukisiwe Iyabukeza eqenjini amanothi khetha iqembu Susa.
3. Inothi lizosuswa.