Momwe Mungagwiritsire Ntchito Alfabeti mu Excel

Sankhani zambiri ndendende momwe mukufunira

Zilembo zabwino za Excel, mizere yodalirika komanso zofanana ndi mapulogalamu ena a MS Office zimapanga ntchito yoyenera kulemba ndi kusunga mndandanda wamakalata. Mukakhala ndi mauthenga onsewa, mukhoza kuwusankha kuti mukwaniritse zosowa zanu popanda zochepa zochepa za phokoso.

Kuphunzira momwe mungagwiritsire ntchito alphabetti mu Excel komanso njira zina zothetsera malemba kungakupulumutseni ma tani a nthawi ndikukupatsani mphamvu zochuluka pazomwe mukufunikira kuzigwiritsa ntchito.

Zindikirani njira zonse za Microsoft Excel kuphatikizapo 2016, 2013, 2010, 2007 ndi 2003 kapena kale komanso Excel kwa Mac 2016, 2011, 2008 ndi 2004. Mungathe kupanga njira zina pogwiritsira ntchito Excel pa Intaneti ndi Office 365.

Momwe Mungasankhire Maailbasi mu Excel

Njira yosavuta kuti afotokozere gawo mu Excel ndi kugwiritsa ntchito gawo la mtundu. Kumene inu mumapezera gawoli kumadalira mtundu wa Excel omwe mukuugwiritsa ntchito.

Mu Excel 2003 ndi 2002 ya Windows kapena Excel 2008 ndi 2004 ya Mac , tsatirani izi.

1. Onetsetsani kuti mulibe maselo osalongosola m'ndandanda.
2. Dinani pa selo iliyonse m'ndandanda yomwe mukufunika kuyisanthula.
3. Sankhani Dongosolo pazakutchi ndipo sankhani mtundu . Mutu wa bokosiwu udzatsegulidwa.
4. Sankhani ndime yomwe mukufuna kufotokozera mwachidule m'ndandanda mwasakatulo, sankhani Kupita .
5. Dinani OK kuti mulembe mndandanda wa chilembo.

Mu Excel 2016, 2013, 2010 ndi 2007 ya Windows; Excel 2016 ndi 2011 kwa Mac; ndi Office Excel Online, kusankha ndi kosavuta.

1. Onetsetsani kuti mulibe maselo osalongosola m'ndandanda.
2. Dinani Sungani & Sungani mu gawo la Kusintha kwa tabu ya Home.
3. Sankhani Pangani A mpaka Z kuti mumvetsetse mndandanda wanu.

Sakani Zilembedwa ndi Maulendo Ambiri

Ngati mukufuna kufalitsa ma selo angapo ku Excel pogwiritsa ntchito mndandanda wambiri, gawoli limakuthandizani kuti muchite zimenezo.

Mu Excel 2003 ndi 2002 ya Windows kapena Excel 2008 ndi 2004 ya Mac , tsatirani izi.

1. Sankhani maselo onse omwe mukufuna kufufuza polemba zilembo ziwiri kapena zingapo m'mabuku.
2. Sankhani Dongosolo pazakutchi ndipo sankhani mtundu . Mutu wa bokosiwu udzatsegulidwa.
3. Sankhani ndondomeko yoyamba imene mukufuna kufotokozera deta yanu mu Bokosi Loyenera ndi kusankha Kupita .
4. Sankhani gawo lachiwiri limene mukufuna kufufuza maselo osiyanasiyana m'ndandanda. Mungathe kupanga mitundu itatu mpaka iwiri.
5. Sankhani Mutu wailesi yawowanda Mutu ngati mndandanda uli ndi mutu pamwamba.
6. Dinani OK kuti mulembe mndandanda wa chilembo.

Mu Excel 2016, 2013, 2010, 2007 ndi 2007 ya Windows kapena Excel 2016 ndi 2011 ya Mac, kusankha ndi kophweka. (Mbali iyi sipezeka ku Office 365 Excel Online.)

1. Sankhani maselo onse omwe mukufuna kufufuza polemba zilembo ziwiri kapena zingapo m'mabuku.
2. Dinani Sungani & Sungani mu gawo la Kusintha kwa tabu ya Home.
3. Sankhani Mwambo Wosankha. A dialog dialog box adzatsegulidwa.
4. Sankhani Deta Zanga Zili ndi mitu yoyang'anila bokosi ngati mndandanda wanu uli ndi mutu wapamwamba.
5. Sankhani ndondomeko yoyamba imene mukufuna kufotokozera deta Sakani Ndibokosi.
6. Sankhani Makhalidwe a Cell mu Bokosi la Bokosi.
7. Sankhani A mpaka Z mu Bokosi la Malamulo.
8. Dinani botani lazowonjezera pamwamba pa bokosi la bokosi.
9. Sankhani ndime yachiwiri yomwe mukufuna kufotokozera deta mu Bokosi la Mndandanda.
10. Sankhani Makhalidwe a Cell mu Bokosi la Bokosi.
11. Sankhani A mpaka Z mu Bokosi la Malamulo.
12. Dinani Mzere Wonjezerani kuti muyang'ane ndi ndime ina, ngati mukufuna. Dinani KULERA mukakonzeka kufalitsa tebulo lanu.

Kusintha Kwakukulu ku Excel

Muzochitika zina, kusankha alfabheti sizingatheke. Mwachitsanzo, mutha kukhala ndi mndandanda wautali womwe uli ndi maina a miyezi kapena masabata omwe mungakonde kufufuza nthawi. Excel adzakwaniritsirani izi, komanso.

Mu Excel 2003 ndi 2002 ya Windows kapena Excel 2008 ndi 2004 ya Mac , sankhani mndandanda womwe mukufuna kuwusankha.

1. Sankhani Dongosolo pazakutchi ndipo sankhani mtundu . Mutu wa bokosiwu udzatsegulidwa.
2. Dinani pakani pakasankha pansi pa dialog box.
3. Dinani ndondomeko yochepetsedwa mu mndandanda wa Choyamba Mndandanda Wowonjezera Choyamba ndipo sankhani kusankha komwe mukufuna kugwiritsa ntchito.
4. Dinani KULI kawiri kuti muyambe mndandanda wanu mndandanda wa nthawi.

Mu Excel 2016, 2013, 2010 kapena 2007 ya Windows ndi Excel 2016 ndi 2011 ya Mac, sankhani mndandanda womwe mukufuna kuwusankha. Kusankha ndi kosavuta. (Mbali iyi sipezeka ku Office 365 Excel Online.)

1. Dinani Sungani & Sungani mu gawo la Kusintha kwa tabu ya Home.
2. Sankhani Mwambo Wosankha. Mutu wa bokosiwu udzatsegulidwa.
3. Dinani mzere wotsitsa mu List list ndikusankha Mndandanda wamtundu . Nkhani ya Lists Lists idzatsegulidwa.
4. Sankhani njira yomwe mukufuna kugwiritsa ntchito.
5. Dinani KULI kawiri kuti muyambe mndandanda wanu mndandanda wa nthawi.

Ngakhale Mitu Yambiri Yamtundu

Excel imapereka njira zambiri zolowera, kutengera ndikugwira ntchito ndi mtundu uliwonse wa deta. Onani 6 Njira Zowonetsera Dongosolo mu Excel kwa mauthenga othandiza komanso zowonjezereka.