Kushanda muMicrosoft Excel, yekutanga yekutanga kudzidza kuisa tambo uye makoramu patafura. Pasina hunyanzvi uhu, hazvigoneke kushanda neTabular data. Ngatitorei nemaitiro ekuwedzera iyo ikholamu mukubuditsa.
Chidzidzo: Maitiro ekuwedzera iyo ikholamu mune yeMicrosoft Word Tafura
Insert column
Mukurinda, pane nzira dzinoverengeka dzekuisa chikamu pane pepa. Vazhinji vavaive nyore, asi mushandisi weumbozha anogona kunge asingabve pakarepo nezvose. Uye zvakare, pane sarudzo yekuwedzera otomatiki inowedzera tambo kurudyi rwetafura.Nzira 1: Insert kuburikidza neyekurongedza panel
Imwe yenzira dzakareruka dzekusaisa mari yekuvhiya kuburikidza neakakomberedza Excel kuronga.
- Kudzvanya mumarongero akakomberedzwa nemazita emakoramu maererano nechikamu, kuruboshwe raunoda kuisa makoramu. Mune ino kesi, chikamu chakapihwa zvachose. Tinya kurudyi mbeva bhatani. Mune menyu inoonekwa, sarudza iyo "paste" chinhu.
- Mushure meizvozvo, ikholamu nyowani inowedzerwa pakarepo kuruboshwe kwenzvimbo yakasarudzwa.
Nzira 2: Kuwedzera sero kuburikidza nemusoro menyu
Iwe unogona kuita basa iri uye zvimwe zvakasiyana, kureva kuburikidza nemamenji emenyu yechitokisi.
- Dzvanya pane chero sero iri muColumn kurudyi rwekamuri yakarongwa kuti uwedzere. Dzvanya pane ichi chinhu chakakodzera mbeva bhatani. Mumamiriro ezvinhu menyu anooneka, sarudza "paste ...".
- Panguva ino kuwedzera hazvisizvo. Iwindo diki rinovhura, umo iwe waunoda kutaura kuti ndiye mushandisi anoenda kuInternt:
- Tsanga;
- Mutsara;
- Sero ine shanduko pasi;
- Sero ine shanduko kurudyi.
Isu tinogadzirazve switch ku "Column" chinzvimbo uye tinya pane "ok" bhatani.
- Mushure meizvi zviito, ikholamu ichawedzerwa.
Nzira 3: bhatani pane ribhoni
Iko kuiswa kwemakoramu kunogona kuitwa uchishandisa bhatani rinokosha patepi.
- Sarudza iyo sero kuruboshwe iyo iyo yakarongwa kuti uwedzere chikamu. Kuve mu "Imba" tab, tinya pane iyo icon muchimiro cheiyo yakatsanangurwa triangle, iri pedyo ne "Paste" bhatani "Cell" block block patepi. Mune menyu inovhura, sarudza iyo "Insert makoramu kune pepa" chinhu.
- Mushure meizvozvo, ikholamu ichawedzerwa kuruboshwe kwechinhu chakasarudzwa.
Nzira yechina: kushandisa zvinopisa makiyi
Zvakare, chikamu chitsva chinogona kuwedzerwa nemakiyi anopisa. Uye pane sarudzo mbiri dzekuwedzera
- Mumwe wavo akafanana neyekutanga nzira yekuisa. Iwe unofanirwa kudzvanya pane chikamu pane yakakomberedzwa kurongedza pane iyo kurudyi kweiyo nzvimbo yakatarwa yekuisa uye kufonera ctrl + kiyi yekubatanidza.
- Kuti ushandise sarudzo yechipiri, iwe unofanirwa kuita kudzvanya pane chero sero mune iyo column kurudyi kwenzvimbo yekuisa. Wobva wafona pane CTRL ++ keyboard. Mushure meizvozvo, ipapo hwindo diki nesarudzo yemhando yekuisa, iyo yakatsanangurwa nenzira yechipiri yekuita basa racho. Zvimwe zviito chaizvo zvakafanana: Sarudza clause "column" uye tinya pane "ok" bhatani.
Chidzidzo: Keys inopisa muExcle
Nzira 5: Kuisa makoramu akati wandei
Kana iwe uchida pakarepo underedze makoramu akati wandei, saka mukushaikwa hazvigoneke kuita basa rakaparadzana kune chimwe chinhu chimwe nechimwe, sezvo maitiro aya anogona kusanganiswa mune chimwe chiito.
- Iwe unofanirwa kutanga wasarudza masero akawanda akawanda mune yakatsanangurwa mitezo kana zvikamu pamusangano wekurongedza, makoramu angani anoda kuwedzerwa.
- Wobva washandisa chimwe chezviito kuburikidza nemusoro menyu kana nemakiyi anopisa ayo akatsanangurwa nenzira dzakapfuura. Nhamba inoenderana yemakoramu ichawedzerwa kuruboshwe kwenzvimbo yakasarudzwa.
Nzira 6: Kuwedzera iyo ikholamu pakupera kwetafura
Dzese nzira dziri pamusoro dzakakodzera kuwedzera vatauri pakutanga uye nepakati petafura. Ivo vanogona zvakare kushandiswa kuisa makoramu pakupera kwetafura, asi mune iyi nyaya iwe unofanirwa kuita chimiro chakakodzera. Asi pane nzira dzekuwedzera iyo ikholamu kusvika kumagumo etafura kuti yangoonekwa nechirongwa ichi kune chikamu chayo. Kuti uite izvi, iwe unofanirwa kuita, iyo inonzi "Smart" tafura.
- Isu tinosimbisa iyo tafura iyo yatinoda kushandura ive "Smart" tafura.
- Kuva muTabha Home Tabhi, tinya pane iyo "fomati seTafura" bhatani, iyo iri mu "masitaji" zvishandiso "block block patepi. Muzvinyorwa zvakabviswa, sarudza imwe yeiyo huru rondedzero yetafura yekugadzira zvirairo pane yako kungwara.
- Mushure meizvozvo, hwindo iro hwindo rinovhura, iro rinoratidza maironga enzvimbo yakasarudzwa. Kana iwe waona chimwe chinhu chisina kunaka, ipapo unogona kugadzirisa pano chaipo. Chinhu chikuru ndechekuti iwe unofanirwa kuita iri nhanho ndeyekutarisa kana bhokisi rekutarisa rakaiswa padhuze ne "tafura ine misoro" paramende. Kana tafura yako ine ngowani (uye kazhinji zviitiko zvakadaro), asi hapana tick yechinhu ichi, saka iwe unofanirwa kuiisa. Kana zvese zvigadziriso zvikaiswa nenzira kwayo, wobva wango tinya pane "ok" bhatani.
- Mushure meizvi zviito, huwandu hwakazvipira hwakagadzirirwa setafura.
- Iye zvino kuitira kuti igonese chikamu chitsva mune ino tafura, zvakaringana kuzadza chero sero kune kodzero yacho. Iyo ikholamu umo sero iri rinowanikwa nekukurumidza.
Sezvauri kuona, pane akati wandei nzira dzekuwedzera mitsva yemitsara kuti Excel yepepa iri pakati petafura uye mumazita ekupedzisira. Kuti uwedzere kune yakanyanya nyore uye yakanakira, zvakanaka kuti ugadzire, iyo inonzi "Smart" tafura. Mune ino kesi, paunenge uchiwedzera data kune iyo renji kurudyi rwetafura, inozosanganisirwa mazviri sekhorosi nyowani.