Ungasibeka Kanjani Isithombe Ngemva Kombhalo ku-Excel - Isinyathelo Ngesinyathelo Umhlahlandlela

Abantu abaningi bayazi ukuthi usifaka kanjani isithombe kuspredishithi se-Excel. Kodwa uma bezama ukukwenzela umbhalo, ngeke baphumelele. Iqiniso liwukuthi isithombe sifakwe ungqimba olukhethekile, olutholakala ngaphezu kombhalo. Ngakho isithombe sizokweqa. Kodwa yini engenziwa ukuze kufakwe isithombe ngemva kombhalo ukuze sibe isizinda sawo?

Futhi kukhona umsebenzi okuvumela ukuthi ufinyelele lo mphumela. Ibizwa ngokuthi izihloko. Manje sizofunda ukuthi singayisebenzisa kanjani. 

Isinyathelo ngesinyathelo imiyalelo yokubeka isithombe ngemuva kombhalo ku-Excel

Ake siqale ngomyalo ojwayelekile ozochaza zonke izici ezidingekayo, bese sizonaka amaqhinga athile angenziwa ngombhalo nezithombe. Lokhu kuzosindisa isikhathi njengoba asikho isidingo sokuqhubeka uma ulwazi olulandelayo lungadingeki esimweni esithile. Ungayibuyekeza ngemva kwesikhashana, lapho udinga ukwenza isenzo esihlinzekwe esigabeni esithile. 

Indlela esiyichazile ingeyokwenziwa ngandlela thize futhi ngokusobala ayiklanyelwe lokhu. Kodwa ngezihloko nonyaweni, ungakwazi ngempela ukufaka isithombe sombhalo. Konke kuqala ngokuthi sivula incwadi yokusebenzela ye-Excel bese sibheka ithebhu ethi “Faka” kuribhoni.

Ungasibeka Kanjani Isithombe Ngemva Kombhalo ku-Excel - Isinyathelo Ngesinyathelo Umhlahlandlela
1

Okulandelayo, sibheka ingxenye ethi "Umbhalo", lapho ungathola khona inkinobho ethi "Izihloko Nezansi". Udinga ukuchofoza kwesokunxele kukho.

Ungasibeka Kanjani Isithombe Ngemva Kombhalo ku-Excel - Isinyathelo Ngesinyathelo Umhlahlandlela
2

Kubalulekile ukuqaphela ukuthi uma imonitha inkulu kakhulu, le nkinobho ingase igoqwe. Ukuze uyifinyelele kuleli cala, udinga ukuchofoza imenyu yokudonsela phansi ehambisanayo.

Lesi sithombe-skrini sibonisa ukuthi zonke izici zeqembu zigoqeka kanjani zibe imenyu yokudonsela phansi eyodwa.

Ungasibeka Kanjani Isithombe Ngemva Kombhalo ku-Excel - Isinyathelo Ngesinyathelo Umhlahlandlela
3

Ngemva kokuchofoza inkinobho ethi “Inhlokweni Nonyaweni”, kuzovela enye ithebhu enemingcele. Kwimenyu evelayo, kunomsebenzi wokufaka isithombe. Umuntu odinga ukuhlanganisa isithombe kudokhumenti angasithola eqenjini le-Header Elements.

Ungasibeka Kanjani Isithombe Ngemva Kombhalo ku-Excel - Isinyathelo Ngesinyathelo Umhlahlandlela
4

Okulandelayo, ibhokisi lengxoxo lizovela lapho kunezinketho eziningi zokukhetha indawo yesithombe. Isithombe sethu sitholakala ngqo kukhompuyutha, ngakho-ke singasithola ngenkinobho ethi “Phequlula”, etholakala eduze kwenkambu ethi “Kusuka kufayela”.

Ungasibeka Kanjani Isithombe Ngemva Kombhalo ku-Excel - Isinyathelo Ngesinyathelo Umhlahlandlela
5

Ngemva kwalokho, sibheka isithombe esifanelekayo futhi sifaka ngendlela evamile, njengoba kwenzeka kuzo zonke ezinye izinhlelo. Ngemva kokuba isithombe sesifakiwe, uzodluliselwa kumodi yokuhlela. Phakathi naso, ngeke usibone isithombe ngokwaso. Lokhu akufanele kukwethuse. I-& sign izoboniswa esikhundleni salokho. Kumodi yokuhlela, ungamisa isithombe endaweni efanele. Isibonelo, siyibeke phakathi nendawo yedokhumenti. Ungakwazi futhi ukukhetha indawo kwesokunxele, kwesokudla, phezulu, phansi, nanoma iyiphi enye ngaphakathi kweshidi ledokhumenti.

