Excel Formatting Styles

Iyi tutori inoshandisa kushandiswa kwekugadzirisa mafashoni eku Excel nemitemo-nhanho-nhanho.

01 yegumi

Kushandisa Kufambisa Mitambo

Mutsamba iyi, tichashandisa maitiro ekugadzirisa maitiro ekugadzirisa Excel kuti tiwedzere rumwe ruvara kune pepa rekushanda kwedu. Kuita izvi hakungoripa chete kutarisa kwakajeka, asi kunogonawo kuita kuti zvive nyore kuverenga nekududzira dhesi rekushanda.

Kunyanya, tichashandisa shading kumusoro webasa riri mumiganhu ye2 ne7 uyewo mitsetse 3 ne6 tichishandisa maitiro ekudisa maTesita ari paImba yebhu yebhoni .

Kuita kuti shingaira dzedu dziwedzere kushanda, tichasarudza zvisingasviki masero ematare uchishandisa Ctrl key pa keyboard. Izvi zvichatibvumira kuti tishandise mafomati kune masero akaiswa pachena panguva imwe chete.

Kuwedzera Shading ku Worksheet Headings

1. Dzvanya pane zvakabatanidzwa zita rekero mumuganhu 2.
2. Dhinda uye ubatisise kamba Ctrl pane keyboard.
3. Draganisa sarudza masero A7 kusvika kuF7 kuti avasimbise uye pamwe chete nekodzero yesero chekiti.
4. Bvisa Ctrl .
5. Dzvanya pamusana wemusara wepamusoro pakuguma kweiyo mazita emhando.
6. Sarudza Chibvumirano 3 chisarudzo kubva pamitambo iripo.
7. Izvo zvose zvakabatanidzirwa sekipi uye zvinyorwa mumutsara 7 zvinofanira kunge zvino zvine ruvara rwemashoko akachena magwaro.
8. Kuita kuti magwaro matsvene aoneke zvishoma, bhura paBold icon pabhoni.
9. Icho chinonyanya kushandiswa ndeye mutsvuku B B pasi petiyiti chikamu chebhoni.

Kuwedzera Shading kuRow 3 uye 6

1. Draganisa sarudza masero A3 kusvika kuF3 kuti uonekwe.
2. Dhinda uye ubatisise kamba Ctrl pane keyboard.
3. Dragodza masero A6 kusvika kuF6 kuti uonekwe pamwe chete nemasero A3 kusvika kuF3.
4. Dzvanya pamusana wemusara wepamusoro pakuguma kweiyo mazita emhando.
5. Sarudza 40% - Accent 3 sarudzo kubva pamitambo iripo.
6. Masero A3 kusvika kuF3 uye A6 kusvika kuF6 anofanira kunge ave nechiedza chakasvibirira chine mutsvuku.

02 yegumi

Cell Styles Overview

Sero musimboti muExcel inosanganiswa yekusarudza maitiro - akadai semasikisi emhando uye marara, mafomu efoni , uye masero emasero, uye shading - iyo inodanwa uye inochengetwa sechikamu chebasa.

Excel ine dzakawanda dzakavakwa mumasero esero zvinogona kushandiswa sezvinoitirwa pepa rekushandura kana kuchinjwa sezvinodiwa. Aya maitiro akavakwa anogonawo kushanda sechikonzero chetsika yemasikirini emaitiro anogona kuchengetedzwa uye kugoverana pakati pebhuku rebasa.

Imwe nzira yekushandisa michina ndeyokuti kana sero yekare ishandiswa mushure mekunge yaiswa mune pepa rekushanda, masero ose anoshandisa chimiro achazongoshandiswa patsva kuti aratidze kuchinja.

Uyezve, maitiro esero anogona kusanganisira Excel's lock cell features iyo inogona kushandiswa kudzivirira kuchinja kusina mvumo kune mamwe masero, mapepa ese ebasa, kana mabhuku ose ebasa.

03 wegumi

Cell Styles uye Document Themes

