Saka hoto a Microsoft Excel

Wasu ayyukan da aka yi a alluna suna buƙatar shigarwa daban-daban hotuna ko hotuna. Excel yana da kayan aikin da zasu baka damar aiwatar da manna irin wannan. Bari mu tsara yadda za ayi.

Siffofin don saka hotuna

Don shigar da hoto a cikin tebur na Excel, dole ne a fara saukar da shi zuwa rumbun kwamfutar ko kuma mitar haɗin da aka haɗa da ita. Muhimmin fasalin fasalin hoton shine cewa ta hanyar tsoho ba'a haɗe shi da takamaiman sel ba, amma kawai sanya shi a cikin yankin da aka zaɓa na takarda.

Darasi: Yadda ake saka hoto a cikin Microsoft Word

Sanya hoto a kan takardar

Da farko mun gano yadda ake saka hoto a kan takarda, sannan kawai zamu gane yadda zamu haɗa hoto wurin takamaiman sel.

1. Zaɓi wayar inda kake son saka hoton. Je zuwa shafin Saka bayanai. Latsa maballin "Zane"wanda yake a cikin shinge na saiti "Misalai".



2. Wurin saka hoton yana buɗewa. Ta hanyar tsoho, koyaushe yana buɗewa a babban fayil "Hotunan". Sabili da haka, da farko zaka iya canja wurin hoton da zaku saka a ciki. Kuma zaka iya yin hakan ta wata hanyar: ta hanyar dubawa ta wannan taga je zuwa duk wasu kundin adireshin kwamfyuta na PC ko mai amfani da shi ta hanyar sadarwa. Bayan kun zabi zabi hoto wanda zaku kara wa Excel, danna maɓallin Manna.

Bayan wannan, an saka hoton a takardar. Amma, kamar yadda aka ambata a baya, kawai ya ta'allaka ne akan takardar kuma ba a haɗe shi da kowace tantanin halitta.

Gyara hoto

Yanzu kuna buƙatar shirya hoton, ba shi ƙirar da ya dace da girma.

1. Mun danna hoton tare da maɓallin linzamin kwamfuta na dama. Zaɓuɓɓukan hoto ana buɗe ta hanyar menu. Danna kan kayan "Girman da kaddarorin".



2. Ana buɗe wata taga wacce akwai kayan aiki da yawa don canza kayan hoton. Anan zaka iya canza girmansa, launi, amfanin gona, ƙara sakamako da ƙari mai yawa. Dukkanta ya dogara ne akan takamaiman hoton da dalilan amfani dashi.



3. Amma a mafi yawan lokuta babu buƙatar buɗe taga "Girman girma da kaddarorin", tunda akwai isassun kayan aikin da aka miƙa akan tef a cikin ƙarin toshe na shafuka "Aiki tare da zane".



4. Idan muna son sanya hoto a cikin tantanin halitta, to mafi mahimmancin batun yayin gyara hoto yana canza girmansa saboda kar yayi girman girman sel da kansa. Kuna iya sake girmanwa ta hanyoyi masu zuwa:
   • ta cikin menu na mahallin;
   • panel a kan tef;
   • taga "Girman girma da kaddarorin";
   • ta jan iyakokin hoto tare da linzamin kwamfuta.

Halarci hoto

Amma, koda bayan hoton ya zama ƙarami fiye da tantanin halitta kuma an sanya shi a ciki, har yanzu bai kasance cikin kulawa ba. Wannan shine, idan, alal misali, muke yin rarrabawa ko kuma wani nau'in yin odar bayanan, to sel za su canza wurare, hoton zai zauna a wuri guda a kan takardar. Amma, a cikin Excel, har yanzu akwai wasu hanyoyi don haɗa hoto. Bari mu bincika su gaba.

Hanyar 1: kariya ta takarda

Hanya guda don haɗa hoto shine don kare takardar daga canje-canje.

1. Mun daidaita girman hoton zuwa girman kwayar kuma saka shi a can, kamar yadda aka bayyana a sama.



2. Mun danna kan hoton kuma zaɓi abu a cikin menu na mahallin "Girman da kaddarorin".



3. Ana buɗe yanayin taga hoton yana buɗewa. A cikin shafin "Girman" mun tabbata cewa girman hoton ba ya girma da girman sel. Hakanan muna bincika akasin waɗannan alamun "Game da Girman Asali" da "Rike rabon al'amari" akwai alamun bincike. Idan wasu sigogi ba su dace da bayanin da ke sama ba, to, canza shi.



4. Je zuwa shafin "Bayanai" na wannan taga. Duba kwalaye sabanin sigogin "Kayan da aka kiyaye" da "Buga abu"idan ba a shigar dasu ba. Mun sanya canjin a cikin toshe saitunan "Kafa abun abu a bango" a matsayi "Matsar da gyara abu tare da sel". Lokacin da aka gama duk saitirorin da aka ƙayyade, danna maɓallin Rufelocated a cikin ƙananan kusurwar dama na taga.



5. Zaɓi duka takardun ta latsa maɓallin keɓaɓɓiyar maɓalli Ctrl + A, kuma tafi cikin menu na mahallin zuwa taga tsarin saitin tantanin halitta.



6. A cikin shafin "Kariya" taga da ke buɗe, buɗe akwati "Kariyar kariya" kuma danna maballin "Ok".



7. Zaɓi tantanin inda hoton yake, wanda ke buƙatar gyarawa. Bude taga taga kuma a cikin shafin "Kariya" duba akwatin kusa da darajar "Kariyar kariya". Latsa maballin "Ok".



