Pakapita nthawi, buku lanu lantchito la Excel limakhala ndi mizere yochulukira ya data yomwe imakhala yovuta kuigwiritsa ntchito. Chifukwa chake, pakufunika mwachangu kubisa mizere yodzaza ndikutsitsa tsambalo. Mizere yobisika mu Excel siyiphatikiza pepala ndi zidziwitso zosafunikira ndipo nthawi yomweyo kutenga nawo gawo pazowerengera zonse. Mu phunziro ili, muphunzira momwe mungabise ndikuwonetsa mizere yobisika ndi mizati, komanso kuwasuntha ngati kuli kofunikira.
Sungani mizere ndi mizati mu Excel
Nthawi zina zimakhala zofunikira kusuntha mzere kapena mzere kuti mukonzenso pepala. Mu chitsanzo chotsatira, tiphunzira momwe tingasunthire ndime, koma mukhoza kusuntha mzere mofanana ndendende.
- Sankhani mzati womwe mukufuna kusuntha podina pamutu wake. Kenako dinani Dulani lamulo pa tabu Yanyumba kapena njira yachidule ya kiyibodi Ctrl+X.
- Sankhani ndime ili kumanja kwa malo omwe mukufuna kuyikapo. Mwachitsanzo, ngati mukufuna kuyika mzati woyandama pakati pa mizati B ndi C, sankhani ndime C.
- Pa tabu Yanyumba, kuchokera pa menyu yotsitsa ya lamulo la Matani, sankhani Matani Odula Maselo.
- Mzerewu udzasunthidwa kumalo osankhidwa.
Mutha kugwiritsa ntchito malamulo a Dulani ndi Matani podina kumanja ndikusankha malamulo ofunikira kuchokera pazosankha.
Kubisa mizere ndi mizati mu Excel
Nthawi zina zimakhala zofunikira kubisa mizere kapena mizati, mwachitsanzo, kuzifanizitsa ngati zili kutali ndi mzake. Excel imakupatsani mwayi wobisa mizere ndi mizati ngati pakufunika. Muchitsanzo chotsatirachi, tidzabisa mizati C ndi D kuti tifanizire A, B ndi E. Mukhoza kubisa mizere mofanana.
- Sankhani mizati yomwe mukufuna kubisa. Kenako dinani kumanja pagulu lomwe mwasankha ndikusankha Bisani kuchokera pamenyu yankhaniyo.
- Mizati yosankhidwa idzabisika. Mzere wobiriwira umasonyeza malo a mizati yobisika.
- Kuti muwonetse mizati yobisika, sankhani mizati kumanzere ndi kumanja kwa zobisika (mwa kuyankhula kwina, kumbali zonse za zobisika). Mu chitsanzo chathu, awa ndi mizati B ndi E.
- Dinani kumanja pamndandanda womwe wasankhidwa, kenako sankhani Onetsani kuchokera pamenyu yankhani. Mizati yobisika idzawonekeranso pazenera.