Kwa ogwiritsa ntchito ambiri a Excel, kukopera matebulo ndikosavuta. Koma, sikuti aliyense amadziwa zina mwazomwe zimapangitsa kuti njirayi ikhale yogwira ntchito moyenera momwe mitundu yambiri ya data imafunira mosiyanasiyana. Tiyeni tiwone mwatsatanetsatane mbali zina za kukopera deta mu Excel.
Koperani ku Excel
Kukopera tebulo ku Excel ndikubwereza. Palibe magawidwe amtunduwu malinga ndi komwe mukuyika: Kusiyanitsa kwakukulu pakati pa njira zakukopera ndi momwe mukufuna kukopera chidziwitso: pamodzi ndi mafomula kapena ndi deta yowonetsedwa.
Phunziro: Kulemba matebulo mu Mirosoft Mawu
Njira 1: kukopera mwachisawawa
Kukopera kosavuta mosasamala mu Excel kumapereka mwayi wopanga tebulo limodzi ndi mafomulidwe onse ndi mawonekedwe ake.
- Sankhani dera lomwe mukufuna kukopera. Timadina pa malo osankhidwa ndi batani loyenera la mbewa. Zosintha zamakina zikuwoneka. Sankhani chinthu mmenemo Copy.
Pali njira zina zomwe mungachite potsatira gawo ili. Choyamba ndi kukanikiza njira yaying'ono pa kiyibodi Ctrl + C mutatsimikizira m'deralo. Njira yachiwiri imaphatikizapo kukanikiza batani Copyili pa nthiti mu tabu "Pofikira" pagulu lazida Clipboard.
- Tsegulani dera lomwe tikufuna kulowetsamo deta. Ili likhoza kukhala pepala latsopano, fayilo ina ya Excel, kapena dera lina la maselo patsamba limodzi. Dinani pa cell, yomwe iyenera kukhala selo lamanzere lakumanzere kwa tebulo lomwe laikidwa. Pazosankha zofanizira, muzosankha, sankhani "Ikani".
Palinso zosankha zina. Mutha kusankha foni ndikanikiza njira yaying'ono pa kiyibodi Ctrl + V. Kapenanso, mutha dinani batani. Ikani, yomwe ili kumanzere kwenikweni kwa riboni pafupi ndi batani Copy.
Pambuyo pake, deta idzayikidwa ndikusungidwa kwa masanjidwe ndi mawonekedwe.
Njira 2: Kukopera Makhalidwe
Njira yachiwiri imaphatikizapo kukopera mfundo za thebulo zokha zomwe zikuwonetsedwa pazenera, osati fomula.
- Timatsata zomwe tasankha mwanjira imodzi tafotokozazi.
- Dinani kumanja komwe mukufuna kuti muiike data. Pazosankha zofanizira, pazosankha zofunikira, sankhani "Makhalidwe".
Pambuyo pake, tebulo lidzawonjezedwa ku pepalalo popanda kusunga fomati ndi mitundu. Ndiye kuti, ndizomwe zimawonetsedwa pazenera zokha.
Ngati mukufuna kutsitsa zomwe zili, koma nthawi yomweyo sungani mafayilo oyambira, muyenera kupita pazosankha "Lowetsani mwapadera". Pamenepo paboloko Ikani Mfundo muyenera kusankha "Zotsatira zamtundu woyambira".
Zitatha izi, tebulo lidzawonetsedwa momwe limapangidwira, koma m'malo mwazomwe zimakhazikitsidwa maselo adzadzaza zonse.
Ngati mukufuna kugwira ntchito iyi pokhapokha mutasunga masanjidwewo osati manambala onse, ndiye kuti muyenera kusankha "Zotsatira zamawonekedwe ndi manambala".
Njira 3: pangani zolemba ndikusunga m'litali mwake
Koma, mwatsoka, ngakhale kugwiritsa ntchito mawonekedwe oyambirirawa sikukuloletsani kuti mupange tebulo ndi mulitali woyambira. Ndiye kuti, nthawi zambiri pamakhala zochitika pomwe, pambuyo pakuyikapo, deta singalowe m'maselo. Koma Excel amatha kugwiritsa ntchito zochita zina kuti apitirize kutalika kwa mzati.
- Koperani tebulo m'njira iliyonse mwanjira zonse.
- Pamalo omwe mukufuna kuyika deta, itanani menyu wanthawi zonse. Timadutsa mfundozo "Lowetsani mwapadera" ndi "Sanjani Kukula kwa Zithunzi Zoyambirira".
Mutha kuzichita mwanjira ina. Kuchokera pamenyu yazonse, pitani kawiri pachinthucho ndikupanga dzina lomweli "Ikani mwapadera ...".
Windo limatseguka. Mu "Chonde" bokosi lanu, sinthani kusintha Zipilala Zam'mbali. Dinani batani "Zabwino".
Njira iliyonse yomwe mungasankhe pazosankha ziwiri zomwe zili pamwambapa, mulimonse momwe zingakhalire, tebulo lojambulidwalo lidzakhala ndi mulingo wofanana monga gwero.
Njira 4: ikani ngati chithunzi
Pali nthawi zina pomwe tebulo limafunikira kuyikidwamo osati mwamaonekedwe, koma monga chithunzi. Vutoli limathetsedwanso mothandizidwa ndi cholowa chapadera.
- Timatengera zomwe mukufuna.
- Sankhani malo oti muyike ndikuyitanitsa menyu yankhaniyo. Pitani "Lowetsani mwapadera". Mu block "Zosankha zina" sankhani "Zojambula".
Pambuyo pake, idathayo imayikidwa pa pepalalo ngati chithunzi. Mwachilengedwe, kusintha tebulo lotere sikungatheke.
Njira 5: kukopera pepala
Ngati mukufuna kutengera tebulo lonse kwathunthu ku pepala lina, koma nthawi yomweyo onetsetsani kuti likufanana ndi gwero, ndiye pankhaniyi, ndibwino kukopera pepala lonse. Pankhaniyi, ndikofunikira kudziwa kuti mukufunadi kusamutsa chilichonse chomwe chili patsamba lolembalo, pokhapokha njira iyi singagwire ntchito.
- Pofuna kuti musasankhe pamanja maselo onse a pepalalo, ndipo izi zimatenga nthawi yayitali, dinani kumakona omwe ali pakati pa mapanelo ndi oyanjana molumikizana. Pambuyo pake, pepala lonse lidzawunikidwa. Kuti tikope zomwe zili, timalemba pa kiyibodi pophatikiza Ctrl + C.
- Kuti muyike deta, tsegulani pepala latsopano kapena buku latsopano (fayilo). Momwemonso, dinani ku rectangle yomwe ili pamphepete mwa mapanelo. Kuti tiike deta, timalemba mitundu yophatikiza Ctrl + V.
Monga mukuwonera, titatha kuchita izi, tinatha kukopera pepalalo pamodzi ndi tebulo ndi zina zonse zomwe zidalimo. Nthawi yomweyo, zinali zotheka kupulumutsa osati zolemba zoyambirira zokha, komanso kukula kwa maselo.
Wosindikiza tsamba la Excel lili ndi zida zochulukirapo zotsatsira matebulo monga momwe wosuta amafunira. Tsoka ilo, si aliyense amene amadziwa za zovuta zakugwirira ntchito ndi phukusi lapadera ndi zida zina zokopera zomwe zingakulitse kwambiri kuthekera kosamutsa deta, komanso zochita za ogwiritsa.
