Ungafaka kanjani ikholamu ku-Excel

Ukusebenza kuMicrosoft Excel, okubaluleke kakhulu ukufunda ukufaka izintambo namakholomu etafuleni. Ngaphandle kwaleli khono, cishe akunakwenzeka ukusebenza nedatha ye-tabular. Ake sibhekane nendlela yokufaka ikholamu ku-Efpelle.

Isifundo: Ungangeza kanjani ikholomu etafuleni le-Microsoft Word

Faka ikholomu

Ku-Excel, kunezindlela eziningana zokufaka ikholamu ekhasini. Iningi lazo lilula, kepha umsebenzisi we-novice angeke abhekane nakho ngokushesha. Ngaphezu kwalokho, kunenketho yokungeza ngokuzenzakalela izintambo ngakwesokudla kwetafula.

Indlela 1: Faka ngokusebenzisa iphaneli yokuxhumanisa

Enye yezindlela ezilula zokufaka ukufakwa kuwukusebenza ngephaneli yokuxhumanisa evundlile.

1. Ukuchofoza kuphaneli evundlile yokuxhumanisa ngamagama amakholomu ngokusho komkhakha, ngakwesobunxele lapho udinga ukufaka amakholomu. Kulokhu, ikholomu yabelwa ngokuphelele. Chofoza inkinobho yegundane kwesokudla. Kumenyu evela, khetha into ethi "Namathisela".



2. Emva kwalokho, ikholomu entsha ifakwa ngokushesha ngakwesokunxele sendawo ekhethiwe.

Indlela 2: Ukungeza iseli ngemenyu yokuqukethwe

Ungenza lo msebenzi futhi ehlukile, okungukuthi ngemenyu yokuqukethwe yeseli.

1. Chofoza kunoma iyiphi iseli etholakala kwikholamu ngakwesokudla kwekholomu ehlelelwe ukwengeza. Chofoza kule nkinobho yesokudla yesokudla kwesokudla. Kumenyu yomongo evelayo, khetha u- "Namathisela ...".



2. Lesi sikhathi sokungeza asisho ngokuzenzakalelayo. Iwindi elincane liyavula, lapho ufuna ukucacisa khona ukuthi ngumsebenzisi ozofaka:
   • Ikholamu;
   • Umugqa;
   • Iseli ngejubane phansi;
   • Iseli ngokushintshwa kwesokudla.

   Sihlela kabusha ukushintshela esimweni se- "Column" bese uqhafaza inkinobho ethi "Kulungile".



3. Ngemuva kwalezi zenzo, ikholomu izongezwa.

Indlela 3: Inkinobho ku-Ribbon

Ukufaka amakholomu kungenziwa kusetshenziswa inkinobho ekhethekile ethepheni.

1. Khetha iseli ngakwesokunxele kwaso kuhlelwe ukwengeza ikholomu. Ukuba sethebhu "Yasekhaya", chofoza isithonjana ngendlela yonxantathu ongenayo, etholakala eduze kwenkinobho ethi "Namathisela" ku-Ithuluzi le- "Cell" ethepheni. Kumenyu evula, khetha i- "Insert Colombs entweni eshidi".



2. Ngemuva kwalokho ikholamu izongezwa ngakwesokunxele kwento ekhethiwe.

Indlela 4: Kusebenzisa okhiye abashisayo

Futhi, ikholomu entsha ingangezwa ngezinkinobho ezishisayo. Futhi kunezindlela ezimbili zokungeza

1. Enye yazo ifana nendlela yokuqala yokufakwa. Udinga ukuchofoza emkhakheni wephaneli yokuxhumanisa evundlile ekwesokunene sendawo yokufaka okuhlosiwe bese ushayela inhlanganisela yokhiye we-CTRL ++.



