Momwe mungakope tebulo kuchokera ku Excel mu Excel

Kwa ogwiritsa ntchito kwambiri, njira yokopera matebulo sivuta kwambiri. Koma si aliyense amene akudziwa zozizwitsa zina zomwe zimakupatsani mwayi kuti mupange njirayi moyenera kwa mawonekedwe osiyana ndi osiyanasiyana. Tiyeni tilingalire mwatsatanetsatane zinthu zina zomwe zikupera deta mu pulogalamu ya Excel.

Kukopera Kupambana

Kukopera tebulo pa Excel ndi chilengedwe chomwe chimapangidwa ndi zomwezo. Munjira yomweyo, palibe kusiyana kutengera komwe mukukayika deta: kudera lina la pepala lomwelo, patsamba latsopano kapena buku lina (fayilo). Kusiyanitsa kwakukulu pakati pa njira yokopera ndi momwe mukufuna kulembera chidziwitso: palimodzi ndi njira kapena zokha ndi zomwe zikuwonetsedwa.

Phunziro: Kutengera matebulo ku Mirosoft Mawu

Njira 1: Koperani

Kukopera kosavuta kwabwino kwambiri kuti ukhale bwino kumaphatikizapo kupanga tsatani patebulo limodzi ndi mapangidwe onse omwe amayikidwa ndi mawonekedwe.

Tikuwonetsa m'dera lomwe tikufuna. Dinani pa malo omwe adagawidwa ndi batani lamanja. Zosankha zomwe zikuchitika. Sankhani mu "kope".

Pali njira zina zothandizira kuchita izi. Oyamba mwa iwo amakhala ndi kukanikiza kiyibodi ya Ctrl + C zikasaka pambuyo posankha deralo. Njira yachiwiri ikuphatikiza batani la "Copy", lomwe limapezeka pa tepi mu "kunyumba" la "Kusinthanitsa Buffer".

Tsegulani malo omwe tikufuna kuyika deta. Itha kukhala pepala latsopano, fayilo ina yapamwamba kapena malo ena a maselo omwe ali patsamba lomwelo. Dinani pa cell yomwe iyenera kukhala khungu lakunzere kumanzere. Munkhani yankhani mu gawo lolowera, sankhani "phala".

Palinso njira zina zochitira. Mutha kuwonetsa vtrl + v kiyibodi pa kiyibodi. Kuphatikiza apo, mutha kudina batani la "phala", lomwe lili kumanzere kwa tepi pafupi ndi batani la "Copy".

Pambuyo pake, kuyikidwa deta kumachitika ndikusunga mapangidwe ndi njira.

Njira 2: Kukopera Mfundo

Njira yachiwiri imapereka njira zokopera mipando yomwe imawonetsedwa pazenera, osati njira.

Koperani zambiri munjira imodzi yomwe tafotokozazi.
Mwa kuwonekera batani la mbewa lamanja pamalo omwe muyenera kuyika deta. Munkhani yankhani mu gawo lolowera, sankhani "mfundo".

Pambuyo pake, tebulo lidzawonjezedwa papepala popanda kukhazikitsa mawonekedwe ndi njira. Ndiye kuti, zomwe zimawonetsedwa pazenera zomwe zimajambulidwa.

