Ikani chithunzi mu Microsoft Excel

Ntchito zina zochitidwa ndimatafura zimafuna kukhazikitsidwa kwa zithunzi kapena zithunzi zosiyanasiyana. Excel ili ndi zida zomwe zimakuthandizani kuti muzichita phokoso lofananako. Tiyeni tiwone momwe angachitire.

Zolemba poyika zithunzi

Kuti muthe kuyika chithunzi patebulo la Excel, iyenera kutsitsidwa kaye pakompyuta yolowera kapena kutulutsa media yolumikizidwa nayo. Chofunikira kwambiri pakuyika kwa chithunzichi ndikuti mosakakamira sichimamangika ndi foni inayake, koma chimangoikidwa pamalo osankhidwa a pepalalo.

Phunziro: Momwe mungayikitsire chithunzi mu Microsoft Mawu

Ikani chithunzi patsamba

Poyamba timazindikira momwe tingajambule chithunzi papepala, ndipo pokhapokha tidzaona momwe tingalumikizire chithunzi ndi foni inayake.

1. Sankhani foni yomwe mukufuna kukhazikitsa chithunzicho. Pitani ku tabu Ikani. Dinani batani "Zojambula"lomwe lili muzosungirako "Zithunzi".



2. Tsamba lazithunzi loikapo limatsegulidwa. Mwakukhazikika, nthawi zonse imatsegulidwa mufoda "Zithunzi". Chifukwa chake, mutha kusinthitsa chithunzi chomwe muti muyike. Ndipo mutha kuchita izi mwanjira ina: kudzera pa mawonekedwe omwewo pitani ku buku lina lililonse la PC hard drive kapena media atalumikizidwa nayo. Mukasankha chithunzithunzi chomwe muti muwonjezere ku Excel, dinani batani Ikani.

Pambuyo pake, chithunzicho chimayikidwa pa pepalalo. Koma, monga tanena kale, imangokhala pa pepala ndipo sichimalumikizana kwenikweni ndi khungu lililonse.

Kusintha kwa zithunzi

Tsopano muyenera kusintha chithunzicho, kuchipatseni mawonekedwe oyenera ndi kukula kwake.

1. Timadina pachinthunzicho ndi batani loyenera la mbewa. Zosankha zotsegulira zimatsegulidwa ngati mndandanda wazakudya. Dinani pazinthuzo Kukula ndi katundu wake ".



2. Zenera limatseguka momwe muli zida zambiri zosinthira zithunzi. Apa mutha kusintha kukula kwake, mtundu wake, mbewu, kuwonjezera zina ndi zina zambiri. Zonse zimatengera chithunzithunzi ndi zolinga zomwe zimagwiritsidwa ntchito.



3. Koma nthawi zambiri sipakufunika kutsegula zenera "Makulidwe ndi katundu", popeza pali zida zokwanira zomwe zimaperekedwa pa tepi pazinthu zowonjezera za ma tabo "Gwirani zojambula".



4. Ngati tikufuna kuyika chithunzi mu khungu, ndiye kuti chinthu chofunikira kwambiri ndikasintha chithunzi ndikusintha kukula kwake kuti sichikula kuposa kukula kwa khungu lenilenilo. Mutha kusintha mu njira zotsatirazi:
   • kudzera menyu yazonse;
   • gulu pa tepi;
   • zenera "Makulidwe ndi katundu";
   • pokokera m'malire a chithunzicho ndi mbewa.

Kupeza chithunzi

Koma, ngakhale chithunzicho chitakhala chocheperako kuposa chipinda chija ndikuchiyika momwemo, chidakhalabe chosagwiritsika ntchito. Izi zikutanthauza, ngati, mwachitsanzo, tikasanja kapena mtundu wina wa kulondera, ndiye kuti maselo amasintha malo, ndipo chithunzicho chikhala pamalo omwewo. Koma, ku Excel, pali njira zina zojambulira chithunzi. Tiyeni tiwalingalire mopitilira.

