Izitayela zokufometha kwe-Excel

Lokhu kufundisa kuhlanganisa ukusebenzisa izitayela zokufometha kwangaphambi kokusetha ku-Excel ngezibonelo zesinyathelo ngesinyathelo.

01 kwezingu-10

Ukusebenzisa Izitayela Zokufometha

Kulesi sinyathelo, sizosebenzisa izitayela zokufometha zangaphambi kokusetha kwe-Excel ukuze wengeze umbala othile ekhasini lethu lomsebenzi . Ukwenza kanjalo akugcini nje ukuthi unikeze ukubukeka okungaphezulu, kepha kungenza kube lula ukufunda nokuhumusha idatha yephepha lokusebenzela.

Ngokuqondile, sizosebenzisa ukufaka shading ezihlokweni zomsebenzi emigqeni engu- 2 no-7 kanye nemigqa engu-3 no-6 usebenzisa izinketho zokufometha zezitayela ezisendlini yasekhaya yebhande .

Ukwenza imizamo yethu iphumelele, sizokhetha amangqamuzana angasondelene yedatha besebenzisa ikhi Ctrl ekhibhodi. Lokhu kuzosenza sikwazi ukusebenzisa ukufometha kuwo wonke amaseli aqokomisiwe ngesikhathi esisodwa.

Ukwengeza Shading kuya Okushicilelwe Worksheet Izihloko

1. Chofoza kusihloko sesihloko esihlangene kulayini 2.
2. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
3. Hudula ukhethe amaseli A7 kuya ku-F7 ukuze uwaqokomise kanye nesitoreji sesihloko esihlanganisiwe.
4. Khipha ukhiye we- Ctrl .
5. Chofoza umcibisholo ophansi ekupheleni kohlu lwezitayela ezitholakalayo.
6. Khetha inketho ye- Accent 3 kusuka ezitayela ezitholakalayo.
7. Kokubili i-cell title ehlangene kanye nezihloko ezisebuseni 7 kufanele manje zibe nombhalo omhlophe ongobuhlaza obumnyama.
8. Ukwenza umbhalo omhlophe ubonakale kancane, chofoza uphawu lweBold ku-ribbon.
9. Isithonjana esinesibindi singumyalezo omnyama B ngaphansi kwesigaba sefonti webhande.

Ukwengeza Shading kuya Rows 3 no 6

1. Hudula ukhethe amaseli A3 kuya ku-F3 ukuze uwaqokomise.
2. Cindezela bese ubamba ukhiye we- Ctrl kukhibhodi.
3. Hudula ukhethe amaseli A6 kuya ku-F6 ukuze uwaqokomise kanye namaseli A3 kuya ku-F3.
4. Chofoza umcibisholo ophansi ekupheleni kohlu lwezitayela ezitholakalayo.
5. Khetha okukhethwa kukho okungu-40% - I-Accent 3 kusuka ezitayela ezitholakalayo.
6. Amaseli A3 kuya ku-F3 no-A6 kuya ku-F6 kufanele manje abe nesizinda esiluhlaza esibomvu nombhalo omnyama.

02 kwezingu-10

Izitayela zeselula Uhlolojikelele

Isitayela seseli ku-Excel kuyinhlanganisela yokhetho lokufometha - njengama-font nobukhulu bombala, amafomethi wezinombolo , nemingcele yeseli, kanye ne-shading - okuthiwa futhi igcinwe njengengxenye yephepha lokusebenzela.

I-Excel inezindlela eziningi ezakhelwe ngaphakathi esitokisini ezingasetshenziselwa njengokushicilela noma zishintshiwe njengoba zifisiwe. Lezi zindlela ezakhelwe ngaphakathi zingasebenza njengesisekelo samasethingi eseli ngokwezifiso ezingagcinwa futhi zabelwe phakathi kwamabhuku okusebenza.

Enye inzuzo yokusebenzisa izitayela yukuthi uma isitayela seseli ishintshiwe ngemuva kokuthi isetshenziselwe ishidi, wonke amaseli asebenzisa isitayela azovuselela ngokuzenzakalelayo ukuze abonise izinguquko.

Ngaphezu kwalokho, izitayela zeseli zingafaka i- Excel's cell lock isici esingasetshenziselwa ukuvimbela izinguquko ezingagunyaziwe kumaseli athile, ama-worksheets noma izincwadi zokusebenzela.

03 ka-10

Izitayela zeselula nama-Document Themes

