Maitiro ekutevedzera tafura kubva kuExcel muExcel

Kune vashandisi vekukunda vazhinji, maitiro ekutevedzera matafura haisiri kuoma kukuru. Asi, havasi vese vanoziva zvimwe zvekuti vanokutendera kuti uite izvi sezvinobvira zvinogoneka kune imwe mhando yedata uye zvakasiyana-siyana. Ngationgororei zvakadzama zvimwe zvinhu zvekutevedzera data mune yekuwedzera chirongwa.

Kutevedzera kuti abate

Kutevedzera tafura mukuremekedza ndiko kusikwa kweiyo kudzokorora kwayo. Mukuita kwayo kwazvo, hapana mutsauko unoreva zvinoenderana nekwauchazoisa data: kune imwe nzvimbo yeiyo sheethero rimwe chete, pane rimwe bepa kana rimwe bhuku (faira). Musiyano mukuru pakati pekutevedzera nzira ndewekuti iwe unoda kutevedzera ruzivo: pamwe chete neFormas kana chete ne data rakaratidzwa.

Chidzidzo: Kutevedzera matafura muMirosoft izwi

Nzira 1: Kopa default

Kurerutsa kupusa nekumwe kusekerera kunosanganisira kugadzira kopi ye tafura pamwe chete neese mafomula yakaiswa mukati maro uye kuumbwa.

1. Isu tinosimbisa nzvimbo yatinoda kutevedzera. Dzvanya pane yakagoverwa nzvimbo ine bhatani rekurudyi bhatani. Mameseji menyu anooneka. Sarudza iyo mairi "kopi".

   

   Pane dzimwe sarudzo dzekuita nhanho iyi. Yekutanga yavo inosanganisira mukudzvanya kabhodhi yeCTRL + C makiyi mushure mekusarudzwa kwenzvimbo. Iyo yechipiri sarudzo inosanganisira kudzvanya iyo "Kopa" bhatani, iyo iri patepi mu "Imba" tab mu "Exchange Buffer" Toolbu.



2. Vhura iyo nzvimbo iyo yatinoda kuisa data. Inogona kunge iri bhegi nyowani, imwe faira yekubira kana imwe nzvimbo yemasero pane imwe chete pepa. Dzvanya pane sero rinofanira kunge riri yekumusoro kuruboshwe cell yakaiswa tafura. Mukati menyu yemukati mune iyo isa paramita, sarudza "paste".

   

   Kune zvakare dzimwe nzira dzekuita sarudzo. Iwe unogona kusimbisa iyo CTRL + V keyboard pane iyo keyboard. Mukuwedzera, iwe unogona kudzvanya pane "paste" bhatani, iyo iri pane iyo yekuruboshwe yemucheto weTape padyo ne "Kopa" bhatani.

Mushure meizvozvo, kuiswa kwedata kuchaitwa uku uchichengetedza fomati uye mafomula.

Nzira 2: Kutevedzera Maitiro

Iyo nzira yechipiri inopa yekutevedzera chete tafura yeyema yetafura inoratidzwa pachiratidziri, uye kwete mafomula.

1. Kopa iyo data mune imwe yenzira dzakatsanangurwa pamusoro apa.
2. Nekudzvanya bhatani rekurudyi remamote munzvimbo iwe kwaunoda kuisa data. Mukati menyu yemukati mune iyo isa parameter, sarudza "kukosha" chinhu.

Mushure meizvozvo, tafura ichawedzerwa kune pepa pasina kuchengetedza chimiro uye mafomula. Ndokunge, iyo data chete inoratidzwa pachiratidziri ichakohwa.

Kana iwe uchida kutevedzera tsika, asi panguva imwe chete chengetedza iyo yekutanga fomati, saka iwe unofanirwa kuenda kune iyo menyu chinhu "Special Insert" panguva yekuisa. Ikoko, mu "isa maComts" block, iwe unofanirwa kusarudza "kukosha uye kwepakutanga fomati".

Mushure meizvozvo, tafura ichaunzwa muchimiro chekutanga, asi chete panzvimbo yeiyo mafomula yechitokisi ichazadza iyo nguva dzose tsika.

