Kugwira ntchito ndi matebulo ndi ntchito yaikulu ya Excel. Kuti muchite zovuta pa tebulo lonse, muyenera choyamba kusankha ngati cholimba. Osati ogwiritsa ntchito onse akhoza kuchita izi moyenera. Komanso, pali njira zingapo zofotokozera izi. Tiyeni tipeze momwe mungagwiritsire ntchito njira zosiyanasiyana mungagwiritse ntchito njirayi pa gome.
Njira yosankha
Pali njira zingapo zosankhira tebulo. Zonsezi n'zosavuta ndipo zimagwira ntchito pafupifupi pafupifupi zonse. Koma nthawi zina, ena mwa njirazi ndi osavuta kugwiritsa ntchito kuposa ena. Tiyeni tipitirize kuganizira za mawonekedwe a ntchito iliyonse.
Njira 1: kusankha kophweka
Njira yodziwika kwambiri yosankha tebulo yomwe pafupifupi onse ogwiritsira ntchito ndi kugwiritsa ntchito mbewa. Njirayi ndi yophweka komanso yosamvetsetseka ngati n'kotheka. Gwiritsani botani lamanzere la mchenga ndi kukokera tebulo lonse. Ndondomekoyi ikhoza kuchitidwa ponseponse komanso pozungulira. Mulimonsemo, maselo onse a m'dera lino adzadziwika.
Kuphweka ndi kufotokozera - mwayi waukulu wa njirayi. Pa nthawi yomweyi, ngakhale kuti ikugwiranso ntchito pa matebulo akuluakulu, sizingatheke kuzigwiritsa ntchito.
Phunziro: Kusankha maselo mu Excel
Njira 2: Kusankhidwa kwachinsinsi
Mukamagwiritsa ntchito matebulo aakulu njira yabwino kwambiri ndikugwiritsa ntchito makiyi otentha. Ctrl + A. Mu mapulogalamu ambiri, kuphatikiza uku kumabweretsa kusankhidwa kwa chikalata chonsecho. Muzikhalidwe zina, izi zimagwiranso ntchito ku Excel. Koma pokhapokha ngati wogwiritsa ntchito akusindikiza mgwirizanowo pamene chithunzithunzi chili mu chopanda kanthu kapena mu chipinda chodzaza chosiyana. Ngati mukugwiritsira ntchito mabatani osakaniza Ctrl + A pamene mtolowo uli m'gulu limodzi la maselo (zochitika ziwiri kapena zambiri zomwe zili pafupi ndi deta), choyamba choyamba chingasankhe dera lino ndipo yachiwiri yokha idzasankha pepala lonse.
Ndipo tebulo ndilokulondola. Choncho, dinani pa selo iliyonse ndipo yesani njirayo Ctrl + A.
Gome lidzawonetsedwa ngati limodzi.
Chinthu chopanda kukayikira cha njirayi ndikuti ngakhale tebulo lalikulu kwambiri likhoza kupatsidwa pafupifupi nthawi yomweyo. Koma njira iyi ili ndi zovuta zake. Ngati mtengo kapena ndondomeko imalowetsedwa mu selo pamphepete mwa tablespace, pafupi ndi mzere kapena mzere kumene malowa alipo adzasankhidwa mwachangu. Zochitikazi sizimaloledwa nthawi zonse.
Phunziro: Keyi Zowonjezera mu Excel
Njira 3: Kusintha
Pali njira yothandizira kuthetsa vuto lomwe talitchula pamwambapa. Inde, sizimapereka kusankha kwasangamsanga, monga kungatheke pogwiritsa ntchito njira yachinsinsi Ctrl + A, koma panthawi imodzimodziyo magome aakulu ndi abwino komanso ophweka kusiyana ndi osankhidwa osankhidwa omwe akufotokozedwa poyamba.
- Gwiritsani chinsinsi Shift pa kibodiboli, ikani cholozera mu selo kumanzere kumanzere ndipo dinani batani lamanzere.
- Kusunga fungulo Shift, pezani pepala mpaka kumapeto kwa tebulo, ngati silingakwanire pakali pazenera. Ikani chithunzithunzi mu selo lakumanja la tablepace ndipo dinani kachiwiri ndi batani lamanzere.
Zitatha izi, tebulo lonse lidzawonetsedwa. Komanso, chisankhocho chidzachitika pokhapokha pa malire a pakati pa maselo awiri omwe ife tazijambula. Choncho, ngakhale pali madera a deta omwe ali pafupi, sakuphatikizidwa muchisankho ichi.
Kusankhidwa kungathenso kupangidwanso. Choyamba selo yapansi, ndiyeno chapamwamba. Ndondomekoyi ikhonza kuchitika kumbali inayo: sankhani maselo apamwamba ndi otsika m'maselo oseri ndi fungulo lomwe lili pansi Shift. Chotsatira chomaliza chimakhala chosasamala ndi malangizo ndi dongosolo.
Monga momwe mukuonera, pali njira zitatu zofunika kusankha tebulo ku Excel. Yoyamba ndi yotchuka kwambiri, koma yosasangalatsa kwa malo akuluakulu. Njira yofulumira kwambiri ndiyo kugwiritsa ntchito makiyi afupikitsidwe. Ctrl + A. Koma zili ndi zovuta zina, zomwe zingathetsedwe ndi kuthandizidwa ndi kusankha pogwiritsa ntchito batani Shift. Kawirikawiri, ndi zosiyana, njira zonsezi zingagwiritsidwe ntchito pazochitika zilizonse.
