Chotsani mzere mu Microsoft Excel

Pogwira ntchito ndi Excel, nthawi zambiri mumayenera kusintha njira yochotsera mizere. Njirayi imatha kukhala imodzi kapena gulu, kutengera ntchito zomwe mwapatsidwa. Chosangalatsa kwambiri pankhaniyi ndikuchotsedwa pamikhalidwe. Tiyeni tiwone zosankha zingapo za njirayi.

Njira yochotsera

Kuchotsa stitch kumatha kuchitidwa m'njira zosiyanasiyana. Kusankhidwa kwa yankho kumadalira ntchito zomwe wogwiritsa ntchito amadzipangira. Ganizirani zosankha zingapo, kuchoka pa njira zosavuta mpaka zovuta.

Njira 1: kuchotsera kamodzi kudzera menyu

Njira yosavuta yochotsa stitches ndi mtundu umodzi wa njirayi. Mutha kuyigwiritsa ntchito menyu.

1. Dinani kumanja pa maselo aliwonse amzera omwe mukufuna kuti achotse. Pazosankha zomwe zikuwoneka, sankhani Chotsani ... ".



2. Iwindo laling'ono limatseguka pomwe muyenera kufotokozera zomwe zimayenera kuchotsedwa. Timasintha kusintha "Mzere".

   

   Pambuyo pake, chinthu chomwe chatchulidwa chidzachotsedwa.

   Mukhozanso dinani kumanzere kwa nambala ya mzere mumadongosolo ofikira. Kenako, dinani kusankha ndi batani loyenera la mbewa. Pazosankha zomwe zayambitsidwa, sankhani chinthucho Chotsani.

   

   Potere, njira yochotsera imachitika nthawi yomweyo ndipo palibe chifukwa chochitira zina zowonjezera pazenera posankha chinthu chokonzera.

Njira 2: Kuchotsera Amodzi Pogwiritsa Ntchito Zida za Matepi

Kuphatikiza apo, njirayi imatha kuchitika pogwiritsa ntchito zida zomwe zili pa riboni, zomwe zimapezeka pa tabu "Pofikira".

1. Pangani zosankha kulikonse pamzere womwe mukufuna kuchotsa. Pitani ku tabu "Pofikira". Timadina pachizindikiro mu mawonekedwe a kakang'ono kakang'ono, komwe kali kumanja kwa chithunzi Chotsani mu bokosi la zida "Maselo". Mndandanda umawoneka momwe muyenera kusankha chinthucho Chotsani mizera ".



2. Chingwecho chimachotsedwa nthawi yomweyo.

Muthanso kusankha mzere wonsewo ndikudina kumanzere kwa nambala yake mumadongosolo oyenda. Pambuyo pake, kukhala mu tabu "Pofikira"dinani pachizindikiro Chotsaniili m'bokosi la chida "Maselo".

Njira 3: kuchotsedwa kwa zochuluka

Kuti muchotse zidutswa za gulu, choyambirira, muyenera kusankha zinthu zofunika.

1. Kuti muthane ndi mizere ingapo yoyandikana, mutha kusankha maselo owonera omwe ali mgulu limodzimodzi. Kuti muchite izi, gwiritsani batani lamanzere lamanzere ndikusuntha chotembezera pazinthu izi.

   

   Ngati mtunduwo ndi waukulu, ndiye kuti mutha kusankha maselo apamwamba kwambiri mwa kuwonekera kumanzere. Kenako gwiritsani fungulo Shift ndikudina foni yotsika kwambiri pamtundu womwe mukufuna kufafaniza. Zinthu zonse zapakati pawo zidzawonetsedwa.

   

   Ngati mukufuna kufufutira mizere yomwe ili kutali ndi mzake, ndiye kuti muwasankhe, dinani chimodzi mwamaselo omwe ali mkati mwaiwo, dinani kumanzere ndi fungulo lomwelo Ctrl. Zinthu zonse zosankhidwa zidzayikidwa chizindikiro.



2. Kutsata njira yachindunji yochotsera mizere, timayitanitsa mitu yankhani kapena kupita ku zida zomwe zili pa tepi, kenako ndikutsatira malangizowo omwe adaperekedwa pakufotokozera njira zoyambirira ndi zachiwiri za bukuli.

Muthanso kusankha zinthu zofunika kudzera pazenera zolumikizira. Pankhaniyi, sikuti maselo amodzi omwe adzawunikidwa, koma mizere yonse.

