Saka da Daidaita Hoto a cikin Excel

Wani lokaci, don yin wasu ayyuka a cikin Excel, kuna buƙatar saka wani nau'in hoto ko hoto a cikin tebur. Bari mu ga yadda za a iya yin hakan daidai a cikin shirin.

lura: kafin a ci gaba kai tsaye kan hanyar shigar da hoto a cikin Excel, kuna buƙatar sanya shi a hannu - akan rumbun kwamfutar ko kebul na USB wanda ke da alaƙa da PC.

Saka hoto akan takarda

Don farawa, muna gudanar da aikin shiri, wato, buɗe takaddun da ake so kuma je zuwa takardar da ake buƙata. Muna ci gaba bisa tsari mai zuwa:

1. Mun tashi a cikin tantanin halitta inda muke shirin saka hoton. Canja zuwa shafin "Saka"inda muka danna maballin "Misali". A cikin jerin zaɓuka, zaɓi abu "zane-zane".
2. Wani taga zai bayyana akan allon da kake buƙatar zaɓar hoton da ake so. Don yin wannan, fara zuwa babban fayil ɗin da ke ɗauke da fayil ɗin da ake buƙata (ta tsohuwa, babban fayil "Hotuna"), sannan danna shi kuma danna maɓallin "Buɗe" (ko kuma za ku iya danna sau biyu akan fayil ɗin).
3. A sakamakon haka, za a saka hoton da aka zaɓa a kan takardar littafin. Koyaya, kamar yadda kuke gani, an sanya shi a saman sel kuma ba shi da alaƙa da su. Don haka bari mu ci gaba zuwa matakai na gaba.

Daidaita hoton

Yanzu muna buƙatar daidaita hoton da aka saka ta hanyar ba shi girman da ake so.

1. Danna kan hoton tare da maɓallin linzamin kwamfuta na dama. A cikin jerin zaɓuka, zaɓi "Size da Properties".
2. Tagan tsarin hoto zai bayyana, inda zamu iya daidaita sigoginsa:
   • girma (tsawo da nisa);
   • kusurwar juyawa;
   • tsawo da faɗi a matsayin kashi;
   • kiyaye rabbai, da dai sauransu.
3. Koyaya, a mafi yawan lokuta, maimakon zuwa taga tsarin hoto, saitin da za'a iya yi a cikin shafin "Tsara" (a wannan yanayin, zane da kansa ya kamata a zaba).
4. Bari mu ce muna buƙatar daidaita girman hoton don kada ya wuce iyakar tantanin halitta da aka zaɓa. Kuna iya yin haka ta hanyoyi daban-daban:
   • je zuwa saituna "Dimensions and Properties" ta cikin mahallin menu na hoton kuma daidaita girman a cikin taga wanda ya bayyana.
   • saita ma'auni ta amfani da kayan aikin da suka dace a cikin shafin "Tsara" akan ribbon shirin.
   • riƙe maɓallin linzamin kwamfuta na hagu, ja ƙananan kusurwar dama na hoton a tsaye zuwa sama.

Haɗa hoto zuwa tantanin halitta

Don haka, mun sanya hoto a kan takardar Excel kuma muka daidaita girmansa, wanda ya ba mu damar shigar da shi cikin iyakokin tantanin halitta da aka zaɓa. Yanzu kuna buƙatar haɗa hoto zuwa wannan tantanin halitta. Ana yin haka ne ta yadda a lokuta inda canjin tsarin tebur ya haifar da canji a ainihin wurin tantanin halitta, hoton yana motsawa tare da shi. Kuna iya aiwatar da wannan ta hanya mai zuwa:

1. Muna saka hoto kuma muna daidaita girmansa don dacewa da iyakokin tantanin halitta, kamar yadda aka bayyana a sama.
2. Danna kan hoton kuma zaɓi daga lissafin "Size da Properties".
3. Kafin mu, da riga saba hoto format taga zai bayyana. Bayan tabbatar da cewa ma'auni sun dace da ƙimar da ake so, da kuma cewa akwai akwatunan rajista "A kiyaye daidai gwargwado" и "Dangane da girman asali", tafi к "Abubuwa".
4. A cikin kaddarorin hoton, sanya akwatunan rajistan shiga a gaban abubuwan "Abu mai kariya" и "Buga abu". Hakanan, zaɓi zaɓi "Matsar da girma tare da sel".

Kare tantanin halitta tare da hoto daga canje-canje

Ana buƙatar wannan ma'auni, kamar yadda sunan rubutun ke nunawa, don kare tantanin halitta da ke ɗauke da hoton daga canzawa da gogewa. Ga abin da kuke buƙatar yi don wannan:

