Pogwira ntchito ndi matebulo, nthawizina pamakhala kusintha kusintha mazenera omwe ali mmalo mwake. Tiyeni tiwone momwe tingachitire izi mu Microsoft Excel popanda kutaya deta, koma panthawi yomweyi, mosavuta komanso mofulumira.
Mizere yosunthira
Mu Excel, zipilala zingasinthidwe m'njira zingapo, zonse zimakhala zovuta komanso zowonjezereka.
Njira 1: Lembani
Njira iyi ndiyonse, monga yoyenera ngakhale kwa zaka zambiri za Excel.
- Timasankha pa selo iliyonse yachitsulo kumanzere komwe timakonzekera kusuntha khola lina. M'ndandanda wa nkhani, sankhani chinthucho "Sakani ...".
- Dera laling'ono likuwoneka. Sankhani mtengo mkati mwake "Column". Dinani pa chinthucho "Chabwino"pambuyo pake ndime yatsopano mu tebulo idzawonjezeredwa.
- Dinani pang'onopang'ono pamphaneti wodalumikiza pamalo omwe dzina la ndime yomwe tikufuna kusuntha likuwonetsedwa. Mu menyu yachidule, lekani kusankha pa chinthucho "Kopani".
- Gwiritsani ntchito batani lamanzere kuti muzisankha ndondomeko yomwe munapanga kale. M'mawotchu a nkhaniyi muzitsulo "Njira Zowonjezera" sankhani mtengo Sakanizani.
- Pambuyo pazowonjezera m'malo oyenera, tifunika kuchotsa chigawo choyambirira. Dinani pamanja pa mutu wake. Mu menyu yachidule, sankhani chinthucho "Chotsani".
Potsatira izi zinthuzo zidzatha.
Njira 2: ingani
Komabe, pali njira yosavuta yosamukira ku Excel.
- Dinani pazowonongeka yophatikizapo ndi kalata yomwe imatchula adiresi kuti musankhe lonse khola.
- Timasankha kumalo osankhidwa ndi batani laling'ono la mouse ndipo pamatsegulo otseguka timasiya kusankha pa chinthucho "Dulani". M'malo mwake, mukhoza kudina pa chithunzicho ndi dzina lenileni lomwe lili pa kaboni "Kunyumba" mu chigawo cha zipangizo "Zokongoletsera".
- Mofananamo monga momwe tafotokozera pamwambapa, sankhani ndimeyo kumanzere komwe muyenera kusuntha mzere umene tadula kale. Dinani botani lamanja la mouse. Mu menyu yachidule, lekani kusankha pa chinthucho "Yesani Maselo Odulidwa".
Pambuyo pachithunzi ichi, zinthu zidzasuntha monga momwe mukufunira. Ngati ndi kotheka, momwemo mungasunthire magulu a zigawozo, ndikuwunikira pazifukwa zoyenera.
Njira 3: Njira yoyendetsera patsogolo
Palinso njira yosavuta komanso yopita patsogolo yosuntha.
- Sankhani ndime yomwe tikufuna kusuntha.
- Sungani chithunzithunzi mpaka kumalire a dera losankhidwa. Pa nthawi yomweyi timalumikiza Shift pabokosilo ndi batani lamanzere. Sungani mbewa potsatira njira yomwe mukufuna kusuntha.
- Panthawi yosunthira, mzere wa khalidwe pakati pa ziwonetsero ukuwonetsera komwe chinthu chosankhidwa chidzalowetsedwa. Pambuyo pa mzere uli pamalo abwino, ingomasula batani.
Pambuyo pake, zipilala zofunika zidzasinthidwa.
Chenjerani! Ngati mukugwiritsa ntchito kachitidwe ka Excel (2007 ndi kale), ndiye Shift Palibe chifukwa chokhalira pamene mukusunthira.
Monga mukuonera, pali njira zingapo zosinthira zipilala. Zonsezi ndizovuta kwambiri, koma panthawi imodzimodzizi zomwe mungasankhe kuchita, ndi zina zotsogola, zomwe sizinagwiritse ntchito nthawi zonse zakale za Excel.
