Momwe Mungayikitsire Chithunzi Kumbuyo Kwazolemba mu Excel - Gawo ndi Gawo Kalozera

Anthu ambiri amadziwa kuyika chithunzi mu Excel spreadsheet. Koma ngati ayesa kuchitira lembalo, sangapambane. Chowonadi ndi chakuti chithunzicho chimayikidwa pamtundu wapadera, womwe uli pamwamba pa malembawo. Kotero chithunzicho chidzadutsana nacho. Koma kodi chingachitike n’chiyani kuti muike chithunzi kumbuyo kwa lembalo kuti chikhale maziko ake?

Ndipo pali ntchito yomwe imakulolani kuti mukwaniritse izi. Amatchedwa mitu. Tsopano tiphunzira momwe tingagwiritsire ntchito. 

Malangizo a pang'onopang'ono poyika chithunzi kumbuyo kwa zolemba mu Excel

Tiyeni tiyambe ndi malangizo onse omwe adzafotokoze zonse zofunika, ndiyeno tidzatchera khutu ku zidule zomwe zingatheke ndi malemba ndi zithunzi. Izi zidzapulumutsa nthawi chifukwa palibe chifukwa chopitira patsogolo ngati mfundo zotsatirazi sizikufunika pazochitika zinazake. Mutha kuwonanso pakapita nthawi, mukafunika kuchita zomwe zaperekedwa m'gawo linalake. 

Njira yomwe tafotokozayi ndi yongopeka ndipo momveka bwino sinapangidwe kuti izi zitheke. Koma kudzera pamitu ndi m'munsi, mutha kuyika chithunzi cha mawuwo. Zonse zimayamba ndikuti timatsegula buku la Excel ndikuyang'ana tabu "Ikani" pa riboni.

Kenako, timayang'ana gawo la "Text", momwe mungapezere batani la "Mitu ndi Mapazi". Muyenera kumanzere alemba pa izo.

Ndikofunika kuzindikira kuti ngati chowunikiracho ndi chachikulu kwambiri, batani ili likhoza kugwa. Kuti muyipeze munkhaniyi, muyenera kudina pamenyu yotsitsa yofananira.

Chithunzichi chikuwonetsa momwe zinthu zonse za gulu zimagwera mumndandanda wotsitsa umodzi.

Mukadina batani la "Mitu ndi Mapazi", tabu ina yokhala ndi magawo idzawonekera. Mu menyu omwe akuwoneka, pali ntchito yoyika chithunzi. Munthu amene akufunika kuphatikiza chithunzi mu chikalata akhoza kuchipeza mu gulu la Header Elements.

Kenako, bokosi la zokambirana lidzawoneka momwe muli zosankha zambiri posankha malo a chithunzicho. Chithunzi chathu chili pakompyuta, kuti tithe kuchipeza kudzera pa batani la "Sakatulani", lomwe lili pafupi ndi gawo la "From file".

Pambuyo pake, timayang'ana chithunzi choyenera ndikuchiyika m'njira yoyenera, monga momwe zimachitikira m'mapulogalamu ena onse. Pambuyo chithunzi anaikapo, inu adzasamutsidwa kusintha akafuna. Panthawiyi, simudzawona chithunzicho. Izi siziyenera kukuwopsyezani inu. The & sign idzawonetsedwa m'malo mwake. Mukusintha mawonekedwe, mutha kuyimitsa chithunzicho pamalo oyenera. Mwachitsanzo, tinayiyika ndendende pakati pa chikalatacho. Mutha kusankhanso malo kumanzere, kumanja, pamwamba, pansi, kapena china chilichonse mkati mwa chikalatacho.

Mukadina kumanzere pa selo lililonse lomwe silinaphatikizidwe pamutu, mudzawona momwe chithunzi chosankhidwa chili kumbuyo kwa maselo. Zonse zomwe zili nawo zidzawonetsedwa pamwamba.

