Mashandisiro eZvitaera muMicrosoft Excel - Chikamu 2

Muchikamu chechipiri chechinyorwa, iwe uchadzidza mamwe matekiniki epamusoro ekushanda nematayera muMicrosoft Excel.

Muchikamu chino, iwe uchaona machinjiro eiyo default Excel masitaera uye nekuagovera pakati pemabhuku ebasa. Pano iwe unowana mamwe mazano ekukubatsira kuti uwane zvakanyanya kubva mukushandisa zvitaera muMicrosoft Excel.

Nzira yekushandura sei preset style?

Iwe unogona kushandura chero preset maitiro, zvisinei, haugone kushandura zita rayo!

Kushandura chinhu chechimwe chemaitiro emaitiro:

1. PaExcel Ribhoni enda ku: Home (Kumba) > Styles (Maitiro) > Zvitaera zvemasero (cell styles).
2. Kurudyi tinya pane maitiro aunoda kuchinja uye tinya Shandura (Shandura).
3. Bvisa mabhokisi ari padyo neakagoneswa maitiro, kana kudzvanya bhatani zera (Format) uye shandura hunhu musero fomati dialog box.
4. Sarudza iyo yaunoda fomati uye tinya OK.
5. dzvanya OK mubhokisi rekutaura sitaira (Style) kupedzisa kugadzirisa.

Nzira yekugadzira yako wega chimiro chitsva?

Ini pachangu, ini ndinosarudza kugadzira masitayera matsva pane kugadzirisa masitaera eMicrosoft, nechikonzero chiri nyore chekuti iwe unogona ipapo kupa chimiro chakagadzirwa zita rine musoro. Asi iyi inhau yechisarudzo chomunhu oga!

Pane nzira mbiri dzekugadzira chimiro chitsva:

Method 1: Kopa maitiro kubva muchitokisi

Kukopa mafomati esero echimiro chitsva:

1. Fomati sero nenzira yaunoda kuti chimiro chitsva chitaridzike.
2. dzvanya Home (Kumba) > Styles (Maitiro) > Zvitaera zvemasero (Sero Zvitaera) paMicrosoft Excel Ribhoni.
3. Sarudza chinhu New Cell Style (Gadzira Cell Style), bhokisi rekufomatidza dialog richaonekwa. Ziva kuti mafomati epafafitera aya akazadzwa nezvirongwa zvakarongwa mudanho rekutanga.
4. Ipa chimiro zita rakakodzera.
5. dzvanya OK. Ndokumbira utarise kuti ikozvino chimiro chako chitsva chave kuwanikwa muhwindo rekusarudza chimiro pasi tsika (Custom).

Nzira 2: Gadzira Chimiro Chitsva muBhokisi reMafomati Dialog

Neimwe nzira, unogona kugadzira chimiro chitsva mubhokisi refomati. Nokuda kweizvi:

1. dzvanya Home (Kumba) > Styles (Maitiro) > Zvitaera zvemasero (Sero Zvitaera) paMicrosoft Excel Ribhoni
2. Sarudza chinhu New Cell Style (Gadzira Cell Style) kuti uvhure bhokisi rekufomatidza dialog.
3. dzvanya zera (Format) kuvhura bhokisi rebhokisi remaseti efomati.
4. Rondedzera yaunoda mafomati maseru sarudzo wobva wadzvanya OK.
5. dzvanya OK pahwindo sitaira (Style) kugadzira chimiro chitsva.

Nzira mbiri idzi dzichagadzira chimiro chetsika mubhuku rako rekushanda.

Mazano anobatsira: Usafe zvakare kutambisa nguva nemaoko kuseta masero, shandisa masitaira kubasa, kudzora mafomati zvigadziriso nekukurumidza uye zvakanyanya nekuita nemamenu ezvitaera.

