Gadzira, Kopa, uye Gadzirisa Maitiro eStest Styles muExpcel

Shandisai Cell Styles kuti Udzidze Mafashiti Maawa

Sero maitiro muExcel inosanganiswa kwekufambisa-sarudzo - zvakadai semasikisi emhando uye marara, mafomu emitauro , uye miganero yemasero, uye shading - iyo inodanwa uye inoponeswa sechikamu chebasa rekushanda .

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.

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.

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.

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.

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.

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.

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.

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.

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.