Wosuta aliyense akugwira ntchito ku Excel, posakhalitsa amakumana ndi momwe zinthu zomwe zili mu selo sizigwirizana ndi malire ake. Pankhaniyi, pali njira zambiri zochotsera izi: kuchepetsa kukula kwa zomwe zili; zigwirizana ndi zomwe zilipo; yonjezerani kuchuluka kwa maselo; wonjezere kutalika kwake. Chakumapeto kwa mavesi otsiriza, omwe ali okhudza kusankha kutalika kwa mzere, tidzakambirana zambiri.
Kugwiritsa ntchito kusankha
Kuzikonza kwapadera ndi chida chogwiritsidwa ntchito mu Excel chomwe chimathandiza kuwongolera maselo. Nthawi yomweyo tiyenera kukumbukira kuti, ngakhale dzina, ntchitoyi siimagwiritsidwa ntchito. Kuti muwonjezere chinthu china, muyenera kusankha mndandanda ndikugwiritsa ntchito chida chodziwika.
Kuwonjezera apo, ziyenera kunenedwa kuti kukwera kwa galimoto kumagwira ntchito ku Excel kokha kwa maselo omwe ali ndi mawu okulumikiza mawu amathandizidwa pakukongoletsa. Kuti mulowetse malowa, sankhani selo kapena pezani pepala. Dinani kusankhidwa ndi batani lamanja la mouse. M'ndandanda wamakono, sankhani malo "Sungani maselo ...".
Pali kutsegulira kwazenera mawonekedwe. Pitani ku tabu "Kugwirizana". Mu bokosi lokhalamo "Onetsani" onetsetsani bokosi pafupi ndi choyimira "Tsatirani ndi mawu". Kuti muzisunga ndi kugwiritsa ntchito kusintha kosinthika, dinani pa batani "Chabwino"yomwe ili pansi pazenera ili.
Tsopano, pa chidutswa chosankhidwa cha pepala, kukulumikiza mawu kumaphatikizidwa ndipo mungagwiritse ntchito posankha kusankha kutalika kwa mzere. Ganizirani momwe mungachitire zimenezi m'njira zosiyanasiyana pogwiritsa ntchito chitsanzo cha Excel 2010. Komabe, ziyenera kuzindikiranso kuti ndondomeko yofanana ya ntchito ingagwiritsidwe ntchito potsatira pulogalamuyi ndi Excel 2007.
Njira 1: Konzani Panel
Njira yoyamba imaphatikizapo kugwira ntchito ndi gulu loyang'anizana lomwe ma tebulo a mzere alipo.
- Dinani pa chiwerengero cha mndandanda pazowonjezera kuti muzitha kugwiritsa ntchito kukwera kwa galimoto. Pambuyo pachitachi, mzere wonsewo udzawonetsedwa.
- Timakhala pamalire apansi a mzere mu gawo la gulu logwirizana. Chotsegulacho chiyenera kutenga mawonekedwe a muvi wolozera mbali ziwiri. Dinani kawiri pa batani lamanzere.
- Pambuyo pazigawozi, ndizomwe zidakali zosasinthika, kutalika kwa mzere kumangowonjezera mofunikira kwambiri, kotero kuti mawu onse omwe ali mu maselo ake onse akuwoneka pa pepala.
Njira 2: Thandizani kuthamanga mofanana ndi mizere yambiri
Njira yomwe ili pamwambayi ndi yabwino pamene mukuyenera kuti muyambe kugwiritsira ntchito mzere umodzi kapena awiri, koma bwanji ngati pali zinthu zambiri zofanana? Pambuyo pake, ngati tichita molingana ndi ndondomeko yomwe idatchulidwa poyamba, ndiye kuti ndondomekoyi iyenera kuthera nthawi yambiri. Pankhaniyi, pali njira yotulukira.
- Sankhani mzere wonse wa mizere yomwe ntchito yeniyeniyo iyenera kugwirizanitsidwa pa gulu logwirizana. Kuti muchite izi, gwiritsani batani lamanzere ndi kugwedeza chithunzithunzi pa gawo lomwe likugwirizana ndi gululi.
Ngati malowa ndi aakulu kwambiri, dinani pang'onopang'ono pa gawo loyambalo, kenaka dikirani batani Shift pa kambokosi ndipo dinani mbali yomaliza ya gulu logwirizana la malo omwe mukufuna. Pankhaniyi, mizere yake yonse idzafotokozedwa.
- Ikani malonda pa malire a m'munsi mwa magawo onse osankhidwa mu gulu logwirizana. Pachifukwa ichi, chithunzithunzi chiyenera kutengera ndondomeko yomweyo. Dinani kawiri pa batani lamanzere.
- Pambuyo pochita ndondomekoyi, mzere wonse wa osankhidwawo udzawonjezeka kutalika kwa kukula kwa deta yosungidwa m'maselo awo.
Phunziro: Kusankha maselo mu Excel
Njira 3: Chotsani pazitsulo
Kuphatikizanso, mungagwiritse ntchito chida chapadera pa tepi kuti muyambe kujambula pamtunda wa selo.
- Sankhani zolemba pa pepala limene mukufuna kugwiritsa ntchito zozizwitsa. Kukhala mu tab "Kunyumba", dinani pa batani "Format". Chida ichi chimayikidwa pazenera zolepheretsa. "Maselo". Mndandanda umene umapezeka m'gululi "Cell Size" sankhani chinthu "Mzere wamtundu wamtundu wosankhidwa".
- Pambuyo pake, mizere ya mitundu yosankhidwa idzawonjezera msinkhu wawo mofunikira kwambiri kuti maselo awo asonyeze zonse zomwe zili mkati mwake.
Njira 4: Sankhani Kutalika kwa Maselo Ogwirizanitsidwa
Pa nthawi imodzimodziyo, tiyenera kukumbukira kuti ntchito yodzikongoletsa siigwira ntchito pa maselo ogwirizana. Koma panopa, palinso njira yothetsera vutoli. Njira yopulumukira ndiyo kugwiritsa ntchito ndondomeko ya zochita zomwe selo weniweni limagwirizanitsa sizichitika, koma zokhazokha. Choncho, tidzatha kugwiritsa ntchito teknoloji yodzigwiritsira ntchito.
- Sankhani maselo omwe mukufuna kuwagwirizanitsa. Dinani kusankhidwa ndi batani lamanja la mouse. Pitani ku chinthu cha menyu "Sungani maselo ...".
- Muwindo lokhazikitsa lomwe limatsegula, pitani ku tabu "Kugwirizana". Mu bokosi lokhalamo "Kugwirizana" m'munda wapadera "Mwachilendo" sankhani mtengo "Kusankha kwa pakati". Pambuyo pokonza, dinani pa batani "Chabwino".
- Zitatha izi, deta ikupezeka kudera lonse logawa, ngakhale kuti ilo likusungidwa m'seri yotsala, popeza kuyanjana kwa zinthu, kwenikweni, sikuchitika. Choncho, ngati, mwachitsanzo, muyenera kuchotsa malembawo, ndiye kuti akhoza kuchitidwa kokha kumaselo omaliza. Kenaka sankhani mapepala onse omwe malembawo aikidwa. Mu njira iliyonse yapitayi yomwe yakhala ikufotokozedwa pamwambapa, timaphatikizapo autosampling kutalika.
- Monga mukuonera, pambuyo pa zochitikazi, zodzipangira kusankha kutalika kwa mzere zinapangidwa ndi chinyengo chopitilira cha kuphatikiza zinthu.
Kuti musasankhe mwapatali kutalika kwa mzere uliwonse, ndikugwiritsa ntchito nthawi yochuluka, makamaka ngati tebulo ndi lalikulu, ndi bwino kugwiritsa ntchito chida cha Excel ngati chosankha. Ndicho, mukhoza kusintha kusintha kwa mizere ya maulendo aliwonse. Vuto lokha lingakhalepo ngati mutagwira ntchito ndi pepala pomwe maselo ophatikizidwa alipo, koma panopa mungapeze njira yothetsera zochitika pakali pano polemba zomwe mwasankha mwa kusankha.
