Ungagcizelela kanjani imingcele yetafula e-Excel

Ukukhethwa kwemingcele kuMicrosoft Excel kungenye yezindlela zokuqokwa kwayo okubukwayo, noma kunjalo, kulolu hlelo kunezinye izindlela ezikuvumela ukuthi udale i- "Smart" noma itafula elisebenzayo. Uma ungakakwenzi lokhu futhi unesifiso sesihloko, qiniseka ukuthi ufunda umhlahlandlela wereferensi ngezansi noma uye kulezi zindlela ezilandelayo ukuze ufunde ukuthi ungayikhetha kanjani imingcele yetafula.

Funda kabanzi: Ukwakha itafula ku-Microsoft Excel

Indlela 1: Kusetshenziswa izikhala ezijwayelekile

I-Excel inezikhala ezijwayelekile ezivame kakhulu ukuba abasebenzisi abajwayelekile bakwazi ukubona imingcele yetafula. Baphakamisa ukwabiwa okuhlukile kwemigqa nokuguqulwa, ngakho-ke bayoba wusizo ezimweni ezithile. Ukwengeza imingcele enjalo, kuzodingeka wenze ukuchofoza okumbalwa.

1. Ngenkinobho yegundane kwesobunxele, qokomisa zonke izinto ezifakiwe etafuleni ukuze izinguquko ezibonakalayo zisebenza kubo bonke.



2. Nweba imenyu ethi "Border", esethebhu yasekhaya, bese ukhetha enye yezinketho ezenziwe ngomumo. Kumenyu efanayo, ungabuka ngokushesha izinguquko ezenziwe etafuleni ngokusebenzisa isithonjana ngakwesokunxele.



3. Ngemuva kokusebenzisa imingcele, buyela etafuleni futhi ukwazisa ukubukeka kwayo. Uma kufanelekile kuwe, ungashiya yonke into njengoba injalo, ngenye indlela iya kwezinye izilungiselelo.



4. Isibonelo, akukho okuzophazamisa ukuvulwa kwemenyu efanayo futhi kushintshe umbala womugqa usebenzisa imibala ejwayelekile, imibala yetimu noma izithunzi zangokwezifiso.



5. Okufanayo kusebenza kuhlobo lwemigqa, noma kunjalo, isethi ikhawulelwe ezinketho ezimbalwa ezihlukile eziqhubekayo nezinamachashazi.



6. Uma umbala nohlobo lwemigqa kukhethwe ngemuva kokudalwa kwemingcele, ngalinye lizodingeka ngokwehlukana, lichofoza inkinobho yegundane kwesobunxele ngethuluzi lokuhlela elisebenzayo.



7. Ngale nqubo, imigqa eyiphutha ingavela ngenxa yokucindezela okungafanele.



8. Bese ubasuse ngemenyu yokudonsela phansi efanayo usebenzisa ithuluzi ku- "Sula umngcele".

Uma ungalingani nezinketho zakudala noma isidingo sokwenza ngokwezifiso okungajwayelekile kwemingcele yetafula kuvelile, sebenzisa izinketho ezilandelayo zokubuka design.

Indlela 2: Umdwebi womngcele wesandla

Umdwebo wesandla womngcele wethebula e-Excel uzokwakha umklamo ngamunye womugqa ngamunye njengoba kudingeka kumsebenzisi uqobo. Ukuze wenze lokhu, sebenzisa imenyu yokudonsela phansi efanayo, kepha yenza ezinye izenzo.

1. Vula uhlu "Imingcele" lapho ukhetha khona "Dweba umngcele" ithuluzi.



2. Uma uhlobo lomugqa nombala walo kuzohlukahluka ngokuzenzakalelayo, kushintshe ngokushesha ukudala umklamo ofanele lapho udweba.



3. Qala ukudweba imingcele, ngokuchofoza izinkambu ezidingekayo noma ukuchitha imali kuzo, ngokushesha ukudala okubonakalayo enkombeni ngayinye.

Indlela 3: Isebenzisa "elinye umngcele" ithuluzi

Ithuluzi elibizwa nge- "Eminye imingcele" lizokuvumela ukuthi udale imigqa engeyona ingxenye yezifanekiso ezijwayelekile, ngokwesibonelo, lapho ufuna ukuwela iseli noma engeza umklamo ongajwayelekile.

1. Kulokhu, vula yonke imenyu "yomngcele" ofanayo, kepha khetha amathuluzi okugcina ".



2. Qala ukudala imigqa efasiteleni eyabelwe lokhu. Ivezwa njengeseli elikhulisiwe elinombhalo wethempulethi, futhi ukucindezela imiphetho kungangeza noma kususwe umugqa ngokushesha.



3. Kule thebhu, ungashintsha ngokushesha uhlobo lomngcele nombala walo, ufunde umphumela ewindini lokubuka kuqala.



4. Iya kuthebhu ethi "Gcwalisa", uma udinga ukushintsha umbala wangemuva weseli ngalinye eliyingxenye yetafula.



5. Esikrinini esilandelayo, ubona inketho yokuthi imingcele engeyona eyejwayelekile ingeze kangakanani, ngokwesibonelo, idala umphumela wesitokisi esiwela umugqa onamachashazi noma umugqa oqhubekayo.

Indlela 4: Ukusetshenziswa kwe- "Cell Styles" umsebenzi

Njengendlela yokugcina, siphakamisa ukuthi sifunde imisebenzi "yezitayela zeseli", ezingasetshenziswa futhi ukudala umklamo womngcele ongajwayelekile, kufaka phakathi amanye amaseli afakiwe etafuleni le-Excel. Izilungiselelo zomuntu siqu zaleli thuluzi aziyona kangako, ngakho-ke izifanekiso ezenziwe ngomumo zivame ukubandakanyeka.

1. Okokuqala, yabela lonke itafula amaseli alo ofuna ukuwashintsha ngosizo lwe- "Cell Styles". Cindezela umugqa ngegama lomsebenzi ku-block "izitayela" ezitholakala kuthebhu yasekhaya.



2. Iwindi elihlukile livula ngezibonelo zamaseli wohlobo lwedatha, izihloko noma amafomethi wezinombolo. Thatha indawo yokusebenza bese uchofoza kabili kukho ukuze usebenzise.



3. Lapho nje uvala iwindi, ungabheka umphumela. Isibonelo, isithombe-skrini esingezansi sikhombisa ukwakheka okungajwayelekile ngemingcele ephindwe kabili, okunzima ukuyenzela yona, kepha ukusebenzisa izifanekiso kungokuchofoza ezimbili.



4. Uma ungaya "Dala Cell Style" ithuluzi lapho uxhumana leli thuluzi, ungakwazi ngesandla ukufaka, nquma ukuthi izobandakanya isitayela, bese usinike igama nendawo phezu main Ukukhetha panel.