Wasu ayyuka da aka yi a cikin Tables suna buƙatar shigarwa da wasu hotuna ko hotuna a cikinsu. Excel yana da kayan aikin da zai ba ka damar yin irin wannan saka. Bari mu kwatanta yadda ake yin hakan.
Hanyoyin Sanya Hotuna
Don saka hoto a cikin tebur ɗin na Excel, dole ne a fara sauke shi zuwa rumbun kwamfutarka ko maɓallin da aka cire wanda ya haɗa shi. Wani muhimmin mahimmanci na saka hoto shi ne cewa ta hanyar tsoho ba a haɗa shi da wani ƙira ba, amma an sanya shi a cikin wani yanki ne kawai na takardar.
Darasi: Yadda za a saka hoto a cikin Microsoft Word
Saka hoto akan takardar
Da farko, zamu gano yadda za a saka hoton a kan takarda, sa'an nan kuma zamu gano yadda za a haɗa hoto zuwa wani ƙwayar salula.
- Zaɓi tantanin halitta inda kake son sa hoton. Jeka shafin "Saka". Danna maballin "Zane"wanda aka samo a cikin saitunan saiti "Hotuna".
- Rufin hoto ya buɗe. By tsoho, yana buɗewa a cikin babban fayil. "Hotuna". Sabili da haka, zaka iya canja wuri zuwa gare shi hoton da za a saka. Kuma zaka iya yin shi ta wata hanya: ta hanyar dubawa ta wannan taga, je zuwa kowane ɗakin waya na rumbun kwamfutar na PC ko ta hanyar sadarwa. Bayan ka yi zaɓi na hoto da za ka ƙara zuwa Excel, danna maballin Manna.
Bayan haka, an saka hoto akan takardar. Amma, kamar yadda aka ambata a baya, kawai ya ta'allaka ne akan takardar kuma ba a haɗa shi da kusan kowane tantanin halitta ba.
Shirya hoto
Yanzu kana buƙatar gyara hoton, ba shi da siffar da ya dace.
- Danna hoto tare da maɓallin linzamin linzamin dama. Ana buɗe sigogin zane a cikin menu mahallin. Danna abu "Girma da kaddarorin".
- Gila yana buɗewa inda akwai kayan aiki masu yawa don canza alamun hoton. A nan za ku iya canja girmanta, launi, datsa, ƙara haɓaka kuma kuyi yawa. Duk duk ya dogara ne da siffar ta musamman da kuma dalilin da ake amfani dashi.
- Amma a mafi yawan lokuta babu buƙatar bude taga. "Dimensions da kaddarorin", kamar yadda akwai kayan aikin da aka ba su akan rubutun a cikin ƙarin akwati na shafuka "Yin aiki tare da Hotuna".
- Idan muna son saka hoto a cikin tantanin halitta, to, mahimmin mahimmanci lokacin gyara hoto shine canza girmansa don kada su fi girman girman tantanin halitta. Zaka iya sake karuwa a cikin hanyoyi masu zuwa:
- ta hanyar mahallin mahallin;
- panel a kan tef;
- taga "Dimensions da kaddarorin";
- jawo iyakoki na hoto tare da linzamin kwamfuta.
Hada hotuna
Amma, ko da bayan bayanan ya zama karami fiye da tantanin salula kuma an sanya shi a cikinta, har yanzu bai kasance ba. Wato, idan muka, alal misali, yin gyare-gyare ko wani nau'i na yin amfani da bayanai, kwayoyin za su canza wurare, kuma zane zai kasance a wuri guda a kan takardar. Amma, a Excel, akwai sauran hanyoyi don haɗa hoto. Yi la'akari da su kara.
Hanyar 1: kariya ta takardar
Ɗaya daga cikin hanyar da za a haɗa hoto shi ne don kare takardar da canje-canje.
- Daidaita girman girman hoto zuwa girman tantanin halitta kuma saka shi a can, kamar yadda aka bayyana a sama.
- Danna kan hoton kuma zaɓi abu a cikin menu mahallin "Girma da kaddarorin".
- Maɓallin kaddarorin hoto yana buɗewa. A cikin shafin "Girman" Tabbatar cewa girman hoton bai fi girman girman tantanin halitta ba. Har ila yau bincika ga wasu alamomi "Aboki ga girman asali" kuma "Ajiye rabbai" Akwai tikiti. Idan kowane saitin bai dace da bayanin da aka sama ba, to, canza shi.
- Jeka shafin "Properties" wannan taga. Sa akwati a gaban sigogi "Abu mai kariya" kuma "Rubutun abu"idan ba a shigar su ba. Sanya sauyawa a cikin saituna "Riƙe wani abu zuwa bango" a matsayi "Matsar da shirya wani abu tare da kwayoyin". Lokacin da aka sanya duk saitunan da aka ƙayyade, danna maballin. "Kusa"located a cikin kusurwar dama kusurwar ta taga.
- Zaɓi duk takardar ta latsa maɓallan gajeren hanya Ctrl + A, kuma tafi ta cikin mahallin mahallin a cikin tsarin saitunan tsarin salula.
- A cikin shafin "Kariya" bude taga cire rajistan daga saitin "Kwayar karewa" kuma danna maballin "Ok".
- Zaɓi tantanin halitta inda za'a saita hotunan. Bude taga a shafin "Kariya" kara da darajar "Kwayar karewa". Danna maballin "Ok".
- A cikin shafin "Binciken" a cikin asalin kayan aiki "Canje-canje" a kan tef danna maballin "Kayan Shafin".
- Ginin yana buɗewa inda muke shigar da kalmar sirri da ake so don kare takardar. Muna danna maɓallin "Ok", kuma a cikin taga mai zuwa wanda ya buɗe, muna maimaita kalmar shiga ta sake.
Bayan wadannan ayyukan, ana kare kundin da aka samo hotunan daga canje-canje, wato, hotunan suna ɗaure su. Babu canje-canje a cikin wadannan kwayoyin har sai an cire kariya. A wasu jeri na takardar, kamar yadda dā, zaka iya yin canje-canje da ajiye su. A lokaci guda, yanzu ko da idan ka yanke shawara don warware bayanai, hoto ba ya zuwa ko'ina tare da tantanin halitta wanda aka samo shi.
Darasi: Yadda za a kare cell daga canje-canje a Excel
Hanyar 2: saka hoto a cikin bayanin kula
Hakanan zaka iya hašawa hoto ta hanyar saka shi a cikin bayanin kula.
- Mun danna kan tantanin halitta wanda muke shirya don saka hoton, tare da maɓallin linzamin linzamin dama. A cikin mahallin menu, zaɓi abu "Saka bayanai".
- Ƙananan taga yana buɗe, an tsara shi don rikodin bayanan. Matsar da siginan kwamfuta zuwa iyakarta kuma danna kan shi. Wani menu na mahallin ya bayyana. Zaɓi abu a ciki "Tsarin rubutu".
- A cikin bayanin bude bayanan, je zuwa shafin "Launuka da Lines". A cikin akwatin saitunan "Cika" danna kan filin "Launi". A cikin jerin da ya buɗe, ci gaba da ganawa. "Hanyar cikawa ...".
- Yanayin yanayin cika ya buɗe. Jeka shafin "Zane"sa'an nan kuma danna maballin tare da wannan suna.
- Ƙarin maɓallin ƙara ya buɗe, daidai daidai kamar yadda aka bayyana a sama. Zaɓi hoto kuma danna maballin Manna.
- Hoton da aka kara zuwa taga "Hanyar cika". Sanya alamar a gaban abu "Ku riƙe yawan girman hoto". Muna danna maɓallin "Ok".
- Bayan haka, za mu koma taga "Tsarin rubutu". Jeka shafin "Kariya". Cire rajistan daga saitin "Abu mai kariya".
- Jeka shafin "Properties". Saita canza zuwa matsayi "Matsar da shirya wani abu tare da kwayoyin". Bayan haka, danna maballin "Ok".
Bayan yin duk ayyukan da aka sama, ba za a saka hotunan kawai ba cikin bayanin kula da tantanin halitta, amma har ma ya danganta shi. Hakika, wannan hanya ba dace da kowa ba, kamar yadda sakawa cikin bayanin kula ya sanya wasu ƙuntatawa.
Hanyar 3: Developer Mode
Hakanan zaka iya hašawa hotuna zuwa tantanin halitta ta hanyar yanayin mai dasu. Matsalar ita ce ta hanyar tsoho ba'a kunna yanayin haɓaka ba. Don haka, da farko, muna bukatar mu taimaka.
- Da yake cikin shafin "Fayil" je yankin "Zabuka".
- A cikin sigogi na sigogi, motsa zuwa sashi Ribbon Saita. Saita alamar kusa da abu "Developer" a gefen dama na taga. Muna danna maɓallin "Ok".
- Zaɓi tantanin halitta wanda muke shirya don saka hoton. Matsa zuwa shafin "Developer". Ya bayyana bayan mun kunna yanayin da ya dace. Danna maballin Manna. A cikin menu wanda ya buɗe a cikin toshe "Ayyukan ActiveX" zabi abu "Hoton".
- Mai sarrafa ActiveX ya bayyana a matsayin ma'auni mara kyau. Daidaita girmanta ta jawo iyakoki da sanya shi a cikin tantanin halitta inda kake shirin shirya hoton. Muna danna maɓallin linzamin maɓallin dama a kan kashi. A cikin mahallin menu, zaɓi abu "Properties".
- Maɓallin mallaki abu ya buɗe. Matsayyar saɓani "Sanya" saita lambar "1" (ta tsoho "2"). A cikin sautin layi "Hoton" Danna maballin, wanda ya nuna dige.
- Rufin hoto ya buɗe. Muna neman hoton da ake so, zaɓi shi kuma danna maballin. "Bude".
- Bayan haka, za ka iya rufe fenin kaddarorin. Kamar yadda kake gani, an riga an saka hoto. Yanzu muna buƙatar ɗaukar shi sosai a tantanin halitta. Zaɓi hoton kuma je zuwa shafin "Layout Page". A cikin akwatin saitunan "A ware" a kan tef danna maballin "Daidaita". Daga menu mai sauke, zaɓi abu "Koma zuwa Grid". Sa'an nan kuma dan kadan ya motsa gefen hoton.
Bayan yin ayyuka na sama, hoton za a ɗaure shi zuwa grid da cell da aka zaɓa.
Kamar yadda kake gani, a cikin shirin na Excel akwai hanyoyi da yawa don saka hoto a cikin tantanin halitta kuma ɗaure shi zuwa gare shi. Hakika, hanyar da saka a cikin bayanin kula bai dace da duk masu amfani ba. Amma sauran nau'ukan biyu suna da mahimmanci kuma kowannensu ya yanke shawarar kansa wanda ya fi dacewa da shi kuma ya fi dacewa da nasarorin da aka sa a saka.
