Ukuze usebenze ku-Microsoft Excel, kuqala kuqala ukufunda indlela yokufaka imigqa namakholomu etafuleni. Ngaphandle kwale khono, cishe akunakwenzeka ukusebenza nemininingwane ye-tabular. Ake sibone ukuthi singeza kanjani ikholomu ku-Excel.
Isifundo: Indlela yokwengeza ikholomu etafuleni le-Microsoft Word
Faka ikholomu
Ku-Excel, kunezindlela eziningana zokufaka ikholomu kushidi. Iningi lazo lilula, kodwa umsebenzisi we-novice angeke asebenze ngokushesha nakho konke. Ngaphezu kwalokho, kunenketho yokufaka ngokuzenzekelayo imigqa ngakwesokudla kwetafula.
Indlela 1: faka ngokusebenzisa iphaneli yokuxhumanisa
Enye yezindlela ezilula zokufaka zikhona ngephaneli yokuxhumanisa ephelele ye-Excel.
- Sichofoza iphaneli yokuxhumanisa enezingqimba enegama lekholomu kumkhakha ngakwesokunxele lapho sidinga khona ukufaka ikholomu. Kulesi simo, ikholomu igcizelele ngokuphelele. Chofoza inkinobho yesokudla yegundane. Emenyu evelayo, khetha into Namathisela.
- Emva kwalokho, ikholomu entsha ishaywa ngokushesha ngakwesokunxele kwendawo ekhethiwe.
Indlela 2: Engeza ngemenyu yokuqukethwe yeseli
Ungenza lo msebenzi ngendlela ehlukile, okungukuthi ngokusebenzisa imenyu yokuqukethwe yeseli.
- Chofoza kunoma iyiphi iseli elitholakala kukholomu ngakwesokudla kwekholomu okuhleliwe ukuthi ingezwa. Chofoza kule nto nge inkinobho yegundane kwesokudla. Emenyu yomongo evelayo, khetha into "Namathisela ...".
- Kule nkathi ukuhlanganisa akuzenzakaleli. Iwindi elincane livuleka lapho kudingeka khona ukuthi ucacise ukuthi umsebenzisi uzofaka ini:
- Ikholomu;
- Umzila;
- I-Shift Down Cell;
- Iseli ishintshelwe ngakwesokudla.
Hambisa ushintsho endaweni "Ikholomu" bese uchofoza inkinobho "Kulungile".
- Emva kwalezi zenzo, ikholomu izofakwa.
Indlela 3: Inkinobho yebhande
Ukufaka amakholomu kungenziwa ngokusebenzisa inkinobho ekhethekile ebhethini.
- Khetha iseli ngakwesokunxele ofuna ukufaka kukholomu. Ukuba ngaphakathi kuthebhu "Ikhaya", chofoza isithonjana ngesimo soxantathu oluvuliwe esiseduze nenkinobho Namathisela ebhodini lamathuluzi "Amaseli" kwi-tape. Emenyu evula, khetha into "Faka amakholomu kushidi".
- Ngemva kwalokho, ikholomu izongezwa ngakwesokunxele kwento ekhethiwe.
Indlela 4: sebenzisa ama-hotkeys
Futhi, ikholomu entsha ingezwa nge-hotkeys. Futhi kunezinketho ezimbili zokwengeza
- Omunye wabo ufana nendlela yokuqala yokufaka. Udinga ukuchofoza emkhakheni kwiphaneli yokuxhumanisa enezingqimba esekwesokudla kwendawo ehlosiwe yokufaka bese uthayipha inhlanganisela yekhiye Ctrl ++.
- Ukuze usebenzise ukhetho lwesibili, udinga ukuchofoza kunoma iyiphi iseli kukholomu ngakwesokudla endaweni yokufaka. Bese uthayiphe ikhibhodi Ctrl ++. Emva kwalokho, iwindi elincane lizovela ngokukhetha uhlobo lokufaka, okuchazwe ngendlela yesibili yokwenza umsebenzi. Izenzo ezengeziwe zifana nalokho: khetha into "Ikholomu" bese uchofoza inkinobho "Kulungile".
Isifundo: Amakhadi ashisayo ku-Excel
Indlela 5: Faka ama Columns amaningi
Uma udinga ukufaka amakholomu amaningana ngesikhathi esisodwa, khona-ke ku-Excel asikho isidingo sokuba kwenziwe umsebenzi ohlukile kwento ngayinye, ngoba le nqubo ingahlanganiswa ibe yisenzo esisodwa.
- Kumele uqale ukhethe amaseli amaningi emgqeni ogobile noma imikhakha iphaneli yokuxhumanisa njengoba udinga ukwengeza amakholomu.
- Bese usebenzisa enye yezenzo ngokusebenzisa imenyu yesimo noma ngokusebenzisa izinkinobho ezishisayo, ezichazwe ngezindlela zangaphambilini. Inombolo ehambelana yamakholomu izongezwa ngakwesokunxele kwendawo ekhethiwe.
Indlela 6: engeza ikholomu ekupheleni kwetafula
Zonke izindlela ezingenhla zifanele ukwengeza amakholomu ekuqaleni kanye naphakathi kwetafula. Zingasetshenziswa futhi ukufaka amakholomu ekupheleni kwetafula, kodwa kulokhu kuzodingeka wenze ukufometha okufanelekile. Kodwa kunezindlela zokwengeza ikholomu ekupheleni kwetafula ukuze kutholakale ngokushesha ohlelweni njengengxenye yalo esheshayo. Ukwenza lokhu, udinga ukwenza ithebula okuthiwa "smart".
- Khetha ububanzi bethebula esifuna ukuphendukela etafuleni "elihlakaniphile".
- Ukuba ngaphakathi kuthebhu "Ikhaya", chofoza inkinobho "Fometha njengetafula"esitholakala kwibhulogi yamathuluzi "Izitayela" kwi-tape. Kulolu hlu oluvula, khetha olunye uhlu olukhulu lwezitayela zetafula ngokuqonda kwalo.
- Emva kwalokho, iwindi livula lapho izixhumanisi zendawo ekhethiwe zikhonjiswa. Uma ukhethe okuthile okungalungile, khona-ke ungakulungisa lapha. Into esemqoka okumele yenziwe kulesi sinyathelo ukuhlola ukuthi ngabe isheke lihlelwe yini. "Ithebula ngezihloko". Uma ithebula lakho linomhlobiso (futhi ezimweni eziningi liyi), kodwa le nto ayifakiwe, bese udinga ukuyifaka. Uma zonke izilungiselelo zihlelwe kahle, mane uchofoze inkinobho. "Kulungile".
- Ngemva kwalezi zenzo, ibanga elikhethiwe lifomethiwe njengetafula.
- Manje, ukuze ufake ikholomu entsha kuleli tafula, kwanele ukugcwalisa noma yiliphi iseli ngakwesokudla kwalo nedatha. Ikholomu lapho leli seli likhona khona lizobe seliba khona ngokushesha.
Njengoba ungabona, kunezindlela eziningi zokwengeza amakholomu amasha efelini le-Excel, kokubili phakathi kwetafula nasezigabeni ezidlulele. Ukwenza ukungezwa kube lula futhi kulula kunokwenzeka, kungcono ukudala okuthiwa i-smart table. Kulesi simo, uma ungeza idatha ebangeni ngakwesokunene kwetafula, kuzofakwa ngokuzenzakalelayo kuwo ngendlela yekholomu entsha.
