Ukukhetha isithombe ohlwini olwehliswayo

Ukwakhiwa kwenkinga

Kudingekile ukwenza isiqiniseko sokuthi kwelinye lamaseli eshidi kukhona uhlu lokudonsela phansi olunamagama, uma kukhethiwe, umkhiqizo uzovezwa eduze kwalo njengesithombe:

Ividiyo

Isinyathelo 1. Dala uhla lwemibhalo ngesithombe bese ulunikeza igama

Sidala kuqhubeke Uhlu lwango-1 siyikhathalogu enamagama nezithombe zezimpahla, ezihlanganisa amakholomu amabili (imodeli и Photo):

Manje sidinga ukunikeza igama kuhla lwemibhalo yethu ukuze sibhekisele kulo ngokuzayo. Ku-Excel 2003 nangaphezulu, salokhu siya kumenyu Faka – Igama – Yabela (Faka – Igama – Chaza), naku-Excel 2007 nangaphezulu - chofoza inkinobho Umphathi wegama ithebhu amafomula. Dala ububanzi - faka igama (isibonelo I-Photo Album) futhi ucacise ifomula njengekheli:

=СМЕЩ(Лист1!$A$1;1;0;СЧЁТЗ(Лист1!$A:$A)-1;1)

=OFFSET(Лист1!$A$1;1;0;COUNTA(Лист1!$A:$A)-1;1)

Le fomula inquma iseli lokugcina elibanjwe kukholamu A futhi ikhiphe ububanzi ukusuka ku-A2 ukuya kuleli seli elitholiwe. Ukwakhiwa okunjalo okuyinkimbinkimbi kuyadingeka ukuze ngokulandelayo wengeze amamodeli amasha ohlwini lwethu futhi ungacabangi ngokulungisa ububanzi. Uma kungadingeki wengeze okuthile ngokuqinisekile, esikhundleni sokufaka le fomula ethusayo, vele ufake =A2:A5

Isinyathelo 2. Uhlu oluya phansi lokukhetha imodeli

Ake siye Ishidi 2 futhi udale iseli lapho ngohlu lokudonsela phansi ukuze umsebenzisi akhethe imodeli yefoni (makube ngu-A1). Khetha iseli bese uye kumenyu Idatha - Hlola (Idatha - Ukuqinisekisa) noma ezinguqulweni ezintsha ze-Excel - kuthebhu Idatha - Ukuqinisekiswa Kwedatha (Idatha - Ukuqinisekiswa Kwedatha). Ngokuqhubekayo ensimini Uhlobo Lwedatha (Vumela) Khetha Uhlu, kodwa njengoba Umthombo khombisa wethu I-Photo Album (ungakhohlwa ukwengeza uphawu olulinganayo phambi kwayo):

Ngaphezu kwalokho, kulula ukunikeza leli seli igama - imenyu futhi Faka – Igama – Yabela bese ufaka igama (ngokwesibonelo Choice) futhi OK.

Isinyathelo sesi-3: Kopisha Isithombe

Masisuse isithombe sokuqala ku-albhamu yezithombe siye ohlwini lokudonsela phansi. Khetha iseli ngesithombe sokuqala (hhayi isithombe ngokwaso, kodwa iseli!) kanye

ku-Excel 2003 nakamuva, cindezela u-Shift ukuze uvule imenyu Hlela. Into engabonakali ngaphambilini kufanele ivele lapho. Kopisha njengesithombe:

Ku-Excel 2007 nangaphezulu, ungavele unwebe okwehliswayo ngaphansi kwenkinobho Kopisha (Kopisha) on Ikhaya ithebhu:

Ku-Excel 2010, kuzovela elinye iwindi elengeziwe elinenketho yohlobo lwesithombe esizokwakhiwa:

Kuyo, udinga ukukhetha izinketho "njengasesikrinini" kanye "ne-raster".

Kopisha, yiya ku Ishidi 2 ohlwini lokudonsela phansi futhi kunoma iyiphi iseli engenalutho eduze kwalo, faka isithombe-skrini sethu esincane seseli ngesithombe (imenyu Hlela – Namathisela noma evamile I-CTRL + V).

Isinyathelo 4. Dala isixhumanisi esiguqukayo esithombeni esikhethiwe

Manje udinga ukwenza isixhumanisi esizokhomba iseli ngesithombe esikhethiwe. Ukuvula imenyu Faka – Igama – Chaza or Umphathi wegama ithebhu amafomula bese udala obunye ububanzi obuqanjwe igama:

Igama lesixhumanisi sethu, ake sithi, lizoba Photo, kanye nefomula

=СМЕЩ(Лист1!$B$2;ПОИСКПОЗ(Выбор;Фотоальбом;0)-1;0;1;1)

=OFFSET(Лист1!$B$2;MATCH(Выбор;Фотоальбом;0)-1;0;1;1)

Ngobuchwepheshe, umsebenzi MATCH ithola iseli elinemodeli efiselekayo kukhathalogi ngegama, nomsebenzi OFFSET bese inikeza isixhumanisi seseli eseduze kwesokudla segama elitholiwe, okungukuthi iseli elinesithombe somkhiqizo.

Isinyathelo sesi-5. Ukunamathisela isithombe kusixhumanisi

Kusele ukukhetha isithombe esikopishiwe kuso Uhlu lwango-2 bese ufaka ibha yefomula

=Photo

bese ucindezela u-Enter

Konke! 🙂

• Dala uhlu lokudonsela phansi kumaseli eshidi lokusebenzela 
• Ukudala Okwehliswayo Okuncike 
• Yakha Ngokuzenzakalelayo Uhlu Olwehliswayo Ngamathuluzi Okwengeza we-PLEX 
• Uhlu olwehliswayo olunokususwa ngokuzenzakalelayo kwezinto esezisetshenzisiwe kakade
• Uhlu olwehliswayo olunokwengezwa okuzenzakalelayo kwezinto ezingekho