Ungasibeka Kanjani Isithombe Ngemva Kombhalo ku-Excel - Isinyathelo Ngesinyathelo Umhlahlandlela
6

Ngemva kokuchofoza kwesokunxele kunoma iyiphi iseli engafakiwe kunhlokweni, uzobona ukuthi isithombe esikhethiwe sitholakala kanjani ngemva kwamaseli. Konke okuqukethwe kwabo kuzovezwa phezulu.

Isici kuphela okufanele sicatshangelwe ukuthi uma isithombe singenayo imibala ekhanyayo, kanye nenani labo likhulu kakhulu, khona-ke ngeke liboniswe kahle. Zilungiselele ukuhlanekezela isithombe esingezwe ngemuva ngale ndlela.

Ungasibeka Kanjani Isithombe Ngemva Kombhalo ku-Excel - Isinyathelo Ngesinyathelo Umhlahlandlela
7

Yiqiniso, umsebenzisi angakwazi, ngaphakathi kwemikhawulo ethile, ukulungisa ukukhanya kwesithombe. Lokhu kwenziwa kuthebhu efanayo "Ukusebenza ngonhlokweni nonyaweni". Ifomethi yesithombe ilawulwa ngenkinobho yegama elifanayo. Futhi itholakala kumenyu engaphansi ethi “Header and Footer Elements”.

Ungasibeka Kanjani Isithombe Ngemva Kombhalo ku-Excel - Isinyathelo Ngesinyathelo Umhlahlandlela
8

Okulandelayo, ibhokisi lengxoxo lizovuleka lapho sinentshisekelo kuthebhu yesibili. Kuyo, endaweni yokukhetha imodi yokubonisa umbala, udinga ukuthola inkinobho ethi "Substrate", bese uqinisekisa izenzo zakho (okungukuthi, chofoza OK).

Ungasibeka Kanjani Isithombe Ngemva Kombhalo ku-Excel - Isinyathelo Ngesinyathelo Umhlahlandlela
9

Isithombe ngeke ngokushesha singakhanyi kangako.

Ungasibeka Kanjani Isithombe Ngemva Kombhalo ku-Excel - Isinyathelo Ngesinyathelo Umhlahlandlela
10

Akusona isithombe kuphela esingafakwa njengengemuva. Ngisho nombhalo ungabekwa ngemuva kwamanye amaseli. Ukuze wenze lokhu, vula inkambu unhlokweni nonyaweni, bese unamathisele lo mbhalo lapho. Kulokhu, umbala kufanele usethelwe kumpunga okhanyayo.

Futhi ekugcineni, ukususa isithombe sangemuva, awudingi ukukhathazeka kakhulu. Vele uvule unhlokweni, uwukhethe, bese uwususa ngendlela evamile. Ngemuva kokuthi ukuchofoza kwegundane kwesokunxele kwenziwe kunoma iyiphi iseli yamahhala ngaphandle kwesihloko noma unyaweni, izinguquko zizolondolozwa ngokuzenzakalelayo.

Uwengeza kanjani umbhalo ngaphakathi/phezu komumo we-SmartArt

I-SmartArt inguqulo ethuthuke kakhulu ye-Excel Shapes. Ikuvumela ukuthi uthuthukise kakhulu ukubonwa kwedatha, ngoba ibonakala ngesimanjemanje kakhulu kanye nobufushane. Izimo ze-SmartArt zivele okokuqala ku-Excel 2007. 

Izinzuzo Eziyinhloko Ze-SmartArt Shapes:

  1. Zenzelwe ngokukhethekile ukumela isihloko esithile ngohlelo. 
  2. Izimo ze-SmartArt zi-semi-automated, ngakho zonga isikhathi esiningi namandla kumsebenzisi.
  3. Ubulula. Leli thuluzi lenza kube nokwenzeka ukudweba ngisho nezifunda eziyinkimbinkimbi ngaphandle komzamo owengeziwe.
    Ungasibeka Kanjani Isithombe Ngemva Kombhalo ku-Excel - Isinyathelo Ngesinyathelo Umhlahlandlela
    11

Kunenombolo enkulu yezindlela zokumela imidwebo esekelwa leli thuluzi. Nazi ezimbalwa zazo: iphiramidi, umdwebo, imijikelezo, izinqubo, nokunye. Eqinisweni, umsebenzi omningi usuwenzelwe umuntu. Kwanele nje ukuba nombono ekhanda lakho ukuthi isifunda kufanele sibukeke kanjani, bese ugcwalisa ithempulethi.

