Bisani mizere ndi maselo mu Microsoft Excel

Mukamagwira ntchito ku Excel, nthawi zambiri mutha kukumana ndi gawo pomwe gawo lalikulu la masanjidwewo limangogwiritsidwa ntchito kuwerengera ndipo samakhala ndi chidziwitso kwa wogwiritsa ntchito. Izi zimangotenga malo ndipo zimasokoneza chidwi. Kuphatikiza apo, ngati wogwiritsa ntchitoyo aphwanya dongosolo lawo mwangozi, izi zitha kubweretsa kusokonezedwa kwa kuwerengera konsekonse muzolemba. Chifukwa chake, ndibwino kubisa mizere kapena maselo amtundu umodzi palokha. Kuphatikiza apo, mutha kubisa deta yomwe siyofunika posakhalitsa kuti isasokoneze. Tiyeni tiwone kuti izi zingachitike bwanji.

Bisani ndondomeko

Pali njira zingapo zosiyana zobisira maselo ku Excel. Tiyeni tikhazikike pa aliyense wa iwo, kuti wogwiritsa ntchito athe kumvetsetsa zomwe zingakhale zosavuta kwa iye kugwiritsa ntchito njira ina.

Njira 1: Gulu

Njira imodzi yodziwika bwino yobisira zinthu ndikuyiyika m'magulu.

1. Sankhani mizere ya pepala yomwe mukufuna kuyika, kenako ndikubisala. Sikoyenera kusankha mzere wonse, koma mutha kuyika chizindikiro chimodzi mu mizere yamagulu. Kenako, pitani tabu "Zambiri". Mu block "Kapangidwe", yomwe ili pa riboni ya chida, dinani batani "Gulu".



2. Windo laling'ono limatsegulira lomwe limakupatsani mwayi wosankha zomwe zimayenera kukhala m'magulu: mizere kapena mzati. Popeza tikufunika kugawa mizere ndendende, sitisintha pazosintha, chifukwa kusinthaku kumangokhala kumene tikufunika. Dinani batani "Zabwino".



3. Pambuyo pa izi, gulu limapangidwa. Kuti mubise zomwe zili momwemo, ingodinani pachizindikirocho ngati chizindikiro opanda. Ili kumanzere kwa gulu lounikira.



4. Monga mukuwonera, mizereyo yabisika. Kuti muwawonetse kachiwiri, dinani chikwangwani kuphatikiza.

Phunziro: Momwe mungapangire gulu ku Excel

Njira 2: kukokera maselo

Njira yolondola kwambiri yobisira zomwe zili m'maselo mwina ikukoka m'malire a mizere.

1. Khazikitsani cholowetsa pagawo lolinganizidwa, komwe manambala amodzi alembedwa, mpaka kumunsi kwa mzere komwe zomwe tikufuna kubisa. Poterepa, chowavumbulutsa amayenera kusinthidwa kukhala chithunzi mu mawonekedwe a mtanda wokhala ndi cholembera chawiri, chomwe chimawongoleredwa chokweza pansi. Kenako gwiritsani batani lakumanzere ndikusuntha cholembayo mpaka malire ndi m'munsi mwa mzere atsekedwe.



2. Mzerewu udzabisika.

Njira 3: maselo agulu pokokera ndi kutsitsa maselo

Ngati mukufuna kubisa zinthu zingapo nthawi imodzi pogwiritsa ntchito njirayi, ndiye muyenera kusankha kaye.

1. Timagwira batani lamanzere lamanzere ndikusankha pagawo lolozera lomwe limagwirizana ndi gulu la mizere yomwe tikufuna kubisa.

   

   Ngati mtunduwo ndi waukulu, ndiye kuti mutha kusankha zinthu motere: dinani kumanzere kuti mupeze nambala ya mzere woyamba wa gulu loyanjanalo, ndiye gwiritsani batani Shift ndikudina nambala yotsiriza ya chiwerengero chomwe mukufuna.

   

   Mutha kusankha mizere ingapo yosiyana. Kuti muchite izi, kwa aliyense wa iwo muyenera dinani batani lakumanzere pomwe mukugwira kiyi Ctrl.



2. Khalani otemberera pamphepete mwa mzere uliwonse wa mizere iyi ndikuyikoka mpaka malire atatsekedwa.



3. Izi sizingobisalira mzere womwe mukugwiritsa ntchito, komanso mizere yonse yamtundu wosankhidwa.

Njira 4: menyu wankhani

Njira ziwiri zam'mbuyomu, ndizothandiza kwambiri komanso ndizosavuta kugwiritsa ntchito, komabe sizingatsimikizire kuti maselo amabisika kwathunthu. Nthawi zonse pamakhala malo ochepa, ogwiramo omwe mungakulitse cell kumbuyo. Mutha kubisala mzere pogwiritsa ntchito menyu.