Njira 1: kuteteza pepala

Njira imodzi yophatikiza chithunzi ndikuteteza pepalali kuti lisinthe.

1. Timasintha kukula kwa chithunzicho kukula kwake kwa khungu ndikuyika pamenepo, monga tafotokozera pamwambapa.



2. Timadulira chithunzicho ndikusankha chinthucho menyu Kukula ndi katundu wake ".



3. Tsamba lazithunzithunzi limatsegulidwa. Pa tabu "Kukula" onetsetsani kuti kukula kwa chithunzicho sikokulira kuposa kukula kwa khungu. Timayang'ananso mosiyana ndi zomwe zikuwonetsa "Ponena za Kukula koyambirira" ndi "Sungani gawo lanu" panali zikwangwani. Ngati gawo lina silikugwirizana ndi kufotokoza pamwambapa, musinthe.



4. Pitani ku tabu "Katundu" zenera lomweli. Chongani mabokosi moyang'anizana ndi magawo "Chotetezedwa" ndi "Sindikizani chinthu"ngati sanakhazikitsidwe. Tikuyika kusintha kosinthika "Kumangirira chinthu kumbuyo" m'malo "Sinthani ndikusintha chinthu ndi maselo". Zosintha zonse zikamalizidwa, dinani batani Tsekaniili pakona ya kumunsi ya zenera.



5. Sankhani pepala lonse ndikusintha njira yachidule Ctrl + A, ndi kudutsa menyu wazomwe mukuyang'ana pazenera la mawonekedwe.



6. Pa tabu "Chitetezo" zenera lomwe limatsegulira, tsekani njirayo "Selo yotetezedwa" ndipo dinani batani "Zabwino".



7. Sankhani khungu lomwe chithunzicho chili, chomwe chikufunika kukhazikitsidwa. Tsegulani zenera la mawonekedwe ndi tabu "Chitetezo" onani bokosi pafupi ndi mtengo wake "Selo yotetezedwa". Dinani batani "Zabwino".



8. Pa tabu "Ndemanga" mu bokosi la zida "Sinthani" pa riboni, dinani batani Tetezani Mapepala.



9. Iwindo limatsegulidwa momwe timalowetsamo mawu achinsinsi oteteza pepalalo. Dinani batani "Zabwino", ndipo pawindo lotsatira lomwe limatsegulira, bwerezani mawu achinsinsi omwe mudalowe.

Pambuyo pazochita izi, magulu omwe zithunzizo zimatetezedwa pakusintha, ndiye kuti, zithunzi zimaphatikizidwa kwa iwo. Palibe zosintha zomwe zingachitike m'maselo amenewa mpaka chitetezo chitachotsedwa. M'mitundu ina, ngati kale, mutha kusintha zina ndikusunga. Nthawi yomweyo, tsopano ngakhale mutaganiza zosankha, chithunzicho sichingapite kulikonse kuchokera mu cell momwe ilimo.

Phunziro: Momwe mungatetezere khungu kuti lisasinthe ku Excel

Njira 2: ikani chifanizo pa cholembera

Muthanso kujambula chithunzithunzi pochidziwitsa kuti chikhale cholembera.

1. Timadula khungu lomwe timaganizira zoika chithunzicho ndi batani la mbewa yoyenera. Pazosankha zofanizira, sankhani Ikani Chidziwitso.



2. Iwindo laling'ono limatsegulira zolemba. Timasunthira chotembezera kumalire ake ndikudina. Zosintha zamtundu wina zimawonekera. Sankhani chinthu mmenemo "Zolemba.



3. Pazenera lotseguka lokonza mawonekedwe amawu, pitani tabu "Mitundu ndi mizere". Mu makatani "Dzazani" dinani pamunda "Mtundu". Pamndandanda womwe umatseguka, pitani kujambula "Njira zodzaza ...".



