Malangizo ndi chida cholozera cha Excel. Ndi iyo, mutha kuwonjezera ndemanga zosiyanasiyana pazomwe zili m'maselo. Ichi chimakhala chofunikira pamatafura pomwe, pazifukwa zosiyanasiyana, simungasinthe mawonekedwe a mizati kuti muwonjezere mzere wina ndi kufotokozera. Tiyeni tiwone momwe mungawonjezere, kuchotsa ndikugwira ntchito ndi zolemba mu Excel.
Phunziro: Ikani zolemba mu Microsoft Mawu
Gwirani ntchito ndi zolemba
Pazomwe mulembazo simunganglemba zolemba zowerengera, komanso kuwonjezera zithunzi. Kuphatikiza apo, pali zinthu zina zingapo za chida ichi, zomwe tikambirana pansipa.
Kulenga
Choyamba, tiona momwe tingapangire cholembera.
- Kuti muwonjezere cholembera, sankhani selo yomwe tikufuna kuti ipangidwe. Timadulira pomwepo ndi batani la mbewa. Zosankha zam'mawu zimatsegulidwa. Dinani pa icho pa chinthucho Ikani Chidziwitso.
- Windo laling'ono lazikhalidwe limatsegukira kumanja kwa khungu losankhidwa. Pamwambapa, mosasamala, ndi dzina la akaunti yomwe wosuta adalowa mu kompyuta (kapena kulowa mu Microsoft Office). Poika chikwangwani m'dera la zenera ili, atha kulembapo kuchokera pa kiyibodi chilichonse mwanzeru zake, zomwe akuwona kuti ndizofunikira kuyika ndemanga pafoniyo.
- Dinani kwina kulikonse pa pepalalo. Chachikulu ndichakuti izi ziyenera kuchitidwa kunja kwa gawo la ndemanga.
Chifukwa chake, titha kunena kuti ndemanga ipangidwe.
Chizindikiro chakuti khungu lili ndi cholembera ndi chisonyezo chaching'ono chofiyira pakona yake ya kudzanja lamanja.
Pali njira inanso yopangira chinthuchi.
- Sankhani selo yomwe ndemanga izikhala. Pitani ku tabu "Ndemanga". Pa nthiti mumakonzedwe "Zolemba" dinani batani Pangani Zindikirani.
- Pambuyo pake, zenera lomwelo lomwe limanenedwa pamwambapa limatseguka pafupi ndi chipindacho, ndipo zomwe zidalowetsedwamo zimawonjezeredwa momwemo.
Onani
Kuti muwone zomwe zili mu ndemanga muyenera kungoyendayenda pafoni momwe muli. Pankhaniyi, simukuyenera kudina chilichonse pa mbewa kapena pa kiyibodi. Ndemanga idzawoneka ngati popupu. Katswiri atangochotsa pamalo ano, zenera limasowa.
Kuphatikiza apo, mutha kuyendera zolemba pogwiritsa ntchito mabatani Kenako ndi "Zakale"ili pa tabu "Ndemanga". Mukadina mabatani awa, zolemba pa pepalizo zimayendetsedwa motsatizana wina ndi mzake.
Ngati mukufuna kuti ndemanga zizipezeka pafupipafupi pa pepalalo, mosasamala kanthu komwe kounikira ali, ndiye muyenera kupita pa tabu "Ndemanga" ndi bokosi la zida "Zolemba" kanikizani batani pambali "Onetsani zolemba zonse". Atha kuyitanidwanso Onetsani zolemba zonse.
Pambuyo pa izi, ndemanga ziziwonetsedwa mosasamala malo ampikisanowo.
Ngati wogwiritsa ntchito akufuna kuti abweze zonse mwanjira yakale, ndiye kuti, abisa zinthuzo, ndiye kuti ayenera dinani batani "Onetsani zonse".
Kusintha
Nthawi zina muyenera kusintha ndemanga: isinthe, onjezani zambiri, kapena sinthani masinthidwe ake. Njirayi ndiyosavuta komanso yachilendo.
- Dinani kumanja pa foni yomwe ili ndi ndemanga. Pazosankha zomwe zikuwoneka, sankhani "Sinthani Chidziwitso".
- Pambuyo pake, zenera limatsegulidwa ndi cholembera kukonzekera kusintha. Mutha kupanga zolemba zatsopano nthawi yomweyo, kufufuta zakale, ndikupanga zolemba zina ndi zokambiranazo.
- Ngati muwonjezerapo voliyumu yomwe simalowa m'malire a zenera, ndipo pomwepo gawo lazinthuzo ndizobisika kuti muwone, mutha kukulitsa zenera. Kuti muchite izi, sinthani cholozera kumbali iliyonse yoyera pamphepete mwa ndemanga, dikirani mpaka itatenge mawonekedwe a muvi wopereka ndalama, ndikugwira batani lakumanzere, ndikulowetsani komwe mukuchokera.
- Ngati mutatambasulira zenera kwambiri kapena kuchotsera malembawo ndipo simukufunanso malo akulu operekera ndemanga, akhoza kuchepetsedwa chimodzimodzi. Koma nthawi ino malirewo akuyenera kukokedwa kuloza pakati pazenera.
- Kuphatikiza apo, mutha kusuntha mawonekedwe a zenera lokha popanda kusintha kukula kwake. Kuti muchite izi, sinthani cholozera mpaka kumalire a zenera ndikudikirira mpaka chithunzithunzi chooneka ngati mivi inayi yomwe ikuloza mbali zosiyanasiyana chikuwonekera. Kenako muyenera kugwirizira batani la mbewa ndikukokera pazenera kumbali yomwe mukufuna.
- Pambuyo pakukonzanso kumachitika, monga momwe zimapangidwira, muyenera kumadina kulikonse papepala kunja kwa munda kuti musinthe.
Pali njira yopitilira kusintha zolemba ndikugwiritsa ntchito zida zomwe zili pa tepi. Kuti muchite izi, sankhani khungu lomwe lilimo ndikudina batani "Sinthani Chidziwitso"ili pa tabu "Ndemanga" mu bokosi la zida "Zolemba". Pambuyo pake, zenera lokhala ndi ndemangayo lidzasinthika.
Powonjezera Chithunzi
Chithunzi chimatha kuwonjezeredwa pazenera la zolemba.
- Pangani cholembedwa mu foni yokonzekera. Mumachitidwe akusintha, tayimirira m'mphepete mwa zenera la ndemanga mpaka chithunzi chachinayi cha mivi chikaonekera kumapeto kwa cholozera. Dinani kumanja. Zosankha zam'mawu zimatsegulidwa. Mmenemo timadutsa pamtengo "Zindikirani ...".
- Tsamba losintha likutsegulidwa. Pitani ku tabu "Mitundu ndi mizere". Timadulira pamunda ndi mndandanda wotsika "Mtundu". Pazosankha zomwe zikuwoneka, pitani "Njira zodzaza ...".
- Windo latsopano limatseguka. Mmenemo, pitani ku tabu "Zojambula", kenako dinani batani la dzina lomweli.
- Zenera losankha chithunzilo limatsegulidwa. Timasankha chithunzi chomwe timafuna pa hard drive kapena media media. Chisankho chikapangidwa, dinani batani Ikani.
- Pambuyo pake, timangobwerera pazenera lakale. Apa tikuwona bokosi moyang'anizana ndi chinthucho "Sungani chiyerekezo" ndipo dinani batani "Zabwino".
- Bwereranso ku zenera lolemba. Pitani ku tabu "Chitetezo". Tsegulani bokosi "Chotetezedwa".
- Kenako, pitani ku tabu "Katundu" ndikukhazikitsa kusintha "Sinthani ndikusintha chinthu ndi maselo". Malangizo awiri omaliza amayenera kutsirizidwa kuti aphatikize cholembera ndipo, chifanizo chake. Kenako, dinani batani "Zabwino".
Monga mukuwonera, opaleshoniyo idayenda bwino ndipo chithunzicho chidayikidwa mu khungu.
Phunziro: Momwe mungayikitsire chithunzi mu khungu mu Excel
Chotsani cholemba
Tsopano tiyeni tipeze momwe tingalembe zolemba.
Pali njira ziwiri zochitira izi, komanso kupanga ndemanga.
Kuti mukwaniritse njira yoyamba, muyenera dinani kumanja komwe kuli cholembera. Pazosankha zomwe zimawonekera, ingodinani batani Chotsani Chidziwitso, pambuyo pake sangalole.
Kuti muchepetse njira yachiwiri, sankhani foni yomwe mukufuna. Kenako pitani ku tabu "Ndemanga". Dinani batani Chotsani Chidziwitso, yomwe imayikidwa pa tepi mu chipangizo chothandizira "Zolemba". Izi zichotsanso ndemanga kwathunthu.
Phunziro: Momwe mungachotsere zolemba mu Microsoft Mawu
Monga mukuwonera, kugwiritsa ntchito ndemanga za Excel, simungangowonjezera ndemanga mufoni, komanso kuyika chithunzi. Pazinthu zina, gawo ili lingapereke thandizo labwino kwa wogwiritsa ntchito.
