Ukufaka kanye nokulungisa isithombe ku-Excel

Kwesinye isikhathi, ukwenza imisebenzi ethile ku-Excel, udinga ukufaka uhlobo oluthile lwesithombe noma isithombe etafuleni. Ake sibone ukuthi lokhu kungenziwa kanjani kahle ohlelweni.

Qaphela: Ngaphambi kokuthi uqhubekele ngqo enqubweni yokufaka isithombe ku-Excel, udinga ukuba naso – kusigcinalwazi sekhompyutha noma idrayivu ye-USB exhunywe kwi-PC.

Ukufaka isithombe eshidini

Okokuqala, senza umsebenzi wokulungiselela, okungukuthi, vula idokhumenti oyifunayo bese uya eshidini elidingekayo. Siqhubeka ngohlelo olulandelayo:

1. Sisukuma esitokisini lapho sihlela ukufaka isithombe. Shintshela kuthebhu "Faka"lapho sichofoza inkinobho “Imifanekiso”. Ohlwini lokudonsela phansi, khetha into “Imidwebo”.
2. Iwindi lizovela esikrinini lapho udinga ukukhetha khona isithombe osifunayo. Ukuze wenze lokhu, qala uye kufolda equkethe ifayela elidingekayo (ngokuzenzakalelayo, ifolda "Izithombe"), bese uchofoza kukho bese ucindezela inkinobho "Vula" (noma ungavele uchofoze kabili ifayela).
3. Ngenxa yalokho, isithombe esikhethiwe sizofakwa ephepheni lencwadi. Kodwa-ke, njengoba ubona, ivele ibekwe phezulu kwamaseli futhi ayihlanganise lutho nawo. Ngakho-ke asiqhubekele ezinyathelweni ezilandelayo.

Ukulungisa isithombe

Manje sidinga ukulungisa isithombe esifakiwe ngokusinika ubukhulu obufunayo.

1. Chofoza esithombeni ngenkinobho yegundane engakwesokudla. Ohlwini olwehliswayo, khetha "Usayizi Nezakhiwo".
2. Iwindi lefomethi yesithombe lizovela, lapho singalungisa khona amapharamitha alo:
   • ubukhulu (ubude nobubanzi);
   • i-angle yokujikeleza;
   • ubude nobubanzi njengephesenti;
   • ukugcina izilinganiso, njll.
3. Nokho, ezimweni eziningi, esikhundleni sokuya efasiteleni lefomethi yesithombe, izilungiselelo ezingenziwa kuthebhu "Ifomethi" (kulokhu, umdwebo ngokwawo kufanele ukhethwe).
4. Ake sithi sidinga ukulungisa usayizi wesithombe ukuze singadluli imingcele yeseli ekhethiwe. Ungakwenza lokhu ngezindlela ezahlukene:
   • iya kuzilungiselelo “Ubukhulu Nezakhiwo” ngokusebenzisa imenyu yokuqukethwe yesithombe bese ulungisa usayizi efasiteleni elivelayo.
   • setha izilinganiso usebenzisa amathuluzi afanele kuthebhu "Ifomethi" kuribhoni yohlelo.
   • ubambe inkinobho yegundane lesokunxele, hudula ikhona elingezansi kwesokudla lesithombe ngokudayagonali phezulu.

Ukunamathisela isithombe kuseli

Ngakho-ke, sifake isithombe eshidini le-Excel futhi salungisa usayizi waso, okwasivumela ukuba singene emingceleni yeseli ekhethiwe. Manje udinga ukunamathisela isithombe kule seli. Lokhu kwenziwa ukuze ezimweni lapho ukuguqulwa kwesakhiwo setafula kuholela ekushintsheni kwendawo yokuqala yeseli, isithombe sihamba nayo. Ungakwazi ukwenza lokhu ngale ndlela elandelayo:

1. Sifaka isithombe bese silungisa usayizi waso ukuze ulingane nemingcele yeseli, njengoba kuchazwe ngenhla.
2. Chofoza isithombe bese ukhetha ohlwini "Usayizi Nezakhiwo".
3. Ngaphambi kwethu, kuzovela iwindi lefomethi yesithombe esejwayelekile. Ngemva kokuqinisekisa ukuthi ubukhulu buhambisana namanani afunekayo, futhi kukhona namabhokisi okuhlola “Gcina izilinganiso” и "Ngokuphathelene nosayizi wangempela", hamba к "Izakhiwo".
4. Ezicini zesithombe, beka amabhokisi okuhlola ngaphambi kwezinto "Into evikelekile" и "Printa into". Futhi, khetha inketho “Hambisa futhi ushintshe usayizi ngamaseli”.

Ukuvikela iseli ngesithombe ezinguqukweni

Lesi silinganiso, njengoba negama lesihloko lisho, siyadingeka ukuze kuvikelwe iseli eliqukethe isithombe ukuthi lingashintshwa futhi lisuswe. Nakhu okudingeka ukwenze kulokhu:

