Momwe mungayikitsire chithunzi mu Excel spreadsheet. Kuyika ndikusintha chithunzi mu Excel

Ntchito ina yochitidwa mu Excel spreadsheet imafuna kuwonjezera zojambula zosiyanasiyana ndi zithunzi ku data ya tabular. Pulogalamuyi ili ndi zida zingapo zomwe zimakulolani kuti muyike chithunzi. M'nkhaniyi, tipenda mwatsatanetsatane njira zingapo zogwiritsira ntchito njirayi: kupyolera mu chitetezo cha mapepala, makina opangira mapulogalamu, ndi kuwonjezera zolemba papepala.

Makhalidwe oyika zithunzi

Kuti muwonjezere molondola chithunzi patsamba lamasamba, chithunzicho chiyenera kukhala pa hard drive ya PC kapena pa media zochotseka zolumikizidwa nacho.

Tcherani khutu! Poyamba, chithunzi chowonjezeredwa sichimangiriridwa ku selo linalake, koma chimangokhala pamalo olembedwa a tsambalo.

Kuyika chithunzi papepala

Choyamba, tiyeni tifotokoze momwe ndondomeko yoyika chithunzi mu malo ogwirira ntchito imachitikira, ndiyeno tipeze momwe mungawonjezere chithunzi ku selo linalake. Njirayi ikuwoneka motere:

1. Timasankha selo lomwe tikukonzekera kuikamo chithunzi. Timasunthira ku gawo lotchedwa "Insert", lomwe lili pamwamba pa spreadsheet. Timapeza chipika cha malamulo "Zithunzi" ndipo timadina chinthucho "Chithunzi".

2. Zenera lotchedwa "Insert Chithunzi" likuwonekera pazenera. Mwachikhazikitso, nthawi zonse imapezeka mu Foda ya Zithunzi. Ndizotheka kusamutsa pasadakhale ku foda iyi chithunzi chomwe tikufuna kuyika pa tsamba lamasamba. Njira ina ndikukhalabe pawindo lomwelo ndikupita kufoda ina pagalimoto yapakompyuta yanu kapena media media yolumikizidwa. Mukamaliza kusintha zonse, posankha chithunzi, dinani batani "Ikani".

3. Okonzeka! Chithunzi chofunidwa chinawonekera pa spreadsheet worksheet. Ndizofunikira kudziwa kuti chithunzicho sichinaphatikizidwe ku selo iliyonse ya chikalatacho. Tidzakambirana za ndondomeko yomangiriza pang'ono.

Kusintha kwazithunzi

Tiyeni tikambirane za momwe tingasinthire chithunzi chomwe chayikidwa kuti chikhale ndi miyeso yoyenera yomwe imawoneka yogwirizana pa pepala la ntchito ya spreadsheet. Njirayi ikuwoneka motere:

1. Timadina pa chithunzi chomwe chayikidwa RMB. Menyu yankhani ikuwonekera pazenera, kukulolani kuti musinthe chithunzi chimodzi kapena china. Sankhani chinthu chotchedwa "Size ndi Properties".

2. Chiwonetserocho chikuwonetsa kabokosi kakang'ono kotchedwa Chithunzi Format. Nawa chiwerengero chachikulu cha magawo osinthika omwe amakulolani kuti musinthe mawonekedwe a chithunzicho. Basic zoikamo: kukula, kulocha, cropping, zosiyanasiyana zotsatira, ndi zina zotero. Zosintha zambiri zidapangidwa kuti wogwiritsa ntchito athe kusintha chithunzi chomwe chayikidwa pa ntchito zosiyanasiyana.

3. Ngati palibe chifukwa chosinthira mwatsatanetsatane chithunzi chomwe chayikidwa, ndiye kuti sitidzafunika zenera la "Miyeso ndi Katundu". Njira ina yosinthira chithunzicho ndikupita ku gawo lowonjezera la "Kugwira Ntchito ndi Zithunzi", lomwe lili pamwamba pa mawonekedwe a spreadsheet.

4. Ngati tikufuna kuyika chithunzi mu selo, ndiye kuti tiyenera kusintha chithunzicho kuti kukula kwake kufanane ndi kukula kwa selo lokha. Kusintha kukula kumachitika ndi njira zotsatirazi: kudzera pawindo la "Miyeso ndi katundu"; kusuntha malire a chithunzicho mothandizidwa ndi LMB; kugwiritsa ntchito zida zomwe zili pa riboni, komanso menyu yankhaniyo.

Kulumikiza chithunzi

Pambuyo pochita zinthu zonse zomwe zafotokozedwa pamwambapa, chithunzi chomwe chidalowetsedwamo mulimonsemo sichinagwirizane ndi selo. Mwachitsanzo, ngati wogwiritsa ntchito asankha zomwe zili patsamba logwirira ntchito, ma cell asintha malo, koma chithunzicho chidzakhalabe pamalo omwe adayikidwa. Spreadsheet ili ndi njira zingapo zomwe zimakulolani kuti muphatikize chithunzi ku selo yosankhidwa mu chikalata. Tiyeni tikambirane zimenezi mwatsatanetsatane.