1. Timapereka mizere m'njira imodzi mwanjira zitatu, zomwe tidakambirana pamwambapa:
   • kokha ndi mbewa;
   • kugwiritsa ntchito kiyi Shift;
   • kugwiritsa ntchito kiyi Ctrl.



2. Timadina pamzera woyenera wotsogola ndi batani la mbewa yoyenera. Zosintha zamakina zikuwoneka. Chizindikiro "Bisani".



3. Mzere wokwera udzabisika chifukwa cha zomwe tatchulazi.

Njira 5: tepi ya zida

Mutha kubisanso mizere pogwiritsa ntchito batani pazida.

1. Sankhani ma cell omwe ali m'mizere yomwe mukufuna kubisala. Mosiyana ndi njira yakale, sikofunikira kusankha mzere wonse. Pitani ku tabu "Pofikira". Dinani batani pazida. "Fomu"yomwe imayikidwa mu block "Maselo". Pa mndandanda womwe ukuyambira, sinthani chowonetsa pachinthu chimodzi m'gululo "Kuwoneka" - Bisani kapena onetsani. Pazowonjezera, sankhani chinthu chomwe chikufunika kuti mukwaniritse cholinga - Bisani Mizere.



2. Pambuyo pake, mizere yonse yomwe inali ndi maselo osankhidwa m'ndime yoyamba idzabisika.

Njira 6: kusefa

Kuti mubise zomwe sizofunikira posachedwa kuti zisasokoneze, mutha kuyika kusefa.

1. Sankhani tebulo lonse kapena limodzi mwa maselo ake mumutu. Pa tabu "Pofikira" dinani pachizindikiro Sanjani ndi Fyulutayomwe ili mgululi "Kusintha". Mndandanda wamachitidwe umatseguka, pomwe timasankha chinthucho "Zosefera".

   

   Mutha kuchita zina. Mukasankha tebulo kapena mutu, pitani tabu "Zambiri". Mabatani akuwona "Zosefera". Ili pa tepi mu block. Sanjani ndi Fyuluta.



2. Kulikonse mwa njira ziwiri zomwe mukugwiritsira ntchito, chithunzi cha zosefera chidzawonekera m'maselo am'mutu. Kakulimbo kakang'ono kakang'ono komwe kamaloza pansi. Timadulira chizindikiro ichi mu mzere womwe uli ndi lingaliro lomwe tidzafefa.



3. Zosankha zosewerera zimatseguka. Dziwani zofunikira zomwe zili m'mizere yomwe zingabisike. Kenako dinani batani "Zabwino".



4. Pambuyo pa izi, mizere yonse komwe kuli ndizofunika zomwe tidadutsamo zizabisidwa pogwiritsa ntchito zosefera.

Phunziro: Sanjani ndi kusefa deta mu Excel

Njira 7: kubisa maselo

Tsopano tiyeni tikambirane momwe tingabisire maselo amtundu uliwonse. Mwachilengedwe, sizingachotsedwe kwathunthu ngati mizere kapena mizati, chifukwa izi ziziwononga kapangidwe ka chikalatacho, komabe pali njira, ngati sichitha kubisala zinthuzo, ndiye kubisa zomwe zalembedwazo.

1. Sankhani khungu limodzi kapena zingapo kuti zibisike. Timadina pachidutswa chosankhidwa ndi batani loyenera la mbewa. Zosankha zam'mawu zimatsegulidwa. Sankhani zomwe zili mmenemo "Mtundu wamtundu ...".



2. Tsamba losintha likuyamba. Tiyenera kupita pa tabu yake. "Chiwerengero". Komanso mu gawo lachitetezo "Mawerengero Amanambala" sonyezani malo "Makonda onse". Gawo lamanja la zenera m'mundawo "Mtundu" timayendetsa motere:

   ;;;

   Dinani batani "Zabwino" kuti musunge zoikamo.



3. Monga mukuwonera, zitatha izi zonse zomwe zimapezeka mu maselo osankhidwa zidasowa. Koma anangowona ndi maso, ndipo ndikupitabe komweko. Kuti mutsimikizire izi, ingoyang'anani mzere wa mawonekedwe momwe amawonetsera. Ngati mukufunikiranso kuwonetsera kuwonetsedwa kwa maselo, muyenera kusintha mawonekedwe omwe ali m'mayikowo kukhala amodzi omwe anali kale kudzera pazenera la mitundu.

Monga mukuwonera, pali njira zingapo zomwe mungabise mizere ku Excel. Komanso ambiri aiwo amagwiritsa ntchito matekinoloje osiyanasiyana: kusefa, kupanga magulu, kusintha malire. Chifukwa chake, wogwiritsa ntchito ali ndi zida zambiri zosankhira ntchito yothetsera ntchitoyi. Atha kugwiritsa ntchito njira yomwe akuwona kuti ndi yoyenera pankhani inayake, komanso kuti ikhale yabwino kwambiri komanso yosavuta kwa iye. Kuphatikiza apo, pogwiritsa ntchito masanjidwe, ndizotheka kubisa zomwe zili m'maselo amodzi.