Kugwira ntchito ndi matebulo ndiye ntchito yayikulu ya Excel. Kuti muchite zinthu zovuta pagawo lonse la tebulo, muyenera kusankha kaye ngati gulu lolimba. Sikuti ogwiritsa ntchito onse amadziwa momwe angachitire izi molondola. Komanso, pali njira zingapo zowonetsera izi. Tiyeni tiwone momwe, pogwiritsa ntchito njira zosiyanasiyana, mungapangire izi pamanja.
Ndondomeko Yopatula
Pali njira zingapo zosankhira tebulo. Zonsezi ndizosavuta ndipo zimagwira ntchito nthawi zonse. Koma nthawi zina, zina mwazosankha izi ndizosavuta kugwiritsa ntchito kuposa zina. Tiyeni tikambirane za magwiridwe antchito iliyonse.
Njira 1: Kusankha Kosavuta
Kusankha pagome kofala kwambiri komwe pafupifupi ogwiritsa ntchito onse amagwiritsa ntchito mbewa. Njira ndi yosavuta komanso yothandiza monga momwe kungathekere. Gwirani batani lamanzere lamanzere ndikusuntha chotembezera pazonse za tebulo. Ndondomeko ikhoza kuchitidwa ponseponse komanso pa digonal. Mulimonsemo, maselo onse m'derali adzaikidwa chizindikiro.
Kuphweka komanso kumveka bwino ndizofunikira zazikuluzikulu izi. Nthawi yomweyo, ngakhale imagwiranso ntchito pama tebulo akulu, sichinthu chosavuta kugwiritsa ntchito.
Phunziro: Momwe mungasankhire maselo mu Excel
Njira 2: kusankhidwa ndi kiyi
Mukamagwiritsa ntchito matebulo akulu, njira yosavuta kwambiri ndikugwiritsa ntchito kuphatikiza kwa hotkey Ctrl + A. M'mapulogalamu ambiri, kuphatikiza kumeneku kumapangitsa kuwonekera kwa chikalata chonse. Pazinthu zina, izi zimagwiranso ntchito ku Excel. Koma pokhapokha wogwiritsa ntchito atayimira kuphatikiza pamene chidziwitso mulibe chopanda kapena muchipinda chokha chosadzazidwa. Ngati kukanikiza kuphatikiza mabatani Ctrl + A kupanga pomwe tchipitikizo chili mu limodzi la maselo omwe ali pafupi (ziwiri kapena zingapo zoyandikana ndi deta), ndiye kuti kuwonekera koyamba kumangowunikira dera lino komanso chachiwiri - pepala lonse.
Ndipo gome ndiye, mulinso mndandanda wopitilira. Chifukwa chake, timadula iliyonse ya maselo ake ndikulemba makiyi Ctrl + A.
Gome lilozeredwa monga mtundu umodzi.
Ubwino wosatsutsika wa njirayi ndikuti ngakhale tebulo lalikulu kwambiri lingasankhidwe nthawi yomweyo. Koma njirayi ilinso ndi "zovuta". Ngati mtengo uliwonse kapena chidandaulo chayikidwa mwachindunji m'chipindacho pafupi ndi malire a tebuloyo, mzere woyandikana ndi mzere womwe mtengo womwe uli pamenepo udzasankhidwa zokha. Izi sizili chovomerezeka nthawi zonse.
Phunziro: Ogula otentha
Njira 3: Shift
Pali njira yothandizira kuthetsa vuto lomwe tafotokozazi. Zachidziwikire, sizimapereka magawidwe pompopompo, chifukwa izi zitha kuchitidwa pogwiritsa ntchito njira yachidule yodulira Ctrl + A, koma nthawi yomweyo kwa matebulo akulu ndikofunikira kwambiri komanso yabwino kuposa kusankha kosavuta kofotokozedwa koyambirira.
- Gwirani fungulo Shift pa kiyibodi, ikani cholozera mu khungu lamanzere lamanzere ndikudina kumanzere.
- Popanda kutulutsa kiyi Shift, falitsani pepalalo mpaka kumapeto kwa tebulo, ngati silikukwana kutalika kwa chophimba. Tikuyika chidziwitso mu bokosi lakumanzere kwa tebuloyo ndikudina kachiwiri ndi batani lakumanzere.
Pambuyo pa izi, gome lonse lidzasankhidwa. Kuphatikiza apo, masankhidwe adzachitika pokhapokha pakati pa maselo awiri omwe tidadutsawo. Chifukwa chake, ngakhale pali madera omwe ali ndi madera oyandikana nawo, sangaphatikizidwe mukusankhidwa.
Kudzipatula kumathandizanso m'njira zina. Choyamba pansi cell, kenako pamwamba. Mutha kutsatira njirayi kulowera lina: sankhani maselo akumanzere ndikumanzere kumanzere ndi kiyi yosindikizidwa Shift. Zotsatira zomaliza sizidalira kutsogoleredwa ndi dongosolo.
Monga mukuwonera, pali njira zazikulu zitatu zosankhira tebulo ku Excel. Yoyamba mwa iwo ndiyotchuka kwambiri, koma yosasokoneza madera akulu. Njira yothamanga kwambiri ndikugwiritsa ntchito njira yaying'ono Ctrl + A. Koma ili ndi zovuta zina zomwe zimatha kuchotsedwa pogwiritsa ntchito njira pogwiritsa ntchito batani Shift. Mwambiri, kupatula zosowa, njira zonsezi zitha kugwiritsidwa ntchito mulimonse.
