Yadda ake saka hoto a cikin maƙunsar bayanai na Excel. Saka da daidaita hoto a cikin Excel

Wasu ayyukan da aka yi a cikin maƙunsar bayanai na Excel suna buƙatar ƙarin zane-zane da hotuna iri-iri zuwa bayanan tabular. Shirin yana da kayan aiki da yawa waɗanda ke ba ku damar saka hoto. A cikin labarin, za mu bincika dalla-dalla hanyoyi da yawa don aiwatar da wannan hanya: ta hanyar kariyar takardar aiki, yanayin haɓakawa, da ƙara bayanin kula zuwa takaddar aiki.

Siffofin saka hotuna

Don ƙara hoto daidai a takardar aikin maƙunsar rubutu, hoton da kansa dole ne ya kasance a kan rumbun kwamfutarka ta PC ko a kan kafofin watsa labarai masu ciruwa da ke da alaƙa da shi.

Kula! Da farko, hoton da aka ƙara ba a ɗaure shi da takamaiman tantanin halitta ba, amma kawai yana cikin yanki mai alama na takaddar aikin.

Saka hoto akan takarda

Da farko, bari mu ayyana yadda hanyar shigar da hoto a cikin wurin aiki ke faruwa, sannan mu gano yadda ake ƙara hoto zuwa takamaiman tantanin halitta. Tafiya tayi kama da haka:

1. Muna yin zaɓi na tantanin halitta wanda muke shirin sanya hoton a ciki. Mun matsa zuwa sashin da ake kira "Saka", wanda yake a saman maƙunsar bayanai. Mun sami toshe na umarni "Misali" kuma a ciki muna danna kashi "Hoto".

2. Taga mai taken “Saka Hoto” yana bayyana akan allon. Ta hanyar tsoho, koyaushe yana bayyana a babban fayil ɗin Hotuna. Yana yiwuwa a canja wurin a gaba zuwa wannan babban fayil ɗin hoton da muke shirin sakawa a kan maƙunsar aikin. Wani zaɓin shine ka kasance a cikin taga ɗaya kuma je zuwa wani babban fayil akan faifan kwamfuta na sirri ko kuma haɗin yanar gizo mai cirewa. Bayan kammala duk magudi, ta hanyar zaɓar hoto, danna maɓallin "Saka".

3. Shirya! Hoton da ake so ya bayyana akan takardar aikin maƙunsar. Ya kamata a lura cewa hoton a halin yanzu ba a haɗe zuwa kowane tantanin halitta na takarda ba. Za mu yi magana game da tsarin dauri kadan daga baya.

Shirya hoto

Bari mu yi magana game da yadda za a canza hoton da aka saka don ya sami madaidaicin ma'auni waɗanda suka yi daidai da takardar aikin maƙunsar rubutu. Tafiya tayi kama da haka:

1. Mun danna hoton da aka saka RMB. Menu na mahallin yana bayyana akan allon, yana ba ku damar canza ma'aunin hoto ɗaya ko wata. Zaɓi kashi mai suna "Size and Properties".

2. Nunin yana nuna ƙaramin akwati da ake kira Tsarin Hoto. Anan akwai adadi mai yawa na sigogi masu canzawa waɗanda ke ba ku damar shirya abubuwan hoton. Saitunan asali: girman, tint, cropping, tasiri daban-daban, da sauransu. An ƙirƙiri babban adadin saituna domin mai amfani zai iya gyara hoton da aka saka don ayyuka iri-iri.

3. Idan babu buƙatar cikakken editan hoton da aka saka, to ba za mu buƙaci taga "Dimensions and Properties". Wani zaɓi don canza hoton shine zuwa ƙarin sashin "Aiki tare da Hotuna", wanda yake a saman maƙunsar bayanai.

4. Idan muna son saka hoto a cikin tantanin halitta, to muna bukatar mu gyara hoton ta yadda girmansa ya yi daidai da girman kwayar halitta. Ana yin gyaran girman girman ta hanyoyi masu zuwa: ta taga "Dimensions and Properties"; motsa iyakokin hoton tare da taimakon LMB; amfani da kayan aikin da ke kan kintinkiri, da kuma menu na mahallin.

Haɗe hoto

Bayan aiwatar da duk magudin da aka kwatanta a sama, hoton da aka saka a kowane hali ya kasance ba tare da haɗe da tantanin halitta ba. Misali, idan mai amfani ya jera bayanan akan takardar aikin, sel za su canza matsayinsu, amma hoton zai kasance a daidai wurin da aka saka shi. Maƙunsar bayanai yana da hanyoyi da yawa waɗanda ke ba ka damar haɗa hoto zuwa tantanin halitta da aka zaɓa a cikin takarda. Bari mu yi magana game da wannan dalla-dalla.

