Gwirani ntchito ndi zolemba pa Excel

Zolemba ndi chida chophatikizidwa. Ndi icho, mutha kuwonjezera ndemanga zosiyanasiyana zomwe zili m'maselo. Izi m'matebulo zimakhala zofunikira kwambiri, pomwe pazifukwa zosiyanasiyana ndizosatheka kusintha maudindo kuti iwonjezere gawo lina lowonjezera. Tiyeni tiwone momwe mungawonjezere, kufufuta ndikugwira ntchito ndi zolemba ku Excel.

Phunziro: Ikani zolemba mu Microsoft Mawu

Gwiritsani ntchito zolemba

Zolemba, simungangolemba zolemba zolembedwa pa cell, komanso kuwonjezera zithunzi. Kuphatikiza apo, palinso zinthu zinanso zingapo za chida ichi chomwe tikambirana.

Chilengedwa

Choyamba, tizindikira momwe tingapangire cholembera.

1. Kuphatikiza cholembera, sankhani khungu lomwe tikufuna kuti mupange. Dinani pa batani la mbewa. Mndandanda wa nkhaniyo umatseguka. Dinani mmenemo pa chinthucho "Cholemba".



2. Zenera laling'ono loyankhidwa limatseguka kumanja kwa khungu lomwe lasankha. Mu kusakhazikika kwake kwambiri, dzina la akauntiyo limafotokozedwa, lomwe wosuta adalowa mu kompyuta (kapena adalowa mu Microsoft Office). Pokhazikitsa cholozera kuderali pazenera ili, limatha kuyimba mutu uliwonse pa kiyibodi, yomwe imayang'ana zofunikira kuyika ndemanga pa cell.



3. Dinani pa malo ena aliwonse papepala. Chinthu chachikulu ndikuti izi zidachitika kunja kwa gawo.

Chifukwa chake, titha kunena kuti ndemangayo idzalengedwa.

Cholembera chomwe khungu limakhala ndi cholembera ndi chizindikiro chaching'ono chofiyira pakona yakumanja.

Pali njira ina yopangira chinthu ichi.

1. Tikutsindika za foni yomwe ili. Pitani ku "kuwunika" tabu. Pa tepi mu "zolemba" zosintha, dinani batani la "Chidziwitso".



2. Pambuyo pake, pafupi ndi cell akutsegula zenera lomwelo, lomwe lidakambidwa pamwambapa, ndipo zolemba zofunika zimawonjezedwa.

Kuwona

Kuti musamakayile zomwe zili mu ndemanga, mumangofunika kubweretsa chotemberero ku khungu lomwe lili ndi. Pankhaniyi, palibe chomwe chimafunikira kukanikizidwa pa mbewa kapena pa kiyibodi. Ndemangayi idzawoneka mu mawonekedwe a zenera la pop-up. Conturtur atangochotsedwa pamalo ano, zenera lidzazimiririka.

Kuphatikiza apo, kuyenda kwa zolemba kumatha kuchitika pogwiritsa ntchito mabatani "otsatira" ndi "m'mbuyomu" yomwe ili mu ndemanga. Mukadina mabatani awa, idzakhala imodzi mwamodzi ndi yomwe ingayambitse zolemba papepala.

Ngati mukufuna ndemanga kuti mupeze pepala, mosasamala kanthu komwe mawuwo ali, muyenera kupita ku "zolemba" pa tepi kuti dinani pa "Onetsani zolemba" batani. Imatha kutchedwanso "kuwonetsa zolemba zonse."

Pambuyo pa zochita izi, ndemanga zimawonetsedwa mosatengera malo olerera.

Ngati wogwiritsa ntchito akufuna kubweza chilichonse muukalamba, ndiye kuti, kubisa zinthu, kumayenera kuyambiranso pa batani la "Show not".

Kusintha

Nthawi zina muyenera kusintha ndemanga: sinthani, onjezani chidziwitso kapena kusintha malo. Njirayi ndi yophweka komanso yofunika kwambiri.

1. Mwa kuwonekera batani lamanja pa cell, yomwe ili ndi ndemanga. Pazomwe zidachitika menyu, sankhani "kusintha njira".



2. Pambuyo pake, zenera limatseguka ndi chojambulidwa chokonzekera kusintha. Mutha kupanga zolemba zatsopano, kusiya zakale, kutulutsa zopukutira zina ndi lembalo.