1. Khetha lonke ishidi, esiqala ngalo ukususa okukhethiwe esithombeni ngokuchofoza kunoma iyiphi enye iseli, bese ucindezela inhlanganisela yokhiye. Ctrl + A. Bese sibiza imenyu yokuqukethwe kwamaseli ngokuchofoza kwesokudla noma yikuphi endaweni ekhethiwe bese ukhetha into "Ifomethi Yeseli".
2. Efasiteleni lokufometha, shintshela kuthebhu "Ukuvikela", lapho sisusa ukumaka ibhokisi elibhekene nento “Iseli elivikelwe” bese uchofoza OK.
3. Manje chofoza iseli lapho isithombe sifakwe khona. Ngemva kwalokho, futhi ngokusebenzisa imenyu yokuqukethwe, iya kufomethi yayo, bese uya kuthebhu "Ukuvikela". Maka ibhokisi eduze kwenketho “Iseli elivikelwe” bese uchofoza OK.Qaphela: uma isithombe esifakwe kuseli sidlulela ngokuphelele, ukuchofoza kuso ngezinkinobho zegundane kuzobiza izici nezilungiselelo zesithombe ngokwaso. Ngakho-ke, ukuze uye esitokisini esinesithombe (sikhethe), kungcono ukuchofoza kunoma iyiphi enye iseli eduze kwayo, bese usebenzisa okhiye bokuzulazula kukhibhodi (phezulu, phansi, kwesokudla, kwesokunxele), hamba uye kokudingekayo. Futhi, ukubiza imenyu yokuqukethwe, ungasebenzisa ukhiye okhethekile kukhibhodi, etholakala kwesokunxele Ctrl.
4. Shintshela kuthebhu "Buyekeza"lapho chofoza inkinobho “Vikela Ishidi” (uma ubukhulu bewindi bucindezelwa, kufanele uqale uchofoze inkinobho "Ukuvikela", ngemva kwalokho into oyifunayo izovela ohlwini lokudonsela phansi).
5. Kuzovela iwindi elincane lapho singasetha khona iphasiwedi ukuze sivikele ishidi kanye nohlu lwezenzo ezingenziwa abasebenzisi. Chofoza uma usulungile OK.
6. Ewindini elilandelayo, qinisekisa iphasiwedi efakiwe bese uchofoza KULUNGILE.
7. Njengomphumela wezenzo ezenziwe, iseli lapho isithombe sitholakala khona izovikelwa kunoma yiziphi izinguquko, okubandakanya. ukususwa.Ngesikhathi esifanayo, amaseli asele eshidi ahlala ehleleka, futhi izinga lenkululeko yokwenza ngokuhlobene nawo lincike ekutheni yiziphi izinto esizikhethile lapho ukuvikelwa kweshidi kuvulwa.

Ukufaka isithombe kumazwana weseli

Ngaphezu kokufaka isithombe kuseli yetafula, ungasengeza kunothi. Ukuthi lokhu kwenziwa kanjani kuchazwe ngezansi:

1. Chofoza kwesokudla kuseli lapho ufuna ukufaka khona isithombe. Ohlwini oluya phansi, khetha umyalo "Faka inothi".
2. Indawo encane yokufaka inothi izovela. Hambisa ikhesa phezu komngcele wendawo yenothi, chofoza kwesokudla kuyo futhi ohlwini oluvulayo, chofoza entweni "Ifomethi yenothi".
3. Iwindi lezilungiselelo zenothi lizovela esikrinini. Shintshela kuthebhu "Imibala Nemigqa". Ezinkethweni zokugcwalisa, chofoza kumbala wamanje. Kuzovuleka uhlu lapho sikhetha khona into "Izindlela Zokugcwalisa".
4. Efasiteleni lezindlela zokugcwalisa, shintshela kuthebhu "Isithombe", lapho sicindezela khona inkinobho enegama elifanayo.
5. Iwindi lokufaka isithombe lizovela, lapho sikhetha khona inketho "Kusuka kufayela".
6. Ngemuva kwalokho, kuzovuleka iwindi lokukhetha izithombe, esesivele sihlangane nalo ekuqaleni kwesihloko sethu. Iya kufolda equkethe ifayela elinesithombe osifunayo, bese ucindezela inkinobho "Faka".
7. Uhlelo luzosibuyisela efasiteleni langaphambilini ukuze sikhethe izindlela zokugcwalisa ngephethini ekhethiwe. Thikha ibhokisi ukuze uthole inketho “Gcina izilinganiso zesithombe”, bese uchofoza OK.
8. Ngemuva kwalokho, sizozithola sisefasiteleni lefomethi yenothi elikhulu, lapho sishintshela kuthebhu "Ukuvikela". Lapha, susa ukumaka ibhokisi eduze kwento “Into Evikelwe”.
9. Okulandelayo, hamba kuthebhu "Izakhiwo". Khetha inketho "Hambisa futhi ushintshe into kanye namaseli". Zonke izilungiselelo zenziwe, ngakho ungacindezela inkinobho OK.
10. Njengomphumela wezenzo ezenziwe, asikwazanga nje ukufaka isithombe njengenothi esitokisini, kodwa futhi ukusinamathisela esitokisini.
11. Uma uthanda, inothi lingafihlwa. Kulesi simo, izoboniswa kuphela uma uhambisa phezulu kweseli. Ukuze wenze lokhu, chofoza kwesokudla kuseli ngenothi bese ukhetha into kumenyu yokuqukethwe "Fihla inothi".Uma kunesidingo, inothi lifakwe emuva ngendlela efanayo.

