Zvimiso formatting muna MS Excel - zvishoma-anozivikanwa divi chakakurumbira spreadsheet

Mhuri muhofisi zvivezwa ose Microsoft Corporation pasi Excel zita riri dungwerungwe simba spreadsheet processors dzakakurumbira chaizvo zvose zvavo vanoshandisa pachake kombiyuta uye vanachiremba nhete Profile iyo yakatarwa iyi zvikuru-software maturusi vagara kuva chinokosha zvikuru mubasa akarongeka, Graphics , uye zvimwe Statistical mashoko.

Ichi Software chigadzirwa chiri Michina ruzivo rakagadzirirwa nenyanzvi kubudiswa guru mashoko seti. Excel unokubvumira michina zvakajeka formalize kuti Implementation ane zvakasiyana-siyana zvakafanana computations, uyewo kuti processing kusanganiswa uye zvakawedzerwa mashoko ari bhuku guru.

Somuenzaniso, kuita makasimba, yakarurama uye vakarongeka kuongorora mari, mari mitero, etc. Key zviri software iyi simba yagara zvakanaka kudzidza nevanhu wekuongorora. Asi Excel anezvakawanda wezvakavanzika uye mazano anozivikanwa chete rakamanikana pedenderedzwa unyanzvi. Rimwe mapato aya chakavanzika ndokunge formatting. basa iri rinopa akasiyana chaizvo zvakawanda kujairika zvinhu.

The mudziyo, yainzi "zvimiso formatting" zvinoita kuti vabudirire zvikuru dzinonakidza migumisiro uye zvinoshamisa kuona chiitiko kuchifinha date pazvinhu. Mukana kushandisa basa iri kugadzirisa matambudziko akasiyana-siyana uye vari siyana chaizvo. Zvimiso formatting kunoita kumanikidza mumwe muchitokisi youduku maererano mukati kana zvakafanorongwa ezvinhu. Izvi mhando formatting zviri nyore uye zvikuru lucid mu pokuongorora guru mashoko pazvinhu.

Zvimiso formatting kuna Excel, pasina kupamhidzira, riri simba mudziyo inovhura kusingaenzaniswi tarisiro kushanda Spreadsheets uye kubvumira kuti matsva Kutarira siyana akaoma nenhamba. Chaizvo ichi chinoshamisa mukana kutarisa zvose zvemarudzi zvokuratidzira mapepa. Zvimiso zvinogona kuita nyore kuwana kusara siyana, kukuvhiringidza kubva zvinonyatsorehwa akatevedzana Data. Maitiro inokosha uyewo haana inonyangarika kubva muongorori maonero. Izvi zvinogona zvikuru kubatsira vari kubudiswa Statistical mashoko. Zvimiso formatting muna Excel 2007 rine zvimwe zvinonakidza akura features, akadai ruvara gradients, zvakasiyana shading Data mitsetse, anokosha mifananidzo vari kuwedzera masero uye anobvumira kuti nokukurumidza kuronda kudyidzana pakati siyana zviratidzo.

Use zvimiso formatting kuri nyore chaizvo - mashomanana mbeva the clicks. Toti ukaronga tafura dzimwe masero kuti rine zvimwe parameters. Unofanira kuchinja sero ukaguta mavara maererano nokuchinja kusanganiswa mashoko tsika zviri mazviri. Somuenzaniso, kana sero chine kunaka nhamba, izvozvo vachangoerekana kuzadza ruvara rakatsvuka, uye kana zvakanaka - green.

Kuti aite izvi, chete vanofanira kushandisa "Format" Muterere, baya chinhu umo "CONDITIONAL formatting". Muchitokisi ichi, izvo zvakafanira kuisa zvinodiwa format, zvinofanira pachena. Munyaya nhaurirano bhokisi "CONDITIONAL formatting" unofanira kutaridzwa ezvinhu pasi iyo muchitokisi uye kushandura noruvara mukaguta. Tiine bhatani "Format" zvakafanana bhokisi nhaurirano kutsanangura achida kuonekwa.

Kana uchida kuchinja formatting mumwe muchitokisi chimwe, zvichienderana data, ipapo zvakafanira kushandisa kuti "nzira" kuti kuruboshwe donhwe-pasi nyora bhokisi ndokunge zvinogona. Kure pakati pamakamuri hazvina basa. The yemaitiro rinogonawo kuva chero: kunyange dzemaitirwe pamusoro Statistical kukosha, kunyange kukosha depreciation kuti midziyo. Somuenzaniso, kana uchida, apo sero A1 ndiyo vakawanda kubva mana, sero chaiyo kana masero akawanda azviwanira yeyero aguta, zvino, sezvo mamiriro, kupinda mutoo: "= Mod (A1, 4) = 0." Zvadaro shandisa "Format" bhatani kuti kutaridzwa kutsvakwa mukaguta ruvara. Uyezve, maererano kungatonziwo uye pasting formatting iri zvaitambidzwa sero zvaaida kana chikuva.