Izitayela zeselula zisekelwe kumbhali wedokhumenti osetshenziselwa yonke ibhuku lokusebenzela. Izingqikithi ezahlukene zinezinketho ezahlukene zokufometha ngakho uma isihloko sedokhumenti sishintshwa, izitayela zesitokisi zalowo dokhumenti nazo ziyashintsha.

04 kwezingu-10

Ukusebenzisa isitayela seselula esakhiwe

Ukusebenzisa enye yezitayela zokufometha ezakhelwe ngaphakathi ku-Excel:

1. Khetha ububanzi bamaseli okufanele afomatiwe;
2. Ethempelini laseKhaya lebhebhoni, chofoza isithonjana se- Cell Styles ukuvula igalari yezitayela ezitholakalayo;
3. Chofoza kusitayela sesitfombe esifuna ukufaka isicelo.it.

05 ka-10

Ukwakha isitayela seSikrini sangokwezifiso

Ukwakha isitayela sesitayela yangokwezifiso:

1. Khetha iseli elilodwa lomsebenzi weshidi;
2. Sebenzisa zonke izinketho zokufometha ezifunayo kule seli - isitayela esakhelwe singasetshenziswa njengendawo yokuqala;
3. Chofoza ithebhu yaseKhaya ku-ribbon.
4. Chofoza ku-option Styles Styles kwi-Ribbon ukuvula igalari yeselula .
5. Njengoba kuboniswe esithombeni ngenhla, chofoza inketho entsha yezitayela zeseli phansi kwegalari ukuvula ibhokisi lengxoxo yesitayela ;
6. Thayipha igama lesitayela esisha ebhokisini legama lesitayela;
7. Izinketho zokufometha esivele zisetshenziswe kuseli elikhethiwe zizofakwa kuhlu ebhokisini lengxoxo.

Ukwenza izinketho ezengeziwe zokufometha noma ukuguqula izinketho zamanje:

1. Chofoza inkinobho yefomathi ebhokisini lengxoxo yesitayela ukuvula ibhokisi lengxoxo yefomathi yefomathi.
2. Chofoza kuthebhu ebhokisini lengxoxo ukuze ubuke izinketho ezitholakalayo;
3. Sebenzisa zonke izinguquko ezifisiwe;
4. Chofoza OK ukuze ubuyele ebhokisini lengxoxo yesitayela ;
5. Ebhokisini lebhokisi lengxoxo, ngaphansi kwesigatshana esithi I- Style Includes (Ngesibonelo) , cima amabhokisi okuhlola kwanoma yikuphi ukufometha okungafunwa.
6. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela.

Igama lesitayela esisha lengezwe phezulu kwegalari yeStyles Styles ngaphansi kwesihloko sangokwezifiso njengoba kuboniswe esithombeni ngenhla.

Ukuze usebenzise isitayela esisha kumaseli eshidi lokusebenzela, landela uhlu lwamanyathelo ngenhla ukusebenzisa isitayela esakhelwe ngaphakathi.

06 kwangu-10

Ukukopisha Izitayela Zamaselula

Ukukopisha isitayela sesitayela esingokwezifiso sokusetshenziswa encwadini ehlukile:

1. Vula ibhuku lezincwadi eliqukethe isitayela esingokwezifiso okuzokopishwa;
2. Vula ibhuku lokusebenzela ukuthi isitayela likopishwa kuso.
3. Kule ncwadi yesibini, chofoza ithebhu yaseKhaya kubhebhoni.
4. Chofoza ku-Isithonjana Sesitayela Seselula kwi-Ribbon ukuvula igalari yeselula .
5. Chofoza inketho Yokuhlanganisa Izitayela ezansi kwegalari ukuvula ibhokisi lokuhlanganisa lezindlela zokuhlanganisa .
6. Chofoza egameni lomsebenzi oqukethe isitayela sokukopishwa;
7. Chofoza OK ukuvala ibhokisi lengxoxo.

Kuleli qophelo, ibhokisi lokuxwayisa lizovela libuza ukuthi ufuna ukuhlanganisa izitayela ngegama elifanayo.

Ngaphandle kokuba ube nezitayela zenkambiso enegama elifanayo kodwa izinketho zokufometha ezihlukene kuzo zombili izincwadi zokusebenza, okuyinto, ngendlela, engakaze kube umqondo omuhle, chofoza inkinobho ye- Yebo ukuqedela ukudluliselwa kwesitayela encwadini yokusebenzela.

