Kuyika ndi Kusintha Chithunzi mu Excel

Nthawi zina, kuti mugwire ntchito zina mu Excel, muyenera kuyika chithunzi kapena chithunzi patebulo. Tiyeni tiwone momwe izi zingachitikire mu pulogalamuyi.

Zindikirani: musanayambe kuyika chithunzi mu Excel, muyenera kukhala nacho pafupi - pa hard drive ya kompyuta kapena USB drive yomwe imalumikizidwa ndi PC.

Kuyika chithunzi papepala

Poyamba, timagwira ntchito yokonzekera, ndiye, tsegulani chikalata chomwe mukufuna ndikupita ku pepala lofunikira. Timapitilira molingana ndi dongosolo ili:

1. Timadzuka m'chipinda momwe timakonzekera kuyika chithunzicho. Sinthani ku tabu "Ikani"kumene ife dinani batani “Zifanizo”. Pa mndandanda wotsitsa, sankhani chinthucho “Zojambula”.
2. A zenera adzaoneka pa nsalu yotchinga imene muyenera kusankha ankafuna fano. Kuti muchite izi, choyamba pitani ku chikwatu chomwe chili ndi fayilo yofunikira (mwachisawawa, chikwatu “Zithunzi”), kenako dinani ndikusindikiza batani "Tsegulani" (kapena mutha kungodina kawiri pafayiloyo).
3. Zotsatira zake, chithunzi chosankhidwa chidzayikidwa pa pepala la bukhu. Komabe, monga mukuonera, amangoikidwa pamwamba pa maselo ndipo alibe chochita nawo. Choncho tiyeni tipitirire ku masitepe otsatirawa.

Kusintha chithunzi

Tsopano tikuyenera kusintha chithunzi chomwe chayikidwapo pochipatsa miyeso yomwe tikufuna.