Usambofa wakagadzira chimiro chakafanana kaviri! Kunyangwe manyorerwo akachengetedzwa chete mubhuku rebasa raakagadzirwa, zvinokwanisika kutumira kunze (kubatanidza) masitaera kubhuku rebasa idzva uchishandisa basa rekubatanidza.

Nzira yekubatanidza sei masitaera emabhuku maviri ebasa?

Kufambisa masitayera pakati pemabhuku ebasa:

1. Vhura bhuku rebasa rine manyorerwo aunoda uye bhuku rebasa iro manyorerwo acho achatumirwa kunze kwenyika.
2. Mubhuku raunoda kunamira manyorerwo acho, tinya Home (Kumba) > Styles (Maitiro) > Zvitaera zvemasero (Sero Zvitaera) paMicrosoft Excel Ribhoni
3. Sarudza chinhu Merge Styles (Merge Styles) kuvhura dialog box sezvakaratidzwa pazasi.
4. Sarudza bhuku rine maitiro aunoda (munyaya yangu ndiro bhuku styles template.xlsx, iro roga bhuku rebasa rakavhurika kunze kwerinoshanda).
5. dzvanya OK. Ziva kuti masitayera echivanhu akabatanidzwa uye ave kuwanikwa kuti ashandiswe mubhuku rebasa raunoda.

Mazano anobatsira: Iwe unogona kuchengetedza masitaera esero aunoda mubhuku rekushanda rakasiyana kuti zvive nyore kusanganisa nemabhuku ebasa, pane kutsvaga nekusingaperi mafaera akapararira pamaforodha akawanda pakombuta yako.

Nzira yekubvisa sei chimiro chetsika?

Kubvisa chimiro chiri nyore sekugadzira. Kubvisa chimiro chetsika:

1. Mhanya: Home (Kumba) > Styles (Maitiro) > Zvitaera zvemasero (Sero Zvitaera) paMicrosoft Excel Ribhoni.
2. Tinya kurudyi pamaitiro auri kuda kudzima.
3. Sarudza murairo kubva pane menyu Kudzima (Delete).

Zvese ndezvekutanga! Hapana acharamba kupfava kwechishandiso ichi!

Zviripachena, munhu wega wega achasarudza nzira idzo chishandiso chakapihwa chingashandiswa kuvandudza kugona. Kuti ndikupe chikafu chekufunga, ini ndinokupa mamwe ezvangu mazano ekushandisa masitaera muMicrosoft Excel.

Mashandisiro aungaita Zvitaera muMicrosoft Excel

• Kugadzira kuwirirana kwakazara mumagwaro ako kana zvinyorwa zvechikwata chako / kambani.
• Kudzikisira kwakakosha mukuedza uchitsigira sero fomati mune ramangwana.
• Iko kugona kugovera chimiro chetsika nemumwe munhu asingakwanise kugadzira yavo maitiro nekuda kwehunyanzvi kana nguva yekunetsa.
• Kuseta masitaera ane manhamba efomati yaunoshandisa nguva zhinji. Ndiri kufara kuti pakupedzisira ndine tsika yekumisikidza kumisikidzwa: # ##0;[Red]-# ##0like style.
• Kuwedzera zviratidzo zvinoonekwa zvinoratidza basa uye chinangwa chesero. Input masero - mune imwe maitiro, maseru ane mafomula - mune imwe, kubuda maseru - mune yechitatu dhizaini, zvinongedzo - mune yechina.

Wakafunga kushandisa zvitaera muMicrosoft Excel? Ndine chivimbo chekuti chishandiso ichi chinogona uye chichavandudza kugona kwako. Nei achiramba asingafarirwi? - mubvunzo uyu unondivhiringa !!!

Iwe une mamwe mazano ekuti ungashandisa sei zvitaera muExcel spreadsheets? Sei uchifunga kuti tinorerutsa kukosha kwechishandiso ichi? Wakawana chinyorwa ichi chichibatsira here?

Ndapota siya mhinduro dzako pazasi! Mazano uye mhinduro inogamuchirwa!