Hanyar 1: kariyar takarda

Kare takardar aiki daga gyare-gyare daban-daban shine ɗayan hanyoyin haɗa hoto zuwa tantanin halitta. Tafiya tayi kama da haka:

1. Muna aiwatar da daidaita girman hoton zuwa girman tantanin halitta kuma saka shi ta amfani da hanyoyin da aka bayyana a sama.

2. Danna hoton da aka saka. Ƙananan menu na mahallin yana bayyana. Danna kan "Size and Properties" kashi.

3. An nuna taga sanannen “Format Hoto” akan allon. Muna matsawa zuwa sashin "Size" kuma tabbatar da cewa girman hoton bai wuce girman tantanin halitta ba. Bugu da ƙari, tabbatar da cewa akwai ticks kusa da abubuwan "Ku kiyaye daidaiku" da "dangane da girman asali". Idan kowace dukiya ba ta dace da wacce aka kwatanta a sama ba, gyara ta.

4. A cikin wannan taga mun sami sashin "Properties" kuma matsa zuwa gare shi. Idan babu alamun bincike kusa da abubuwan "Buga abu" da "Abubuwan da aka kare", to dole ne a duba su. Mun sami kayan “Snap abu zuwa bango” kuma mun sanya alamar bincike kusa da rubutun “Matsar da canza abu tare da sel.” Bayan aiwatar da duk magudi, danna maɓallin "Rufe", wanda yake a ƙasan taga "Format Hoto".

5. Yin amfani da haɗin maɓalli akan maballin "Ctrl + A" muna yin zaɓin duk takaddun aikin. Muna kiran menu na mahallin kuma danna maɓallin "Format Cells ...".

6. Wani taga mai suna "Format Cells" ya bayyana akan allon. Je zuwa sashin "Kariya" kuma cire alamar "Kariyar Tantanin halitta". Bayan aiwatar da duk magudi, danna maɓallin "Ok" wanda yake a ƙasan taga.

7. Yanzu muna yin zaɓi na tantanin halitta wanda hoton da aka saka yake, wanda muke shirin haɗawa. A cikin hanyar da ke sama, muna sake zuwa taga "Format Cells" ta amfani da menu na mahallin. Har yanzu, muna matsawa zuwa sashin "Kariya" kuma wannan lokacin sanya alamar bincike kusa da kadarar "Kariyar Tantanin halitta". Bayan aiwatar da duk manipulations, danna kan "Ok".

8. Je zuwa sashin "Review", wanda yake a saman maƙunsar bayanai. Mun sami toshe da ake kira "Changes" kuma danna kan "Kare Sheet" kashi.

9. An nuna taga mai suna "Takarda Kare" akan allon. A cikin filin “Password to disable sheet protection”, shigar da kalmar wucewa. Muna danna maɓallin "Ok". Wani taga yana bayyana akan nunin da dole ne ka sake shigar da kalmar wucewa.

10. Shirya! Mun kare tantanin halitta tare da hoton da aka saka daga kowane canje-canje. A wasu kalmomi, hoton yana haɗe zuwa tantanin halitta.

Har sai an kashe kariyar, ba zai yiwu a yi kowane canje-canje a cikin tantanin halitta mai kariya na takardar aikin ba. Ko da mun tsara bayanan, hoton da aka saka zai kasance a cikin tantanin halitta.

Hanyar 2: Saka hoto a cikin bayanin kula

Yin amfani da bayanin kula, kuna iya danganta hoton. Tafiya tayi kama da haka:

1. Danna-dama akan tantanin halitta da muke son saka hoton a ciki. An buɗe ƙaramin menu na mahallin mahallin. Danna kan abin da ake kira "Saka bayanin kula".

2. An nuna ƙaramin taga akan allon, yana ba ku damar rubuta rubutu. Matsar da mai nuni zuwa firam ɗin taga kuma danna kan shi. Ana nuna sabon menu na mahallin akan allon. Danna kan "Note Format" kashi.

3. Wani sabon taga ya bayyana akan nunin, wanda aka tsara don saita bayanan kula. Matsa zuwa sashin "Launuka da Layuka". Mun sami dukiyar "Cika" kuma buɗe jerin inuwa a cikin sashin "Launi". A cikin jerin abubuwan da aka saukar, danna kan rubutun "Cika hanyoyin…".