Maitiro esero anobva pamusoro wehurukuro iyo inoshandiswa kune rimwe bhuku rebasa. Misoro yakasiyana ine zvinyorwa zvakasiyana-siyana zvekufambisa kuitira kuti kana dhiyabhorosi isingashandurwi, maitiro esero edhiyo iroro zvakare anochinja.

04 yegumi

Kushandisa Imba Yakagadzirwa MuShona

Kushandisa imwe yezvakavakwa mumasikirwo ekugadzira mafaira mu Excel:

1. Sarudza uwandu hwemasero kuti hufananidzwe;
2. PaImba yebhu yebhoni, tsvaga paStest Styles icon kuti uzarure guritsa remafiripe anowanikwa;
3. Dzvanya pane yaidiwa seyero yesero yekushandisa.it.

05 of 10

Kugadzira Chero Cell Cell Style

Kugadzira tsika yechimiro chema cell:

1. Sarudza imwe sarashiti yeshizha;
2. Isa zvose zvingasarudzwa zvekufambisa maitiro pane sero iri - chivakwa chakachengetwa chinogona kushandiswa sekutanga;
3. Dzvanya paImba yebhu paibhoni.
4. Dzvanya pa Cell Styles chisarudzo paibhoni kuti uzarure Cell Styles gallery.
5. Sezvinoratidzwa mumufananidzo wepamusoro, chengetedza Iko itsva yesero maitiro pazasi kwei gallery kuti uzarure Style dialog box ;
6. Tora zita renzvimbo itsva musimboti Name name box;
7. Izvo zvingasarudzwa zvekufambisa zvakashandiswa kune imwe sero yakasarudzwa zvichaiswa mubhokisi rebhokisi.

Kuti uite mamwe maitiro ekufambisa kana kuchinja zvisarudzo zvezvino:

1. Dzvanya paIndaneti yeBhizimusi muItaly dialog box kuti uzarure maDenesi eDaily dialog box.
2. Dzvanya pane tabha mubhokisi rebhokisi kuti uone zviripo zvaunogona;
3. Isa zvose zvaunoda kuchinja;
4. Dzvanya OK kuti udzoke kuItambo dialog box;
5. Mumutambo dialog box, pasi pechikamu chinonzi Style Includes (Nomuenzaniso) , tsanidza mabhokisi ekutsvaga chero upi hwekufambisa husingadiwi.
6. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda.

Zita idzva remutauro rinowedzerwa kumusoro kweScell ​​Styles gallery pasi peChirongwa cheStudio sezvinoratidzwa mumufananidzo uri pamusoro.

Kuti ushandise chimiro chitsva kumasero ari mune pepa rekushanda, tevera maatanho ezvinyorwa pamusoro apa kushandisa shanduro yakagadzirwa.

06 of 10

Kukopa Cell Styles

Kukopa tsika yechimiro chemaitiro yekushandisa mune rimwe bhuku rebhuku:

1. Vhura bhuku rebhuku rino rine tsika yechimiro inofanira kunyorwa;
2. Vhura bhuku rebhuku iro chimiro chiri kunyorwa.
3. Muchikoro chechipiri ichi, chengetera Home tab paibhoni.
4. Dzvanya pa Cell Styles icon pane ribhoni kuti uzarure Cell Styles gallery.
5. Dzvanya paKubatanidza Matanho eSync pane pasi pei gallery kuti uzarure Merge Styles dialog box.
6. Dzvanya pazita rebhuku rebhuku rine chinyorwa chinonyorwa;
7. Dzvanya OK kuti uvhare bhokisi rebhokisi.

Panguva ino, bhokisi rekucherechedza richaonekwa richikumbira kana iwe uchida kubatanidza mafaira ane zita rimwe chete.

Kunze kwekunge iwe une tsika yakagadzirwa nemazita akasiyana asi maitiro akasiyana-siyana ekufambisa mumabhuku ose ebasa, ayo, nenzira, haisi iyo pfungwa yakanaka, bhoja bhodhi Yes kuti upedze kutendwa kwemavara mumabhuku ekushandira.

