Yakha, Kopisha, kwaye Uguqula izitayela zeeStown Custom kwi Excel

Sebenzisa iiStyles zeSeli ukuFakela ngokukhawuleza amaFebhu okusebenzela

Isitayela seeselula kwi-Excel yintlangano yeendlela zokwenza ifomathi - ezifana nobukhulu befonti kunye nombala, amafomathi amanani , kunye nemida yeeselfowuni, kunye ne-shading - ebizwa ngokuba yigama kwaye igcinwe njengenxalenye yeshidi lomsebenzi .

I-Excel inezindlela ezininzi ezakhiweyo zeseli ezingasetyenziswa njengephepha lokusebenzela okanye ziguqulwe njengoko zifunwayo. Ezi zakhiwo ezakhiweyo zingasetyenziswa njengesiseko seendlela zeselula ezingasindiswa kwaye zabiwe phakathi kweencwadi zokusebenzela .

Enye inzuzo ekusebenziseni izitayela kukuba ukuba isitayela yeselungiso ishintshiwe emva kokuba isetyenziswe kwiphepha lokusebenzela, zonke iiseli ezisebenzisa isitawu ziya kuhlaziywa ngokuzenzekelayo ukuze zibonise utshintsho.

Ngaphezulu, izitenfini zeeseli zingabandakanya i- Excel yokukhiya iiseli zesici ezingasetyenziselwa ukuthintela utshintsho olungagunyazisiweyo kwiiseli ezithile, iifayile ezisebenzayo, okanye zonke iincwadi zokusebenzela.

Izitayela zeSeli kunye neNcwadi zeZihloko

Izitayela zeselula zisekelwe kwimixholo yomxholo esetyenziswe kwincwadi yonke yomsebenzi. Izihloko ezahlukeneyo zineenketho ezahlukeneyo zokufometha ukuze ukuba umxholo wombhalo utshintshwe, izitayela zeseli zolu xwebhu ziguqukile.

Ukusebenzisa isakhiwo seSeli esakhiweyo

Ukusebenzisa enye yeendlela zokufometha ezakhelwe kwi-Excel:

1. Khetha uluhlu lweeseli ezizofomathiweyo;
2. Kwiphepha laseKhaya lebhoni , cofa kwiStyles Styles icon ukuvula igalari yezindlela ezikhoyo;
3. Cofa kwisitayela eselunqwenela ukufaka isicelo.

Ukudala iStown Style Style

Ukudala isitayela yeseli yesimo:

1. Khetha isisethi esisodwa sephepha;
2. Faka isicelo zonke iindlela zokwenza ifomathi ezifunwayo kule seliyi - isitayela esakhelwe singasetyenziswa njengendawo yokuqala;
3. Cofa kwiThebhu yaseKhaya kwibhere.
4. Cofa kwiCandelo leStyles Styles kwi-Ribbon ukuvula igalari yeSelfyles.
5. Njengoko kuboniswe kumfanekiso ongentla, nqakraza kwikhetho elitsha lesitayela sezantsi phantsi kwegalari ukuvula ibhokisi yencoko yencoko ;
6. Thayipha igama lesitayela esitsha kwibhokisi legama lomdlalo;
7. Izinketho zokufomatha ezisetyenziswe kwisisele ekhethiweyo ziya kubalwa kwibhokisi yencoko.

Ukwenza ukhetho olongezelelweyo lwefomathi okanye ukuguqula ukhetho olukhoyo:

1. Cofa kwiqhosha leFomathi kwibhokisi yencoko yencoko yokuvula ibhokisi yencoko yencoko yeefom.
2. Cofa kwi-bhokisi kwibhokisi yencoko ukujonga okukhethwa kukho;
3. Faka isicelo zonke iinguqu ezifunwayo;
4. Cofa Kulungile ukubuyela kwibhokisi yencoko yencoko;
5. Kwibhokisi yencoko yencoko, phantsi kwecandelo elinesihloko esithi Style Includes (By Example) , cima ibhokisi yokubhekisisa nayiphi na ifomathi engayifuni.
6. Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela.

Igama lohlobo olutsha longezwa phezulu kwigalari yeStyles Styles phantsi kwesihloko sokwemvelo njengoko kuboniswe kumfanekiso ongentla.

Ukusebenzisa isitayela esitsha kwiiseli kwiphepha lokusebenzela, landela uluhlu lwamanyathelo angentla ngenjongo yokusebenzisa isitayela esakhelwe.

Ukukopisha iiStyles zeSeli

Ukukopa isitayela eselungileyo yesetyenziselwa ukusetyenziswa kwincwadi eyahlukeneyo:

1. Vula incwadi yokubhala equkethe isitayela esiqhelekileyo ukuba ikopiwe;
2. Vula incwadi yokusebenzela ukuba isitayela ikopishwe.
3. Kule ncwadi yesibini, nqakraza ithebhu yaseKhaya kwibhere.
4. Cofa kwi icon Styles Styles kwi-Ribbon ukuvula igalari yeSelfyles.
5. Cofa kwiKhetho lokudibanisa izitayela ngaphantsi kwegalari ukuvula ibhokisi yencoko yodidi lokudibanisa .
6. Cofa kwigama lencwadi yokusebenzela equkethe isitayela sokukopishwa;
7. Cofa u-OK ukuvala ibhokisi yencoko.