4. Dongosolo lodzaza limatseguka. Pitani ku tabu "Zojambula", kenako dinani batani ndi dzina lomweli.



5. Zenera lowonjezera limatsegulidwa, chimodzimodzi monga tafotokozera pamwambapa. Sankhani chithunzi ndikudina batani Ikani.



6. Chithunzi chikuwonjezeredwa pazenera "Njira zodzaza". Chongani bokosi pafupi ndi chinthucho "Sungani chiyerekezo". Dinani batani "Zabwino".



7. Pambuyo pake tibwerera pazenera "Zolemba. Pitani ku tabu "Chitetezo". Sakani kusankha njira "Chotetezedwa".



8. Pitani ku tabu "Katundu". Khazikitsani kusintha "Sinthani ndikusintha chinthu ndi maselo". Kutsatira izi, dinani batani "Zabwino".

Pambuyo pochita zonse zomwe zatchulidwa pamwambapa, chithunzicho sichingoyikidwa kokha mu cholembera foni, chimangirizidwanso nacho. Zachidziwikire, njirayi sioyenera aliyense, popeza kuyika chikalatacho kumaletsa zoletsa zina.

Njira 3: Njira Yopangira

Mutha kulumikizanso zithunzi pafoni kudzera pa pulogalamu yaukadaulo. Vuto ndilakuti mwakukhazikika mtundu wopanga sukonzekera. Chifukwa chake, choyamba, tifunika kuyatsegula.

1. Kukhala mu tabu Fayilo pitani pagawo "Zosankha".



2. Pazenera losankha, sinthani ku gawo laling'ono Kukhazikika kwa Ribbon. Chongani bokosi pafupi "Wopanga" kumanja kwa zenera. Dinani batani "Zabwino".



3. Sankhani khungu lomwe mukufuna kukonza chithunzi. Pitani ku tabu "Wopanga". Adawoneka titatha kugwiritsa ntchito njira zofananira. Dinani batani Ikani. Pazosankha zomwe zimatseguka, muzikhala ActiveX amazilamulira sankhani "Chithunzi".



4. Gawo la ActiveX limawoneka ngati cholembera zopanda kanthu. Sinthani kukula kwake pokokera m'malire ndikuyika mu cell momwe mukufuna kukhazikitsa chithunzicho. Dinani kumanja pa chinthu. Pazosankha zofanizira, sankhani "Katundu".



5. Zenera la katundu limatsegulidwa. Paramu wotsutsa "Kuyika" khazikitsani chithunzi "1" (mosalephera "2") Mu mzere wa chizindikiro "Chithunzi" dinani batani lomwe likuwonetsa ellipsis.



6. Tsamba loyika chithunzilo limatseguka. Tikufuna chithunzithunzi chomwe mukufuna, sankhani ndikudina batani "Tsegulani".



7. Pambuyo pake, mutha kutseka zenera. Monga mukuwonera, chithunzicho chatayikidwa kale. Tsopano tifunika kulumikizira tokha mu cell. Sankhani chithunzi ndikupita ku tabu Masanjidwe Tsamba. Mu makatani Sanjani pa tepi dinani batani Gwirizanani. Kuchokera pa menyu wotsika, sankhani Lumikizanani ndi Gridi. Kenako timayenda pang'ono m'mphepete mwa chithunzicho.

Pambuyo pochita izi pamwambapa, chithunzicho chidzalumikizidwa ku gridi ndi foni yosankhidwa.

Monga mukuwonera, mu pulogalamu ya Excel pali njira zingapo zoikitsira fano mu khungu ndikuziphatikiza. Inde, njira yokhala ndi cholembera mu notsi siyoyenera kwa onse ogwiritsa ntchito. Koma zosankha ziwirizi ndizaponseponse ndipo aliyense ayenera kusankha kuti ndi iti yomwe ingakhale yoyenera kwa iye ndikukwaniritsa zolinga za kuyika momwe angathere.