Chinthu chokha choyenera kuganizira ndi chakuti ngati chithunzicho chilibe mitundu yowala, komanso chiwerengero chawo ndi chachikulu kwambiri, ndiye kuti sichidzawonetsedwa bwino. Khalani okonzeka kusokoneza chithunzi chomwe chawonjezeredwa kumbuyo motere.

Zowona, wogwiritsa ntchito amatha, mkati mwa malire ena, kusintha kuwala kwa chithunzicho. Izi zimachitika pa tabu yomweyi "Kugwira ntchito ndi mitu ndi ma footer". Mawonekedwe a chithunzi amawongoleredwa kudzera pa batani la dzina lomwelo. Ndipo ili mu "Header and Footer Elements" submenu.

Kenako, bokosi la zokambirana lidzatsegulidwa momwe tili ndi chidwi ndi tabu yachiwiri. Pa izo, m'munda posankha mtundu wowonetsera, muyenera kupeza batani la "Substrate", ndikutsimikizira zochita zanu (ndiko kuti, dinani Chabwino).

Chithunzicho sichidzakhala chowala kwambiri.

Sichithunzi chokha chomwe chingalowetsedwe ngati maziko. Ngakhale malemba akhoza kuikidwa kumbuyo kwa maselo ena. Kuti muchite izi, tsegulani gawo lamutu ndi lapansi, ndikumata mawuwa pamenepo. Pankhaniyi, mtundu uyenera kukhala wotuwa.

Ndipo potsiriza, kuchotsa chithunzi chakumbuyo, simuyenera kudandaula kwambiri. Mwachidule kutsegula chamutu, kusankha izo, ndiyeno kuchotsa mu njira muyezo. Pambuyo kudina mbewa kumanzere kupangidwa pa selo iliyonse yaulere kunja kwa mutu kapena pansi, zosintha zidzapulumutsidwa.

Momwe mungawonjezere zolemba mkati / pamwamba pa mawonekedwe a SmartArt

SmartArt ndi mtundu wapamwamba kwambiri wa Excel Shapes. Zimakuthandizani kuti musinthe mawonekedwe a deta, chifukwa imadziwika ndi zamakono komanso mwachidule. Mawonekedwe a SmartArt adawonekera koyamba mu Excel 2007. 

Ubwino Wachikulu wa Mawonekedwe a SmartArt:

1. Amapangidwa makamaka kuti awonetsere mutu wakutiwakuti. 
2. Mawonekedwe a SmartArt ndi a semi-automated, kotero amapulumutsa nthawi ndi mphamvu zambiri kwa wogwiritsa ntchito.
3. Kuphweka. Chida ichi chimathandizira kujambula ngakhale mabwalo ovuta popanda kuyesetsa kwina.
   

   

Pali njira zambiri zowonetsera zithunzi zomwe chida ichi chimathandizira. Nazi zochepa chabe mwa izo: piramidi, kujambula, kuzungulira, njira, ndi zina. Ndipotu ntchito zambiri zachitika kale kwa munthuyo. Ndikokwanira kukhala ndi lingaliro m'mutu mwanu momwe dera liyenera kuonekera, ndiyeno lembani template.

Kuti mumvetsetse momwe mungawonjezere mawu pamwamba pa mawonekedwe a SmartArt, choyamba muyenera kumvetsetsa momwe mungachitire nthawi zonse. Kuti muyike cholembedwa mu chithunzi, choyamba muyenera kusankha chinthu choyenera, kenako pezani malo alemba ndikudina. Kenako mudzafunsidwa kuti mulowetse zambiri ndipo mutalowa muyenera kudina malo aliwonse opanda kanthu.

Mutha kumatanso zomwe zidakopera kale pa clipboard mugawo lolowetsa mawu. 

Pakhoza kukhala vuto lomwe gawo lalemba silikuwoneka. Kenako muyenera kupeza batani mu mawonekedwe a muvi kumanzere kwa graphic element ndikudina.

