Sei kuwedzera tambo kuna Excel: audzwa, mienzaniso

The "Excel" kubva Microsoft Office - simba spreadsheet mupepeti, izvo zvinoita kwete chete chitoro Data mumitsara neshongwe, asiwo kuti Masvomhu dzakaoma uye kuti vazviise zvabuda ari graphical format.

Nyaya iyi ongorora zvose sei kushandisa pemitsara riri pamusoro nevakawanda pepa mabhuku mukati yakarongerwa mundiro, uye panguva imwecheteyo kudzidza kuisa wechikamu muna Excel-pamusara. Sezvikonzero tinotora 2007 Microsoft Office kusunungurwa.

Mhando tambo kuvhiyiwa mu "Excel"

The iripo akavhiyiwa kushandiswawo mitsetse iri nani zvishoma (isingatsiki mibvunzo pamanyorerwo uye kopi):

• sarudzo;
• namatidza;
• deleting;
• misha;
• transposition.

Ngationei munzira dzipi kuti zvinetso izvi mu "Excel 2007", uye pakutanga, somunhu womumhuri muna Excel mutsetse.

kuti shading

Kakawanda, vanoshandisa 'Excel' chirongwa kuvhiringidzwa rokuti "Highlight" kusarudzwa imwe avakazviita kuti zvakawanda masero.

Mu "Excel 2007" rinowanikwa mutsetse zvinosanganisira 16.384 masero, uye kusimbisa zvawo, tinya kuruboshwe bhatani zvakakwana tinya vakaverengwa misoro, vakaronga vertically kuruboshwe kumucheto jira.

Kana uchida kuti govera mumitsara chete mashomanana masero, tevedzera selection, vakabata pasi kuruboshwe mbeva bhatani. Kana unogona kuwana chimwe muchitokisi, wokudhinda mubatirire Shift + Ctrl kiyi uye, pasina muchisunungura nayo, achizviendesa museve "kodzero" kana "kuruboshwe", zvichienderana iyo nzira zvichaitawo kusarudza.

Yambiro! Hezvino zvimwe nuances. Kana vose sero mitsetse akasarudza isina kana akazara data, ipapo tara mutsetse pakarepo kuguma jira, kureva pamberi. E. nechitokisi nhamba 16, 384. Kana paiva "pakakoromoka muenzaniso" (masero ose vaiva chinhu uye akazadza asangana, kana vakutarisire) , kusarudzwa anomhanya muchitokisi kuti "anosiyaniswa" uye iye, zvakare, achapinda yasarudzwa siyana. Saka, pamwe mubatanidzwa makiyi «Shift + Ctrl + Akasiya / Kodzero" kungwaririra.

zvino isu kuna sei kuwedzera kuva musara muna Excel.

Kuisa mumwe musara itsva

Good kuziva! Line mu "Eksele" nguva dzose akawedzera pamusoro hama kuti sero vakasarudzwa (s), mbiru - kuruboshwe.

Step One. Simbisa foni kana chikuva masero, kana tambo rose izvo kuronga kuwedzera mutsetse itsva.

Step Two. Shandisa kusarudza mumwe remapazi maviri:

• Nokutsikirira kodzero mbeva bhatani kuvhura akapoteredza Muterere, izvo zvinogona kuenda "Isa" uye zvadaro kushandisa redhiyo mabhatani kusarudza 'tambo'. Click "OK", uye pamusoro Sero rako vakasarudzwa (s) ichava mutsetse idzva, chose chinhu.
• On the "Home" yokudimbudzira Ribbon mupumburu kuboka "Masero" - "Insert" - ". Insert mitsara iri jira"

Kuitwa!

Sezvaunogona kuona, mushure Implementation pamusoro kunenge izvi unokwanisa pamusoro mashoko ako zvachose itsva amboita mutsetse.

Saka, sei kuwedzera tambo kuna Excel, tinonzwisisa.

Deleting mumutsara

Kufanana mumutsara itsva akaiswa, achibvisa zvakakwana kuita zviito maviri chete.

Step One. Iwe anoratidza mutsetse uchida uninstall, kana nyore cursor wako chero muchitokisi Napamusara kuti iwe vasingachadi.

Zvikuru! Pasinei waona foni kana chikuva zvichabviswa dzadzimwa rose mutsetse mubhuku zvachose - kureva nyaya "Excel 2007" ari muchitokisi wa1 kusvika 16384 ndipo. Kana chete uchida kubvisa umboo dzako kubva muchitokisi, zvakakwana kushandisa pashure kusarudza Delete bhatani pamusoro kiibhodhi.