8. A cikin shafin "Duba" a cikin akwatin kayan aiki "Canza" a kan kintinkiri, danna maballin Kare Sheet.



9. Wani taga yana buɗewa wanda muke shigar da kalmar sirri da ake so don kare takardar. Latsa maballin "Ok", kuma a taga na gaba wanda zai buɗe, sake maimaita kalmar wucewa.

Bayan waɗannan ayyuka, layin dake cikin hotunan ana samun kariya daga canje-canje, wato, hotunan suna haɗe da su. Ba za a iya yin canje-canje a cikin waɗannan ƙwayoyin ba har sai an cire kariyar. A cikin sauran layin takardar, kamar baya, zaku iya yin kowane canje-canje kuma adana su. A lokaci guda, yanzu koda kun yanke shawarar warware bayanan, hoton ba zai shiga ko'ina daga cikin tantanin da yake ciki ba.

Darasi: Yadda za a kare kwayar halitta daga canje-canje a cikin Excel

Hanyar 2: saka hoto a cikin bayanin kula

Hakanan zaka iya ɗaukar hoto ta hanyar wucewa zuwa bayanin kula.

1. Mun danna kan tantanin da muke shirin saka hoton tare da maɓallin linzamin kwamfuta na dama. A cikin mahallin menu, zaɓi Saka bayanai.



2. Windowara karamin taga yana buɗe don bayanan rakodin. Muna matsa siginar daga kan iyaka kuma danna shi. Wani menu na mahallin ya bayyana. Zaɓi abu a ciki "Tsarin bayanin kula".



3. A cikin taga taga don saita tsarin bayanin kula, je zuwa shafin "Launuka da layi". A cikin toshe saitin "Cika" danna filin "Launi". A lissafin da yake buɗe, je zuwa rakodin "Hanyoyi don cika ...".



4. Hanyar cike take tana buɗe. Je zuwa shafin "Zane", sannan danna kan maɓallin tare da sunan iri ɗaya.



5. Addara hoton taga yana buɗewa, daidai yake kamar yadda aka bayyana a sama. Zaɓi hoto kuma danna maɓallin Manna.



6. An kara hoton a taga "Hanyoyi don cika". Duba akwatin kusa da abun "Kula da rabon fannin". Latsa maballin "Ok".



7. Bayan wannan mun koma zuwa taga "Tsarin bayanin kula". Je zuwa shafin "Kariya". Cire zaɓi "Kayan da aka kiyaye".



8. Je zuwa shafin "Bayanai". Saita canji zuwa wuri "Matsar da gyara abu tare da sel". Bayan wannan, danna maballin "Ok".

Bayan aiwatar da duk ayyukan da ke sama, hoton ba kawai za a shigar da shi cikin bayanin kwayar ba, har ma a haɗe da shi. Tabbas, wannan hanyar ba ta dace da kowa ba, tunda shigarwar a cikin bayanin kula yana sanya wasu ƙuntatawa.

Hanyar 3: Yanayin Haɓaka

Hakanan zaka iya haɗa hotuna zuwa sel ta yanayin mai haɓaka. Matsalar ita ce ta hanyar tsoho ba a kunna yanayin mai haɓaka ba. Don haka, da farko, muna buƙatar kunna shi.

1. Kasancewa a cikin shafin Fayiloli je zuwa sashen "Zaɓuɓɓuka".



2. A cikin zaɓuɓɓukan window, matsa zuwa sashin Saitin Ribbon. Duba akwatin kusa da "Mai Haɓakawa" a gefen dama ta taga. Latsa maballin "Ok".



3. Zaɓi tantanin da muke shirin saka hoton. Matsa zuwa shafin "Mai Haɓakawa". Ta bayyana bayan mun kunna yanayin daidaitawa. Latsa maballin Manna. A cikin menu wanda yake buɗewa, a cikin toshe Gudanar da ActiveX zaɓi abu "Hoto".



4. Abubuwan ActiveX yana bayyana azaman quad. Daidaita girmansa ta hanyar jan iyakokin kuma sanya shi cikin tantanin da ka shirya sanya hoton. Danna-dama akan wani kashi. A cikin mahallin menu, zaɓi "Bayanai".



5. Taga abun yana buɗewa. M misali "Jeri" saita adadi "1" (ta tsohuwa "2") A cikin layin sigogi "Hoto" danna maɓallin da ke nuna ellipsis.



6. Hoton shigar da hoton yana buɗewa. Muna neman hoton da ake so, zaɓi shi kuma danna maballin "Bude".



7. Bayan haka, zaku iya rufe taga kayan. Kamar yadda kake gani, an riga an saka hoton. Yanzu muna buƙatar ɗaukar shi cikakke a cikin tantanin halitta. Zaɓi hoto kuma je zuwa shafin Tsarin shafin. A cikin toshe saitin Tace a kan tef danna kan maɓallin A daidaita. Daga zaɓin-ƙasa, zaɓi Matsa zuwa Grid. Sannan mun dan motsa kadan daga gefen hoton.

Bayan aiwatar da matakan da ke sama, za a haɗe hoton a cikin grid da tantanin da aka zaɓa.

Kamar yadda kake gani, a cikin shirin Excel akwai hanyoyi da yawa don shigar da hoto a cikin sel kuma a haɗe shi. Tabbas, hanyar tare da saka a cikin bayanin kula bai dace da duk masu amfani ba. Amma sauran zaɓuɓɓuka guda biyu suna da sararin samaniya kuma kowane mutum dole ne ya yanke shawara wanne ne ya fi dacewa da shi kuma ya cika maƙasudin shigarwar gwargwadon damarwa.