Kukopa tafura muExcel

Kukopa tafura ndehumwe hunyanzvi hwakakosha hunofanirwa kuitwa nemushandisi wese weExcel kuti ashande nemazvo. Ngationei kuti nzira iyi inogona kuitwa sei purogiramu nenzira dzakasiyana, zvichienderana nebasa racho.

Kopa uye unamate tafura

Chekutanga pane zvese, kana uchikopa tafura, iwe unofanirwa kusarudza kuti ndeupi ruzivo rwaunoda kudzokorora (maitiro, mafomula, nezvimwewo). Iyo data yakakopwa inogona kunamirwa munzvimbo nyowani pane imwechete pepa, pabepa idzva, kana mune imwe faira.

Method 1: nyore kopi

Iyi nzira inonyanya kushandiswa pakudhindisa matafura. Nekuda kweizvozvo, iwe uchawana kopi chaiyo yemaseru ane yekutanga fomati uye mafomula (kana aripo) akachengetedzwa. Iyo algorithm yezviito ndeiyi inotevera:

1. Nenzira ipi zvayo yakanakira (semuenzaniso, uchishandisa bhatani rekuruboshwe rakadzvanywa), sarudza huwandu hwemasero atinoronga kuisa pa clipboard, nemamwe mazwi, kopi.
2. Tevere, tinya-kurudyi chero kupi mukati mesarudzo uye mune iyo rondedzero inovhura, mira pamurairo "Kopa".Kuti ukope, unogona kungodzvanya musanganiswa Ctrl + C pane keyboard (mushure mekusarudzwa kwaitwa). Iwo murairo unodiwa unogona kuwanikwawo pane chirongwa ribhoni (tab "Kumba", Boka "Clipboard") Iwe unofanirwa kudzvanya pane icon, uye kwete pamuseve wepasi padivi payo.
3. Isu tinoenda kuchitokisi pane pepa ratinoda (mune ikozvino kana rimwe bhuku), kutanga kubva kwatinoronga kuisa iyo data yakakopwa. Sero iri ndiro rinenge riri repamusoro kuruboshwe retafura yakaiswa. Isu tinya-kurudyi pairi uye mune yekudonha-pasi runyorwa tinoda murairo “Isert” (icon yekutanga muboka "Paste Options") Muchiitiko chedu, takasarudza pepa razvino.Sezvakaita nekukopa data yekunamira, unogona kushandisa makiyi anopisa - Ctrl + V. Kana kuti isu tinya pane yaunoda kuraira pane chirongwa ribhoni (mune imwechete tab "Kumba", Boka "Clipboard") Iwe unofanirwa kudzvanya pane iyo icon, sezvakaratidzwa mune iyo skrini pazasi, uye kwete pane yakanyorwa “Isert”.
4. Pasinei neiyo yakasarudzwa nzira yekukopa nekuisa data, kopi yetafura ichaonekwa munzvimbo yakasarudzwa. Maumbirwo emasero uye mafomula arimo achachengetedzwa.

Cherechedza: kwatiri isu, isu hatina kufanira kugadzirisa miganhu yesero yetafura yakakopwa, nekuti yakaiswa mukati memakoramu akafanana neyekutanga. Mune zvimwe zviitiko, mushure mekudzokorora iyo data, uchafanirwa kupedza nguva shoma pa.

Method 2: Kopa Chete Maitiro

Muchiitiko ichi, isu tinongotevedzera chete kukosha kwemasero akasarudzwa ivo pachavo, pasina kuendesa mafomula kunzvimbo itsva (inooneka mhinduro kwavari inokopwa) kana fomati. Hezvino zvatinoita:

1. Uchishandisa chero nzira dzatsanangurwa pamusoro apa, sarudza uye kopa zvinhu zvepakutanga.
2. Tinya-kurudyi pane sero yatinoronga kuisa iyo yakakopwa tsika, uye mune yemukati menyu inovhura, tinya pane iyo sarudzo. “Values” (icon muchimiro cheforodha ine manhamba 123).Dzimwe sarudzo dzePaste Special dzinoratidzwawo pano: chete mafomula, kukosha uye nhamba mafomati, mafomati, nezvimwe.
3. Nekuda kweizvozvo, isu tichawana chaizvo tafura yakafanana, asi tisina kuchengetedza fomati yemasero ekutanga, makoramu upamhi uye mafomula (mibairo yatinoona pachiratidziro ichaiswa panzvimbo).

Cherechedza: Namatidza sarudzo dzakakosha dzinoratidzwawo muchirongwa ribhoni mune iyo huru tab. Unogona kuzvivhura nekudzvanya bhatani rine zvakanyorwa “Isert” uye museve wakaderera.

Kutevedzera Maitiro Kuchengeta Yekutanga Mafomati

Mune menyu yemukati yesero iyo kuiswa kwakarongwa, wedzera sarudzo "Special Paste" nekudzvanya pamuseve uri padyo nemurairo uyu uye sarudza chinhu "Values ​​uye Source Formatting".

