Njengomthetho, ngenxa yobuningi babasebenzisi, ukwengeza amaseli uma usebenza ku-Excel akumele umsebenze obunzima. Kodwa, ngeshwa, akuwona wonke umuntu owazi zonke izindlela zokuzenza. Kodwa kwezinye izimo, ukusebenzisa indlela ethile kungasiza ukunciphisa isikhathi esichithwa enkambisweni. Ake sithole ukuthi yiziphi izinketho zokwengeza amaseli amasha ku-Excel.
Bheka futhi: Ungeza kanjani umugqa omusha kuthebula le-Excel
Indlela yokufaka ikholomu ku-Excel
Inqubo yokwengeza kweselula
Ngokushesha qaphela indlela inqubo yokwengeza amaseli eyenziwe ngayo isuka ohlangothini lobuchwepheshe. Ngokuvamile, lokho esikubiza ngokuthi "ukwengezwa" kuyisinyathelo sokuhamba. Okokuthi, amangqamuzana amane ahambe phansi futhi angakwesokudla. Izindinganiso ezisemkhawulweni weshidi ziyosuswa lapho amangqamuzana amasha angeziwe. Ngakho-ke, kuyadingeka ukuba ulandele inqubo ecacisiwe lapho ishidi ligcwele idatha ngamaphesenti angu-50%. Nakuba, kunikezwe ukuthi ezinguqulweni zanamuhla ze-Excel, kunemigqa eyizigidi ezingu-1 namakholomu eshidi, ngokusemandleni isidingo esinjalo siza kakhulu.
Ngaphezu kwalokho, uma ungeze kahle ama-cell, hhayi imigqa namakholomu aphelele, khona-ke udinga ukucabangela ukuthi etafuleni lapho wenza khona ukusebenza okucacisiwe, idatha izoshintshwa, futhi amanani angeke afane nalawo migqa noma amakholomu afana nawo ngaphambili.
Ngakho-ke, manje siphendukela ezindleleni ezithile zokufaka izakhi kushidi.
Indlela 1: Imenyu yokuqukethwe
Enye yezindlela ezivame kakhulu ukwengeza amaseli ku-Excel ukusebenzisa imenyu yokuqukethwe.
- Khetha into yeshidi lapho sifuna ukufaka khona iseli elisha. Sichofoza kuso ngenkinobho yegundane kwesokudla. Iqala imenyu yokuqukethwe. Khetha isikhundla kuso "Namathisela ...".
- Emva kwalokho, ifasitela elincane lokufaka livula. Njengoba sinesithakazelo sokufaka amaseli, hhayi imigqa noma amakholomu, izinto "Umzila" futhi "Ikholomu" siyazinaki. Yenza ukhetho phakathi kwamaphoyinti "Amaseli, ane-shift kuya kwesokudla" futhi "Amaseli, ngokushintsha", ngokuhambisana nezinhlelo zabo zenhlangano yetafula. Emva kokukhethwa kukwenziwa, chofoza inkinobho. "Kulungile".
- Uma umsebenzisi ekhetha inketho "Amaseli, ane-shift kuya kwesokudla", khona-ke izinguquko zithatha mayelana nefomu njengetafuleni elingezansi.
Uma ukhetho lukhethiwe futhi "Amaseli, ngokushintsha", itafula lizoshintsha kanje.
Ngokufanayo, ungakwazi ukwengeza wonke amaqembu amangqamuzana, kuphela lokhu okudingeka ukhethe inani elifanele lezakhi ngeshidi ngalinye ngaphambi kokuya emenyu yemongo.
Ngemva kwalokho, izakhi zizofakwa nge-algorithm efanayo esiyichazile ngenhla, kodwa kuphela iqembu lonke.
Indlela 2: Inkinobho ku-tape
Ungakwazi futhi ukwengeza izakhi kwi-Excel sheet ngokusebenzisa inkinobho ebhanini. Ake sibone ukuthi singayenza kanjani.
- Khetha isici endaweni yeshidi lapho sihlela khona ukwengeza iseli. Hambisa kuthebhu "Ikhaya"uma okwamanje ungenye. Bese uchofoza inkinobho. Namathisela ebhodini lamathuluzi "Amaseli" kwi-tape.
- Ngemuva kwalokho, le nto izongezwa eshidi. Futhi, kunoma yikuphi, izofakwa nge-offset phansi. Ngakho-ke le ndlela isengcono kakhulu kuneyaphambilini.
Ukusebenzisa indlela efanayo, ungakwazi ukwengeza amaqembu amangqamuzana.
- Khetha iqembu elizungezile lezakhi zeshidi bese uchofoza kwisithonjana esijwayelekile Namathisela kuthebhu "Ikhaya".
- Ngemuva kwalokho, iqembu lezici zamasheya lizofakwa, njengokungeza okukodwa, ngokushiya phansi.
Kodwa uma ukhetha iqembu eliqondile lamaseli, sithola umphumela ohlukile.
- Khetha iqembu eliqondile lamazakhi bese uchofoza inkinobho. Namathisela.
- Njengoba ungabona, ngokungafani nezinketho zangaphambilini, kulokhu iqembu lezakhi lanezelwa ngokushintshela ngakwesokudla.
Kuzokwenzekani uma sengeza izinto eziningi eziphethe ukuqondisa okuqondile nokuqondile ngendlela efanayo?
- Khetha i-orientation ye-orientation ehambelanayo bese uchofoza inkinobho esazijwayele kakade. Namathisela.
- Njengoba ubona, izakhi ezine-shift shift zizofakwa endaweni ekhethiwe.
Uma usufuna ukucacisa ngokucacile lapho izakhi kufanele zihambise khona, futhi, ngokwesibonelo, uma ungeza i-array ofuna ukushintshwa kwenzeke phansi, kufanele ulandele imiyalo elandelayo.
- Khetha isici noma iqembu lezici endaweni esifuna ukuyifaka. Asichofoli inkinobho ejwayelekile Namathisela, noxantathu, okuboniswa ngakwesokudla. Uhla lwezenzo luvulwa. Khetha into kuwo "Faka amaseli ...".
- Emva kwalokhu, ifasitela lokufaka esivele selijwayele indlela yethu kuqala. Khetha inketho yokufaka. Uma thina, njengoba kushiwo ngenhla, sifuna ukwenza isenzo ngokushintsha phansi, bese ufaka ukushintshwa endaweni "Amaseli, ngokushintsha". Emva kwalokho, chofoza inkinobho "Kulungile".
- Njengoba ubona, izakhi zangeziwe eshidi ngokushintsha phansi, okungukuthi, njengoba nje sisetha kuzilungiselelo.
Indlela 3: Ama-hotkeys
Indlela esheshayo yokwengeza izakhi zeshidi ku-Excel ukusebenzisa inhlanganisela ye-hotkey.
- Khetha izakhi endaweni esifuna ukuyifaka. Ngemva kwalokho, thayipha isinqamuleli sekhibhodi ekhibhodi Ctrl + Shift + =.
- Ngemva kwalokhu, ifasitela elincane lokufaka izakhi esivele sizijwayele kuzovulwa. Kulo, udinga ukusetha izilungiselelo zokulungisa eceleni noma phansi bese ucindezela inkinobho "Kulungile" ngendlela efanayo njengoba senze okungaphezu kwesisodwa ngezindlela zangaphambilini.
- Ngemuva kwalokho, izakhi ezitsheni zizofakwa, ngokusho kwezilungiselelo zokuqala ezenziwe kwindima yangaphambilini yale ncwadi.
Isifundo: Amakhidi Eshisayo ku-Excel
Njengoba ubona, kunezindlela ezintathu eziyinhloko zokufaka amaseli etafuleni: usebenzisa imenyu yesimo, izinkinobho zebhande kanye nezinkinobho ezishisayo. Ukusebenza kwalezi zindlela kufana, ngakho-ke uma ukhetha, okokuqala, kulula ukuthi umsebenzisi uthathwe. Nakuba kunjalo, indlela esheshayo ukusebenzisa ama-hotkeys. Kodwa, ngeshwa, akubona bonke abasebenzisi abajwayele ukugcina inhlanganisela ye-Excel eshisayo ekhona ekumbulweni yabo. Ngakho-ke, le ndlela esheshayo ngeke ibe lula kuwo wonke umuntu.