1. Kuti musankhe mizere yoyandikana ndi mizere, gwiritsani pansi batani lakumanzere ndikusuntha chotembezera pazogwirizanitsa yolumikizana kuchokera pazomwe zili mzere zomwe zimayenera kuchotsedwa pansi.

   

   Mutha kugwiritsa ntchito njira pogwiritsa ntchito fungulo Shift. Dinani kumanzere pamzere woyamba wa nambala yomwe ichotsedwe. Kenako gwiritsani fungulo Shift ndikudina nambala yomaliza yatsambalo. Mizere yonse pakati pa manambala awa iwonetsedwa.

   

   Ngati mizere yochotsedwa yabalalika papepala ndipo osalumikizana wina ndi mnzake, ndiye kuti mukuyenera, dinani manambala onse kumanzere onse pamzere wolozera ndi kiyi yosindikizidwa Ctrl.



2. Kuti muchotse mizere yomwe mwasankha, dinani kumanja kusankha kulikonse. Pazosankha, onani Chotsani.

   

   Ntchito yochotsa zinthu zonse zosankhidwa zizachitika.

Phunziro: Momwe mungasankhire zosankha mu Excel

Njira 4: chotsani zopanda kanthu

Nthawi zina patebulopo pamakhala mizere yopanda kanthu, deta yomwe amachotsamo kale. Zinthu zotere zimachotsedwapo bwino. Ngati ali pafupi ndi mnzake, ndiye kuti ndizotheka kugwiritsa ntchito imodzi mwanjira zomwe tafotokozazi. Koma bwanji ngati pali mizere yambiri yopanda kanthu ndipo itamwazikana pang'onopang'ono malo a tebulo lalikulu? Kupatula apo, njira yofufuzira ndikuchotsa zimatha kutenga nthawi yayitali. Kuti muchepetse yankho la vutoli, mutha kugwiritsa ntchito ma algorithm omwe afotokozedwa pansipa.

1. Pitani ku tabu "Pofikira". Pa chida, dinani chizindikiro Pezani ndikuwunikira. Ili pagulu "Kusintha". Pamndandanda womwe umatsegulira, dinani chinthucho "Sankhani gulu la maselo".



2. Iwindo laling'ono posankha gulu la maselo limayambitsidwa. Timayika momwemo zosinthira Maselo opanda kanthu. Pambuyo pake, dinani batani "Zabwino".



3. Monga tikuwona, tikatha kutsatira izi, zinthu zonse zopanda kanthu zimasankhidwa. Tsopano mutha kugwiritsa ntchito kuchotsa njira zilizonse zomwe tafotokozazi. Mwachitsanzo, mutha dinani batani Chotsaniili pa riboni mumtundu womwewo "Pofikira"komwe tikugwira ntchito tsopano.

   

   Monga mukuwonera, zinthu zonse zopanda kanthu za tebulo zichotsedwa.

Tcherani khutu! Mukamagwiritsa ntchito njirayi, mzerewu uyenera kukhala wopanda chilichonse. Ngati tebulo lili ndi zinthu zopanda mzere zomwe zili ndi zina, monga chithunzi pansipa, njirayi siyingagwiritsidwe ntchito. Kugwiritsa ntchito kwake kungapangitse kusintha kwa zinthu komanso kuphwanya kapangidwe ka tebulo.

Phunziro: Momwe mungachotsere mizere yopanda kanthu ku Excel

Njira 5: kugwiritsa ntchito kukonza

Kuti muchotse mizere ndi vuto linalake, mutha kuyikonza. Popeza talinganiza zinthuzo malinga ndi cholinganiza chokhazikitsidwa, titha kutolera mizere yonse yomwe ikukhutitsa zinthuzo, ngati zili zomwazikana patebulopo, ndikuchotsa mwachangu.

1. Sankhani gawo lonse la tebulo momwe mungasankhire, kapena imodzi mwa maselo ake. Pitani ku tabu "Pofikira" ndikudina chizindikiro Sanjani ndi Fyulutalomwe lili mgululi "Kusintha". Pamndandanda wazinthu zomwe zingatsegule, sankhani Makonda.

   

   Zochita zina zitha kutengedwanso zomwe zimathandizanso kutsegulidwa kwa zenera losankha. Mukasankha chilichonse patebulo, pitani ku tabu "Zambiri". Pamenepo m'magulu azokonda Sanjani ndi Fyuluta dinani batani "Sinthani".