Nekuda kweizvozvo, isu tichawana tafura iyo isingazosiyane neyakasiyana kubva kune yekutanga, zvisinei, panzvimbo yemafomula, ichange iine chaiwo maitiro.

Kana tikadzvanya mumenu yemukati yesero kwete pamuseve uri padyo nayo, asi pamurairo pachawo "Special Paste", hwindo rinovhurika iro rinopawo sarudzo yesarudzo dzakasiyana. Sarudza yaunoda sarudzo uye tinya OK.

Method 3: Kopa tafura uchichengetedza hupamhi hwemakoramu

Sezvatakambokurukura, kana iwe ukakopa nekuisa tafura kune imwe nzvimbo itsva (kwete mukati memakoramu akafanana) nenzira yakajairwa, saka kazhinji iwe uchafanirwa kugadzirisa hupamhi hwemakoramu, uchifunga nezve zviri mukati masero. Asi kugona kweExcel kunobvumidza iwe kuti uite nekukurumidza maitiro uchichengetedza zviyero zvepakutanga. Heino maitiro azvinoitwa:

1. Kutanga, sarudza uye kukopa tafura (tinoshandisa chero nzira iri nyore).
2. Wasarudza sero kuti uise data, tinya-kurudyi pairi uye mune sarudzo "Special Paste" sarudza chinhu "Chengetedza upamhi hwembiru".
3. Mune yedu kesi, isu takawana iyi mhedzisiro (pabepa idzva).

mapindukiro

1. Mumenu yemukati yesero, tinya pane kuraira pachayo "Special Paste" uye pahwindo rinovhurwa, sarudza sarudzo "column widths".
2. Saizi yemakoramu munzvimbo yakasarudzwa ichagadziriswa kuti ikwane tafura yekutanga.
3. Iye zvino isu tinokwanisa kukopa-kuisa tafura munzvimbo ino nenzira yakajairwa.

Nzira 4: Isa tafura semufananidzo

Kana iwe uchida kunamira tafura yakakopwa seyakajairika mufananidzo, unogona kuita izvi sezvinotevera:

1. Mushure mekunge tafura yakopwa, mune menyu yemukati yesero yakasarudzwa pakuisa, tinomira pane chinhu “Mufananidzo” mune zvakasiyana "Special Paste".
2. Nekudaro, isu tinowana tafura yakadzokororwa muchimiro chemufananidzo, unogona kutamiswa, kutenderedzwa, uye zvakare kudzokororwa. Asi kugadzirisa iyo data uye kushandura chitarisiko chavo hazvichashande.

Nzira 5: Kopa pepa rose

Mune zvimwe zviitiko, zvingave zvakakosha kukopa kwete chidimbu chimwe chete, asi pepa rose. Nokuda kweizvi:

1. Sarudza zvese zviri mukati mebepa nekudzvanya pane icon pamharadzano yeakachinjika uye yakatwasuka coordinate mabara.Kana kuti unogona kushandisa hotkeys Ctrl+A: dzvanya kamwe chete kana chitubu chiri muchitokisi chisina chinhu kana kaviri kana chinhu chakazadzwa chasarudzwa (kunze kwesero rimwe chete, mune iyi kesi, kudzvanya kumwe kunokwanawo).
2. Masero ese ari papepa anofanira kujekeswa. Uye zvino vanogona kukopa chero nzira iri nyore.
3. Enda kune rimwe pepa / gwaro (gadzira idzva kana shandura kune iripo). Isu tinya pane icon pamharadzano yezvirongwa, uye tozoisa iyo data, semuenzaniso, uchishandisa iyo keyboard nzira Ctrl + V.
4. Nekuda kweizvozvo, tinowana kopi yepepa rine hukuru hwesero uye yekutanga fomati yakachengetedzwa.

Imwe nzira

Unogona kukopa pepa neimwe nzira:

1. Tinya-kurudyi pane zita repepa pazasi pehwindo rechirongwa. Mumenu yezvinyorwa inovhura, sarudza chinhu "Fambisa kana kukopa".
2. Iwindo diki richaonekwa umo isu tinogadzirisa chiito chinofanira kuitwa pane yakasarudzwa pepa, uye tinya OK:
   • kufamba/kukopa mubhuku razvino nesarudzo yenzvimbo inotevera;
   • kufamba/kukopa kubhuku idzva;
   • kuitira kuti kukopa kuitwe, usakanganwa kutarisa bhokisi riri pedyo neparameter inoenderana.
3. Kwatiri isu, takasarudza pepa idzva uye tikawana mhedzisiro iyi. Ndapota cherechedza kuti pamwe chete nezviri mukati mepepa, zita rayo rakakopwawo (kana zvichidikanwa, rinogona kuchinjwa - zvakare kuburikidza nemamiriro ezvinhu epapepa).

mhedziso

Nekudaro, Excel inopa vashandisi nzira dzakasiyana dzekukopa tafura, zvichienderana nekuti chii chaizvo (uye sei chaizvo) chavanoda kutevedzera iyo data. Kupedza nguva shoma uchidzidza nzira dzakasiyana dzekuita basa iri kunogona kukuchengetedza nguva yakawanda gare gare muchirongwa.