Chimodzi mwazinthu zosangalatsa komanso zothandiza ku Excel ndikuthekera kophatikiza maselo awiri kapena kupitilira limodzi. Izi ndizofunikira makamaka popanga zolemba ndi zolemba za patebulo. Ngakhale, nthawi zina imagwiritsidwa ntchito ngakhale mkati mwa tebulo. Nthawi yomweyo, muyenera kuganizira kuti pophatikiza zinthu, zina zimaleka kugwira ntchito molondola, monga kusankha. Palinso zifukwa zina zambiri zomwe wosuta asankha kutulutsa maselo kuti apange tebulo mwanjira ina. Tikhazikitsa njira izi zomwe zingachitike.
Kupatukana kwa Maselo
Njira yolekanitsira maselo ndiyo kusinthanitsa. Chifukwa chake, m'mawu osavuta, kuti mumalize, muyenera kusiya zomwe zidachitika panthawi yophatikizira. Chofunikira kwambiri kuti mumvetsetse ndikuti mutha kungochotsa khungu lomwe lili ndi zinthu zingapo zophatikizika kale.
Njira 1: kusanja mazenera
Ogwiritsa ntchito ambiri amagwiritsidwa ntchito pophatikizira pazenera lophatikizira ndi kusintha kumeneko kudzera mumenyu yazonse. Chifukwa chake, nawonso adzalumikiza.
- Sankhani khungu lolumikizidwa. Dinani kumanja kuti mutsegule menyu yankhani yonse. Pamndandanda womwe umatsegulira, sankhani "Mtundu wamtundu ...". M'malo mwa izi, mutasankha chinthu, mutha kungolembera mabatani pazibatani Ctrl + 1.
- Pambuyo pake, zenera losintha deta limayamba. Pitani ku tabu Kuphatikiza. Mu makatani "Onetsani" sakani njira Cell Union. Kuti mugwiritse ntchito chochita, dinani batani "Zabwino" pansi pazenera.
Pambuyo pazinthu zosavuta izi, khungu lomwe mudagwirako ntchito lidzagawika m'magawo ake. Kuphatikiza apo, ngati deta idasungidwamo, ndiye kuti yonse idzakhala kumanzere kwakumanzere.
Phunziro: Kukhazikitsa matebulo ku Excel
Njira 2: Chingwe cha Ribbon
Koma mwachangu komanso mosavuta, ndikutanthauzira kumodzi, mutha kuwononga zinthuzo kudzera pabatani.
- Monga momwe munachitira kale, choyambirira, muyenera kusankha khungu limodzi. Kenako pagulu lazida Kuphatikiza pa tepi dinani batani "Phatikizani ndi pakati".
- Pankhaniyi, kupatula dzinalo, zochita zotsutsana ndi zomwe zimachitika mutatha kukanikiza batani: zinthuzo sizingatheke.
Kwenikweni pa izi, zosankha zonse zakulekanitsa maselo zimatha. Monga mukuwonera, pali awiri okha aiwo: mawonekedwe a mawonekedwe ndi batani pa riboni. Koma njira izi ndizokwanira mokwanira komanso njira yabwino yokwaniritsira njira yomwe ili pamwambapa.