Ngati mukufuna kutengera mfundozo, koma nthawi yomweyo Sungani mawonekedwe oyambira, ndiye kuti muyenera kupita ku menyu (internent "yapadera" pakuyika. Kumeneko, mu "kuyika mfundo" chotchinga, muyenera kusankha "mfundo zoyambira".

Kuyika mtengo wa kuteteza kwa mawonekedwe a Microsoft Excel

Pambuyo pake, tebulo lidzaperekedwa mu mawonekedwe oyamba, koma m'malo mwa ma cell a foni idzadzaza zofunikira.

Makhalidwe opangidwa amayikidwa mu Microsoft Excel

Ngati mukufuna kugwirira ntchito iyi ndi kusungidwa kwa kuchuluka kwa manambala, osati tebulo lonselo, ndiye kuti muvinidera, ndiye kuti muyenera kusankha "mfundo ndi mafomu a manambala".

Kuyika Miyezo Yophatikizira Manambala Osiyanasiyana mu Microsoft Excel

Njira 3: Pangani Copy Pomwe Mukusunga Ziphuphu

Koma, mwatsoka, ngakhale kugwiritsa ntchito magwero sikukulolani kuti mupange pepalali ndi m'lifupi mwake. Ndiye kuti, nthawi zambiri pamakhala zinthu zomwe sizimayikidwa m'maselo atayika. Koma mwakuposachedwa, ndizotheka kukhalabe ndi m'lifupi choyambirira pogwiritsa ntchito zochita zina.

Koperani tebulo mwanjira iliyonse ya njira iliyonse.
M'malo omwe muyenera kuyika deta, itanani menyu. Nthawi zonse timadutsamo zinthu "zapadera" ndipo "sungani m'lifupi mwake."

Mutha kulembetsa mwanjira ina. Kuchokera pazakudya ziwirizo kawiri kupita ku chinthucho ndi dzina lomwelo "kulowetsa mwapadera ...".

Zenera limatseguka. Mu "ikani" chida ", timakonzanso kuti zisinthe kukhala" mzere wa chikho ". Dinani pa batani la "OK".

Ikani muyeso wapadera mu Microsoft Excel

Mulimonse momwe mungasankhire pazinthu ziwiri zomwe zatchulidwa pamwambapa, mulimonsemo, tebulo lomwe lidzakhala ndi mlirimo womwewo monga gwero.

Gome limayikidwa ndi mulingo woyambirira wa mitu ya Microsoft Excel

Njira 4: Ikani ngati chithunzi

Pali zochitika ngati tebulo liyenera kuyikamo mtundu wamba, koma monga chithunzi. Ntchitoyi imasinthidwanso pogwiritsa ntchito inter.

Chitani zomwe mukufuna.
Sankhani malo kuti muike ndi kuyitanitsa menyu. Pitani ku chinthucho "International". Mu "Zosintha Zina" Kuyika, Sankhani "Chithunzi".

Ikani ngati chithunzi mu Microsoft Excel

Pambuyo pake, deta iikidwa papepala ngati chithunzi. Mwachilengedwe, sizingatheke kusintha tebulo lotere.

Gome la zithunzi limayikidwa mu Microsoft Excel

Njira 5: Kukopera pepala

Ngati mukufuna kutengera tebulo lonse pa pepala lina, koma nthawi yomweyo musatchulidwe kotere, ndibwino kutengera pepala lonse. Pankhaniyi, ndikofunikira kudziwa kuti mukufuna kusintha chilichonse chomwe chili pa pepalalo, apo mwanjira iyi siyikukwanira.

Kuti muchepetse maselo onse a pepalalo, ndipo izi zingatenge nthawi yayitali, dinani pa rectangle pakati pa bwalo lozungulira ndi lolunjika. Pambuyo pake, pepala lonse lidzafotokozedwa. Kutengera zomwe zili patsamba, lembani CTRL + C) pa kiyibodi.

Kugawidwa kwa pepala lonse ku Microsoft Excel

Kuyika deta, tsegulani pepala latsopano kapena buku latsopano (fayilo). Momwemonso, dinani pa rectangle yoyikidwa panjira ya mapanelo. Pofuna kuyika deta, lembani mawu a CTRL + V.

Monga mukuwonera, nditachita izi, tinathamangitsanso pepalalo limodzi ndi tebulo ndi zomwe zili patebulo. Zinapezeka kuti sikungopulumutsidwa osati mawonekedwe oyamba, komanso kukula kwa maselo.

Mkonzi wa Exel wathanzi umakhala ndi zida zochulukirapo kuti mupezere matebulo monga wosuta amafunikira. Tsoka ilo, sikuti aliyense amadziwa za kugwirira ntchito ndi zida zapadera ndi zida zina zomwe zimakupatsani mphamvu kuti muwonjezere zotheka kuti musinthe, komanso zomwe wogwiritsa ntchito.