2. Tsamba losintha mwambo likuyamba. Onetsetsani kuti mwayang'ana bokosi, ngati likupezeka, pafupi ndi chinthucho "Zambiri zanga zimakhala ndi mutu"ngati tebulo lanu lili ndi mutu. M'munda Longosolani muyenera kusankha dzina la chipilalachi pomwe kusankha kwa zochotsa kumachitika. M'munda "Sinthani" muyenera kunena kuti kusankha komwe kudzachitike:
   • Makhalidwe;
   • Mtundu wama cell;
   • Mtundu wamafuta;
   • Chizindikiro cha foni.

   Zonse zimatengera momwe zinthu ziliri, koma nthawi zambiri mawonekedwewo ndi oyenera "Makhalidwe". Ngakhale mtsogolomo tikambirana za kugwiritsa ntchito mawonekedwe ena.

   M'munda "Order" muyenera kutengera momwe madongosolo azisungidwira. Kusankhidwa kwa njira mugawo lino kumatengera mtundu wamtundu wosankhidwa. Mwachitsanzo, pazomwe zalembedwa, zolemba zidzakhala "Kuyambira A mpaka Z" kapena "Kuyambira Z mpaka A", komanso za tsikulo "Kuyambira kale mpaka watsopano" kapena "Kuyambira watsopano mpaka wakale". Kwenikweni, dongosolo lokha silikhala ndi zambiri, chifukwa mulimonsemo, malingaliro azokondweretsa kwa ife azikhala limodzi.
   Pambuyo pazomwe zenera ili lizenera kumaliza, dinani batani "Zabwino".



3. Zosankha zonse za mzere wosankhidwa zidzasanjidwa ndi njira zomwe zatchulidwa. Tsopano titha kusankha zinthu zapafupi ndi njira zilizonse zomwe zidakambidwa poganizira njira zam'mbuyomu, ndikuzichotsa.

Mwa njira, njira yomweyi ingagwiritsidwe ntchito polemba gulu ndikuchotsa unyinji wa mizere yopanda kanthu.

Yang'anani! Tiyenera kudziwa kuti mukamapanga mtundu wamtunduwu, mutachotsa maselo opanda kanthu, malo omwe mizereyo idzasiyanane ndi yoyambayo. Nthawi zina izi sizofunikira. Koma, ngati mukufunikadi kubwezeretsa pomwe mudayambira, ndiye musanasankhe, muyenera kupanga chingwe chowonjezera ndikuwerengera mizere yonse, kuyambira kuyambira woyamba. Zinthu zosafunikira zikachotsedwa, mutha kusinthanso ndi gulu lomwe manambala amachokera kuti laling'ono kupita kokulirapo. Poterepa, tebulo lipeza dongosolo loyambirira, mwachilengedwe, kuchotsa zinthu zomwe zidachotsedwa.

Phunziro: Sinthani zambiri mu Excel

Njira 6: gwiritsani ntchito kusefa

Muthanso kugwiritsa ntchito chida monga kusefa kuti muchotse mizere yomwe ili ndi mfundo zina. Ubwino wa njirayi ndikuti ngati mungafunenso mizere iyi, mutha kuwabweza nthawi zonse.

1. Sankhani tebulo lathunthu kapena chomangira pomwepo ndi pomwepo pakugwira batani lakumanzere. Dinani batani lomwe tikudziwa kale Sanjani ndi Fyulutayomwe ili pa tabu "Pofikira". Koma nthawi ino, kuchokera pamndandanda womwe umatseguka, sankhani malo "Zosefera".

   

   Monga njira yapita, ntchitoyi ikhoza kuthetsedwanso kudzera pa tabu "Zambiri". Kuti muchite izi, kukhala momwemo, muyenera dinani batani "Zosefera"ili mu chipangizo Sanjani ndi Fyuluta.



2. Mukatha kuchita chilichonse mwanjira ili pamwambapa, chizindikiritso cha mawonekedwe osakanizira choloza pansi chimawonekera pafupi ndi gawo lamanja la khungu lililonse kumutu. Dinani pachizindikiro ichi mgawo momwe mtengo ulipo, pomwe timachotsa mzere.



3. Zosankha zosewerera zimatseguka. Dziwitsani zomwe zili mumizere yomwe tikufuna kuchotsa. Pambuyo pake, dinani batani "Zabwino".

Chifukwa chake, mizere yokhala ndi zomwe mudasinthirazo izabisika. Koma amathanso kubwezeretsedwanso pochotsa kusefera.

Phunziro: Kuyika zosefera mu Excel

Njira 7: Njira Zosinthira

Mwatsatanetsatane, muthanso kudziwa magawo osankhidwa ngati mugwiritsa ntchito mitundu yokhazikitsira pojambula ndi kupanga kapena kusefa. Pali zosankha zambiri zakulowera pamilandu iyi, chifukwa chake tikambirana mwachitsanzo kuti mumvetsetse momwe angagwiritsire ntchito chinthuchi. Tiyenera kuchotsa mizere yomwe ili patebulo yomwe ndalama zake zimakhala zosakwana ma ruble 11,000.

1. Sankhani mzati "Ndalama Zopeza"komwe tikufuna kugwiritsa ntchito mitundu yozikika. Kukhala mu tabu "Pofikira"dinani pachizindikiro Njira Zakukonzeraniili pa tepi mu block Masitaelo. Pambuyo pake, mndandanda wa zochita umatsegulidwa. Sankhani malo pamenepo Malamulo Osankha Maselo. Kenako, menyu yina imayambitsidwa. Mmenemo, muyenera kusankha mwachindunji tanthauzo la malamulowo. Payenera kukhala chisankho potengera ntchito yeniyeni. Panokha, muyenera kusankha malo "Zochepera ...".



