Ntchito zina zomwe zimagwiritsidwa ntchito pa matebulo zimafuna kuyika mafano osiyanasiyana kapena zithunzi. Excel ili ndi zida zomwe zimakulolani kuti mupangepo. Tiyeni tione m'mene tingachitire.
Chithunzi Choyika Kuyika
Pofuna kuyika fano mu tebulo la Excel, liyenera kumasulidwa ku diski yochuluka ya kompyuta kapena sing'anga yosasunthika. Chofunika kwambiri choyika chithunzi ndichoti mwachindunji sichikumangirizidwa ndi selo inayake, koma chimangokhala pamalo osankhidwa a pepala.
Phunziro: Momwe mungaike chithunzi mu Microsoft Word
Ikani chithunzi pa pepala
Choyamba, tidzapeza momwe tingagwirire chithunzi pa pepala, ndipo pokhapokha tidzatha kudziwa momwe angagwirizanitse chithunzi ndi selo lapadera.
- Sankhani selo kumene mukufuna kuyika chithunzichi. Pitani ku tabu "Ikani". Dinani pa batani "Kujambula"yomwe ili pamakonzedwe "Mafanizo".
- Chithunzi chotsekera chithunzi chimatsegulidwa. Mwachinsinsi, nthawi zonse imatsegula mu foda. "Zithunzi". Choncho, mukhoza kuyamba koyamba kwa chithunzi chomwe mukufuna kuti muyike. Ndipo mungathe kuchita mwanjira ina: kudzera mu mawonekedwe a mawindo omwewo, pitani ku zolemba zina zilizonse za hard disk ya PC kapena zowonjezera. Mutatha kusankha chithunzi chomwe mukufuna kuwonjezera pa Excel, dinani pa batani Sakanizani.
Pambuyo pake, chithunzichi chimayikidwa pa pepala. Koma, monga tanenera poyamba, zimangokhala pa pepala ndipo sizigwirizana ndi selo iliyonse.
Kusintha kwazithunzi
Tsopano muyenera kusintha chithunzichi, mupatseni mawonekedwe ndi kukula.
- Dinani pa chithunzicho ndi batani lamanja la mouse. Zithunzi zojambula zimatsegulidwa m'makondomu. Dinani pa chinthu "Kukula ndi katundu".
- Zenera likutsegula momwe muli zida zambiri zosinthira katundu wa fanolo. Pano mungasinthe kukula kwake, mtundu, katatu, kuwonjezera zotsatira ndi kuchita zambiri. Zonse zimatengera chithunzi chomwe chimagwiritsidwa ntchito.
- Koma nthawi zambiri palibe chifukwa chotsegula zenera. "Miyeso ndi katundu", popeza pali zipangizo zokwanira zomwe zimaperekedwa pa ndodo muzitsulo zina "Kugwira ntchito ndi Zithunzi".
- Ngati tikufuna kuyika chithunzi mu selo, ndiye mfundo yofunikira kwambiri pakukonza chithunzi ndikusintha kukula kwake kuti zisakhale zazikulu kuposa kukula kwa selo lokha. Mukhoza kukhala ndi njira zotsatirazi:
- kudzera mndandanda wamakono;
- gulu pa tepi;
- zenera "Miyeso ndi katundu";
- kukokera malire a chithunzicho ndi mbewa.
Kujambula zithunzi
Koma, ngakhale chithunzicho chitakhala chaching'ono kuposa selo ndipo chinayikidwa mmenemo, icho chinakhalabe chosagwirizana. Izi zikutanthauza kuti ngati ife, mwachitsanzo, tikupanga mtundu kapena mtundu wina wa deta, maselo adzasintha malo, ndipo kujambula kudzakhala pamalo omwewo pa pepala. Koma, mu Excel, palinso njira zina zojambula chithunzi. Taganizirani izi mobwerezabwereza.
Njira 1: chitetezo cha pepala
Njira imodzi yogwirizira fano ndikuteteza pepala pamasintha.
- Sinthani kukula kwa chithunzicho kukula kwa selo ndikuyiyika pamenepo, monga tafotokozera pamwambapa.
- Dinani pa chithunzi ndikusankha chinthucho m'ndandanda wamakono "Kukula ndi katundu".
- Chithunzi chojambula chithunzi chimatsegulira. Mu tab "Kukula" onetsetsani kuti kukula kwa fano sikuli wamkulu kuposa kukula kwa selo. Komanso fufuzani ku zizindikiro zosiyana "Zokhudzana ndi kukula koyambirira" ndi "Sungani kuchuluka" Panali nkhupakupa. Ngati palipakati iliyonse isagwirizane ndi ndondomeko yomwe ili pamwambayi, yesetsani.
- Pitani ku tabu "Zolemba" zenera yomweyo. Ikani bokosi loyang'ana kutsogolo kwa magawo "Chinthu chotetezedwa" ndi "Chinthu chosindikiza"ngati sakuyikidwa. Ikani kusinthana muzokonzedwa "Kumangirira chinthu kumbuyo" mu malo "Sungani ndi kusintha chinthu ndi maselo". Pamene makonzedwe onse apangidwe apangidwa, dinani pa batani. "Yandikirani"ili kumbali ya kumanja kwazenera pawindo.
- Sankhani pepala lonse podutsa makina osintha Ctrl + A, ndipo pendani m'mawonekedwe a mawonekedwe pawindo la mawonekedwe a selo.
- Mu tab "Chitetezero" mawindo otseguka achotsa cheke kuchokera payimayi "Selo lotetezedwa" ndipo dinani pa batani "Chabwino".
- Sankhani selo komwe chithunzichi chiyenera kukhazikitsidwa. Tsegulani zenera pawonekedwe pa tabu "Chitetezero" tsimikizani mtengo "Selo lotetezedwa". Dinani pa batani "Chabwino".
- Mu tab "Kubwereza" mu chigawo cha zipangizo "Kusintha" pa tepicho dinani batani "Tetezani Tsamba".
- Mawindo amatsegulira m'mene timalowezera mawu oyenera kuteteza pepala. Timakanikiza batani "Chabwino", ndipo pawindo lotsatira lomwe likutsegula, timabwereza kachiwiri kachiwiri.
Zitatha izi, mzere umene zithunzizo zilipo zimatetezedwa ku kusintha, ndiko kuti, zithunzizo zimamangidwa kwa iwo. Palibe kusintha komwe kungapangidwe mu maselowa mpaka chitetezo chichotsedwa. Muzigawo zina za pepala, monga kale, mukhoza kusintha ndikusunga. Pa nthawi yomweyi, tsopano ngakhale mutasankha kusanthula deta, chithunzichi sichipita kulikonse ndi selo yomwe ili.
Phunziro: Momwe mungatetezere selo kuchokera kusintha kwa Excel
Njira 2: Yesani chithunzi mulemba
Mungathenso kugwirizanitsa chithunzi mwa kuikapo mulemba.
- Timakanila selolo momwe timakonzekera kuti tiyike fanolo, ndi batani labwino la mouse. Mu menyu yachidule, sankhani chinthucho "Onetsani Note".
- Fasilo yaing'ono imatsegulidwa, yokonzedwa kulembera makalata. Chotsani cholozera ku malire ake ndipo dinani. Mndandanda wina wamakono umayambira. Sankhani chinthu mmenemo "Zindikirani mtundu".
- Mu mawonekedwe otseguka, pitani ku tabu "Mizere ndi mizere". Mu bokosi lokhalamo "Lembani" dinani kumunda "Mtundu". Mu mndandanda umene umatsegulira, pitirizani pa msonkhano. "Zodzaza Njira ...".
- Foda yodzaza mawonekedwe imatsegula. Pitani ku tabu "Kujambula"ndiyeno dinani pa batani ndi dzina lomwelo.
- Fayilo yowonjezera yowonjezera imatsegula, chimodzimodzi mofanana ndifotokozedwa pamwambapa. Sankhani chithunzi ndipo dinani pa batani Sakanizani.
- Chithunzi chikuwonjezeredwa kuwindo "Dzadzani Njira". Ikani nkhuni patsogolo pa chinthucho "Pitirizani kukula kwa chithunzi". Timakanikiza batani "Chabwino".
- Zitatha izi, tibwerera kuwindo "Zindikirani mtundu". Pitani ku tabu "Chitetezero". Chotsani cheke kuchokera ku parameter "Chinthu chotetezedwa".
- Pitani ku tabu "Zolemba". Ikani kusinthana kuti mukhale malo "Sungani ndi kusintha chinthu ndi maselo". Pambuyo pa izi, dinani pa batani "Chabwino".
Pambuyo pochita zochitika zonsezi, chithunzicho sichidzangowonjezeredwa mu chipinda cha selo, koma chikugwirizananso ndi izo. Inde, njira iyi si yoyenera kwa aliyense, pamene kulembedwa mulemba kumapangitsanso zina.
Njira 3: Njira Yotsatsa
Mukhozanso kulumikiza zithunzi ku selo kupyolera muzokonza njira. Vuto ndilokuti mwachisawawa mawonekedwe opanga osasinthidwa. Choncho, choyamba, tidzatha kutero.
- Kukhala mu tab "Foni" pitani ku gawo "Zosankha".
- Muwindo la magawo, pita ku gawolo Kukonzekera kwa Ribbon. Ikani nkhuni pafupi ndi chinthucho "Wotsambitsa" kumanja kwawindo. Timakanikiza batani "Chabwino".
- Sankhani selo limene tikukonzekera kukhazikitsa fanolo. Pitani ku tabu "Wotsambitsa". Idawonekera titatsegula njira yoyenera. Dinani pa batani Sakanizani. M'ndandanda yomwe imatsegulidwa mu block "ActiveX Elements" sankhani chinthu "Chithunzi".
- Kulamulira kwa ActiveX kumawoneka ngati quad yopanda kanthu. Sinthani miyeso yake mwa kukokera malire ndikuyika mu selo yomwe mukufuna kukonza fanolo. Timasankha batani laling'ono la mouse pa chinthucho. Mu menyu yachidule, sankhani chinthucho "Zolemba".
- Chotsegula katundu wawindo chimatsegula. Mosiyana ndi gawo "Kuyika" ikani nambalayi "1" (mwachinsinsi "2"). Mndandanda wamtunduwu "Chithunzi" Dinani pa batani, lomwe limasonyeza madontho.
- Fayilo lolowera fano likuyamba. Tikuyang'ana chithunzi chomwe tikuchifuna, sankhani ndipo dinani pa batani. "Tsegulani".
- Pambuyo pake, mukhoza kutseka zenera. Monga mukuonera, chithunzicho chatha kale. Tsopano tikufunikira kuliyika kwathunthu ku selo. Sankhani chithunzi ndikupita ku tabu "Tsamba la Tsamba". Mu bokosi lokhalamo "Sungani" pa tepicho dinani batani "Gwirizanitsani". Kuchokera pa menyu otsika pansi, sankhani chinthucho "Sinthani ku Grid". Kenaka musunthire pang'ono pamphepete mwa chithunzicho.
Pambuyo pochita zochitika pamwambazi, chithunzicho chidzamangirizidwa ku gridi ndi selo losankhidwa.
Monga mukuonera, pulogalamu ya Excel pali njira zambiri zoyika chithunzi mu selo ndikuchiyika icho. Inde, njira yokhala ndi zolembera muzitsamba si yoyenera kwa ogwiritsa ntchito onse. Koma zina ziwiri zomwe mungasankhe zimakhala zogwirizana kwambiri ndipo aliyense ayenera kudzipangira yekhayekha kuti amuthandize kwambiri ndipo akugwirizana kwambiri ndi zolinga zake.