1. Dinani pachithunzichi ndi batani lakumanja la mbewa. Pa mndandanda wotsitsa, sankhani “Kukula ndi Katundu”.
2. Zenera la mtundu wazithunzi lidzawoneka, pomwe tingathe kusintha magawo ake:
   • miyeso (kutalika ndi m'lifupi);
   • ngodya ya kuzungulira;
   • kutalika ndi m'lifupi monga peresenti;
   • kusunga milingo, etc..
3. Komabe, nthawi zambiri, m'malo mopita ku zenera la mtundu wa chithunzi, zoikamo zomwe zitha kupangidwa mu tabu "Mtundu" (pankhaniyi, chojambulacho chiyenera kusankhidwa).
4. Tiyerekeze kuti tifunika kusintha kukula kwa chithunzicho kuti chisapitirire malire a selo yosankhidwa. Mutha kuchita izi m'njira zosiyanasiyana:
   • Pitani ku zoikamo "Miyeso ndi katundu" kudzera pamenyu yachithunzichi ndikusintha kukula pawindo lomwe likuwoneka.
   • ikani miyeso pogwiritsa ntchito zida zoyenera pa tabu "Mtundu" pa riboni ya pulogalamu.
   • atagwira kumanzere mbewa batani, kukoka m'munsi pomwe ngodya ya chithunzi diagonally mmwamba.

Kulumikiza chithunzi ku selo

Kotero, tinayika chithunzi pa pepala la Excel ndikusintha kukula kwake, zomwe zinatilola kuti tigwirizane ndi malire a selo yosankhidwa. Tsopano muyenera kulumikiza chithunzi ku selo iyi. Izi zimachitidwa kuti panthawi yomwe kusintha kwa tebulo kumabweretsa kusintha kwa malo oyambirira a selo, chithunzicho chimayenda nacho. Mutha kukhazikitsa izi mwanjira iyi:

1. Timayika chithunzi ndikusintha kukula kwake kuti chigwirizane ndi malire a selo, monga tafotokozera pamwambapa.
2. Dinani pa chithunzicho ndikusankha kuchokera pamndandanda “Kukula ndi Katundu”.
3. Pamaso pathu, zenera lodziwika kale la mtundu wazithunzi lidzawonekera. Pambuyo poonetsetsa kuti miyeso ikugwirizana ndi zomwe mukufuna, komanso kuti pali mabokosi “Sungani milingo” и "Malinga ndi kukula koyambirira", pitani к "Katundu".
4. M'mawonekedwe a chithunzi, ikani mabokosi kutsogolo kwa zinthuzo "Chinthu Chotetezedwa" и "Printa chinthu". Komanso, sankhani njira "Sungani ndikusintha kukula ndi ma cell".

Kuteteza cell yokhala ndi chithunzi kuti isasinthe

Muyeso uwu, monga momwe dzina lamutu limatanthawuzira, ndilofunika kuti muteteze selo lomwe lili ndi chithunzicho kuti lisasinthidwe ndikuchotsedwa. Izi ndi zomwe muyenera kuchita pa izi:

1. Sankhani pepala lonse, lomwe timachotsa koyamba zomwe tasankha pachithunzichi ndikudina pa cell ina iliyonse, kenako dinani batani kuphatikiza. Ctrl + A. Kenako timatcha mndandanda wazinthu zama cell ndikudina kumanja kulikonse komwe mwasankha ndikusankha chinthucho "Cell Format".
2. Pazenera la masanjidwe, sinthani ku tabu "Chitetezo", pomwe timachotsa bokosi loyang'anizana ndi chinthucho "Ma cell otetezedwa" ndipo dinani OK.
3. Tsopano dinani pa selo lomwe chithunzicho chinayikidwa. Pambuyo pake, komanso kudzera mu menyu yankhaniyo, pitani ku mtundu wake, kenako pitani ku tabu "Chitetezo". Chongani bokosi pafupi ndi njira "Ma cell otetezedwa" ndipo dinani OK.Zindikirani: ngati chithunzi chomwe chalowetsedwa mu cell chikudutsani, ndiye kuti dinani ndi mabatani a mbewa mudzayitanira mawonekedwe ndi zoikamo za chithunzicho. Chifukwa chake, kuti mupite ku cell yokhala ndi chithunzi (kusankhani), ndikwabwino kudina cell ina iliyonse pafupi ndi iyo, ndiyeno, pogwiritsa ntchito makiyi oyenda pa kiyibodi (mmwamba, pansi, kumanja, kumanzere), kupita ku chofunika. Komanso, kuti muyitane menyu yankhani, mutha kugwiritsa ntchito kiyi yapadera pa kiyibodi, yomwe ili kumanzere kwa Ctrl.
4. Sinthani ku tabu Ndemangakumene dinani pa batani "Tetezani Mapepala" (pamene miyeso ya zenera ikatsindikiridwa, muyenera dinani kaye batani "Chitetezo", pambuyo pake chinthu chomwe mukufuna chidzawonekera pamndandanda wotsitsa).
5. Iwindo laling'ono lidzawonekera pomwe titha kukhazikitsa mawu achinsinsi kuti titeteze pepala ndi mndandanda wazomwe ogwiritsa ntchito angachite. Dinani mukakonzeka OK.
6. Pazenera lotsatira, tsimikizirani mawu achinsinsi omwe adalowa ndikudina CHABWINO.
7. Chifukwa cha zochita zomwe zachitika, selo lomwe chithunzicho chilili chidzatetezedwa ku kusintha kulikonse, kuphatikizapo. kuchotsa.Panthawi imodzimodziyo, maselo otsala a pepala amakhalabe osinthika, ndipo mlingo wa ufulu wochitapo kanthu pokhudzana ndi iwo umadalira zinthu zomwe tasankha pamene chitetezo cha pepala chinatsegulidwa.

Kuyika chithunzi mu cell comment

Kuwonjezera pa kuyika chithunzi mu selo la tebulo, mukhoza kuwonjezera pa cholemba. Momwe izi zimachitikira zikufotokozedwa pansipa:

1. Dinani kumanja pa selo lomwe mukufuna kuyika chithunzicho. Pa mndandanda wotsitsa, sankhani lamulo "Isert note".
2. Malo ang'onoang'ono olowetsa cholemba adzawonekera. Sungani cholozera pamalire a malo olembera, dinani kumanja kwake ndipo pamndandanda womwe ukutsegulidwa, dinani chinthucho. "Note Format".
3. Zenera la zoikamo zolembera lidzawonekera pazenera. Sinthani ku tabu "Mitundu ndi Mizere". Muzosankha zodzaza, dinani pamtundu womwe ulipo. Mndandanda udzatsegulidwa momwe timasankha chinthucho "Njira Zodzaza".
4. Pazenera la njira zodzaza, sinthani ku tabu "Chithunzi", pomwe timasindikiza batani ndi dzina lomwelo.
5. Zenera loyika zithunzi lidzawonekera, momwe timasankha kusankha "Kuchokera ku fayilo".
6. Pambuyo pake, zenera losankha zithunzi lidzatsegulidwa, zomwe tidakumana nazo kale kumayambiriro kwa nkhani yathu. Pitani ku chikwatu chomwe chili ndi fayilo yokhala ndi chithunzi chomwe mukufuna, kenako dinani batani "Ikani".
7. Pulogalamuyi idzatibwezera kuwindo lapitalo posankha njira zodzaza ndi ndondomeko yosankhidwa. Chongani m'bokosi kuti mwina “Sungani kuchuluka kwa chithunzi”, kenako dinani OK.
8. Pambuyo pake, tidzakhala muwindo lalikulu la cholembera, pomwe timasinthira ku tabu "Chitetezo". Apa, sankhani bokosi lomwe lili pafupi ndi chinthucho "Chinthu Chotetezedwa".
9. Kenako, pitani ku tabu "Katundu". Sankhani njira "Sungani ndikusintha chinthu pamodzi ndi ma cell". Zokonda zonse zidapangidwa, kotero mutha kukanikiza batani OK.
10. Chifukwa cha zochita zomwe tachita, sitinathe kungoyika chithunzi ngati cholembera ku selo, komanso kuchiyika ku selo.
11. Ngati mungafune, cholembacho chikhoza kubisika. Pankhaniyi, ingowonetsedwa mukangoyang'ana pa selo. Kuti muchite izi, dinani kumanja pa selo ndi cholembera ndikusankha chinthucho mumenyu yankhani "Bisani chidziwitso".Ngati ndi kotheka, cholembacho chikuphatikizidwanso chimodzimodzi.

Lowetsani chithunzi mumachitidwe opangira

Excel imaperekanso kuthekera koyika chithunzi mu cell kudzera muzomwe zimatchedwa Njira Yotsatsa. Koma choyamba muyenera kuyiyambitsa, chifukwa imayimitsidwa mwachisawawa.

1. Pitani ku menyu "Fayilo", pomwe timadina chinthucho "Parameters".
2. Zenera la magawo lidzatsegulidwa, pomwe pamndandanda womwe uli kumanzere dinani pagawolo "Sinthani Riboni". Pambuyo pake, mu gawo lamanja la zenera muzokonda za riboni, timapeza mzere "Developer", chongani bokosi pafupi ndi izo ndikudina OK.
3. Timayima m'chipinda chomwe tikufuna kuyika chithunzicho, kenako ndikupita ku tabu "Developer". Mu gawo la zida "Controls" pezani batani "Ikani" ndipo alemba pa izo. Pamndandanda umene ukutsegulidwa, dinani chizindikirocho "Chithunzi" pagulu "Zowongolera zomwe zimagwira ntchito".
4. Cholozeracho chidzasintha kukhala mtanda. Ndi batani lakumanzere la mbewa, sankhani malo a chithunzi chamtsogolo. Ngati ndi kotheka, miyeso ya derali imatha kusinthidwa kapena malo a rectangle (mzere) akhoza kusinthidwa kuti agwirizane ndi selo.
5. Dinani kumanja pa chithunzi chotsatira. Pamndandanda wotsikira pansi wa malamulo, sankhani "Katundu".
6. Tiwona zenera lomwe lili ndi zinthu za elementi:
   • mu mtengo wa parameter "Kukhazikitsa" onetsani nambala "1" (mtengo woyamba - "2").
   • m'munda kuti mulowetse mtengo wotsutsana ndi parameter "Chithunzi" dinani batani ndi madontho atatu.
7. Zenera lokweza zithunzi lidzawonekera. Timasankha fayilo yomwe tikufuna apa ndikutsegula ndikudina batani loyenera (ndikofunikira kusankha mtundu wa fayilo "Mafayilo Onse", chifukwa mwinamwake zina zowonjezera sizidzawoneka pawindo ili).
8. Monga mukuwonera, chithunzicho chimayikidwa papepala, komabe, gawo lokhalo likuwonetsedwa, kotero kusintha kwa kukula kumafunika. Kuti muchite izi, dinani chizindikirocho mu mawonekedwe a makona atatu ang'onoang'ono pansi pagawo lamtengo wapatali "PictureSizeMode".
9. Pamndandanda wotsikira pansi, sankhani njira yokhala ndi nambala "1" poyambira.
10. Tsopano chithunzi chonsecho chikukwanira mkati mwa dera lamakona anayi, kotero zoikamo zikhoza kutsekedwa.
11. Zimangokhala kumangiriza chithunzicho ku selo. Kuti muchite izi, pitani ku tabu "Kupanga tsamba", pomwe timasindikiza batani "Kuyitanitsa". Pa mndandanda wotsitsa, sankhani chinthucho "Align", ndiye - "Snap to Grid".
12. Zachitika, chithunzicho chimangiriridwa ku selo yosankhidwa. Kuonjezera apo, tsopano malire ake "adzamamatira" kumalire a selo ngati tisuntha chithunzicho kapena kuchisintha.
13. Izi zidzakulolani kuti mugwirizane bwino ndi chithunzicho mu selo popanda kuyesetsa kwambiri.

Kutsiliza

Chifukwa chake, pali njira zingapo zomwe mungayikitsire chithunzi mu cell pa pepala la Excel. Njira yosavuta ndiyo kugwiritsa ntchito zida zomwe zili mu Insert tabu, kotero sizodabwitsa kuti iyi ndi njira yotchuka kwambiri pakati pa ogwiritsa ntchito. Kuphatikiza apo, ndizotheka kuyika zithunzi ngati zolemba zama cell kapena kuwonjezera zithunzi papepala pogwiritsa ntchito Mawonekedwe Otsogola apadera.