4. Ana nuna taga inda zaku iya zaɓar hanyar cikewa. Mun matsa zuwa sashin "Hoto", sa'an nan kuma danna kan "Hotuna ..." kashi.

5. An buɗe taga "Saka Hoto", wanda muka saba da mu ta hanyoyin da aka bayyana a sama. Muna yin zaɓi na zane. Bayan aiwatar da duk magudi, danna maɓallin "Saka", wanda yake a ƙasan taga "Saka Hoto".

6. Hoton da aka zaɓa yana nunawa a cikin taga "Hanyoyin Cika". Saka alamar bincike kusa da rubutun "Kiyaye girman hoton." Bayan kammala duk matakai, danna kan "Ok".

7. Mun koma zuwa "Note Format" taga. Mun matsa zuwa sashin "Kariya". Cire alamar bincike kusa da rubutun "Abu mai kariya".

8. Mun matsa zuwa sashin "Properties". A cikin toshe "Snap abu zuwa bango", duba akwatin kusa da sashin "Matsar da canza abu da sel". Bayan aiwatar da duk manipulations, danna kan "Ok".

9. Shirya! Bayan mun aiwatar da duk hanyoyin da aka bayyana a sama, ba a ƙara hoton kawai a cikin bayanin kula ba, har ma a haɗe zuwa tantanin halitta. Tabbas, wannan hanyar ba ta dace da cikakken duk ayyukan da aka warware ta amfani da na'ura mai ba da labari ba, tunda tana da wasu iyakoki.

Hanyar 3: Yanayin Haɓakawa

Kuna iya ɗaure hoto zuwa tantanin halitta ta amfani da yanayin “Mai Haihuwa” na musamman da aka haɗa cikin na'ura mai ɗaukar hoto. Babban wahala shine yanayin yana cikin yanayin kashewa. Bari mu fara kunna shi. Koyarwar mataki-mataki tayi kama da haka:

1. Je zuwa sashin "Fayil", sannan zaɓi abu "Zaɓuɓɓuka".

2. A cikin taga da ya bayyana, je zuwa sashin "Ribbon Add-In". Mun sanya alama kusa da rubutun "Developer". Bayan aiwatar da duk manipulations, danna "Ok".

3. Muna yin zaɓi na yankin da muke son saka hoton a ciki. Je zuwa sashin "Developer" wanda ke bayyana a saman maƙunsar bayanai. A cikin sashin "Add-ons", danna "Saka". A cikin jerin abubuwan da aka saukar, danna gunkin "Hoto", wanda yake a cikin sashin "ActiveX Controls".

4. Tantanin halitta yana nuna ƙarami, nau'in rectangle mara komai. Muna gyara ma'auni domin adadi ya dace a cikin tantanin halitta da aka zaɓa. Ana aiwatar da gyara ta hanyar motsa iyakoki tare da taimakon LMB. Danna-dama akan siffar. Wani ƙaramin menu na mahallin yana buɗewa, wanda muke danna "Properties".

5. Tagan kaddarorin yana bayyana akan allon. Kusa da rubutun "Wurin" mun sanya raka'a. A cikin layin "Hoto" muna samun gunkin a cikin nau'i na dige guda uku kuma danna shi tare da maɓallin linzamin kwamfuta na hagu.

6. Tagan Ƙara Hoton yana bayyana. Mun sami hoton da muke son sakawa. Zaži shi, sa'an nan kuma danna kan "Bude" button located a kasan taga.

7. Lokacin da aka kammala duk hanyoyin, rufe taga kaddarorin. Ana saka hoton da ake so a cikin tantanin halitta. Na gaba, kuna buƙatar aiwatar da tsarin haɗa hoton zuwa tantanin halitta. Muna aiwatar da zaɓin hoto akan filin aiki kuma matsa zuwa sashin "Layout Page", wanda yake a saman maƙunsar bayanai. Nemo toshe "Shirya" kuma zaɓi abin "daidaita". A cikin jerin da ke buɗewa, danna kan "Snap to Grid" kuma dan kadan matsar da shi a waje da iyakar hoton.

8. Shirya! Bayan aiwatar da hanyar da ke sama, mun ɗaure hoton zuwa tantanin halitta.

Kammalawa

A cikin ma'auni na Excel, akwai hanyoyi da yawa don saka hoto da kuma haɗa shi zuwa tantanin halitta, amma ba kowace hanya ce ta dace da magance duk matsalolin ba. Misali, hanyar tushen bayanin kula tana da kunkuntar hankali, yayin da Yanayin Haɓakawa da Sheet Kare su ne zaɓi na gama-gari waɗanda suka dace da duk masu amfani.