Tsopano tiyeni tikambirane mwachindunji momwe mungayikitsire mawu pamwamba pa mawonekedwe a SmartArt. Njira yomweyi ingagwiritsidwe ntchito kuiyika pamalo aliwonse omwe atchulidwa ndi wogwiritsa ntchito. Kuti muchite izi, muyenera kuwonjezera gawo lolemba lokha. Mutha kupeza batani lomwe izi zimachitikira mu "Insert" tabu. Wogwiritsa ntchito amatha kuyipanga mwakufuna kwake, mwachitsanzo, kukhazikitsa zolemba zakumbuyo kapena kusintha makulidwe a malire. Izi zimakulolani kuti muwonjezere maziko a yunifolomu mosagwirizana ndi malemba pamwamba pa mawonekedwe. 

Mutha kufufuta gawo lalemba mofanana ndi mawonekedwe ena aliwonse. Mukhozanso kufufuta malembawo osati kuti asawonekere. Ngati ikufunika kubisika, mawuwo amawonekera mumtundu wakumbuyo, ndipo mwatha.

Kuwonjezera mawu pa chithunzi

Pali njira zina ziwiri zomwe zimakupatsani mwayi wowonjezera zolemba pazithunzi. Choyamba ndi kugwiritsa ntchito zinthu za WordArt. Chachiwiri ndikuwonjezera mawu ngati cholembedwa. Popeza sizosiyana ndi zomwe tafotokozazi, muyenera kugwiritsa ntchito tabu "Ikani".

Lingaliro lazochita lidzakhala lofanana, mosasamala kanthu za pulogalamu ya ofesi yomwe munthu amagwira ntchito - Mawu, Excel kapena PowerPoint.

Tsatanetsatane wa zochita zake ndi yosavuta:

1. Kuwonjezera chithunzi pa spreadsheet. 
2. Pambuyo pake, muyenera kupeza gulu la "Text" pa "Insert" tabu, komwe mumapeza mapangidwe oyenera ndikupereka chidziwitso choyenera. 12.png
3. Kenaka timayang'ana malire akunja a chinthucho (osati malemba okha, koma chinthu chokha) ndi cholozera, dinani ndipo, popanda kumasula mbewa, sunthani malembawo ku chithunzi. Zowongolera zidzawonekeranso, mothandizidwa ndi zomwe mutha kusinthanso ndikusintha zolembedwazo ku ngodya iliyonse yabwino kwa wogwiritsa ntchito. 
4. Kenako timadina chithunzicho (momwemonso, pamalire ake akunja), ndiyeno timasankha zolembedwazo pogwira fungulo la Ctrl. Mudzapeza zinthu ziwiri zosankhidwa. Ndiko kuti, ndondomeko ya zochita ili motere. Choyamba, chithunzicho chimasankhidwa, kenaka Ctrl ndikuponderezedwa, ndiyeno dinani palembalo. Pambuyo pake, dinani batani la "Gulu" ndikusankha "Gulu".

Chochita chomaliza ndichofunika kupanga chimodzi mwa zinthu ziwiri. Ngati muyenera kuwasiya olekanitsidwa, ndiye kuti simungathe kuchita chilichonse. 

Momwe mungapangire chithunzi chakumbuyo mu Excel

Malangizo atsatanetsatane amomwe mungapangire watermark mu Excel adaperekedwa pamwambapa. Kunena mwachidule, muyenera kuyika chithunzi pamutu kapena pansi pa chikalatacho. Pambuyo pake, sinthani magawo a gawo lapansi, ndipo tipeza chonchi.

Palibe ntchito yapadera yomwe ingakulolezeni kuchita izi. Koma powonjezera chithunzi pamutu, tikhoza kugwiritsa ntchito zofanana. Koma m’pofunika kukumbukira kuti mfundo imeneyi ndi yothandiza.

Kusintha pansi komwe kulipo

Kuti muchite izi, muyenera kuchotsa chothandizira chakale ndikuyika china chatsopano. Pambuyo pake, zidzawonjezedwa kumbuyo kwa tebulo.

Watermark

M'malo mwake, iyi ndi gawo lapansi lomwelo, lokha lomwe limapangidwa mwamalemba. Itha kukhala chithunzi chomwe chilipo ndi mawu ofotokozera kapena chomwe mwapanga nokha. Mutha kujambula mu zojambulajambula (mwachitsanzo, ikani adilesi ya webusayiti), kenako ingowonjezerani ngati maziko. Chilichonse, watermark yakonzeka.

