Zamkatimu
Mkonzi wa spreadsheet Excel adapangidwa kuti azikonza zidziwitso zambiri zomwe zimaperekedwa m'matebulo amitundu yosiyanasiyana. Imodzi mwa mitundu yodziwika bwino yamtunduwu ndiyo kukopera. Mwachitsanzo, ngati pali mndandanda wazinthu zoyambira, ndipo muyenera kuwerengera zomwe zimafuna mizati yowonjezera kapena mizere, sikoyenera nthawi zonse kuwonjezera patebulo loyambirira. Zingafunikenso pazifukwa zina. Choncho, yankho lomveka lingakhale kukopera zonse kapena gawo la deta mu pepala latsopano kapena chikalata, ndikusintha zonse ndi kope. Mwanjira iyi, chikalata choyambirira chikhalabe chosakhudzidwa. Kodi zimenezi zingatheke m’njira zotani?
Koperani kosavuta popanda kusintha
Njirayi ndiyo yosavuta kugwiritsa ntchito, ndiyosavuta ngati tebulo la gwero lili ndi data yosavuta popanda mafomu ndi maulalo.
Tcherani khutu! Kukopera kosavuta sikumasintha chilichonse muzolemba zoyambirira.
Ngati chidziwitso cha gwero chili ndi ma formula, amakopedwa pamodzi ndi zina zonse, ndipo muyenera kusamala apa - mukakopera maulalo achibale, amayamba kulozera ku maselo osiyanasiyana komwe kungapezeke deta yolakwika. Choncho, kungokopera deta ndi ma fomula ndikwabwino kokha ngati magwero onse amawu akopedwa nthawi imodzi. Njirayi ikuphatikizapo zotsatirazi.
- Kusankha kwa ma cell. Monga lamulo, mwina kufotokozera ma cell angapo ndi batani lakumanzere, kapena njira yachidule ya kiyibodi "Shift + muvi" imagwiritsidwa ntchito. Zotsatira zake, maselo ena a pepalalo amalembedwa ndi chimango chakuda, ndipo amawonetsedwanso ndi utoto wakuda.
- Koperani ku bolodi. Chokopa ndi gawo lapadera pamakumbukiro apakompyuta opangidwira kusamutsa deta mkati mwa pulogalamu kapena pakati pa mapulogalamu. Kukopera kwa izo kumaseweredwa mwina ndi kukanikiza makiyi "Ctrl + C" kapena "Ctrl + Lowetsani" (kuphatikiza uku ndikofanana). Ndikothekanso kuyigwiritsa ntchito kudzera mu chinthu chofananira cha menyu yankhani kapena kugwiritsa ntchito riboni ya pulogalamu.
- Kutchula malo oti muyikepo. Timasunthira komwe tikufuna kukopera deta, ndikuwonetsa ndi cholozera selo yomwe idzakhala selo lakumanzere la deta yomwe iyenera kuikidwa. Samalani ngati malo oyikapo ali kale ndi deta. Akhoza kufufutidwa.
- Imayitanira zomwe zili mu clipboard m'malo otchulidwa. Izi zimachitika ndi makiyi "Ctrl + V" kapena "Shift + Insert" kapena chinthu chofananira cha menyu yankhani kapena riboni ya pulogalamu.
Ngati zofunika zokha ndizofunika
Nthawi zambiri, chidziwitso m'maselo chimachokera ku mawerengedwe omwe amagwiritsa ntchito maumboni a maselo oyandikana nawo. Mukangokopera maselo oterowo, zidzachitidwa limodzi ndi ma formula, ndipo izi zidzasintha zomwe mukufuna.
Pankhaniyi, ma cell okha ndi omwe ayenera kukopera. Monga momwe zinalili m'mbuyomu, mtundu wofunikira umasankhidwa koyamba, koma kukopera pa clipboard, timagwiritsa ntchito menyu ya "paste options", "values only" sub-item. Mukhozanso kugwiritsa ntchito gulu logwirizana mu riboni pulogalamu. Masitepe ena onse omata zomwe mwakoperayo amakhalabe chimodzimodzi. Zotsatira zake, ma cell ofunikira okha ndi omwe adzawonekere pamalo atsopano.
Zofunika! Mafomula ndi mawonekedwe samasungidwa motere.
Izi zikhoza kukhala zosavuta komanso zolepheretsa, malingana ndi momwe zinthu zilili. Nthawi zambiri, mawonekedwe (makamaka ovuta) amafunikira kusiyidwa. Pankhaniyi, mungagwiritse ntchito njira zotsatirazi.
Pamene mukufuna zonse zofunika ndi akamagwiritsa
Kusankhidwa kwa ma cell a njira yokoperayi kumakhalabe komweko, koma kumachitika pogwiritsa ntchito menyu yankhani (Ikani chinthu Chapadera) kapena kugwiritsa ntchito riboni ya pulogalamuyo. Mwa kuwonekera pa Ikani Chizindikiro Chapadera chokha, mutha kutsegula bokosi la zokambirana lomwe limapereka zosankha zambiri, ndipo mutha kuphatikiza deta pogwiritsa ntchito ntchito. Mwachitsanzo, simungangoyika zomwe zatumizidwa m'maselo omwe mwatchulidwa, koma onjezerani omwe ali kale papepala. Nthawi zina izi zimakhala zosavuta.
Zimachitikanso kuti tebulo lili ndi mizati yambiri m'lifupi mwake, ndipo mutatha kukopera mfundozo, pamafunika ntchito zambiri zowawa kwambiri kuti muyike m'lifupi mwake. Pamenepa, "Paste Special" dialog ili ndi chinthu chapadera "Column Width". Kuyika kumachitika mu magawo awiri. Matani "column widths" poyamba kuti "kukonzekera danga" ndiyeno kukopera mfundo zake. Gomelo ndilofanana ndendende ndi loyambirira, koma m'malo mwa mafomula, lili ndi mfundo. Nthawi zina ndi bwino kukopera kokha m'lifupi m'lifupi mizati kuti tebulo kuwoneka ngati choyambirira, ndi kulowetsa mfundo mu maselo pamanja. Kuphatikiza apo, mutha kusankha chinthucho "koperani ndikusunga kukula kwa mizati" mumenyu yankhani. Zotsatira zake, kuyikako kudzachitidwa mu sitepe imodzi.
Kukopera ngati chitsanzo
Nthawi zina, pamafunika kukopera gawo la tebulo kotero kuti pambuyo pake likhoza kuzunguliridwa ndi kusinthidwa popanda kusintha, popanda kukhudza malo ena patebulo lonselo. Pankhaniyi, ndizomveka kukopera deta ngati chithunzi chokhazikika.
Njira zokopera pa clipboard ndizofanana ndi zomwe zidachitika m'mbuyomu, koma poyika, chinthu cha "Chithunzi" pagulu la "Paste Special" chimagwiritsidwa ntchito. Njirayi siigwiritsidwa ntchito kawirikawiri chifukwa deta yomwe ili m'maselo omwe amakopera motere sangasinthidwe mwa kungolowetsa mfundo.
Kope lathunthu la pepala lonse
Nthawi zina muyenera kukopera pepala lonse ndikuliyika mu chikalata chomwecho kapena china. Pankhaniyi, muyenera kuyitanira mndandanda wazomwe zili patsamba lomwe lili kumanzere kumanzere kwa pulogalamuyo ndikusankha chinthu cha "sunthani kapena kukopera".
Gulu limatsegula momwe njira yokopera imayikidwa. Makamaka, mutha kufotokoza m'buku lomwe mukufuna kuyika pepala latsopano, kulisuntha kapena kulikopera, ndikulongosola malo omwe ali pakati pa mapepala omwe alipo omwe kusamutsidwa kudzapangidwira. Mukadina batani la "Chabwino", tsamba latsopano lidzawonekera m'buku lomwe lafotokozedwa ndi zonse zomwe zalembedwa.
Kutsiliza
Kukopera ndi chimodzi mwazinthu zomwe zimafunsidwa kwambiri mu Excel. Kwa matebulo osavuta opanda mafomu, njira yoyamba ndiyo yabwino kwambiri, ndipo pamatebulo omwe ali ndi njira zambiri ndi maulalo, nthawi zambiri ndibwino kugwiritsa ntchito njira yachiwiri - kukopera zikhalidwe zokha. Njira zina sizigwiritsidwa ntchito kawirikawiri.