UkuFometha iiStyles

Olu qeqesho lugubungela ukusebenzisa izitayela zokufomathiza kwangaphambili kwi-Excel kunye nemimiselo yesinyathelo kunye neyinyathelo.

01 ngo-10

Ukusebenzisa izitayela zokufometha

Kule nyathelo, siza kusebenzisa iifayile zokufometha zangaphambili ze-Excel ukuze ungeze umbala kwiphepha lethu lomsebenzi . Ukwenza oko akunikezeli nje ukujonga okubonakalayo, kodwa kungenza kube lula ukufunda nokutolika idatha yeshidi.

Ngokuchanekileyo, siya kusebenzisa i-shading kwiifom zokwenza umsebenzi kwiimigangatho 2 no-7 kunye nemigca 3 no-6 usebenzisa iindlela zokufomathiza zeStyles ezikwiphepha laseKhaya lebhebhoni .

Ukwenza imizamo yethu iphumelele, siza kukhetha iiseli ezingasondelene zedatha isebenzisa ukhiye weCtrl kwibhodibhodi. Oku kuya kusenza sikwazi ukusebenzisa ifomathi kuzo zonke iiseli ezigqityiweyo ngexesha elifanayo.

Ukongeza i-Shading ukuya kwi-Worksheet Headings

1. Cofa kwifayile yedibaniso edibeneyo kumqolo 2.
2. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
3. Hudula ukhetha iiseli ze-A7 ukuya kwi-F7 ukuze zigqityiwe kunye nefowuni yesigxina.
4. Ukukhulula ikhiye ye Ctrl .
5. Cofa kwitolo elihlayo ekupheleni kweelwimi zezetekethi ezikhoyo.
6. Khetha ukhetho lwe- Accent 3 kwiindlela ezikhoyo.
7. Zombini iiseliti zefayile ezidibeneyo kunye nezihloko ezikumqolo wesi-7 mazibe ne-text background emhlophe.
8. Ukuze wenze umbhalo omhlophe ubonakale ngakumbi, nqakraza kwi- Bold icon kwi-Ribbon.
9. Ikhonkco enesibindi yileta ebomvu B ngaphantsi kwecandelo lomgca webhebhoni.

Ukongeza i-Shading ukuya kwiiNdlu 3 no-6

1. Hudula ukhethe iiseli ze-A3 ukuya kwi-F3 ukuzigqamisa.
2. Cinezela kwaye ubambe iqhosha le Ctrl kwikhibhodi.
3. Hudula ukhetha iiseli ze-A6 ukuya kwi-F6 ukuzigqamisa kunye neeseli ze-A3 ukuya kwi-F3.
4. Cofa kwitolo elihlayo ekupheleni kweelwimi zezetekethi ezikhoyo.
5. Khetha u- 40% - ukhetho lwe- Accent 3 ukusuka kwiifayile ezikhoyo.
6. Iiseli ze-A3 ukuya kwi-F3 kunye ne-A6 ukuya kwi-F6 kufuneka ngoku zifumane imvelaphi eluhlaza kunye nombhalo omnyama.

02 ngo 10

Iifayile zeeString Overview

Isitayela seeselula kwi-Excel yintlangano yeendlela zokwenza ifomathi - ezifana nobukhulu bomnxeba kunye nombala, amafomathi amanani , kunye nemida yomgca, kunye ne-shading - ebizwa 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.

03 ngo 10

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.

04 we-10

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.

05 we-10

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.

06 ngo 10

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.

07 ngo 10

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.

08 ngo 10

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 .

09 we-10

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.

10 kwi-10

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.