Mu phunziro lomaliza, tidadziwa zoyambira zakusanja mu Excel, kusanthula malamulo oyambira ndi mitundu yamitundu. Nkhaniyi ingoyang'ana pa kusanja kwachikhalidwe, mwachitsanzo, kusinthidwa ndi wogwiritsa ntchito. Kuphatikiza apo, tidzasanthula njira yothandiza ngati kusanja ndi ma cell, makamaka ndi mtundu wake.
Nthawi zina mutha kukumana ndi mfundo yoti zida zosinthira mu Excel sizitha kusuntha zomwe zikufunika. Mwamwayi, Excel imakupatsani mwayi wopanga mndandanda wamitundu yanu.
Pangani mtundu wokhazikika mu Excel
Muchitsanzo chomwe chili pansipa, tikufuna kusanja zomwe zili patsambalo ndi kukula kwa T-shirt (gawo D). Kusanja mwachizolowezi kudzakonza kukula kwake motsatira zilembo, zomwe sizingakhale zolondola. Tiyeni tipange mndandanda wamakonda kuti tisankhe kukula kwake kuyambira kakang'ono mpaka kakang'ono.
- Sankhani selo lililonse patebulo la Excel lomwe mukufuna kusanja. Mu chitsanzo ichi, tidzasankha selo D2.
- Dinani Deta, kenako dinani lamulo Kusankha.
- Bokosi la zokambirana lidzatsegulidwa Kusankha. Sankhani ndime yomwe mukufuna kusanja tebulo. Pankhaniyi, tidzasankha kusanja ndi kukula kwa T-shirt. Ndiye m'munda Order pitani Mndandanda Wazikhalidwe.
- A dialog box adzaoneka Wapamwamba… Chonde sankhani MTANDA WATSOPANO mu gawo Wapamwamba.
- Lowetsani makulidwe a T-shirt m'munda Lembani zinthu mu dongosolo lofunikira. Muchitsanzo chathu, tikufuna kusanja kukula kwake kuyambira kakang'ono mpaka kakang'ono, kotero tidzalowa motsatana: Yaing'ono, Yapakatikati, Yaikulu ndi X-Yaikulu mwa kukanikiza fungulo. Lowani pambuyo pa chinthu chilichonse.
- Dinani kuwonjezerakuti musunge mtundu watsopano. Mndandanda udzawonjezedwa ku gawoli Wapamwamba. Onetsetsani kuti yasankhidwa ndikudina OK.
- Zenera la dialog Wapamwamba adzatseka. Dinani OK mu dialog box Kusankha kuti athe kupanga masanjidwe mwamakonda.
- Spreadsheet ya Excel idzasanjidwa mofunikira, kwa ife, ndi kukula kwa T-shirt kuyambira yaying'ono mpaka yayikulu.
Sanjani mu Excel ndi mawonekedwe a cell
Kuphatikiza apo, mutha kusanja spreadsheet ya Excel ndi mawonekedwe a cell m'malo mwa zomwe zili. Kusanja kumeneku kumakhala kothandiza makamaka ngati mugwiritsa ntchito zolemba zamitundu m'maselo ena. Muchitsanzo chathu, tidzasanja deta potengera mtundu wa cell kuti tiwone maoda omwe ali ndi malipiro omwe sanatoledwe.
- Sankhani selo lililonse patebulo la Excel lomwe mukufuna kusanja. Mu chitsanzo ichi, tidzasankha selo E2.
- Dinani Deta, kenako dinani lamulo Kusankha.
- Bokosi la zokambirana lidzatsegulidwa Kusankha. Sankhani ndime yomwe mukufuna kusanja tebulo. Ndiye m'munda Kusankha tchulani mtundu wamtundu: Mtundu wa Cell, Mtundu wa Font, kapena Chizindikiro cha Maselo. Muchitsanzo chathu, tidzasankha tebulo ndi column Njira yolipirira (gawo E) ndi mtundu wa cell.
- Mu Order sankhani mtundu woti muwusankhe. Kwa ife, tidzasankha mtundu wofiira wofiira.
- Press OK. Gomelo tsopano lasanjidwa ndi mtundu, ndi maselo ofiira owala pamwamba. Dongosololi limatithandiza kuwona bwino madongosolo abwino.