3. Ngati lembalo likuwonjezeredwa lomwe siligwirizana m'malire a zenera, ndipo chifukwa chake gawo lina la zidziwitso limabisika kwa diso, mutha kuwonjezera zenera. Kuti muchite izi, muyenera kubweretsa cholozera kwa malo owuma pabwino, dikirani, ikatenga mawonekedwe a kumanzere, ikani kutali ndi pakati.



4. Ngati mwatambasula zenera kapena kuchotsa lembalo ndipo musafunikirenso malo ambiri a ndemanga, ndiye kuti zitha kuchepetsedwa chimodzimodzi. Koma nthawi ino malire amafunika kukoka pazenera lazenera.



5. Kuphatikiza apo, mutha kusuntha malo owonera zenera popanda kusintha kukula kwake. Kuti muchite izi, muyenera kukweza cholozera kumalire a zenera ndikudikirira, pamene chithunzi mu mivi inayi imatumizidwa kumalekezero osiyanasiyana. Kenako dinani batani la mbewa ndikukoka zenera mbali yomwe mukufuna.



6. Pambuyo pokonzanso njira imachitika, monga momwe mukupangira, muyenera dinani pamalopo pa pepala kunja kwa gawo la Sinthani.

Pali njira yosinthira zolemba ndi zida za temp. Kuti muchite izi, sankhani khungu lomwe lili ndi batani la "Kusintha" Komwe lili mu "kuwunika" tabu mu "Zolemba". Pambuyo pake, zenera lokhala ndi ndemanga likhala likusintha.

Kuwonjezera chithunzi

Chithunzicho chitha kuwonjezeredwa pazenera.

1. Pangani cholembera mu selo lokonzekereratu. Posintha mode, timayatsa m'mphepete mwa Ndemanga mpaka pomwe chithunzi cha mavioni anayi sichimawoneka kumapeto kwa chotemberero. Dinani batani lamanja. Mndandanda wa nkhaniyo umatseguka. Mmenemo, pitani pamawu a "zolemba zojambulidwa ...".



2. Zenera lotseguka limatsegulidwa. Pitani ku "mitundu ndi mizere" tabu. Dinani pamunda ndi mndandanda wotsika ". Mumenyu zomwe zikuwoneka, pitani ku "njira zodzaza ...".



3. Windo latsopano limatsegulidwa. Mmenemo, pitani ku "Chithunzi" tabu, kenako dinani batani lomwelo.



4. Zenera losankha zithunzi limatseguka. Sankhani chithunzi chomwe mukufuna pa hard disk kapena dissic. Pambuyo kusankha kupangidwa, dinani batani la "phala".



5. Pambuyo pake, kubwerera kokha ku zenera lapitalo. Apa tikukhazikitsa nambala yolumikizana "Sungani kuchuluka kwa chithunzicho" ndikudina batani la "Ok".



6. Bweretsani ku zenera lolemba. Pitani ku "chitetezo". Chotsani bokosi loyang'ana "chinthu chotchinjiriza".



7. Kenako, timasamukira ku tabu ya "katundu" ndikuyika switch ku "kusuntha ndikusintha chinthu ndi ma cell". Mfundo ziwiri zomaliza zomwe zimayenera kuchitidwa kuti amangiridwe ndipo, motero, chithunzi chopita ku cell. Kenako, dinani batani la "OK".

Monga tikuwonera, opaleshoniyo ikuyenda bwino ndipo chithunzicho chimayikidwa mu khungu.

Phunziro: Momwe mungayikitsire chithunzi mu cell mu Excel

Kuchotsa zolemba

Tsopano tiyeni tipeze momwe mungafufuzire.

Muthanso kuchita izi m'njira ziwiri monga momwe mumapangira ndemanga.

Kuti mugwiritse ntchito njira yoyamba, muyenera dinani khungu lomwe lili ndi cholembera, chabwino. Mumenyu zomwe zimawoneka, mumangodina batani la "Chotsani Chidziwitso", pambuyo pake sichitha.

Kuchotsa njira yachiwiri, sankhani khungu lomwe mukufuna. Kenako pitani ku "kuwunika" tabu. Dinani pa batani la "Chotsani Chidziwitso", chomwe chili pa tepi mu "zolemba" zida. Izi zimapangitsanso kuchotsedwa kwathunthu kwa ndemanga.

Phunziro: Momwe mungachotse zolemba mu Microsoft Mawu

Monga mukuwonera, mothandizidwa ndi zolemba zambiri, simungathe kuwonjezera ndemanga pa cell, koma ngakhale kuyika chithunzi. Panthawi zina, izi zitha kukhala ndi thandizo lalikulu kwa wogwiritsa ntchito.