Step Two. Kusarudza kubva:

• Kudzvanya kodzero mbeva bhatani kurera chechinyorwa Muterere, izvo kuenda "Kudzima", uye ipapo tichibatsirwa haizoshandisi kusarudza "Line". Press "OK" uye tambo "curdle" sokunge akanga kumbovapo.
• On the "Home" yokudimbudzira kutamira tepi kuboka "Masero" - "zvinomuomera kuikanganwa" - ". Kudzima mitsara kubva jira"

Kufambira mutsetse

By anozunungusa mutsetse zvakare, vakawanda kunzwisisa kufamba zvimwe duku-siyana emasero. Asi muchiitiko chino izvi zvaramba anoita musimboti chiito rakasiyana.

Sarudza mutsetse rose kana masero ayo munhu. Zvadaro kutamisira cursor kuti inowanikwa selection, kuti cursor vanofanira kuchinja uye kutora chimiro yakashatiswa mumufambiro miseve. Batisisa pasi kuruboshwe mbeva bhatani kuti "andobata" masero ako, kune itsva vaida nzvimbo uye kusunungurwa. Kana nzvimbo watama, akanga atova vakazadzwa chero data, iwe vachangoerekana kuzoshandiswa yokutsiva zviri chipfuro masero.

Transposing mitsetse

vanozvishandisa vazhinji "Excel" kuti nokukurumidza kunzwisisa sei kuwedzera tambo kuna Excel, sei kufamba kana kopi, asi transposition anoramba haanzwisisiki vazhinji, uyewo kuvapo yakadaro basa iri chirongwa.

Transposition mutsetse - muitiro unoponesa chinjikira kuti hunyambiri yakatarwa nemasero. Saizvozvowo, mbiru transposition - ndiro neizvi muitiro.

Option, sezvo yokutendeutsa kunogona kuitwa vaviri:

• Sarudza kuwanda masero rwonzi uye kutevera (nokutsikirira yakarurama mbeva bhatani kana mubatanidzwa Ctrl + C). Next, mira pamusoro sero yaunoda kutanga shongwe yako itsva data, svinudzai akapoteredza Muterere "namatidza Special", apo Checkbox "transpose". Kuitwa! Tambo akava mbiru.

• Excel 2007 ane chinokosha - ". Transpose" Kana uchizopa kutendeutsa zvakawanda masero shanu riri kunze kwaasingasvikiri ichi anosimbisawo chaizvo shanu masero, asi akaronga iri shongwe. Tinya chiratidzo "vakaenzana" uye kunyora "Transpose." Open parenthesis uye zvinosimbisa zvenguva yako, iyo iri kuenda kutendeutsa. Ugopfiga chikomboredzo uye wokudhinda Kupinda panzvimbo chete Ctrl + Shift + Enter. Kuitwa!

Zvinofanira kunzwisiswa kuti musimboti wokutanga (chaiwo muwedzero) zviri nani sezvo harishandisi fomura. Kana ukashandisa pfungwa yechipiri, uye ipapo Kudzima yepakutanga tambo, iwe tora zeroes zvose pachinzvimbo tsika dzavo.

Matafura mukati mubhuku uye mamiriro avo

Kunze mureza Pepa mitsara neshongwe kuripo uyewo Excel tafura. Muinyore iri nyore - ". Table" chete sarudza yakarurama chikuva masero, uye ipapo pamusoro Tab "Isa" sarudza Funga kusiyana nzira rokuvhiya mitsara zvakadaro patafura kushanda mitsetse mu kwakajairika bhuku.

Zvinonzi kunzwisisa kuti yavaive zvakafanana masero. Kuti pinza kana zvinomuomera kuikanganwa mitsara kubva akapoteredza menu iripo zvinhu "Insert - Table misara kumusoro" uye "Kudzima - Rows petafura." Uyezve, unogona kuwedzera mutsetse itsva, nokungoita anozunungusa cursor kuti sero pasi rworudyi tafura kutsikirira Tab.

Panewo zviduku kusiyana racho, asi vanoshandisa bedzi headers. Kana iwe sarudza chimwe kana kupfuura masero ane tafura Header, uye kutevera kufamba kwavo, uchaona kuti mashoko chete iwe kutevedzera uye yepakutanga mazita vakaramba panzvimbo. Kana tikaedza yose tafura kutama, ipapo hapana peculiarities, vakatamira pasina matambudziko.

Tinovimba kuti kuratidzwa kwauri zvose zvakavanzika sei kuwedzera tambo kuna Excel, sei kuti zvinomuomera kuikanganwa, kufamba uye transpose mutsetse.