Contents
Samar da matsala
Wajibi ne a tabbatar da cewa a cikin ɗayan sel na takardar akwai jerin zaɓuka tare da sunaye, lokacin da aka zaɓa daga abin da za a nuna samfurin kusa da shi azaman hoto:
Video
Mataki 1. Ƙirƙiri kundin adireshi tare da hoto kuma ba shi suna
Muna ƙirƙira akan Jerin 1 mu kasida ce mai dauke da sunaye da hotunan kaya, wanda ya kunshi ginshikai guda biyu (model и Photo):
Yanzu muna buƙatar ba da suna ga kundin adireshi domin mu koma gare shi a nan gaba. A cikin Excel 2003 da tsofaffi, don wannan muna zuwa menu Saka - Suna - Sanya (Saka - Suna - Ƙayyade), kuma a cikin Excel 2007 da sababbi - danna maɓallin Mai sarrafa suna tab dabarbari. Ƙirƙiri kewayon – shigar da suna (misali Photo Album) kuma saka dabarar azaman adireshin:
=СМЕЩ(Лист1!$A$1;1;0;СЧЁТЗ(Лист1!$A:$A)-1;1)
=OFFSET(Лист1!$A$1;1;0;COUNTA(Лист1!$A:$A)-1;1)
Wannan dabara tana ƙayyade tantanin halitta na ƙarshe a cikin shafi A kuma yana fitar da kewayon daga A2 zuwa wannan tantanin halitta da aka samo. Irin wannan ingantacciyar gini ana buƙatar don ƙara sabbin samfura zuwa jerin mu kuma kada muyi tunanin gyara kewayon. Idan ba lallai ne ka ƙara wani abu ba, to, maimakon shigar da wannan dabarar mai ban tsoro, kawai shigar = A2: A5.
Mataki 2. Jerin saukarwa don zaɓar samfuri
Muje zuwa Takardar 2 kuma ƙirƙirar tantanin halitta a wurin tare da jerin zaɓuka don mai amfani don zaɓar ƙirar waya (bari ya zama A1). Zaɓi cell kuma je zuwa menu Bayanai - Duba (Bayani - Tabbatarwa) ko a cikin sababbin sigogin Excel - akan shafin Bayanai - Tabbatar da Bayanai (Data - Tabbatar da Bayanai). Ci gaba a cikin filin Nau'in Bayanai (Ba da izini) zabi list, amma kamar yadda source nuna mana Photo Album (kada ku manta da ƙara alamar daidai a gabansa):
Bugu da ƙari, ya dace don ba wannan tantanin halitta suna - menu kuma Saka - Suna - Sanya sannan shigar da suna (misali zabi) da kuma OK.
Mataki 3: Kwafi Hoton
Bari mu matsar da hoton farko daga kundin hoto zuwa jerin abubuwan da aka saukar. Zaɓi tantanin halitta tare da hoton farko (ba hoton kanta ba, amma tantanin halitta!) Kuma
a cikin Excel 2003 kuma daga baya, riƙe Shift don buɗe menu Shirya. Abun da ba a iya gani a baya yakamata ya bayyana a wurin. Kwafi azaman Hoto:
A cikin Excel 2007 da sababbi, zaku iya kawai fadada zazzagewar da ke ƙasa da maɓallin Kwafi (Kwafi) on Gida tab:
A cikin Excel 2010, wani ƙarin taga zai bayyana tare da zaɓin nau'in hoton da za a ƙirƙira:
A ciki, kuna buƙatar zaɓar zaɓuɓɓukan "kamar yadda akan allo" da "raster".
Kwafi, je zuwa Takardar 2 zuwa jerin abubuwan da aka saukar kuma a cikin kowane tantanin halitta mara komai kusa da shi, saka ƙaramin hoton mu na tantanin halitta tare da hoto (menu) Gyara - Manna ko kuma na saba CTRL+V).
Mataki 4. Ƙirƙiri hanyar haɗi mai ƙarfi zuwa hoton da aka zaɓa
Yanzu kana buƙatar yin hanyar haɗi wanda zai nuna tantanin halitta tare da hoton da aka zaɓa. Buɗe menu Saka - Suna - Ƙayyade or Mai sarrafa suna tab dabarbari kuma ƙirƙirar wani kewayon mai suna:
Sunan hanyar haɗin yanar gizon mu, bari mu ce, zai kasance Photo, da dabara
=СМЕЩ(Лист1!$B$2;ПОИСКПОЗ(Выбор;Фотоальбом;0)-1;0;1;1)
=OFFSET(Лист1!$B$2;MATCH(Выбор;Фотоальбом;0)-1;0;1;1)
A fasaha, aiki MATCH ya sami tantanin halitta tare da samfurin da ake so a cikin kasida da suna, da aikin OFFSET sannan ya ba da hanyar haɗi zuwa tantanin halitta kusa da dama na sunan da aka samo, watau cell tare da hoton samfurin.
Mataki 5. Haɗa hoto zuwa hanyar haɗi
Ya rage don zaɓar hoton da aka kwafi a kunne Jerin 2 kuma shigar a cikin dabara bar
=Photo
kuma latsa Shigar
Duka! 🙂
- Ƙirƙiri jeri mai saukewa a cikin sel ɗin takardar aiki
- Ƙirƙirar Dogarorin Dogara
- Ƙirƙirar Lissafin saukarwa ta atomatik tare da PLEX Add-In Tools
- Jerin saukarwa tare da gogewa ta atomatik na abubuwan da aka riga aka yi amfani da su
- Jerin saukarwa tare da ƙari ta atomatik na abubuwan da suka ɓace