Zamkatimu
Kupanga vuto
Ndikofunikira kuwonetsetsa kuti mu imodzi mwama cell a pepalalo pali mndandanda wotsikira pansi wokhala ndi mayina, ukasankhidwa kuchokera pomwe, chinthucho chidzawonetsedwa pafupi ndi chithunzi:
Video
Gawo 1. Pangani chikwatu ndi chithunzi ndikuchipatsa dzina
Timalenga pa Mndandanda 1 ndife kabukhu kakang'ono kamene kali ndi mayina ndi zithunzi za katundu, wopangidwa ndi mizati iwiri (lachitsanzo и Photo):
Tsopano tikuyenera kupereka dzina ku chikwatu chathu kuti tizichilozera mtsogolomo. Mu Excel 2003 ndi kupitilira apo, chifukwa cha izi timapita ku menyu Lowetsani - Dzina - Perekani (Lowetsani - Dzina - Tanthauzirani), ndi mu Excel 2007 ndi zatsopano - dinani batani Woyang'anira Dzina tsamba Mafomu. Pangani mndandanda - lowetsani dzina (mwachitsanzo Photo Album) ndipo tchulani fomula ngati adilesi:
=СМЕЩ(Лист1!$A$1;1;0;СЧЁТЗ(Лист1!$A:$A)-1;1)
=OFFSET(Лист1!$A$1;1;0;COUNTA(Лист1!$A:$A)-1;1)
Fomula iyi imasankha selo lomaliza lomwe limakhala mugawo A ndikutulutsa kuchokera ku A2 kupita ku selo lomwe lapezekali. Kumanga kovutirapo koteroko kumafunika kuti pambuyo pake tiwonjezere zitsanzo zatsopano pamndandanda wathu komanso osaganiza zowongolera. Ngati simukuyenera kuwonjezera chilichonse, m'malo moyika fomu yowopsa iyi, ingolowetsani =A2:A5
Gawo 2. Dontho-pansi mndandanda kusankha chitsanzo
Tiyeni tipite Mapepala 2 ndi kupanga selo pamenepo ndi mndandanda wotsitsa kuti wogwiritsa ntchito asankhe chitsanzo cha foni (chikhale A1). Sankhani selo ndikupita ku menyu Deta - Chongani (Deta - Kutsimikizika) kapena m'mitundu yatsopano ya Excel - pa tabu Deta - Kutsimikizika kwa data (Deta - Kutsimikizika kwa data). Kupitilira kumunda Mtundu wa Data (Lolani) Sankhani List,koma ngati gwero kuwonetsa zathu Photo Album (musaiwale kuwonjezera chizindikiro chofanana patsogolo pake):
Kuphatikiza apo, ndikosavuta kupatsa cell iyi dzina - menyu kachiwiri Ikani - Dzina - Perekani ndiyeno lowetsani dzina (mwachitsanzo Kusankha) ndi OK.
Gawo 3: Koperani Chithunzicho
Tiyeni tisunthire chithunzi choyamba kuchokera ku chimbale cha zithunzi kupita ku mndandanda wotsikira pansi. Sankhani selo ndi chithunzi choyamba (osati chithunzicho, koma selo!)
mu Excel 2003 ndipo kenako, gwirani Shift kuti mutsegule menyu Sinthani. Chinthu chosawoneka kale chiyenera kuwonekera pamenepo. Koperani ngati Chithunzi:
Mu Excel 2007 ndi zatsopano, mutha kungowonjezera kutsika pansi pa batani Koperani (Koperani) on Kunyumba tabu:
Mu Excel 2010, zenera lina lowonjezera lidzawonekera ndi kusankha mtundu wa chithunzi chomwe chiyenera kupangidwa:
Mmenemo, muyenera kusankha zosankha "monga pawindo" ndi "raster".
Koperani, pitani ku Mapepala 2 pamndandanda wotsikira pansi ndi m'selo iliyonse yopanda kanthu pafupi nayo, ikani chithunzithunzi chathu chaching'ono cha cell ndi chithunzi (menyu Sinthani - Matani kapena mwachizolowezi Ctrl + V).
Khwerero 4. Pangani ulalo wamphamvu ku chithunzi chosankhidwa
Tsopano muyenera kupanga ulalo womwe udzaloze ku selo ndi chithunzi chosankhidwa. Kutsegula menyu Lowetsani - Dzina - Tanthauzirani or Woyang'anira Dzina tsamba Mafomu ndi kupanga gulu lina lotchulidwa:
Dzina la ulalo wathu, tinene, lidzakhala Photo, ndi formula
=СМЕЩ(Лист1!$B$2;ПОИСКПОЗ(Выбор;Фотоальбом;0)-1;0;1;1)
=OFFSET(Лист1!$B$2;MATCH(Выбор;Фотоальбом;0)-1;0;1;1)
Mwaukadaulo, ntchito GANIZANI amapeza selo yokhala ndi mtundu womwe mukufuna mu kalozera ndi dzina, ndi ntchitoyo OFFSET kenako amapereka ulalo ku selo loyandikana ndi kumanja kwa dzina lopezeka, mwachitsanzo, selo yokhala ndi chithunzi cha chinthucho.
Gawo 5. Kulumikiza chithunzi ndi ulalo
Zimatsalira kusankha chithunzi chojambulidwa Mndandanda 2 ndi kulowa mu bar formula
=Photo
ndi atolankhani Lowani
Zonse! 🙂
- Pangani mndandanda wotsitsa m'maselo amasamba
- Kupanga Zotsitsa Zodalira
- Pangani Mindandanda Yotsitsa Yokha ndi Zida Zowonjezera za PLEX
- Mndandanda wotsitsa ndikuchotsa zinthu zomwe zagwiritsidwa kale ntchito
- Mndandanda wotsitsa wokhala ndi zinthu zomwe zikusowa