Kuti achite zosiyana pa zomwe zili mu Excel maselo, ayenera choyamba kusankhidwa. Pazinthu izi, pulogalamuyi ili ndi zipangizo zingapo. Choyamba, kusiyana kotereku ndi chifukwa chakuti palifunika kusankha magulu osiyanasiyana a maselo (mzere, mizera, zipilala), komanso kufunika kolemba zinthu zomwe zikugwirizana ndi chikhalidwe china. Tiyeni tipeze momwe tingachitire izi mwa njira zosiyanasiyana.
Ndondomeko yogawidwa
Mukasankha, mungagwiritse ntchito phokoso ndi makina. Palinso njira zomwe zipangizo zowonjezerazi zimagwirizanirana.
Njira 1: Cell Single
Kuti musankhe selo losiyana, ingokanizani chithunzithunzi pa ilo ndi dinani batani lamanzere. Kusankhidwa kumeneku kungapangidwenso pogwiritsa ntchito makatani oyendetsa makina. "Kutsika", "Kukwera", "Cholondola", "Kumanzere".
Njira 2: Sankhani ndimeyi
Kuti muike chizindikiro pazomwe muli patebulo, muyenera kugwiritsira ntchito batani lamanzere ndikusunthira kuchoka pa selo lapamwamba kwambiri pamtanda mpaka pansi, kumene batani ayenera kumasulidwa.
Palinso njira yothetsera vutoli. Sambani batani Shift pa kibokosilo ndipo dinani pamwamba pa selo lachonde. Ndiye, popanda kumasula batani, dinani pansi. Mukhoza kuchita zosiyana.
Kuwonjezera apo, kusankha masalimo mu matebulo, mungagwiritse ntchito njira zotsatirazi. Sankhani selo yoyamba ya chigawocho, kumasula mbewa ndikusindikiza kuphatikiza Ctrl + Shift + Pansi Mzere. Izi zidzakweza mzere wonse mpaka gawo lomalizira limene deta ili. Chinthu chofunika kwambiri pakuchita izi ndi kusakhala kwa maselo opanda kanthu mu ndimeyi. Pankhani yosiyana, malo okhawo asanakhalepo choyamba chopanda kanthu.
Ngati simukusankha kokha ndondomeko ya tebulo, koma mzere wonse wa pepala, ndiye kuti mukufunika kudinkhani botani lamanzere lamanzere pa gawo lofanana lazowonongeka, kumene makalata a zilembo za Chilatini amadziwika maina a zipilalazo.
Ngati mukufuna kusankha mazenera angapo a pepala, ndiye gwiritsani mbewa ndi batani lamanzere lomwe likugwirizanitsa pamodzi ndi magawo omwe akugwirizana nawo.
Pali njira ina yothetsera vutoli. Sambani batani Shift ndipo lembani ndondomeko yoyamba muzotsatira zomwe mwasankha. Ndiye, popanda kumasula batani, dinani pa gawo lomalizira lazowonjezereka m'ndondomeko yazitsulo.
Ngati mukufuna kusankha mazamu osiyana a pepala, ndiye gwiritsani batani Ctrl ndipo, popanda kumasula, dinani pamagulu pazowonongeka kwa malemba omwe mukufuna kulemba.
Njira 3: kusankha mzere
Mizere ya Excel imasiyanso ndi mfundo yofanana.
Kusankha mzere umodzi patebulo, ingokokera chithunzithunzi pamwamba pake ndi batani yomwe ili pansi.
Ngati tebulo ndi lalikulu, ndisavuta kugwira batani. Shift ndipo pang'onopang'ono dinani selo loyamba ndi lotsiriza la mzerewu.
Ndiponso, mizere m'matawuni imatha kulembedwa mofanana ndi zipilala. Dinani pa chinthu choyamba m'ndandanda, ndikulanizitsa kuphatikiza Ctrl + Shift + Kwanja lamanja. Mzerewu ukuwonetsedwa kumapeto kwa tebulo. Koma kachiwiri, chinthu chofunika kwambiri pankhaniyi ndi kupezeka kwa deta mu maselo onse a mzere.
Kusankha mzere wonse wa pepala, dinani pa gawo lofanana la gulu loyang'anitsitsa, kumene chiwerengerochi chikuwonetsedwa.
Ngati mukufuna kusankha mizere yaying'ono pafupi ndi njirayi, yesani mbewa ndi batani lamanzere lomwe likugwiritsidwa ntchito pa gulu lomwe likugwirizana ndi gululi.
Mungathenso kugwira batani Shift ndipo dinani mbali yoyamba ndi yomalizira mu gulu logwirizana la mizere yomwe iyenera kusankhidwa.
Ngati mukufuna kusankha mizere yosiyana, ndiye dinani m'madera onsewa pamzere wozungulira wotsindikiza ndi batani yomwe ili pansi Ctrl.
Njira 4: kusankha pepala lonse
Pali mitundu iwiri ya njirayi pa pepala lonse. Yoyamba mwa izi ndikutsegula pa botani laling'onoting'ono lomwe lili pamsewu wa makonzedwe ofanana ndi ozungulira. Pambuyo pazomwe izi zidzasankhidwa kwathunthu maselo onse pa pepala.
Kugwiritsa ntchito mafungulo kumayambitsa zotsatira zomwezo. Ctrl + A. Zoona, ngati panthawiyi chithunzithunzi chili ndi deta yosasinthasintha, mwachitsanzo, mu tebulo, poyamba pokhapokha dera lino lidzakambidwa. Pambuyo pokhapokha muthamangitsira kuphatikiza adzatha kusankha pepala lonse.
Njira 5: Kugawa Kwapakati
Tsopano tikupeza momwe tingasankhire magulu osiyanasiyana a maselo pa pepala. Pofuna kuchita izi, kokwanira kuzungulira chithunzithunzi ndi batani lamanzere lomwe limagwiritsidwa ntchito kudera linalake pa pepala.
Mungasankhe mtunduwu poika batani. Shift pa khididiyi ndipo pang'onopang'ono dinani kumtunda wakumanzere ndi kuchepetsa selo yolondola la dera losankhidwa. Kapena pochita opaleshoniyi: dinani m'munsi mwa maselo omwe ali kumunsi ndi kumtunda. Mndandanda wa pakati pa zinthu izi udzasindikizidwa.
Palinso kuthekera kwa kulekanitsa maselo kapena mapawi atalikirana. Kuti muchite izi, mwa njira iliyonse yomwe ili pamwambayi, muyenera kusankha mosiyana malo omwe wolembayo akufuna kuitchula, koma batani ayenera kukanikizidwa. Ctrl.
Njira 6: Gwiritsani ntchito zotentha
Mukhoza kusankha malo amodzi pogwiritsa ntchito zotentha:
- Ctrl + Kwathu - kusankhidwa kwa selo yoyamba ndi deta;
- Ctrl + Mapeto - kusankhidwa kwa selo lotsiriza ndi deta;
- Ctrl + Shift + Kutha - kusankha maselo mpaka kugwiritsidwa ntchito kotsiriza;
- Ctrl + Shift + Home - kusankha maselo mpaka kumayambiriro kwa pepala.
Zosankhazi zidzakuthandizani kuti muzisunga nthawi yopanga ntchito.
Phunziro: Keyi Zowonjezera mu Excel
Monga mukuonera, pali zifukwa zambiri zosankha maselo ndi magulu awo osiyanasiyana pogwiritsa ntchito kibokosi kapena mbewa, komanso kugwiritsa ntchito magulu awiriwa. Wosuta aliyense akhoza kusankha kalembedwe kamene kamakhala kosavuta kwa iye payekha, popeza ndi bwino kusankha imodzi kapena maselo ambiri mwa njira imodzi, ndi kusankha mzere wonse kapena pepala lonselo.
