Yadda ake haɗa hoto zuwa tantanin halitta a cikin maƙunsar bayanai na Excel

Lokacin tattara tebur a cikin Excel, sau da yawa ya zama dole a sanya hoto a cikin tantanin halitta. Akwai hanyoyi gama gari da yawa don cim ma aikin da ke hannu. Za a tattauna manyan su a wannan talifin.

Siffofin haɗa hotuna

Kafin buga hotuna a cikin Excel, yana da mahimmanci a yi nazarin fasali da yawa na hanyar:

1. Hoton da mai amfani ke son sakawa dole ne ya kasance a kan rumbun kwamfutarka ko mai cirewa wanda ke da alaƙa da PC.
2. Hoton da aka saka a cikin Excel ba za a haɗa shi nan da nan zuwa takamaiman tantanin halitta ba, amma zai kasance a kan takardar aiki.
3. Wasu hotuna na iya rasa inganci bayan an sanya su akan farantin.

Yadda ake saka hoto a cikin Excel

Da farko, kana buƙatar saka hoton da aka zaɓa a cikin filin aiki na shirin, sa'an nan kuma ɗaure shi zuwa wani takamaiman yanki na tebur. Da farko, kuna buƙatar yin abubuwa masu zuwa:

1. Yanke shawara akan hoto kuma sanya shi a ko'ina akan PC ɗin ku.
2. Bude Microsoft Office Excel.
3. Danna LMB akan sashin da kake son sanya hoton a ciki.
4. Je zuwa sashin "Saka" kuma danna kalmar "Hoto".

5. Ƙayyade hanyar zuwa wurin hoton da ke kan kwamfutar ta hanyar zaɓar ɓangaren diski mai dacewa a cikin taga wanda ya buɗe, sannan danna maɓallin "Saka".

6. Tabbatar cewa an saka hoton kuma ya mamaye wani yanki na filin aikin shirin.

Kula! A wannan mataki, hoton ba za a haɗa shi da wani takamaiman yanki na jeri na tebur ba.

Yadda ake gyara zane

Yanzu kuna buƙatar gyara hoton da aka saka a cikin Excel, kawo shi zuwa sigar "daidai". Kuna buƙatar yin aiki kamar haka:

1. Danna-dama a ko'ina akan hoton da aka saka a baya kuma a cikin menu na mahallin, danna kan layin "Size and Properties".
2. A cikin taga da ya bayyana, zaku iya canza sigogin hoto, shuka shi, amfani da tasiri daban-daban, da sauransu.

3. Rufe taga "Size da Properties" kuma danna kan rubutun "Aiki tare da hotuna" a saman kayan aiki na shirin.
4. Yanzu yana da mahimmanci don rage sigogin hoto don ya dace a cikin tantanin halitta da aka zaɓa na tsararrun tebur. Don wannan dalili, ana iya canza iyakokin hoto tare da LMB.

Yadda ake haɗa hoto zuwa tantanin halitta

Bayan an canza girman, hoton har yanzu ba za a haɗa shi da ɓangaren tsararrun tebur ba. Don gyara hoton, dole ne ku yi wasu ƙarin magudi. Na gaba, za mu yi la'akari da mafi yawan hanyoyin da za a haɗa hoto zuwa tantanin halitta a cikin Microsoft Office Excel.

Muhimmin! Kowace hanya tana dacewa da kowace sigar shirin.

Kariyar Sheet

Za a iya kiyaye takardar aiki a cikin Excel daga canje-canje, sannan za a gyara hoton a wani matsayi. Hanyar ita ce bi matakai masu sauƙi:

1. Matsar da hoton da aka gyara zuwa sashin tebur tare da LMB.

2. Danna-dama akan hoton kuma danna kan layin "Size and Properties".
3. A cikin "Size" menu, duba saitunan. Kimarsu kada ta wuce girman tantanin halitta. Hakanan kuna buƙatar duba akwatunan kusa da layin "Ku kiyaye daidaitattun daidaito" da "dangane da girman asali".

4. Shigar da "Properties" tab. Anan kuna buƙatar sanya maɓallin juyawa kusa da layin "Matsar da canza abu tare da sel." Kishiyar ma'aunin "Abubuwan Kariya" da "Buga abu", dole ne ku duba kwalayen.

5. Rufe taga, zaɓi duk filin aiki ta amfani da Ctrl + A hade na maɓalli kuma je zuwa sashin Tsarin Cell ta danna ko'ina akan takardar RMB.

6. A cikin sabuwar taga a cikin sashin “Kariya”, cire alamar akwatin “Telected cell”, sannan zaɓi tantanin halitta tare da hoton da aka ɗora sannan a sake duba wannan akwatin.

Ƙarin Bayani! Bayan aiwatar da irin wannan magudi, hoton za a gyara shi a cikin wani takamaiman yanki na tsararrun tebur kuma a kiyaye shi daga kowane canje-canje.

Saita hoto a cikin bayanin kula

Hoton da aka sanya a cikin bayanin kula na Excel za a liƙa shi ta atomatik zuwa tantanin halitta. Ana aiwatar da hanyar kamar haka:

1. Danna-dama akan abin da ake so kuma nuna zaɓin "Saka bayanin kula" a cikin menu.
2. A cikin taga rikodin bayanin kula, sake danna-dama kuma nuna layin "Tsarin Bayanan kula".

3. A cikin taga da ya bayyana, je zuwa sashin "Launuka da Layuka", sannan fadada shafin "Launi" kuma danna maballin "Hanyoyin Cika".

4. Wani taga zai buɗe wanda a ciki kuna buƙatar danna shafin ƙarshe a cikin jerin kayan aikin da ke saman kuma danna kalmar "Zane".

5. Ƙayyade hanyar zuwa wurin hoton akan PC kuma danna kalmar "Saka".

6. Yanzu za a ƙara hoton zuwa taga "Hanyoyin Cika". Dole ne mai amfani ya duba akwatin kusa da abin "Kiyaye girman hoton" kuma danna "Ok".

7. Koma zuwa taga "Tsarin bayanin kula" kuma a cikin sashin "Kariya", cire alamar "Abin da za a lura" layin.

8. A cikin wannan taga, matsa zuwa shafin "Properties" kuma sanya maɓallin kunnawa a cikin filin "Matsar da canza abu tare da sel", sannan danna "Ok".

Kula! Hanyar da aka yi la'akari tana ɗaure hoto zuwa bayanin takamaiman tantanin halitta, amma tana sanya ƙuntatawa da yawa akan ɓangaren tsararrun tebur.

Kammalawa

Don haka, zaku iya hanzarta gyara hotuna a cikin sel na Excel ta amfani da kayan aikin da aka gina a cikin shirin. Hanyoyin haɗe-haɗe da aka tattauna a sama za su taimaka wajen kauce wa matsaloli yayin yin aikin.