Njira 1: chitetezo cha pepala

Kuteteza pepala lachikalata ku zosintha zosiyanasiyana ndi njira imodzi yolumikizira chithunzi ku selo. Njirayi ikuwoneka motere:

1. Timayika kusintha kwa kukula kwa chithunzi kukula kwa selo ndikuyiyika pogwiritsa ntchito njira zomwe tafotokozazi.

2. Dinani pa chithunzi chomwe chayikidwa. Menyu yaying'ono yankhani ikuwoneka. Dinani pa "Kukula ndi katundu" chinthu.

3. Zenera lodziwika bwino la "Format Photo" lidawonetsedwa pazenera. Timasunthira ku gawo la "Kukula" ndikuonetsetsa kuti kukula kwa chithunzi sikudutsa kukula kwa selo. Kuphatikiza apo, onetsetsani kuti pali nkhupakupa pafupi ndi zinthu "Sungani milingo" ndi "Zogwirizana ndi kukula koyambirira". Ngati katundu aliyense sakugwirizana ndi zomwe tafotokozazi, zisintheni.

4. Muwindo lomwelo timapeza gawo la "Properties" ndikusunthira kwa izo. Ngati palibe cheke pafupi ndi zinthu "Sindikizani chinthu" ndi "Chinthu Chotetezedwa", ndiye kuti ziyenera kufufuzidwa. Timapeza malowo "Snap object to background" ndikuyika cholembera pafupi ndi mawu akuti "Sungani ndikusintha chinthucho limodzi ndi ma cell." Pambuyo pochita zosintha zonse, dinani batani la "Tsekani", lomwe lili pansi pa zenera la "Format Photo".

5. Pogwiritsa ntchito kiyi pa kiyibodi "Ctrl + A" timasankha tsamba lonse. Timatcha menyu yankhani ndikudina chinthucho "Ma cell Format ...".

6. A zenera lotchedwa "Format Maselo" anaonekera pa zenera. Pitani ku gawo la "Chitetezo" ndikuchotsa "Protected cell" katundu. Pambuyo pochita zosintha zonse, dinani batani la "Chabwino" lomwe lili pansi pawindo.

7. Tsopano timapanga kusankha kwa selo lomwe chithunzi choyikidwacho chili, chomwe tikukonzekera kulumikiza. Mwa njira yomwe ili pamwambapa, timapitanso kuwindo la "Format Cells" pogwiritsa ntchito menyu. Apanso, timapita ku gawo la "Chitetezo" ndipo nthawi ino ikani chizindikiro pafupi ndi katundu wa "Protected cell". Pambuyo pochita zosintha zonse, dinani "Chabwino".

8. Pitani ku gawo la "Review", lomwe lili pamwamba pa mawonekedwe a spreadsheet. Timapeza chipika chotchedwa "Zosintha" ndikudina "Tetezani Mapepala".

9. Zenera lotchedwa "Protect Sheet" linawonetsedwa pazenera. Pagawo la "Password to disable sheet protection", lowetsani mawu achinsinsi. Timadina batani "Chabwino". Wina zenera limapezeka pachionetsero chimene muyenera kachiwiri kulowa achinsinsi.

10. Okonzeka! Tateteza selo ndi chithunzi chomwe chayikidwa kuti chisasinthe. Mwa kuyankhula kwina, chithunzicho chimamangiriridwa ku selo.

Mpaka chitetezocho chitayimitsidwa, sikutheka kupanga kusintha kulikonse mu selo lotetezedwa la tsamba la ntchito. Ngakhale titasankha deta, chithunzi chomwe chidayikidwacho chikhalabe mu cell.

Njira 2: Ikani chithunzi muzolemba

Pogwiritsa ntchito cholembacho, mutha kulumikizanso chithunzicho. Njirayi ikuwoneka motere:

1. Dinani kumanja pa selo lomwe tikufuna kuyika chithunzicho. Mndandanda wazinthu zazing'ono zatsegulidwa. Dinani pa chinthu chotchedwa "Insert Note".

2. Zenera laling'ono linawonetsedwa pazenera, kukulolani kuti mulembe cholemba. Sunthani cholozera pa zenera chimango ndi kumadula pa izo. Zosankha zatsopano zikuwonetsedwa pazenera. Dinani pa "Note Format" chinthu.

3. Windo latsopano linawonekera pachiwonetsero, lopangidwa kuti likhazikitse zolemba. Pitani ku gawo la "Colors ndi Mizere". Timapeza katundu "Dzazani" ndikutsegula mndandanda wa mithunzi mu gawo la "Color". Pamndandanda wotsitsa, dinani "Njira Zodzaza ...".

