Njengomthetho, iningi labasebenzisi, engeza amaseli lapho usebenza ohlelweni lwe-Excel alumeleli umsebenzi onamandla. Kepha, ngeshwa, akuyena wonke umuntu owazi zonke izindlela ezingenzeka. Kepha kwezinye izimo, ukusetshenziswa kwendlela ethile kungasiza ekunciphiseni izindleko zesikhathi sokusetshenziswa kwenqubo. Ake sibheke ukuthi yiziphi izinketho zokwengeza amaseli amasha ku-Excel.
Ngokufanayo, ungangeza wonke amaqembu amaseli, kuphela kulokhu ngaphambi kokushintshwa kwimenyu yomongo Kuzodingeka ukukhetha inani elihambisanayo lezinto eziseshidini.
Ngemuva kwalokho, izakhi zizongezwa ku-algorithm efanayo nathi esichazile ngenhla, kepha yinye kuphela iqembu.
Indlela 2: Inkinobho ku-Ribbon
Ngeza izinto ekhasini le-Excel nazo zingaba yinkinobho ethepheni. Ake sibheke ukuthi singakwenza kanjani.
- Sigqamisa into endaweni yephepha lapho sihlela ukungeza iseli. Sithuthela kuthebhu "Yasekhaya", uma njengamanje ukhona. Bese uchofoza inkinobho ethi "Namathisela" ku- "Ithuluzi le-Cell Tool" block ethepheni.
- Ngemuva kwalokho, into izongezwa ephepheni. Ngaphezu kwalokho, kunoma yikuphi, kuzongezwa ngokususwa phansi. Ngakho-ke le ndlela namanje ayivumelani naphansi kwesokuqala.
Ngosizo lwendlela efanayo, ungangeza amaqembu amaseli.
- Sigqamisa iqembu elivundlile lezinto zeshidi bese sichofoza isithonjana esithi "Faka" esijwayele kithi kuthebhu yasekhaya.
- Emva kwalokho, kuzofakwa iqembu lezinto zeshidi, njengokungezwa okuqinile, ngokuhamba phansi.
Kepha lapho wabela iqembu elimile lamaseli, sizothola umphumela ohlukile.
- Khetha iqembu elithe mpo bese uchofoza inkinobho ethi "Namathisela".
- Njengoba ubona, ngokungafani nezinketho ezedlule, kulokhu iqembu lezinto ezinokushintshwa kwesokudla selingeziwe.
Kuzokwenzekani uma sengeza uhlu lwezakhi zombili ngokulandelana okuvundlile nokuthe mpo?
- Sigqamisa uhlu lwendlela efanelekile futhi sichofoze inkinobho esele siyijwayele "unamathisela".
- Njengoba ubona, izofakwa endaweni ezinikezele ngokushintshwa kwesokudla.
Uma usafuna ukucacisa ngqo lapho izinto kufanele zihanjiswe khona, futhi, ngokwesibonelo, lapho ungeza uhlu, ufuna ukufudumala, kufanele ulandele imiyalo elandelayo.
- Sigqamisa into noma iqembu lezinto, lapho sifuna ukwenza khona ukufaka. Angichofozi enkingeni ethi "Namathisela", kodwa kunxantathu, okukhonjiswa ngakwesokunene salo. Uhlu lwezenzo luyavula. Khetha kuyo into ethi "Faka amaseli ...".
- Emva kwalokho, sekuvele sisijwayeze ngokwendlela yokuqala ye-Insert Window. Khetha inketho yokufaka. Uma thina, njengoba kushiwo ngenhla, sifuna ukwenza isenzo ngokuhamba phansi, bese sibeka ukushintshela esimweni "amaseli, ngokuhamba phansi phansi". Ngemuva kwalokho, chofoza inkinobho ethi "Kulungile".
- Njengoba sikwazi ukubona, izinto zengezwe ephepheni elinokwehla, okungukuthi, njengoba nje sibuze kuzilungiselelo.
Indlela 3: Okhiye abashisayo
Indlela esheshayo yokwengeza izinto zeshidi ku-Efpelle ukusebenzisa inhlanganisela yezinkinobho ezishisayo.
- Sigqamisa izinto endaweni esifuna ukuyifaka. Ngemuva kwalokho, sithayipha inhlanganisela yezinkinobho ezishisayo ze-CTRL + Shift + =.
- Ukulandela lokhu, kuzovela izinto ezincane zokufaka iwindi. Idinga ukusetha izilungiselelo ze-offset kwesokudla noma phansi bese uqhafaza inkinobho ethi "KULUNGILE" ngendlela efanayo naleso eyenziwe kaningi ngezindlela ezedlule.
- Ngemuva kwalokho, izakhi eziseshidi zizofakwa, ngokuya ngezilungiselelo zokuqala ezazenziwe esigabeni esedlule salo myalelo.
Isifundo: Okhiye abashisayo ku-Excel
Njengoba ubona, kunezindlela ezintathu eziphambili zokufaka amaseli etafuleni: Kusetshenziswa imenyu yokuqukethwe, izinkinobho ezisethekeni nasezikhiye ezishisayo. Ngokuya ngokusebenza, lezi zindlela ziyafana, ngakho-ke lapho ukhetha, okokuqala, kube lula umsebenzisi uqobo uyabhekwa. Yize ngokuqinisekile indlela esheshayo ukusetshenziswa okhiye abashisayo. Kepha, ngeshwa, akubona bonke abasebenzisi abajwayele ukugcina inhlanganisela ekhona yezinkinobho ezishisayo ze-Excel kwimemori yabo. Ngakho-ke, hhayi ngayo yonke le ndlela esheshayo kuzoba lula.