Dala, Kopisha, futhi Ushintshe Amathekthini E-Cell Custom ku-Excel

Sebenzisa izitayela zeselula ukuze uthole amafomu okusebenza okusheshayo okufometha

Isitayela seseli ku-Excel kuyinhlanganisela yokhetho lokufometha - njengama-font nobukhulu bombala, amafomu 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.

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.

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.

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.

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.

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.

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 .

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.

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.