Muthanso kupanga chithunzicho kuti chiwoneke bwino kuti muthe kutengera mawonekedwe a watermark. Tiyeni tione mwatsatanetsatane zomwe zikufunika pa izi.

Momwe mungapangire chithunzi chowoneka bwino kumbuyo kwa mawu

Chithunzi chowoneka bwino ndi njira ina yopangira kuti mawu omwe ali kumbuyo kwa chithunzicho awoneke ngati chomalizacho chakutidwapo. Pankhaniyi, wogwiritsa ntchito sangadziwe komwe chithunzicho chili pamwamba kapena pansi palemba. Ingopangitsani chithunzicho kukhala chowoneka bwino, ndiyeno mawuwo amawonekera. Ma watermark amathanso kupangidwa motere.

Momwe mungapangire chithunzi chowoneka bwino mu Excel? Tsoka ilo, izi sizingachitike pogwiritsa ntchito Excel, chifukwa ntchito yake sikugwira ntchito ndi zithunzi ndi zolemba, koma kukonza manambala, zomveka ndi mitundu ina ya data. Chifukwa chake, njira yokhayo yopangira chithunzi chowoneka bwino ndikusintha mawonekedwe owonekera a chithunzi mu Photoshop kapena mkonzi wina uliwonse wazithunzi, ndikuyika chithunzicho muzolembazo.

Momwe mungayikitsire chithunzi mu Excel spreadsheet yomwe siyikuphimba deta

Pali chinthu china chowonjezera cha Excel chomwe ogwiritsa ntchito ambiri mwina sachigwiritsa ntchito. Awa ndi makonzedwe owonekera amtundu wina. Izi ndi zomwe pulogalamu ya spreadsheet ingachite.

Zoona, kasamalidwe mu nkhani iyi nawonso alibe zoletsa. Ndi za kuwonekera kwa kudzaza. Chabwino, kapena kachiwiri, gwiritsani ntchito njira yapitayi ndikuyamba kukonza chithunzicho kuti chisatseke deta kapena kutsitsa pa intaneti. Kenako koperani ndikuyika muzolemba zanu.

Monga mukuwonera, nthawi zambiri, Excel imapereka mwayi woyika zithunzi zamalemba. Koma, ndithudi, iwo ndi ochepa kwambiri ndipo amalamulidwa ndi mfundo yakuti ogwiritsa ntchito pulogalamuyi sasonyeza kuti akufuna kukonza matebulo motere. Nthawi zambiri amakhala ndi magwiridwe antchito okhazikika kapena amanyalanyazidwa kwathunthu. 

Excel ilinso ndi zosankha zambiri zamapangidwe zomwe ndizothandiza. Mwachitsanzo, masanjidwe okhazikika amakulolani kusintha mtundu wa kudzaza (mwa njira, kuwonekera kwakenso), kutengera zomwe zili mu cell. 

Mwachitsanzo, njira yokhala ndi mutu kapena pansi nthawi zambiri sizoyipa, koma chifukwa cha kutayika kwa chithunzithunzi, sikutheka kuzigwiritsa ntchito mokwanira. Zomwezo zimagwiranso ntchito powonekera kwa chithunzicho, chomwe chiyenera kukonzedwa poyamba mu mkonzi wazithunzi.

Njira yokhayo yolumikizira mawu ochulukirapo pamwamba pa chithunzi ndikugwiritsa ntchito chinthu cha Word Art. Koma izi ndizovuta, komabe ndi zithunzi zambiri kuposa zolemba. Zowona, apa mutha kukhazikitsa magawo m'njira yoti zinthu zotere ziziwoneka ngati zolemba. 

Chifukwa chake, Excel imagwiritsidwa ntchito bwino pazolinga zake. Koma ngati pakufunika kuchita zambiri kuposa zomwe zaperekedwa mu pulogalamuyi, nthawi zonse mutha kupeza njira yopulumukira.