1. Zaɓi dukan takardar, wanda muka fara cire zaɓin daga hoton ta danna kowane tantanin halitta, sannan danna haɗin maɓallin. Ctrl + A. Sannan muna kiran menu na mahallin sel ta danna dama a ko'ina cikin yankin da aka zaɓa kuma zaɓi abu "Format Cell".
2. A cikin taga tsarawa, canza zuwa shafin "Kariya", inda muka cire alamar akwatin kishiyar abu "Tantanin halitta mai kariya" kuma danna OK.
3. Yanzu danna tantanin halitta inda aka saka hoton. Bayan haka, kuma ta hanyar menu na mahallin, je zuwa tsarin sa, sannan ku je shafin "Kariya". Duba akwatin kusa da zaɓi "Tantanin halitta mai kariya" kuma danna OK.lura: idan hoton da aka saka a cikin tantanin halitta ya mamaye shi gaba daya, sannan danna shi tare da maballin linzamin kwamfuta zai kira kaddarorin da saitunan hoton da kansa. Don haka, don zuwa tantanin halitta mai hoto (zaɓi), yana da kyau a danna kowane tantanin halitta kusa da shi, sannan, ta amfani da maɓallan kewayawa na maballin (sama, ƙasa, dama, hagu). je wurin da ake bukata. Hakanan, don kiran menu na mahallin, zaku iya amfani da maɓalli na musamman akan madannai, wanda ke gefen hagu na Ctrl.
4. Canja zuwa shafin "Bita"inda danna maballin "Takardar Kariya" (lokacin da aka matsa girman taga, dole ne ka fara danna maɓallin "Kariya", bayan haka abin da ake so zai bayyana a cikin jerin zaɓuka).
5. Wani ƙaramin taga zai bayyana inda za mu iya saita kalmar sirri don kare takardar da jerin ayyukan da masu amfani za su iya yi. Danna lokacin da aka shirya OK.
6. A cikin taga na gaba, tabbatar da kalmar sirri da aka shigar kuma danna OKAYA.
7. Sakamakon ayyukan da aka yi, tantanin halitta wanda hoton yake ciki za a kiyaye shi daga kowane canje-canje, gami da. cirewa.A lokaci guda, sauran sel na takardar suna zama masu iya daidaitawa, kuma matakin 'yancin yin aiki dangane da su ya dogara da abubuwan da muka zaɓa lokacin da aka kunna kariyar takardar.

Saka hoto a cikin sharhin tantanin halitta

Baya ga saka hoto a cikin tantanin halitta, zaku iya ƙara shi zuwa bayanin kula. Yadda ake yin haka an bayyana a ƙasa:

1. Danna dama akan tantanin halitta inda kake son saka hoton. A cikin jerin zaɓuka, zaɓi umarnin "Saka bayanin kula".
2. Ƙananan yanki don shigar da rubutu zai bayyana. Juyar da siginan kwamfuta akan iyakar yankin bayanin kula, danna-dama akansa kuma a cikin jerin da ya buɗe, danna abun. "Format Note".
3. Tagan saitunan bayanin kula zai bayyana akan allon. Canja zuwa shafin "Launuka da Layuka". A cikin zaɓuɓɓukan cikewa, danna kan launi na yanzu. Za a buɗe jerin abubuwan da za mu zaɓi abu a ciki "Hanyoyin Cika".
4. A cikin taga hanyoyin cikewa, canza zuwa shafin "Hoto", inda muke danna maballin da sunan daya.
5. Wani taga saka hoto zai bayyana, wanda a ciki zamu zaɓi zaɓi "Daga fayil".
6. Bayan haka, za a buɗe taga zaɓin hoto, wanda muka riga muka ci karo da shi a farkon labarinmu. Jeka babban fayil ɗin da ke ɗauke da fayil ɗin tare da hoton da ake so, sannan danna maɓallin "Saka".
7. Shirin zai dawo da mu zuwa taga da ta gabata don zaɓar hanyoyin cikewa tare da ƙirar da aka zaɓa. Duba akwatin don zaɓi "Kiyaye girman hoton", sannan danna OK.
8. Bayan haka, za mu sami kanmu a cikin babban taga tsarin bayanin kula, inda muka canza zuwa shafin "Kariya". Anan, cire alamar akwatin kusa da abun "Abin da aka Kare".
9. Na gaba, je zuwa shafin "Abubuwa". Zaɓi zaɓi "Matsar da canza abu tare da sel". An yi duk saitunan, don haka zaka iya danna maɓallin OK.
10. Sakamakon ayyukan da aka yi, mun gudanar ba kawai don saka hoto a matsayin bayanin kula ga tantanin halitta ba, har ma don haɗa shi zuwa tantanin halitta.
11. Idan ana so, ana iya ɓoye bayanin kula. A wannan yanayin, za a nuna shi kawai lokacin da kake shawagi akan tantanin halitta. Don yin wannan, danna-dama akan tantanin halitta tare da bayanin kula kuma zaɓi abu a cikin menu na mahallin "Boye bayanin kula".Idan ya cancanta, ana haɗa bayanin kula a baya ta hanya ɗaya.