Ukuze uqonde ukuthi ungeza kanjani umbhalo phezu komumo we-SmartArt, okokuqala udinga ukuqonda ukuthi uwenza kanjani ngokujwayelekile. Ukuze ufake umbhalo esithombeni, kufanele uqale ukhethe i-elementi efanele, bese uthola indawo yombhalo bese uchofoza kuyo. Ngemuva kwalokho uzocelwa ukuthi ufake imininingwane futhi ngemuva kokufaka udinga ukuchofoza kunoma yisiphi isikhala esingenalutho.

Ungakwazi futhi ukunamathisela ulwazi olukopishwe ngaphambilini ebhodini lokunamathisela endaweni yokufaka umbhalo. 

Kungase kube nesimo lapho indawo yombhalo ingabonakali. Bese udinga ukuthola inkinobho ngesimo somcibisholo ohlangothini lwesobunxele lwesici sesithombe bese uchofoza kuso.

Manje ake sikhulume ngokuqondile ngokuthi ungawufaka kanjani umbhalo phezu komumo we-SmartArt. Indlela efanayo ingasetshenziswa ukuyibeka kunoma iyiphi indawo echazwe umsebenzisi. Ukuze wenze lokhu, udinga ukwengeza inkambu yombhalo ngokwayo. Ungathola inkinobho okwenziwa ngayo lokhu kuthebhu ethi "Faka". Umsebenzisi angayifometha ngokubona kwakhe, isibonelo, ukusetha umbhalo ongemuva noma ulungise ukujiya kwemingcele. Lokhu kukuvumela ukuthi wengeze ingemuva elifana nelinye kumbhalo ongaphezulu komumo. 

Ungasusa inkambu yombhalo ngendlela efanayo nanoma yimuphi omunye umumo. Ungakwazi futhi ukusula umbhalo ngokwawo kunokukwenza ungabonakali. Uma idinga ukufihlwa, umbhalo ugqanyiswa ngombala ongemuva, futhi usuqedile.

Yengeza umbhalo phezu kwesithombe

Kukhona ezinye izindlela ezimbili ezikuvumela ukuthi ungeze umbhalo phezu kwezithombe. Okokuqala ukusetshenziswa kwezinto ze-WordArt. Okwesibili ukungeza umbhalo njengombhalo. Njengoba ingafani naleyo echazwe ngenhla, udinga ukusebenzisa ithebhu ethi "Faka".

Umqondo wezenzo uzofana, kungakhathaliseki ukuthi yiluphi uhlelo lwehhovisi umuntu asebenza kulo - iZwi, i-Excel noma i-PowerPoint.

Ukulandelana kwezenzo kulula kakhulu:

  1. Ukwengeza isithombe kuspredishithi. 
  2. Ngemuva kwalokho, udinga ukuthola iqembu elithi "Umbhalo" kuthebhu ethi "Faka", lapho uthola khona umklamo ofanele futhi unikeze ulwazi olufanele. 12.png
  3. Bese sibheka umngcele wangaphandle wento ngokwayo (hhayi umbhalo ngokwawo, kodwa into ngokwayo) ngekhesa, chofoza kuyo futhi, ngaphandle kokukhulula igundane, hambisa umbhalo esithombeni. Izilawuli nazo zizovela, ngosizo ongashintsha ngalo futhi uphendukise umbhalo kunoma iyiphi i-engeli elungele umsebenzisi. 
  4. Bese sichofoza esithombeni (ngendlela efanayo, emngceleni waso wangaphandle), bese siphinde sikhethe umbhalo ngokubamba ukhiye we-Ctrl. Uzothola izinto ezimbili ezikhethiwe. Okungukuthi, ukulandelana kwezenzo kanje. Okokuqala, isithombe siyakhethwa, bese kucindezelwa u-Ctrl, bese uchofozwa embhalweni. Ngemva kwalokho, chofoza inkinobho ethi “Iqembu” bese kumenyu yokudonsela phansi chofoza okuthi “Iqembu”.

Isenzo sokugcina siyadingeka ukwenza into eyodwa kwezimbili. Uma udinga ukuwashiya ehlukene, awukwazi ukuthatha noma yiziphi izinyathelo. 

Ungasenza kanjani isithombe sangemuva ku-Excel

Imiyalo enemininingwane yokuthi ungayenza kanjani i-watermark ku-Excel inikezwe ngenhla. Ukukubeka kalula, udinga ukufaka isithombe kunhlokweni noma ngaphansi kwedokhumenti. Ngemuva kwalokho, lungisa imingcele ye-substrate, futhi sizothola into enjengale.

Ungasibeka Kanjani Isithombe Ngemva Kombhalo ku-Excel - Isinyathelo Ngesinyathelo Umhlahlandlela
13

