Mukamagwira ntchito ndi Excel spreadsheets, nthawi zina muyenera kubisala mbali zina za pepala. Nthawi zambiri izi zimachitika ngati, mwachitsanzo, mayesero amapezeka mwa iwo. Tiyeni tipeze momwe tingabisire zikhomo pulogalamuyi.
Zolinga zobisala
Pali njira zingapo zomwe mungakwaniritsire. Tiyeni tiwone chomwe iwo aliri.
Njira 1: Kusintha kwa Cell
Njira yabwino kwambiri yomwe mungathe kukwaniritsa zotsatira zake ndi kusintha kwa maselo. Kuti tichite njirayi, timayendetsa chithunzithunzi pazowonongeka komwe kumalo komwe malire ali. Mtsinje wotsutsa womwe ukulozera mbali zonse ziwiri ukuwonekera. Timasankha batani lakumanja lamanzere ndikukoka malire a chigawo chimodzi kupita kumalire a wina, monga momwe zingakhalire.
Pambuyo pake, chinthu chimodzi chidzabisika pambuyo pa chimzake.
Njira 2: Gwiritsani ntchito menyu yoyenera
Ndizovuta kwambiri kuti zolinga izi zigwiritsidwe ntchito mndandanda wamakono. Choyamba, ndi zophweka kusiyana ndi kusuntha malire, ndipo kachiwiri, n'zotheka kukwaniritsa ma selo mokwanira, mosiyana ndi zomwe zapitazo.
- Dinani botani lamanja la mouse pamphindi wosakanikirana ozungulira m'dera la kalatini ya Chilatini yomwe imasonyeza kuti chinsinsicho chibisika.
- M'ndandanda wamakono yomwe ikuwonekera, dinani pa batani "Bisani".
Pambuyo pake, ndondomekoyi idzabisika. Kuti mutsimikizire izi, yang'anani momwe zikhomozo zilili zolemba. Monga momwe mukuonera, kalata imodzi ikusoweka mu dongosolo.
Ubwino wa njira iyi pazipitazo ndi kuti ungagwiritsidwe ntchito kubisala zingapo zofanana panthawi yomweyo. Kuti achite izi, amafunika kusankhidwa, ndipo pakakhala masewera apamwamba, dinani pa chinthucho "Bisani". Ngati mukufuna kupanga njirayi ndi zinthu zomwe sizili pafupi, koma zowbalalika kuzungulira pepala, ndiye kusankha kusankhidwa ndi batani Ctrl pabokosi.
Njira 3: Gwiritsani ntchito zipangizo pa tepi
Kuphatikizanso apo, mungathe kuchita izi mwa kugwiritsa ntchito chimodzi mwa mabatani omwe ali pa kabati mu bokosi lazamasamba. "Maselo".
- Sankhani maselo omwe ali pazitsulo kuti azibisika. Kukhala mu tab "Kunyumba" dinani pa batani "Format"yomwe imayikidwa pa tepi mu zida za zipangizo "Maselo". Mu menyu omwe akuwonekera mu gulu la zosankha "Kuwoneka" dinani pa chinthu "Bisani kapena Kuwonetsa". Mndandanda wina umasankhidwa momwe muyenera kusankha chinthucho "Bisani ndemanga".
- Pambuyo pazochitikazi, zikhozo zidzabisika.
Monga momwe zinalili kale, njira iyi mukhoza kubisa zinthu zingapo kamodzi, ndikuzisankha monga tafotokozera pamwambapa.
Phunziro: Momwe mungasonyezere mazamu obisika ku Excel
Monga momwe mukuonera, pali njira zingapo zobisira mizere ku Excel. Njira yabwino kwambiri ndiyo kusuntha maselo. Koma, tikulimbikitsidwa kuti tigwiritse ntchito chimodzi mwazigawo ziwiri zotsatirazi (mndandanda wamkati kapena batani pa riboni), popeza akutsimikizira kuti maselo adzabisika. Kuwonjezera apo, zinthu zomwe zimabisika mwanjira imeneyi zidzakhala zosavuta kubwereranso ngati pakufunika.