07 pa10

Kugadzirisa Semaawa Anogara Aripo

Kune Excel yakavakwa mumitambo, kazhinji kacho kunakidza kushandura kudhindwa kwemavara pane chimiro pachako, asi zvose zviri mukati uye tsika dzetsika zvinogona kuchinjwa uchishandisa matanho anotevera:

1. PaImba yebhu yebhoni, tsvaga paStest Styles icon kuti uzarure Cell Styles gallery.
2. Tsanangurira-chengetedza pane imwe sefaira kuti uzarure mamiriro ekutenderera uye sarudza Shandura kuti uzarure Shanduko yebhokisi yebhokisi;
3. Mumutambo dialog box, tora pane Bhizimisi bhatani kuti uzarure muIndaneti Cells dialog box
4. Mune iri bhokisi rebhokisi, chengetai pane zvakasiyana-siyana tabs kuti muone zvingawanikwa;
5. Isa zvose zvaunoda kuchinja;
6. Dzvanya OK kuti udzoke kuItambo dialog box;
7. Mumutambo dialog box, pasi pechikamu chinonzi Style Includes (Nomuenzaniso) , tsanidza mabhokisi ekutsvaga chero upi hwekufambisa husingadiwi.
8. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda.

Panguva ino, the modified cell style ichavandudzwa kuti iratidze kuchinja.

08 yegumi

Kuwedzera Muchiri Wemajena Maitiro

Gadzira rupiro rwechimiro chakavakwa kana chimiro chetsika uchishandisa matanho anotevera:

1. PaImba yebhu yebhoni, tsvaga paStest Styles icon kuti uzarure Cell Styles gallery.
2. Chimbidza-chengetedza pane imwe sero yekutengesa kuti uzarure mamiriro ekutenderera uye sarudza Duplicate kuti uzarure Style dialog box;
3. Mumutambo dialog box, tanga muzita remutauro mutsva;
4. Panguva ino, chimiro chitsva chinogona kushandiswa uchishandisa matanho ari pamusoro apa kuitira kuchinja chimiro chiripo;
5. Dzvanya OK kuti uvhare bhokisi rebhokisi uye dzokera kubheji rekushanda.

Zita idzva rezita rinowedzerwa kumusoro kweStest Styles gallery pasi peChemi musoro.

09 yegumi

Kubvisa Cell Style Kufambisa kubva kumashini Epa Worksheet

Kuchenesa maitiro ekufambisa kwemasero kubva mumaseji e data pasina kubvisa sero.

1. Sarudza masero akaenzaniswa neserita yemaitiro yaunoda kubvisa.
2. PaImba yebhu yebhoni, tsvaga paStest Styles icon kuti uzarure Cell Styles gallery;
3. Mune Zvakanaka, Zvakaipa, uye Neutral chikamu pedyo nechokumusoro chemafirimu, chengetedza pane Chinofanira kuitika kuti ubvise maitiro ose akashandiswa.

Cherechedza: Matanho ari pamusoro apa anogona kushandiswa kuti abvise maitiro akashandiswa pamasero ekushanda.

10 pa10

Kusvuta Cell Style

Kunze kwemaitiro akajairika , asingagoni kubviswa, mamwe ose akavakwa-uye mumutauro wesero maitiro anogona kubviswa kubva paS Cell Styles gallery.

Kana chimiro chakabviswa chakanga chakashandiswa kune chero masero ari mubasa rekushanda, zvese zvinoshandiswa pakufambisa zvinosanganiswa nesimboti yakabviswa zvichabviswa pamasero akabatwa.

Kuchenesa sero style:

1. PaImba yebhu yebhoni, tsvaga paStest Styles icon kuti uzarure Cell Styles gallery.
2. Tsanangurira-chengetedza pane imwe sero yekutengesa kuti uzarure mamiriro ekutenderera uye sarudza Delete - sero style yakabva yabviswa kubva pa gallery.