Selo mu Excel ndiye gawo lalikulu la pepala momwe mungalowetse deta ndi zina. Mu phunziro ili, tiphunzira zoyambira zogwirira ntchito ndi ma cell ndi zomwe zili mkati mwake kuti muwerenge, kusanthula ndi kukonza deta mu Excel.
Kumvetsetsa Maselo mu Excel
Tsamba lililonse mu Excel limapangidwa ndi masauzande a rectangles otchedwa ma cell. Selo ndi mphambano ya mzere ndi mzere. Mizere mu Excel imatanthauzidwa ndi zilembo (A, B, C), pamene mizere imasonyezedwa ndi manambala (1, 2, 3).
Kutengera mzere ndi gawo, selo lililonse mu Excel limapatsidwa dzina, lomwe limadziwikanso kuti adilesi. Mwachitsanzo, C5 ndi selo yomwe ili pamzere wa mzere C ndi mzere 5. Mukasankha selo, adilesi yake imawonetsedwa pagawo la Dzina. Chonde dziwani kuti cell ikasankhidwa, mitu ya mzere ndi gawo lomwe ili pamzerewu imawonetsedwa.
Microsoft Office Excel imatha kusankha ma cell angapo nthawi imodzi. Maselo awiri kapena kuposerapo amatchedwa range. Mtundu uliwonse, monga selo, uli ndi adilesi yake. Nthawi zambiri, adilesi yamitundu imakhala ndi ma adilesi akumanzere kumanzere ndi ma cell akumanja akumanja, olekanitsidwa ndi colon. Mtundu woterewu umatchedwa contiguous kapena mosalekeza. Mwachitsanzo, mitundu yomwe ili ndi maselo B1, B2, B3, B4, ndi B5 ingalembedwe ngati B1:B5.
Chithunzi chili m'munsichi chikuwonetsa mitundu iwiri ya ma cell:
- Mtundu A1:A8
- Mtundu A1:B8
Ngati mizati patsamba lantchito ikuimiridwa ndi manambala m'malo mwa zilembo, muyenera kusintha mawonekedwe a ulalo wokhazikika mu Excel. Kuti mumve zambiri, onani phunziro: Kodi mawonekedwe a maulalo mu Excel ndi ati.
Sankhani ma cell mu Excel
Kuti mulowetse deta kapena kusintha zomwe zili mu selo, muyenera kusankha kaye.
- Dinani pa selo kuti musankhe.
- Selo yosankhidwa ikhala m'malire ndipo mitu ndi mizere zidzawonetsedwa. Selo ikhalabe yosankhidwa mpaka mutasankha selo lina lililonse.
Mukhozanso kusankha ma cell pogwiritsa ntchito makiyi a mivi pa kiyibodi yanu (makiyi a mivi).
Sankhani ma cell angapo mu Excel
Mukamagwira ntchito ndi Excel, nthawi zambiri pamafunika kusankha gulu lalikulu la maselo kapena osiyanasiyana.
- Dinani pa selo yoyamba mu mndandanda ndipo, popanda kutulutsa batani, sunthani mbewa mpaka maselo onse oyandikana nawo omwe mukufuna kusankha asankhidwa.
- Tulutsani batani la mbewa, gawo lofunikira lidzasankhidwa. Maselo adzakhala osankhidwa mpaka mutasankha selo lina lililonse.
