Zolemba mu Excel - momwe mungapangire, kuwona, kusintha, kufufuta ndi kuwonjezera chithunzi

Ogwiritsa ntchito novice ambiri a Excel akudziwa bwino za vutolo kuti ndikovuta kwambiri kuyika zidziwitso zambiri m'maselo, palibe pomwe mungasiyire zolemba zanu mtsogolo. M'malo mwake, kuchita izi popanda kuphwanya mawonekedwe a tebulo ndikosavuta. Ndizo zomwe zolemba zimapangidwira.

Kugwira Ntchito ndi Zolemba

Zolemba ndizowonjezera zowonjezera zamaselo osankhidwa. Nthawi zambiri zimakhala zolembedwa ndipo zimakhala ndi ndemanga yeniyeni ya m'modzi mwa olemba patebulo. Kuphatikiza pa zolemba, mutha kuwonjezera chithunzi kumunda womwe ukuwoneka. Komabe, kuti muphatikize ndemanga kapena chithunzi chomwe mukufuna ku cell, muyenera kuphunzira kupanga zilembo zosavuta, kuziwona ndikusintha.. Pambuyo pake, mukhoza kupita ku zoikamo zapamwamba.

Chilengedwe

Njira yopangira zolemba ndiyosavuta ndipo imakhala ndi njira zingapo:

1. Sankhani selo patebulo ndi mbewa. Dinani kumanja pa izo.
2. Kuchokera ku menyu omwe akuwoneka, sankhani ntchito ya "Insert Note".

3. Pambuyo pake, gawo laulere lidzawonekera kumbali ya selo losankhidwa. Mzere wapamwamba udzakhala ndi dzina lolowera.

Mutha kuyika zambiri zamalemba m'munda waulere. Kuti mubise ndemanga, muyenera dinani kumanja pa selo, sankhani ntchito ya "Bisani Ndemanga". Pambuyo pake, ipezeka kuti iwerengedwe pa ulalo womwe ukuwonetsedwa ndi ngodya yofiira.

Review

Mutha kuwona ndemanga zamaselo osiyanasiyana poyang'ana pa aliyense wa iwo ndi cholozera cha mbewa. Pambuyo pake, mawu omwe ali ndi cholembacho amadziwonekera okha. Kuti gawo la ndemanga lizimiririka, muyenera kusuntha cholozera kumalo ena.

Malangizo a akatswiri! Ngati tebulo ndi lalikulu, ndipo liri ndi zolemba zambiri zomwe zimamangiriridwa ku maselo osiyanasiyana, mukhoza kusinthana pakati pawo kudzera pa "Review" tabu. Kwa izi, mabatani "Previous" ndi "Next" amapangidwa.

Kusintha

Nthawi zambiri pamakhala zinthu zomwe zimafunika kusintha zomwe zili pawindo kuti muwonjezere ndemanga. Mutha kuchita izi potsatira njira zingapo:

1. Poyamba dinani pa selo ndi malemba obisika ndi batani lakumanja la mbewa.
2. Pamndandanda womwe umawonekera, sankhani ntchito ya "Sinthani Chidziwitso".
3. Zenera liyenera kutsegulidwa momwe mungasinthire zolembazo, kuwonjezera zithunzi, kuwonjezera kapena kuchepetsa gawo la ndemanga.

Mukhoza kumaliza zoikamo podina paliponse patebulo kunja kwa gawolo kuti mupeze mawu owonjezera.

Njira ina yosinthira ndemanga zama cell ndi kudzera pa Review tabu. Apa muyenera kupeza zida zolembera ndikudina batani "Sinthani".

Kuwonjeza chithunzi

Chimodzi mwazinthu zosangalatsa zamanotsi mu Excel ndikuwonjezera kwa zithunzi zomwe zimawonekera mukamayenda pamaselo osankhidwa. Kuti muwonjezere chithunzi, muyenera kuchita zingapo:

1. Poyamba, muyenera kuwonjezera siginecha yowonjezera mu selo yosankhidwa.
2. Pitani ku ndondomeko yokonza zolemba, lunjikani cholozera cha mbewa ku imodzi mwa malire a selo. Ndikofunika kuwongolera kumalo komwe chizindikiro chokhala ndi mivi inayi chidzawonekera, chomwe chimasiyana mosiyana.
3. Muyenera dinani kumanja pa chithunzichi, sankhani "Note Format" pa menyu yomwe ikuwoneka.
4. Zenera la zosintha liyenera kuwonekera pamaso pa wogwiritsa ntchito. Muyenera kupeza "Colors ndi Mizere" tabu ndi kusintha kwa izo.
5. Dinani pa mndandanda wotsitsa wotchedwa "Color", pansi pa mndandanda womwe ukuwonekera, sankhani "Njira Zodzaza".
6. Zenera latsopano liyenera kuwoneka momwe muyenera kupita ku tabu "Kujambula". Mkati mwa tsambali, dinani batani lomwe lili ndi dzina lomwelo.
7. Zenera la "Insert Images" lidzawonekera, momwe muyenera kusankha chimodzi mwazinthu zitatu: kwezani chithunzi kuchokera ku OneDrive, fufuzani chithunzi pogwiritsa ntchito Bing, kwezani chithunzi kuchokera pakompyuta. Njira yosavuta ndiyo kukweza kuchokera pakompyuta pomwe chikalatacho chili.