Awukho umsebenzi okhethekile ongakuvumela ukuthi wenze lokhu. Kodwa ngokungeza isithombe kunhlokweni, singasebenzisa ukusebenza okufanayo. Kodwa kubalulekile ukukhumbula ukuthi, ngokomthetho, lokhu kuwudondolo.

Ukulungisa i-underlay ekhona

Ukuze wenze lokhu, kufanele ususe ukusekela okudala bese ufaka entsha. Ngemva kwalokho, izokwengezwa ngemuva kwetafula.

watermark

Eqinisweni, lena yi-substrate efanayo, kuphela eyenziwa ngendlela yombhalo. Kungaba isithombe esikhona esinamagama-ncazo wombhalo noma leso osenze wena ngokwakho. Ungayidweba kumhleli wesithombe (isibonelo, faka ikheli lewebhusayithi), bese uvele uyengeze njengendawo engemuva. Konke, i-watermark isilungile.

Ungenza futhi isithombe sibe sobala kancane ukuze ulingise kangcono umphumela we-watermark. Ake sihlolisise ukuthi yini edingekayo kulokhu.

Usenza kanjani isithombe esikhanyayo ngemuva kombhalo

Isithombe esikhanyayo singenye indlela yokwenza umbhalo ongemuva kwesithombe ubonakale uma lesi sithombe simbozwe kuso. Kulesi simo, umsebenzisi angase angazi ukuthi isithombe sitholakala kuphi ngenhla noma ngaphansi kombhalo. Vele wenze isithombe sibe sobala kancane, bese umbhalo uzobonakala ngokuzenzakalelayo. Ama-watermark nawo angenziwa ngale ndlela.

Ungasenza kanjani isithombe esiguquguqukayo ku-Excel? Ngeshwa, lokhu akunakwenziwa kusetshenziswa i-Excel, ngoba umsebenzi wayo awukona ukusebenza ngezithombe nombhalo, kodwa ukucubungula izinombolo, okunengqondo nezinye izinhlobo zedatha. Ngakho-ke, okuwukuphela kwendlela yokwenza isithombe esingafihli lutho ukushintsha izilungiselelo zokungafihli zesithombe ku-Photoshop nanoma yimuphi omunye umhleli wezithombe, bese unamathisele isithombe kudokhumenti.

Usifaka kanjani isithombe kuspredishithi se-excel esingafaki idatha

Kunesici esisodwa esengeziwe se-Excel okungenzeka ukuthi iningi labasebenzisi ngeke basisebenzise. Lezi izilungiselelo zokubonisa ngale zombala othile. Yilokhu kanye okungenziwa wuhlelo lwesipredishithi.

Yiqiniso, ukuphathwa kuleli cala nakho akunayo imingcele. Imayelana nokungafihli kokugcwalisa. Hhayi-ke, noma futhi, sebenzisa indlela yangaphambilini bese uqala ukucubungula isithombe ukuze singambozi idatha noma usilande ku-inthanethi. Yibe usuyikopisha futhi uyinamathisele kudokhumenti yakho.

Njengoba ubona, ngokuvamile, i-Excel inikeza ikhono lokufaka izithombe zombhalo. Kodwa-ke, kunqunyelwe kakhulu futhi kunqunywa ukuthi abasebenzisi balolu hlelo abavamile ukuveza isifiso sokucubungula amatafula ngale ndlela. Ngokuvamile zikhawulelwe ekusebenzeni okujwayelekile noma azinakwa ngokuphelele. 

I-Excel inezinketho eziningi zokufometha ezengeziwe ezisebenzisekayo. Isibonelo, ukufometha okunemibandela kukuvumela ukuthi ushintshe umbala wokugcwalisa (ngendlela, ukubonakala kwayo), ngokusekelwe kulwazi oluqukethwe kuseli. 

Isibonelo, inketho enesihloko noma unyaweni ngokuvamile ayikubi, kodwa ngenxa yokulahlekelwa ukucaca kwesithombe, akunakwenzeka ukuyisebenzisa ngokugcwele. Okufanayo kusebenza ekukhanyeni kwesithombe, okumele kuqala sicutshungulwe kumhleli wezithombe.

Okuwukuphela kwendlela yokwemboza umbhalo omningi noma omncane phezu kwesithombe ukusebenzisa into ye-Word Art. Kodwa lokhu akulungile, nokho ziyizithombe eziningi kunombhalo. Yiqiniso, lapha ungasetha amapharamitha ngendlela yokuthi izinto ezinjalo zibukeke njengombhalo. 

Ngakho-ke, i-Excel isetshenziselwa kangcono inhloso yayo. Kodwa uma kunesidingo sokwenza okungaphezu kwalokho okunikezwa ohlelweni, ungakwazi njalo ukuthola indlela yokuphuma.

shiya impendulo