Faka isithombe kumodi kanjiniyela

I-Excel iphinde inikeze ikhono lokufaka isithombe kuseli ngokusebenzisa okuthiwa Imodi yonjiniyela. Kodwa okokuqala udinga ukuyivula, ngoba ikhutshaziwe ngokuzenzakalelayo.

1. Iya kumenyu "Fayela", lapho sichofoza entweni "Amapharamitha".
2. Kuzovuleka iwindi lamapharamitha, lapho ohlwini olungakwesokunxele chofoza ingxenye “Yenza ngendlela oyifisayo i-Ribbon”. Ngemva kwalokho, engxenyeni efanele yefasitela kuzilungiselelo zeribhoni, sithola umugqa “Unjiniyela”, khetha ibhokisi eliseduze nalo bese uchofoza OK.
3. Sima esitokisini lapho sifuna ukufaka khona isithombe, bese siya kuthebhu “Unjiniyela”. Esigabeni samathuluzi “Izilawuli” thola inkinobho "Faka" bese uchofoza kukho. Ohlwini oluvulayo, chofoza isithonjana "Isithombe" eqenjini “Izilawuli ezisebenzayo”.
4. Ikhesa izoshintsha ibe yisiphambano. Ngokucindezelwa kwenkinobho yegundane kwesokunxele, khetha indawo yesithombe esizayo. Uma kunesidingo, izilinganiso zale ndawo zingase zilungiswe noma indawo kanxande ophumayo (isikwele) ingashintshwa ukuze ingene ngaphakathi kweseli.
5. Chofoza kwesokudla esithombeni esiwumphumela. Ohlwini oludonsela phansi lwemiyalo, khetha "Izakhiwo".
6. Sizobona iwindi elinezakhiwo ze-elementi:
   • kunani lepharamitha "Ukubekwa" khombisa inombolo "1" (inani lokuqala - "2").
   • ensimini yokufaka inani eliphambene nepharamitha "Isithombe" chofoza inkinobho enamachashazi amathathu.
7. Iwindi lokulayisha isithombe lizovela. Sikhetha ifayela olifunayo lapha bese silivula ngokuchofoza inkinobho efanelekile (kunconywa ukukhetha uhlobo lwefayela "Wonke Amafayela", ngoba uma kungenjalo ezinye izandiso ngeke zibonakale kuleli windi).
8. Njengoba ubona, isithombe sifakwe eshidini, nokho, ingxenye yaso kuphela evezwayo, ngakho ukulungiswa kosayizi kuyadingeka. Ukuze wenze lokhu, chofoza isithonjana ngendlela kanxantathu omncane phansi endaweni yenani lepharamitha "PictureSizeMode".
9. Ohlwini oluya phansi, khetha inketho enenombolo “1” ekuqaleni.
10. Manje sonke isithombe silingana ngaphakathi kwendawo engunxande, ukuze izilungiselelo zingavalwa.
11. Kuhlala kuphela ukubopha isithombe kuseli. Ukuze wenze lokhu, yiya kuthebhu "Isakhiwo sekhasi", lapho sicindezela khona inkinobho "Uku-oda". Ohlwini lokudonsela phansi, khetha into "Qondanisa", bese - "Ngena kuGridi".
12. Kwenziwe, isithombe sinamathiselwe kuseli ekhethiwe. Ngaphezu kwalokho, manje imingcele yayo "izonamathela" emingceleni yeseli uma sihambisa isithombe noma sishintsha usayizi waso.
13. Lokhu kuzokuvumela ukuthi uvumelane kahle nesithombe esitokisini ngaphandle komzamo omkhulu.

Isiphetho

Ngakho, kunezindlela ezimbalwa ongafaka ngazo isithombe kuseli eshidini le-Excel. Indlela elula ukusebenzisa amathuluzi kuthebhu ethi Faka, ngakho-ke akumangazi ukuthi lena indlela edume kakhulu phakathi kwabasebenzisi. Ngaphezu kwalokho, kungenzeka ukufaka izithombe njengamanothi eselula noma wengeze izithombe eshidini usebenzisa Imodi Yonjiniyela ekhethekile.