2. Ukuze usebenzise inketho yesibili, kufanele uchofoze kunoma iyiphi iseli kwikholamu ngakwesokudla kwendawo yokufaka. Ngemuva kwalokho shayela kukhibhodi ye-CTRL ++. Ngemuva kwalokho, ke iwindi elincane elinokukhethwa kohlobo lokufaka, oluchazwe ngendlela yesibili yokwenza umsebenzi. Izenzo ezengeziwe ziyefana: khetha ikholomu "ye-Clause bese uqhafaza inkinobho ethi" KULUNGILE ".

Isifundo: Okhiye abashisayo ku-evelela

Indlela 5: Ukufaka amakholomu amaningana

Uma ufuna ukunamathisela amakholomu amaningana, khona-ke ku-Effel akudingekile ukwenza umsebenzi ohlukile wento ngayinye yalokhu, ngoba le nqubo ingahlanganiswa ibe yisenzo esisodwa.

1. Kufanele uqale ukhethe amaseli amaningi kangaka ochungechungeni noma imikhakha evundlile kwiphaneli yokuxhumanisa, mangaki amakholomu adinga ukwengezwa.



2. Ngemuva kwalokho faka enye yezenzo ngemenyu yomongo noma ngezinkinobho ezishisayo ezichazwe ngezindlela ezedlule. Inani elihambisanayo lamakholomu lizongezwa ngakwesokunxele sendawo ekhethiwe.

Indlela 6: Ukungeza ikholomu ekugcineni kwetafula

Zonke izindlela ezingenhla zilungele ukwengeza izikhulumi ekuqaleni naphakathi kwetafula. Zingasetshenziswa futhi ukufaka amakholomu ekugcineni kwetafula, kepha kulokhu kufanele wenze ukufometha okufanele. Kepha kunezindlela zokwengeza ikholomu kuze kube sekupheleni kwetafula ukuze kuthathwe ngokushesha uhlelo lube yingxenye yalo. Ukuze wenze lokhu, kudingeka wenze, okubizwa ngokuthi yiTable "Smart".

1. Sigqamisa ububanzi betafula esifuna ukuguqula itafula elithi "Smart".



2. Ukuba sethebhu yasekhaya, chofoza inkinobho ethi "format njengeTebula", elitholakala ku-Tower "Styles" Ithuluzi elivinjelwe ethepheni. Ohlwini olunqanyuliwe, khetha olunye uhlu olukhulu lwezitayela zokuklama kwetafula ngokubona kwakho.



3. Ngemuva kwalokho, iwindi livuleka, elibonisa izixhumanisi zendawo ekhethiwe. Uma ubonile okuthile okungalungile, ungahle uhlele lapha. Into esemqoka ukuthi udinga ukwenza ngalesi sinyathelo ukubheka ukuthi ibhokisi lokuhlola lifakiwe yini eduze kwe- "tafula nge-Headlines" ipharamitha "ipharamitha". Uma itafula lakho linesigqoko (futhi ezimweni eziningi kungukuthi kunjalo), kepha akukho mkhakha wale nto, khona-ke udinga ukuyifaka. Uma zonke izilungiselelo zisethwe kahle, bese uchofoza inkinobho ethi "Kulungile".



4. Ngemuva kwalezi zenzo, uhla oluzinikezele lwakhiwa njengetafula.



5. Manje ukuze uvumele ikholomu entsha kulelithebula, kwanele ukugcwalisa noma isiphi iseli ngakwesokudla salo. Ikholomu lapho iseli leli litholakala ngokushesha lizoba masinyane.

Njengoba ubona, kunezindlela eziningi zokwengeza amakholomu amasha ekhasini le-Excel Sheet zombili phakathi kwetafula nakuzinsuku zokugcina. Ukwengeza kokulula kakhulu futhi okulula, kungcono ukudala, okubizwa ngethebula elibizwa nge- "Smart". Kulokhu, lapho ungeza idatha ebangeni ngakwesokudla kwetafula, izofakwa ngokuzenzakalelayo kuyo njengekholamu entsha.