4. Iwindo likuwonetsedwa momwe mungasankhire njira yodzaza. Timapita ku gawo la "Chithunzi", kenako dinani "Chithunzi ...".

5. Zenera la "Insert Picture", lomwe timadziwika ndi njira zomwe tafotokozazi, latsegulidwa. Timasankha kujambula. Pambuyo pochita zosokoneza zonse, dinani batani la "Ikani", lomwe lili pansi pa zenera la "Insert Picture".

6. Chithunzi chosankhidwa chikuwonetsedwa pawindo la "Njira Zodzaza". Ikani chizindikiro pafupi ndi mawu akuti "Sungani kuchuluka kwa chithunzicho." Mukamaliza masitepe onse, dinani "Chabwino".

7. Timabwerera kuwindo la "Note Format". Timapita ku gawo la "Chitetezo". Chotsani cholembera pafupi ndi mawu akuti "Chinthu Chotetezedwa".

8. Timapita ku gawo la "Properties". Mu block "Snap object to background", chongani bokosi pafupi ndi "Sungani ndikusintha chinthu chokhala ndi ma cell". Pambuyo pochita zosintha zonse, dinani "Chabwino".

9. Okonzeka! Titakhazikitsa njira zonse zomwe tafotokozazi, chithunzicho sichinangowonjezeredwa pacholembacho, komanso chophatikizidwa ndi selo. Inde, njirayi si yoyenera kwa ntchito zonse zomwe zathetsedwa pogwiritsa ntchito purosesa ya spreadsheet, chifukwa ili ndi malire.

Njira 3: Njira Yopangira

Mukhoza kumanga chithunzi ku selo pogwiritsa ntchito njira yapadera ya "Developer" yophatikizidwa mu purosesa ya spreadsheet. Chovuta chachikulu ndikuti mawonekedwewo ali mumkhalidwe wakunja. Tiyeni tiyitsegule kaye. Maphunziro a tsatane-tsatane akuwoneka motere:

1. Pitani ku gawo la "Fayilo", kenako sankhani "Zosankha".

2. Pazenera lomwe likuwoneka, pitani ku gawo la "Ribbon Add-In". Timayika chizindikiro pafupi ndi mawu akuti "Developer". Pambuyo pochita zosintha zonse, dinani "Chabwino".

3. Timasankha malo omwe tikufuna kuyika chithunzicho. Pitani ku gawo la "Developer" lomwe likuwonekera pamwamba pa mawonekedwe a spreadsheet. Mu gawo la "Zowonjezera", dinani "Ikani". Pamndandanda wotsikira pansi, dinani chizindikiro cha "Image", chomwe chili mugawo la "ActiveX Controls".

4. Selo imawonetsa kakona kakang'ono, kopanda kanthu. Timakonza miyeso kuti chiwerengerocho chigwirizane ndi selo yosankhidwa. Kusintha kumayendetsedwa ndikusuntha malire mothandizidwa ndi LMB. Dinani kumanja pa mawonekedwe. Menyu yaying'ono imatsegulidwa, momwe timadina "Properties".

5. Zenera la katundu likuwonekera pazenera. Pafupi ndi mawu akuti "Kuyika" timayika unit. Pamzere "Chithunzi" timapeza chithunzicho ngati madontho atatu ndikudina ndi batani lakumanzere.

6. Zenera la Add Image likuwonekera. Timapeza chithunzi chomwe tikufuna kuyika. Sankhani izo, ndiyeno alemba pa "Open" batani ili pansi pa zenera.

7. Njira zonse zikamalizidwa, tsegulani zenera la katundu. Chithunzi chomwe mukufuna chimayikidwa mu selo. Kenako, muyenera kuchita njira yolumikizira chithunzicho ku selo. Timakhazikitsa chisankho cha chithunzi pa malo ogwirira ntchito ndikusunthira ku gawo la "Mapangidwe a Tsamba", lomwe lili pamwamba pa spreadsheet. Pezani chipika cha "Konzani" ndikusankha chinthu cha "Align". Pamndandanda womwe umatsegulidwa, dinani "Snap to Grid" ndikusuntha pang'ono kunja kwa malire azithunzi.

8. Okonzeka! Pambuyo potsatira ndondomeko yomwe ili pamwambayi, tamanga chithunzicho ku selo.

Kutsiliza

Mu Excel spreadsheet, pali njira zambiri zoyika chithunzi ndikuchiyika ku selo, koma si njira iliyonse yomwe ili yoyenera kuthetsa mavuto onse. Mwachitsanzo, njira yotengera zolemba ndi yopapatiza, pomwe Developer Mode ndi Protect Sheet ndi zosankha zomwe zimagwirizana ndi ogwiritsa ntchito onse.