2. Zenera losintha mawonekedwe likuyamba. M'munda wamanzere, ikani mtengo wake 11000. Zinthu zonse zomwe ndizocheperako ndizomwe zimapangidwa. M'munda woyenera, mutha kusankha mtundu uliwonse wamtundu, ngakhale mutha kusiyanso mtengo wokhazikika pamenepo. Zosintha zikamalizidwa, dinani batani "Zabwino".



3. Monga mukuwonera, maselo onse momwe mumapezeka ndalama zosakwana ma ruble 11,000 adapangidwa utoto wosankhidwa. Ngati tikufunika kusunga dongosolo loyambiriralo, titachotsa mizere, timalemba manambala mu mzere woyandikana ndi tebulo. Tsegulani zenera losankha lomwe tili nalo kale "Ndalama Zopeza" njira zilizonse zomwe tafotokozazi.



4. Tsamba losanja limatseguka. Monga nthawi zonse, tcherani khutu ku chinthucho "Zambiri zanga zimakhala ndi mutu" panali cheke. M'munda Longosolani sankhani mzati "Ndalama Zopeza". M'munda "Sinthani" mtengo wokhazikitsidwa Mtundu Wamaselo. M'munda wotsatira, sankhani mtundu womwe mizere yake mukufuna kuchotsa, malinga ndi mawonekedwe ake. Kwa ife, ndi pinki. M'munda "Order" sankhani komwe zidutswa zidzasankhidwa: pamwambapa kapena pansipa. Komabe, izi sizofunika kwambiri. M'pofunikanso kudziwa kuti dzinalo "Order" ikhoza kusunthidwa kumanzere kwa munda womwe. Malangizo onse omwe ali pamwambawo atatsirizika, dinani batani "Zabwino".



5. Monga mukuwonera, mizere yonse momwe mumakhala maselo osankhidwa ndi magulu amaphatikizika limodzi. Adzakhala pamwamba kapena pansi pa tebulo, kutengera magawo omwe wogwiritsa ntchitoyo amafotokozedwa pawindo. Tsopano mungosankha mizere iyi ndi njira yomwe timakonda ndikuchotsa pogwiritsa ntchito menyu wazonse kapena batani pa riboni.



6. Kenako mutha kusintha zomwe zili pamulowo ndi manambala kuti gome lathu litenge zomwe zidalipo kale. Mzere wokhala ndi manambala womwe wakhala wosafunikira ungachotsedwe pakuwunikira komanso kukanikiza batani lomwe mukudziwa Chotsani pa tepi.

Ntchito yomwe idaperekedwa imatha.

Kuphatikiza apo, mutha kugwiranso ntchito yofananira ndi mawonekedwe, koma pokhapokha pakuchita izi.

1. Chifukwa chake, ikani mawonekedwe anu pamalowo "Ndalama Zopeza" m'chochitika chofananacho. Timatha kusefa pa tebulo pogwiritsa ntchito imodzi mwanjira zomwe zalengezedwa pamwambapa.



2. Pambuyo pazithunzi zoyimira zosefera ziwonekera kumutu, dinani pa omwe ali mgululi "Ndalama Zopeza". Pazosankha zomwe zimatsegulira, sankhani "Sulani ndi utoto". Pakadutsa magawo Zosefera Zam'manja sankhani mtengo "Osadzaza".



3. Monga mukuwonera, izi zitatha, mizere yonse yomwe idadzazidwa ndi utoto pogwiritsa ntchito makonzedwe ake idasowa. Zabisidwa ndi fyuluta, koma ngati mutachotsa kusefa, ndiye kuti, zinthu zomwe zikuwonetsedwa ziwonetsedwanso.

Phunziro: Zowongolera mu Excel

Monga mukuwonera, pali njira zambiri zochotsera mizere yosafunikira. Njira yanji yomwe mungagwiritsire ntchito zimatengera ntchitoyo ndi kuchuluka kwa zinthu zomwe zichotsedwe. Mwachitsanzo, kuchotsa mzere umodzi kapena awiri, ndizotheka kupitilira ndi zida wamba. Koma pofuna kusankha mizere yambiri, maselo opanda kanthu kapena zinthu malinga ndi momwe mwaperekera, pali ma aligorivimu ochita zinthu omwe amasalira ntchitoyo kwa ogwiritsa ntchito ndikusunga nthawi yawo. Zida zoterezi zimaphatikizapo zenera posankha gulu la maselo, kusintha, kusefa, kusintha mitundu, ndi zina.