Kwa ogwiritsa ntchito ambiri a Excel, ndondomeko yojambula matebulo sivuta. Koma sikuti aliyense akudziwa zina mwazithunzi zomwe zimapangitsa kuti njirayi ikhale yogwira bwino pa mitundu yosiyanasiyana ya deta komanso zolinga zosiyanasiyana. Tiyeni tione zina mwa zinthu zomwe mukujambula deta ku Excel.
Lembani mu Excel
Kujambula tebulo ku Excel ndiko kulengedwa kwake. Muzochitika zokha, palibe kusiyana kulikonse malingana ndi kumene muti mupange deta: kudera lina la pepala limodzi, pa pepala latsopano kapena mu bukhu lina (fayilo). Kusiyanitsa kwakukulu pakati pa njira yojambula ndi momwe mukufuna kufotokozera chidziwitso: ndi malemba kapena ndi deta yosonyezedwa.
Phunziro: Kujambula matebulo mu Mawu a Mirosoft
Njira 1: Lembani mwachinsinsi
Kukopera kophweka mwachisawawa mu Excel kumapereka kupanga kapangidwe ka tebulo limodzi ndi maulendo onse ndi maonekedwe omwe aikidwa mmenemo.
- Sankhani malo omwe tikufuna kuwatsanzira. Dinani kumalo osankhidwa ndi batani lamanja la mouse. Menyu yamakono ikuwonekera. Sankhani chinthu mmenemo "Kopani".
Pali njira zina zomwe mungasankhire pochita masitepe awa. Choyamba ndichokakamizira njira yachinsinsi pa kambokosi. Ctrl + C mutasankha dera. Njira yachiwiri ikuphatikizapo kukakamiza batani. "Kopani"yomwe ili pa leboni mu tabu "Kunyumba" mu gulu la zida "Zokongoletsera".
- Tsegulani malo omwe tikufuna kuika deta. Ichi chikhoza kukhala pepala latsopano, fayilo ina ya Excel, kapena dera lina la maselo pa tsamba limodzi. Dinani mu selo, yomwe iyenera kukhala pamwamba pamzere selo la tebulo lolowetsedwa. Mu menyu yoyenera pazowonjezera, sankhani chinthu "Insert" chinthu.
Palinso njira zina zomwe mungasankhire. Mukhoza kusankha selo ndikusindikizira mgwirizano wa makiyi pa makiyi Ctrl + V. Mwinanso, mukhoza kudinkhani pa batani. Sakanizaniyomwe ili kumbali yakumanzere ya tepi pafupi ndi batani "Kopani".
Pambuyo pake, deta idzasindikizidwa ndikusungiranso zojambula ndi mawonekedwe.
Njira 2: Lembani Makhalidwe Abwino
Njira yachiwiri imaphatikizapo kukopera zokhazokha za tebulo zomwe zikuwonetsedwa pazenera, osati maonekedwe.
- Lembani deta mwa njira imodzi yomwe tafotokozera pamwambapa.
- Dinani botani lamanja la mouse pamalo omwe mukufuna kulemba deta. Mu menyu yoyenera pazowonjezereka, sankhani chinthucho "Makhalidwe".
Pambuyo pake, tebulo idzawonjezeredwa ku pepala popanda kusunga maonekedwe ndi mawonekedwe. Izi ndizokha, deta yomwe ili pulogalamuyi idzaponyedwa.
Ngati mukufuna kutsanzira zikhulupilirozo, koma sungani maonekedwe oyambirira, muyenera kupita kumtundu wazinthu pakalowa "Sakani Mwapadera". Kumeneko mu chipikacho "Ikani malonda" muyenera kusankha chinthu "Makhalidwe ndi maonekedwe oyambirira".
Pambuyo pake, tebulo lidzawonetsedwa mu mawonekedwe ake oyambirira, koma m'malo mwa maonekedwe, maselo adzadzaza ndi zoyenera nthawi zonse.
Ngati mukufuna kupanga opaleshoniyi pokhapokha mutasunga mawerengedwe a manambala, osati tebulo lonse, ndiye muyilo yapadera muyenera kusankha chinthucho "Makhalidwe ndi Mapangidwe A Nambala".
Njira 3: Pangani kanema pamene mukusunga unyinji wa zipilala
Koma, mwatsoka, ngakhale kugwiritsa ntchito maonekedwe oyambirira sikulola kupanga tebulo la tebulo ndi chigawo choyambirira chazitsulo. Izi ndizoti nthawi zambiri pamakhala mavoti atatha kuika deta sikugwirizana ndi maselo. Koma mu Excel n'zotheka kusunga chigawo choyambirira chazitsulo pogwiritsa ntchito zochitika zina.
- Lembani tebuloyi m'njira iliyonse.
- Kumalo kumene muyenera kuyika deta, dinani mndandanda wa masewera. Squentially timapita pamwamba pa mfundozo "Sakani Mwapadera" ndi "Sungani m'lifupi la zikhomo zoyambirira".
Inu mukhoza kuchita mwanjira ina. Kuchokera m'ndandanda wamakono, pitani ku chinthucho ndi dzina lomwelo kawiri. "Kuika Mwapadera ...".
Zenera likuyamba. Mu "Insert" chida chogwiritsira ntchito, yesani kusinthana ku malo "M'lifupi". Timakanikiza batani "Chabwino".
Mulimonse momwe mungasankhire paziganizo ziwirizi, mulimonsemo, tebulo lokoperedwa lidzakhala ndi chigawo chimodzimodzi m'lifupi monga gwero.
Njira 4: Yesani ngati chithunzi
Pali milandu pamene tebulo iyenera kuikidwa osati mwachizolowezi, koma ngati chithunzi. Vutoli lidzathetsedwanso ndi chithandizo chapadera.
- Timatsanzira maulendo omwe timafuna.
- Sankhani malo oyikapo ndi kuitanitsa mndandanda wamakono. Pitani ku mfundo "Sakani Mwapadera". Mu chipika "Njira Zina Zowonjezera" sankhani chinthu "Kujambula".
Pambuyo pake, deta idzalowetsedwa mu pepala monga chithunzi. Mwachibadwa, sikungatheke kusintha tebulo ili.
Njira 5: Kapepala Kapepala
Ngati mukufuna kufotokozera tebulo lonselo pa pepala lina, koma panthawi imodzimodziyo muzisunga mofanana ndi ndondomeko yanu, ndiye kuti ndibwino kuti mufanizire pepala lonse. Pachifukwa ichi, ndikofunikira kudziwa kuti mukufunadi kutumiza zonse zomwe zili pamasamba, ngati njirayi isagwire ntchito.
- Kuti musasankhe mwapadera maselo onse a pepala, zomwe zingatenge nthawi yochuluka, dinani pamakona omwe ali pakati pazowonongeka ndi zowonongeka. Pambuyo pake, pepala lonse lidzakambidwa. Kuti mufanizire zomwe zilipo, yesani kusakaniza pa makiyi Ctrl + C.
- Kuyika deta, kutsegula pepala latsopano kapena bukhu latsopano (fayilo). Mofananamo, dinani pamakona omwe ali pambali ya mapepala. Kuti muike deta, yesani makina osakaniza Ctrl + V.
Monga mukuonera, titatha kuchita izi, tinatha kukopera pepala limodzi ndi tebulo ndi zina zonse. Panthawi imodzimodziyo sizinasungidwe zokhazokha, komanso kukula kwa maselo.
Msewu Wowonjezera Excel ali ndi zida zambiri zokopera matebulo chimodzimodzi ndi mawonekedwe ofunidwa ndi wogwiritsa ntchito. Mwamwayi, siyense akudziwa za maonekedwe akugwiritsidwa ntchito ndi malo ena apadera ndi zida zina zokopera zomwe zingathe kuwonjezera kwambiri mwayi wopititsa deta, komanso kugwiritsira ntchito zochita zogwiritsa ntchito.