Kana iwe uchida kuita izvi chete neicho chengetedzo yeiyo fomati yehuwandu, uye kwete tafura yose, ipapo mune yakakosha isa iwe unofanirwa kusarudza chinhu "kukosha uye mafomu ehuwandu".

Nzira 3: Gadzira kopi apo uchichengetedza columns upamhi

Asi, zvinosuruvarisa, kunyangwe kushandiswa kweruzivo hakubvume kuti uite kopi ye tafura neyakatanga upamhi. Ndokunge, kazhinji pane zviitiko apo iyo data isiri kuiswa mumasero mushure mekuisa. Asi muExcel, zvinokwanisika kuchengetedza iyo yepakutanga kolumn yakafara uchishandisa zvimwe zviito.

1. Kopa tafura neimwe nzira yakajairwa nzira.
2. Munzvimbo yaunoda kuisa data, fonera mamiriro emenyu. Isu tinogara tichienda kuburikidza nezvinhu "inokosha isa" uye "Sevha upamhi hwechikamu chezvekutanga."

   

   Iwe unogona kunyoresa neimwe nzira. Kubva pamhaurirwo emenyu kaviri enda kune icho chinhu nezita rimwe chete "rakakosha kuiswa ...".

   

   Hwindo rinovhura. Mu "isa" Toolbar, isu tinosurongedza kuchinjika kuchinzvimbo "column yakafara". Dzvanya pane "OK" bhatani.

Chero nzira yamakasarudza kubva pane maviri esarudzo dzakanyorwa pamusoro, mune chero nyaya, tafura yekutevedzera ichave neyakaenzana column seyakaenzana.

Nzira yechina: Insert semufananidzo

Pane zviitiko apo tafura inoda kuiswa kunze kweiyo yakajairwa fomati, asi semufananidzo. Iri basa rinogadziriswa zvakare uchishandisa yakakosha isa.

1. Ita kutevedzera huwandu hwaunoda.
2. Sarudza nzvimbo yekuisa uye kufonera mamiriro emenyu. Enda kuchinhu "chakakosha isa". Mu "mamwe maOptrt zvigadziriso" block, sarudza iyo "nhamba" chinhu.

Mushure meizvozvo, iyo data ichave yakaiswa pane pepa semufananidzo. Nomuzvarirwo, hazvizombogone kugadzirisa tafura yakadaro.

Nzira 5: Kutevedzera Sheet

Kana iwe uchida kutevedzera tafura yese pane imwe pepa, asi panguva imwecheteyo chengetedza iyo yakafanana yakafanana sosi, saka mune ino nyaya, zvakanaka kutevedzera pepa rese. Mune ino kesi, zvakakosha kuti uzive kuti unonyatsoda kuendesa zvese izvo zviri pairi sour sheet, kana zvikasadaro nzira iyi haigone.

1. Kuisa Nemaoko kugovera masero ese ezororo, uye izvi zvaizotora nguva yakakura, tinya pane rectangle iri pakati peiyo yakatwasuka uye yakatwasuka kuronga. Mushure meizvozvo, iyo pepa rese richaratidzwa. Kuti utore zvirimo, Type Ctrl + C musanganiswa pane iyo keyboard.



2. Kuisa iyo data, vhura pepa nyowani kana bhuku idzva (faira). Saizvozvo, tinya pane rectangle yakaiswa pane kupindirana kwemapaneru. Kuti uise iyo data, nyora iyo CTRL + V bhatani kusanganisa.

Sezvauri kuona, mushure mekuita izvi zviito, takakwanisa kutevedzera pepa pamwe chete netafura uye nezvimwe zvirimo. Izvo zvakazoita kuti tisanyepedze kwete chete chimiro chekutanga, asi zvakare hukuru hwemasero.

Iyo EXEEL Tafura yeEdheni ine yakawedzera tolkit kutevedzera matafura chaizvo sezvo mushandisi anodikanwa. Nehurombo, havasi vese vanoziva nezve nationalances yekushanda pamwe nekusagadzikana uye mamwe matope ekutengesa anokubvumidza kuwedzera mukana wekutamiswa kwedata, pamwe nekuzvitakura zvishandiso.