07 kwangu-10

Ukuguqula isitayela seSeli esivele sikhona

Ngezindlela ezakhelwe ngaphakathi ze-Excel, kungcono kakhulu ukushintsha impinda yesitayela kunokuba isitayela ngokwaso, kodwa kokubili izitayela ezakhelwe ngaphakathi nezindlela ezingaguquguqukayo zingaguquzwa ngokusebenzisa izinyathelo ezilandelayo:

1. Ethempelini laseKhaya lebhebhoni, chofoza isithonjana se- Cell Styles ukuvula igalari yeselula .
2. Chofoza ngakwesokudla ngesitayela seseli ukuvula imenyu yemenyu bese ukhetha Ukuguqula ukuvula ibhokisi lengxoxo yesitayela ;
3. Ebhokisini lebhokisi lengxoxo, chofoza inkinobho yefomathi ukuze uvule ebhokisini lengxoxo yefomathi yefomathi
4. Kulobhokisi lebhokisi, chofoza kumathebhu ahlukahlukene ukuze ubuke izinketho ezitholakalayo;
5. Sebenzisa zonke izinguquko ezifisiwe;
6. Chofoza OK ukuze ubuyele ebhokisini lengxoxo yesitayela ;
7. Ebhokisini lebhokisi lengxoxo, ngaphansi kwesigatshana esithi I- Style Includes (Ngesibonelo) , cima amabhokisi okuhlola kwanoma yikuphi ukufometha okungafunwa.
8. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela.

Kuleli phuzu, isitayela se-modified cell sizobuyekezwa ukuze sibonise izinguquko.

08 kwezingu-10

Ukufaka isitayela seselula esivele sikhona

Dala impinda yesitayela esakhelwe ngaphakathi noma isitayela esingokwezifiso usebenzisa izinyathelo ezilandelayo:

1. Ethempelini laseKhaya lebhebhoni, chofoza isithonjana se- Cell Styles ukuvula igalari yeselula .
2. Chofoza ngakwesokudla ngesitayela seseli ukuze uvule imenyu yesimo bese ukhetha Duplicate ukuvula ibhokisi lengxoxo yesitayela ;
3. Ebhokisini lengxoxo yesitayela , thayipha egameni lesitayela esisha;
4. Kuleli phuzu, isitayela esisha singashintshwa ngokusebenzisa izinyathelo ezibalwe ngenhla ukuze uguqule isitayela esivele sikhona;
5. Chofoza OK ukuvala ibhokisi lengxoxo bese ubuyela ekhasini lokusebenzela.

Igama lesitayela esisha lengezwe phezulu kwegalari yesitayela seselula ngaphansi kwesihloko sangokwezifiso .

09 kwezingu-10

Ukususa Ukufometha kwesitayela se-Cell kusuka Amaseli E-Worksheets

Ukususa ukufometha kwesitayela seseli kumaseli wedatha ngaphandle kokususa isitayela seseli.

1. Khetha amangqamuzana afakwe ngesitayela seseli ofuna ukususa.
2. Ethempelini laseKhaya le-ribbon, chofoza isithonjana seSlides Styles ukuze uvule igalari yesitayela se-Cell Styles ;
3. Esigabeni Esihle, Esibi, Nesithakazelo eduze naphezulu kwegalari, chofoza inketho evamile ukususa konke ukufometha okusetshenzisiwe.

Qaphela: Izinyathelo ezingenhla zingasetshenziswa futhi ukususa ukufometha okuye kwasetshenziselwa ngesandla ukwenza amasekhondi okusebenza.

10 kwangu-10

Ukususa isitayela seselula

Ngaphandle kwesitayela esivamile, esingenakususwa, zonke ezinye izitayela zesitayela ezakhelwe ngaphakathi neziko zingasuswa kwigalari yeselula .

Uma isitayela esisusiwe sisetshenziswe kunoma yimaphi amangqamuzana kushidi lokusebenzela, zonke izinketho zokufometha ezihambisana nesitayela esusiwe zizosuswa kumaseli athintekile.

Ukususa isitayela seseli:

1. Ethempelini laseKhaya lebhebhoni, chofoza isithonjana se- Cell Styles ukuvula igalari yeselula .
2. Chofoza ngakwesokudla ngesitayela seseli ukuze uvule imenyu yesimo bese ukhetha Susa - isitayela seseli sisuswa ngokushesha kugalari.