Kulo nqaku, ibhokisi lokulinda liya kuvela ukuba libuze ukuba ufuna ukudibanisa izitayela negama elifanayo.

Ngaphandle kokuba unezithethe zenkcubeko kunye negama elifanayo kodwa ukhetho oluhlukeneyo lwefomathi kwiincwadi zombini zomsebenzi, ezikuthi, ngendlela engazange ibe yinto efanelekileyo, nqakraza iqhosha leEwe ukugqiba ukudluliselwa kwesitayela kwincwadi yokusebenzela.

Ukuguqula isimboli seSeli

Kwiifayile ezakhelwe ngaphakathi ze-Excel, ngokuqhelekileyo kukulungele ukuguqula impinda yesitayela kunokuba isitala ngokwayo, kodwa zombini izitayela ezakhiweyo kunye neziko zingaguquzwa ngokusebenzisa amanyathelo alandelayo:

1. Kwiphepha laseKhaya lebhoni, cofa kwiStyles Styles icon ukuvula igalari yeSelfyles.
2. Cofa iqhosha kwisitratli seseli ukuvula imenyu yomongo kwaye ukhethe Ukuguqula ukuvula ibhokisi yencoko yencoko;
3. Kwibhokisi yencoko yebhokisi, qhosha kwiqhosha lokuFometha ukuvula kwibhokisi yencoko yencoko yefomathi
4. Kule bhokisi yencoko, nqakraza kwiifayile ezahlukeneyo ukujonga okukhethwa kukho;
5. Faka isicelo zonke iinguqu ezifunwayo;
6. Cofa Kulungile ukubuyela kwibhokisi yencoko yencoko;
7. Kwibhokisi yencoko yencoko, phantsi kwecandelo elinesihloko esithi Style Includes (By Example) , cima ibhokisi yokubhekisisa nayiphi na ifomathi engayifuni.
8. Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela.

Kule ngongoma, isitayela eselungisiweyo esilungisiweyo iya kuhlaziywa ukubonisa utshintsho.

Ukuphindaphinda isitayela seSeli ekhoyo

Yenza impinda yesitayela esakhelwe kuyo okanye isitayela esiqhelekileyo usebenzisa amanyathelo alandelayo:

1. Kwiphepha laseKhaya lebhoni, cofa kwiStyles Styles icon ukuvula igalari yeSelfyles.
2. Ukucofa kwesokudla kwiseli yeseli ukuvula imenyu yomongo kwaye ukhethe Ukuphindaphindiweyo ukuvula ibhokisi yencoko yencoko;
3. Kwibhokisi yencoko yencoko, thayipha kwigama lesitayela esitsha;
4. Kule ngongoma, isitayela esitsha sinokutshintshwa ngokusebenzisa amanyathelo alwe apha ngentla ngokuguqula isitayela esele sikhona;
5. Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela.

Igama lohlobo olutsha longezwa phezulu kwigalari yeStyles Styles phantsi kwesihloko sabantu .

Ukususwa kohlobo lwefowuni lokufometha kwiiSebenzi zeeSetekethi

Ukususa ifomathi yesitayela yeseli kwiiseli zedata ngaphandle kokususa isitayela seseli.

1. Khetha iiseli ezifomathiweyo ngesitayela esele ofuna ukususa.
2. Kwiphepha laseKhaya lebhebhoni, nqakraza kwi- Cell Styles icon ukuze uvule igalari yeSelfyles Styles ;
3. Kwinqanaba elungileyo, elibi, nelingathathi hlangothi elikufuphi phezulu kwegalari, nqakraza kwiNketho eqhelekileyo ukususa zonke iifomati ezisetyenziswayo.

Qaphela: Amanyathelo angentla angasetyenziselwa ukususa ifomathi esetyenzisiweyo ngesandla ukuba isebenzise iiseli zesebe.

Ukususa isitayela seSeli

Ngaphandle kwesitayela esiqhelekileyo , esingenakususwa, zonke ezinye izakhelo zesakhelo kunye neziko zingasuswa kwigalari yeSelfyles.

Ukuba isitayi esusiwe sisetyenziswe nakweyiphi iiseli kwiphepha lokusebenzela, zonke iindlela zokufomatha ezihambelana nesitayi esusiweyo ziya kususwa kwiiseli ezichaphazelekayo.

Ukususa isitayela yeseli:

1. Kwiphepha laseKhaya lebhoni, cofa kwiStyles Styles icon ukuvula igalari yeSelfyles.
2. Ukucofa kwesokudla kwiseli yeseli ukuvula imenyu yomongo kwaye ukhethe Susa - isitayela yeselula isuswa ngokukhawuleza kwigalari.