8. Chithunzi chikasankhidwa, chimangosintha kupita pawindo lapitalo momwe chithunzi chosankhidwa chidzawonetsedwa. Apa muyenera kuyika bokosi pafupi ndi ntchito "Sungani kuchuluka kwa chithunzicho."
9. Mukadina batani la "Chabwino", zenera loyang'anira zolemba lidzatsegulidwa. Pakadali pano, muyenera kumangirira cholembacho ndi chithunzicho ku cell yomwe idasankhidwa poyamba. Kuti muchite izi, muyenera kupita ku tabu "Chitetezo", osayang'ana bokosi pafupi ndi "Chinthu Chotetezedwa".
10. Kenako, muyenera kupita ku tabu "Properties", fufuzani bokosi pafupi ndi chinthu chosuntha ndikusintha zinthu pamodzi ndi ma cell. Dinani pa batani "Chabwino".

Kuti mukulitse chithunzicho, ndikofunikira kutambasula gawo lazolembazo mosiyanasiyana.

Kuchotsa cholemba

Kuchotsa siginecha yowonjezeredwa ndikosavuta kuposa kukhazikitsa yatsopano kapena kuyisintha. Kuti muchite izi, dinani kumanja pa selo lomwe lili ndi malongosoledwe owonjezera. Kuchokera pa menyu yowonekera, yambitsani lamulo la "Delete note".

Njira yachiwiri yochotsera chizindikiro chowonjezera ku selo yosankhidwa ndi ntchito ya "Review". Musanasankhe izi, muyenera kuyika chizindikiro pa cell ndi mbewa. Pomaliza, dinani batani Chotsani zidziwitso zowonjezera.

Momwe mungasaina cholemba mu Excel

Ngati mu chikalata chimodzi chogawidwa cha Excel zosintha zonse zowonjezera pamaselo zimalembedwa ndi ogwiritsa ntchito osiyanasiyana popanda siginecha iliyonse, zidzakhala zovuta kwambiri kupeza wolemba zina. Mawu a cholembacho amakulolani kuti mukonzekere deta. Kuti muyisiye pamwamba pa kusintha kwina kwa selo, muyenera kuchita zingapo:

1. Sankhani chimodzi mwazinthu zazikulu za menyu "Fayilo".
2. Pitani ku "Zikhazikiko".
3. Pitani ku tabu "General".

4. Munda waulere udzawonekera pansi pa tsamba, momwe muyenera kuyika dzina la wogwiritsa ntchito yemwe wasiya ndemanga pa selo.

Momwe mungapezere cholemba mu Excel

Ngati chikalatacho ndi chachikulu kwambiri, pangakhale zochitika zomwe muyenera kupeza mwamsanga ndemanga yeniyeni. Pangani zotheka. Malangizo opezera malongosoledwe ofunikira kapena zilembo:

1. Pitani ku tabu "Home".
2. Pitani ku gawo la "Pezani ndi kusankha".
3. Dinani pa "Zikhazikiko" batani.
4. Pezani mwayi kusankha "Search scope".
5. Khazikitsani mtengo kuti Dziwani.
6. Dinani pa batani "Pezani Zonse".

Pambuyo pake, mndandanda wokhala ndi maselo molingana ndi gawo lokhazikitsidwa lidzawonekera pamaso pa wogwiritsa ntchito.

Kuwonetsa ndi kubisa cholemba

Ngati mukufuna, mutha kubisa zonse zolembazo kuti zisakhale zowonekera powerenga chikalata chachikulu, kapena kuletsa ntchito yobisala ngati idatsegulidwa kale. Kuti muchite izi, muyenera kutsatira njira zingapo zosavuta:

1. Pitani ku zoikamo zonse pa "Fayilo" tabu, ndiye "Zosankha", pitani ku gawo la "Zapamwamba".
2. Pezani gawo la "Screen".
3. Chongani bokosi pafupi ndi "Zolemba ndi zizindikiro" ntchito.
4. Dinani pa batani "Chabwino". Pambuyo pake, zolemba zobisika zidzawonetsedwa nthawi zonse. Kuti muwabise kwathunthu, muyenera kuyang'ana bokosi pafupi ndi ntchito ya "Palibe zolemba, palibe zizindikiro".

Malangizo a akatswiri! Excel ili ndi mwayi wowonetsa ndemanga pawokha. Kuti izi zitheke, muyenera dinani kumanja pa selo ndi malongosoledwe owonjezera, dinani batani la "Show Notes". Kotero iwo adzawonetsedwa kwanthawi zonse pamaselo osankhidwa. Kupyolera mu mndandanda womwewo, mutha kubisala kufotokozera mwachidule m'malo ofunikira.

Kukopera cholemba kumaselo ena

Ngati cholemba chapangidwa kale, mutha kuchikopera ku cell ina kuti musalembenso mawuwo. Kuti muchite izi, tsatirani malangizo osavuta:

1. Dinani kumanja kuti musankhe selo lomwe lili mu chikalata chomwe mafotokozedwe achidule kapena kusintha kwalumikizidwa.
2. Kuchokera ku menyu omwe amawonekera, sankhani "Copy" ntchito.
3. Pezani selo lomwe mukufuna kumangirirako cholembacho, sankhani podina batani lakumanzere.
4. Pitani ku "Home" tabu, ndiye sankhani "Clipboard", dinani pa "Matani" batani.
5. Mndandanda wa malamulo udzawonekera pamaso pa wogwiritsa ntchito. Chochititsa chidwi ndi "Paste Special". Mukadina, zenera lapadera la zoikamo lidzawonekera, pomwe muyenera kuyang'ana bokosi pafupi ndi zolemba. Ikutsalira kupulumutsa zosintha podina "Chabwino".

Momwe mungasindikize pepala

Ngati simusintha zina, mwachisawawa, zolemba za Excel zimasindikizidwa popanda zolemba. Kuti muwonjezere ku zosindikiza, muyenera kukonza pulogalamuyo:

1. Pitani ku gawo la "Mapangidwe a Tsamba".
2. Pitani ku tabu ya "Kukhazikitsa Tsamba", kenako dinani "Print Headers".

3. Zenera lokhala ndi zinthu zilizonse zosindikiza lidzatsegulidwa. Motsutsana ndi mawu oti "Zolemba", mutha kuziwonjezera pazosindikiza kapena kusiya izi zichotsedwa.

Malangizo a akatswiri! Powonjezera zolemba kuti musindikize, pali njira ziwiri zowonetsera pa chikalata chosindikizidwa. Ngati musankha "Kumapeto kwa pepala" - adzawonekera pansi pa tsamba. Mukhoza kusankha njira "Monga pa pepala" - zolembazo zidzasindikizidwa monga momwe zikuwonekera pamagetsi a chikalatacho.

Kusintha dzina lolowera popanga zolemba

Mukamagwira ntchito ku Excel ndikugawana nawo, mukapanga zolemba, samapatsidwa dzina la wogwiritsa ntchito amene amawasiya. Kuti musinthe kukhala dzina lanu lotchulidwira, muyenera kutsatira njira zingapo:

1. Pakona yakumanzere yakumanzere, dinani tabu "Fayilo".
2. Pitani ku gawo la "Zikhazikiko", "General".
3. Sankhani "Username" pa menyu yomwe ikuwoneka.
4. Munda waulere udzatsegulidwa pamaso pa wogwiritsa ntchito, momwe m'pofunika kulemba dzina lomwe mukufuna.

Zitsanzo za kugwiritsa ntchito zolemba mu Excel

Kuti mumvetsetse momwe ndemanga zowonjezera za cell mu Excel spreadsheet zingathandizire, tikulimbikitsidwa kuti tiganizire zitsanzo zingapo zothandiza kuchokera pazomwe ogwiritsa ntchito ena adakumana nazo:

1. Pamene antchito a kampani imodzi ali ndi ntchito yofanana yolembedwa mu chikalata cha Excel, ogwira nawo ntchito pa tsamba lomwelo mosinthana akhoza kusiya ndemanga ngati osintha, kupereka malangizo, kusinthanitsa zina.
2. Kuyika kwa zithunzi - ngati tebulo lili ndi deta yokhudzana ndi anthu ena, zithunzi za zinthu zilizonse, ngati zimakhudza kusungidwa kwawo, kugulitsa.

3. Kufotokozera kwa mafomu omwe angathandize kuwerengera kwina, kuwerengera.

Ngati musiya ndemanga m'njira yoyenera - kuti ziwonekere panthawi yoyenera komanso kuti musasokoneze ntchito ya ogwiritsa ntchito ena, mutha kukulitsa kwambiri zokolola zantchito yokhudzana ndi matebulo mu Excel.

Maphunziro amakanema pazolemba mu Excel

Malangizo omwe ali pamwambawa akuthandizani kumvetsetsa zoyambira pakupanga, kusintha, kuwonera, kuyika kwapamwamba kwamawu kuma cell mu Excel spreadsheet. Komabe, ngati mukukumana ndi zovuta zilizonse, zovuta ndi zochita zina zokhudzana ndi zolemba, tikulimbikitsidwa kuti muwone mavidiyo ophunzitsira. Ali ndi malangizo a pang'onopang'ono pochita ntchito zosiyanasiyana ndi ndemanga zama cell.

Kutsiliza

Kupanga, kusintha ndikuwona ndemanga pamaselo osiyanasiyana mu Excel sikovuta monga momwe zingawonekere poyang'ana koyamba. Zidzakhala zothandiza kukhala ndi luso loterolo osati kwa anthu omwe amagwira ntchito m'mabungwe akuluakulu, kusunga chinachake pogwiritsa ntchito matebulo, komanso kwa ogwiritsa ntchito osakwatiwa omwe amagwira ntchito ku Excel okha. Sitiyenera kuiwala kuti m'gawo la zolemba simungathe kuwonjezera zolemba zokha, komanso zithunzi, zomwe zimawonjezera phindu lawo pantchito.