Saka hoto a yanayin mai haɓakawa

Hakanan Excel yana ba da ikon saka hoto a cikin tantanin halitta ta hanyar abin da ake kira Developer Mode. Amma da farko kuna buƙatar kunna shi, tunda ba a kashe shi ta tsohuwa.

1. Je zuwa menu "Fayil", inda muka danna abu "Parameters".
2. Za a buɗe taga na sigogi, inda a cikin jerin a hagu danna kan sashin "Kwasta Ribbon". Bayan haka, a cikin ɓangaren dama na taga a cikin saitunan kintinkiri, mun sami layin "Developer", duba akwatin kusa da shi kuma danna OK.
3. Muna tsaye a cikin tantanin halitta inda muke son saka hoton, sannan mu je shafin "Developer". A cikin sashin kayan aiki "Masu sarrafawa" nemo maballin "Saka" kuma danna shi. A cikin jerin da ke buɗewa, danna gunkin "Hoto" cikin rukuni "Ayyukan sarrafawa".
4. Siginan kwamfuta zai canza zuwa giciye. Tare da maɓallin linzamin kwamfuta na hagu, zaɓi yankin don hoton nan gaba. Idan ya cancanta, ana iya daidaita girman wannan yanki ko kuma a iya canza wurin da aka samu rectangle (square) don dacewa da shi a cikin tantanin halitta.
5. Danna dama akan adadi da aka samu. A cikin jerin jerin umarni, zaɓi "Abubuwa".
6. Za mu ga taga tare da kaddarorin kashi:
   • a cikin ƙimar siga "Sanyawa" nuna lambar "1" (ƙimar farko - "2").
   • a cikin filin don shigar da ƙima a gaban siga "Hoto" danna maɓallin tare da dige guda uku.
7. Tagan loda hoto zai bayyana. Mun zaɓi fayil ɗin da ake so anan kuma buɗe shi ta danna maɓallin da ya dace (an ba da shawarar zaɓar nau'in fayil ɗin "Duk Fayiloli", domin in ba haka ba, ba za a iya ganin wasu kari a cikin wannan taga).
8. Kamar yadda kake gani, an saka hoton a kan takardar, duk da haka, kawai wani ɓangare na shi yana nunawa, don haka ana buƙatar daidaita girman girman. Don yin wannan, danna gunkin a cikin nau'in ƙaramin triangle ƙasa a cikin filin ƙimar siga "Yanayin Hotuna".
9. A cikin jerin zaɓuka, zaɓi zaɓi mai lamba "1" a farkon.
10. Yanzu duk hoton ya dace a cikin yankin rectangular, don haka ana iya rufe saitunan.
11. Ya rage kawai don ɗaure hoton zuwa tantanin halitta. Don yin wannan, je zuwa shafin "Tsarin shafi", inda muke danna maballin "Yi oda". A cikin jerin zaɓuka, zaɓi abu "daidaita", sannan - "Snap zuwa Grid".
12. Anyi, hoton yana haɗe zuwa tantanin halitta da aka zaɓa. Bugu da ƙari, yanzu iyakokinsa za su "manne" kan iyakokin tantanin halitta idan muka matsar da hoton ko canza girmansa.
13. Wannan zai ba ka damar daidaita hoton daidai a cikin tantanin halitta ba tare da ƙoƙari mai yawa ba.

Kammalawa

Don haka, akwai hanyoyi da yawa waɗanda zaku iya saka hoto a cikin tantanin halitta akan takardar Excel. Hanya mafi sauƙi ita ce amfani da kayan aikin da ke cikin shafin Sakawa, don haka ba abin mamaki ba ne cewa wannan ita ce hanya mafi shahara tsakanin masu amfani. Bugu da ƙari, yana yiwuwa a saka hotuna azaman bayanan salula ko ƙara hotuna zuwa takarda ta amfani da Yanayin Haɓakawa na musamman.