Momwe mungachotse chingwe ku Excel

Pa nthawi ya ntchito ya Excel, nthawi zambiri mumakhala ndi njira yochotsera mizere. Izi zitha kukhala zosakwatiwa komanso gulu, kutengera ntchitoyi. Chosangalatsa kwambiri pa dongosolo lino chimachotsedwa. Tiyeni tiwone njira zosiyanasiyana panjirayi.

Njira Yochotsa Mizere

Kuchotsa kuchotsedwa kumatha kupangidwa m'njira zosiyanasiyana. Kusankha kwa njira inayake kumadalira zomwe wogwiritsa ntchito amayika patsogolo pawo. Ganizirani njira zosiyanasiyana, kuyambira pazinthu zosavuta komanso kutha ndi njira zovuta.

Njira 1: Kuchotsa kamodzi pa menyu

Njira yosavuta yochotsera mizere ndi njira imodzi yokha ya njirayi. Mutha kupha pogwiritsa ntchito menyu.

1. Kudina kumanja kwa maselo aliwonse a zingwe zomwe mukufuna kufufuta. Muzosankha zomwe zikuwoneka, sankhani "chotsani ...".



2. Windo laling'ono limatsegulidwa, momwe muyenera kutchula zomwe muyenera kuchotsa. Timakonzanso kusinthanitsa ndi "chingwe".

   

   Pambuyo pake, chinthu chodziwikacho chidzachotsedwa.

   Mutha kudinanso batani la Mouse Kumanzere Pamodzi ndi nambala ya mzere pagawo lolumikiza. Kenako, dinani batani lamanja mbewa. Pa menyu oyambitsidwa, mukufuna kusankha "chotsani".

   

   Pankhaniyi, njira ya Deleation imadutsa nthawi yomweyo ndipo safunikira kuwonjezera zina mu zenera losankha.

Njira 2: Kuchotsa kamodzi ndi zida za tepi

Kuphatikiza apo, njirayi imatha kuchitidwa pogwiritsa ntchito zida za temp zomwe zimayikidwa m'bwalo lanyumba.

1. Timatulutsa maperewera kulikonse mzere womwe mukufuna kuchotsa. Pitani ku "kunyumba". Dinani pa picogram mu mawonekedwe a makona atatu, omwe amapezeka kumanja kwa "Chotsani" mu "Zida zam'manja". Mndandanda womwe mukufuna kusankha "Chotsani mizere kuchokera pa pepala" chinthu.



2. Mzerewo uchotsedwa nthawi yomweyo.

Muthanso kuwonetsanso chingwecho mokwanira podina batani la mbewa lamanzere ndi nambala yake pagawo lolumikiza. Pambuyo pake, kukhala mu "kunyumba", dinani chithunzi chochotsa, chomwe chili mu "zida zam'manja".

Njira 3: Kuchotsa Gulu

Kuti muchite kuchotsa mizere ya anthu, choyamba, muyenera kusankha zinthu zofunika.

1. Pofuna kuchotsa mizere yochepa yapafupi, mutha kusankha maselo oyandikana ndi zingwe zomwezo. Kuti muchite izi, tsitsani batani lamanzere la mbewa ndikugwiritsa ntchito chotembereredwa pazinthu izi.

   

   Ngati mtunduwo ndi waukulu, mutha kusankha foni yapamwamba kwambiri podina ndi mbewa yakumanzere. Kenako reat kiyi yosinthira ndikudina pa selo lam'munsi la gulu kuti lichotsedwe. Zinthu zonse zomwe zili pakati pawo zidzatsimikizika.

   

   Ngati mukufuna kuchotsa mizere yotsika yomwe ili kutali ndi wina ndi mnzake, ndiye kuti mupeze gawo limodzi la maselo omwe ali mkati mwake, batani lamanzere la mbewa ndi nthawi imodzi. Zinthu zonse zosankhidwa zidzalembedwa.



2. Kuti muthe kuchotsedwa mwachindunji, itanani zojambulajambula kapena pitani pazida za temp, kenako tsatirani malingaliro omwe adaperekedwa pakulongosola kwa njira yoyamba ndi yachiwiri ya bukuli.

Sankhani zinthu zomwe mukufuna kuchita zimatha kukhala kudzera mu gawo lolumikiza. Pankhaniyi, osati ma cell omwe adzagawidwe, koma mizereyi ndi yonse.

1. Pofuna kutsimikiza gulu loyandikana ndi mbewa, kwezani batani lakumanzere ndikugwiritsa ntchito mawu otsetsereka pamwamba pa mzere wapamwamba kuti achotsedwe pansi.

   

   Muthanso kugwiritsa ntchito njira pogwiritsa ntchito kiyi yosinthira. Dinani kumanzere dinani pa nambala yoyamba ya mitunduyo kuti ichotsedwe. Kenako pini kiyi yosinthira ndikudina nambala yomaliza ya malo omwe atchulidwa. Mizere yonse yaima ili pakati pa manambala awa idzafotokozedwa.

   

   Ngati mizere yochotsa yabalalika pa pepalalo ndipo musakhale malire wina ndi mnzake, ndiye kuti, muyenera kudina batani lakumanzere pabwalo lazogwirizana ndi pini ya Ctrl.



2. Pofuna kuchotsa mizere yosankhidwa, dinani batani lililonse la mbewa. Mu menyu, mumayimitsa "chotsani" chinthu.

   

   Kuchotsa zinthu zonse zosankhidwa kudzapangidwa.

Phunziro: Momwe mungasankhire Excel

Njira 4: Kuchotsa zinthu zopanda kanthu

Nthawi zina mizere yopanda kanthu imatha kupezeka pagome, zomwe zinachotsedwa kale. Zinthu ngati izi zimachotsedwa bwino pa pepalalo. Ngati ali pafupi, ndizotheka kugwiritsa ntchito njira imodzi yomwe tafotokozerazi. Koma choti ndichite ngati pali mizere yambiri yopanda kanthu ndipo yabalalika mdera lalikulu? Kupatula apo, njira yofufuzira ndi kuchotsedwa kwawo imatha kutenga nthawi yayitali. Kuthamangira yankho la ntchitoyi, mutha kugwiritsa ntchito algorithm zotsatirazi.

1. Pitani ku "kunyumba". Pa riboni ya tepi timadina pa "pezani ndi kugawa" chithunzi. Ili m'gulu losintha. Pa mndandanda womwe umatsegulidwa, dinani pa chinthucho "gawo la magawo awiri a maselo".



2. Kusankha kochepa kwa gulu la maselo kumayambitsidwa. Timasinthiratu kupita ku "ma cell opanda kanthu". Pambuyo pake, dinani batani la "OK".



3. Monga tikuwonera, titaikapo izi, zinthu zonse zopanda kanthu zimatsimikizika. Tsopano mutha kugwiritsa ntchito kuti muchotse njira iliyonse yomwe takambirana pamwambapa. Mwachitsanzo, mutha kudina batani la "Chotsani", lomwe limapezeka pa tepi mu tabu imodzi, kunyumba ", komwe tikugwira tsopano.

   

   Monga mukuwonera, zinthu zonse zopanda kanthu zimachotsedwa.

Zindikirani! Mukamagwiritsa ntchito njirayi, mzerewu uyenera kukhala wopanda kanthu. Ngati pali zinthu zopanda pake patebulo lomwe ili mu chingwe chomwe chili ndi zambiri monga chithunzi pansipa, njirayi siyingagwiritsidwe ntchito. Kugwiritsa ntchito kwake kumatha kusintha kusuntha komanso kusokonezeka kwa tebulo.

Phunziro: Momwe mungachotse mizere yopanda kanthu

Njira 5: Kugwiritsa Ntchito Kusankha

Pofuna kuchotsa mizere pachikhalidwe china, mutha kugwiritsa ntchito kukonza. Kusankha Zinthu Ndi Kukhazikika kwakhazikitsidwa, tidzatha kutolera mizere yonse yokhutiritsa ngati abalalika pagome lonse, ndipo tiwachotse mwachangu.

1. Tikuwonetsa dera lonse la tebulo lomwe kusankha liyenera kusanjidwa, kapena limodzi la maselo ake. Pitani ku "Home" ndikudina pa "mtundu ndi sefa" chithunzi cha "chomwe chili mu gulu losintha. Pamndandanda wazosankha zomwe mungatsegule, sankhani "mtundu wa" Mtundu ".

   

   Zochita zina zitha kupangidwanso, zomwe zimabweretsanso pawindo la kusintha kwa mwambo. Pambuyo kuwononga chinthu chilichonse cha tebulo, pitani ku tabu ya data. Pali gulu la zigawo "mtundu ndi zosefera" timadina batani la "Mtundu".



2. Windo la kusinthasintha kwasintha. Onetsetsani kuti mukuyang'ana bokosilo, pankhani ya kusowa kwake, kuzungulira chinthucho "Zambiri Zikakhala ndi mutu", ngati tebulo lanu lili ndi chipewa. Mu "munda wa" muyenera kusankha dzina la mzati womwe kusankha zinthu kumachitika kuti uchotse. Mu "Mtundu", muyenera kutchula moyenereratu kuti gawo lidzasankhidwa:
   • Mfundo;
   • Mtundu wa maselo;
   • Utoto;
   • Chizindikiro cha m'manja.

   Zonse zimatengera zochitika zapadera, koma nthawi zambiri zimayambitsa "matanthawuzo" ndi abwino. Ngakhale mtsogolo tidzakambirana za kugwiritsa ntchito udindo wina.

   Mu "Dongosolo" lomwe muyenera kutchula zomwe zimapangidwira. Kusankhidwa kwa njira zomwe zili m'munda uno kumatengera mtundu wa zomwe zidasankhidwa. Mwachitsanzo, kwa deta ya mameseji, dongosolo lidzakhala "kuchokera ku Z" kapena "Ndili ndi", koma tsiku lakale "kapena" kuchokera kwa Chatsopano kukhala chatsopano "kapena" Kuyambira zatsopano ". Kwenikweni, lamulolokha silili bwino, popeza mulimonsemo, malingaliro osangalatsa kwa ife apezeka limodzi.

   Pambuyo pa malowo pazenera izi zimapangidwa, dinani batani la "OK".



3. Zambiri za mzere wosankhidwa zidzasanjidwa ndi zolimbitsa. Tsopano titha kugawa pafupi ndi zinthu zilizonse zomwe zapemphedwazo zikukambidwa mukaganizira njira zomwe zalembedwazo, ndikuzichotsa.

Mwa njira, njira yomweyo ingathe kugwiritsidwa ntchito kwa gulu komanso kuchotsa mizere yopanda kanthu.

Chidwi! Ndikofunikira kulingalira kuti pochita mtundu wotere, mutachotsa maselo osaneneka, malo am mindayo amasiyana ndi woyamba. Nthawi zina zilibe kanthu. Koma, ngati mukufuna kubwezeretsa malo oyambawo, ndiye kuti musanakonzekere, khola lina liyenera kumangidwa ndikuwerengedwa mmenemo mzere kuyambira woyamba. Pambuyo pa zinthu zosafunikira zimachotsedwa, mutha kukonzanso nambala yomwe nambala iyi imapezeka kuchokera kucheperako. Pankhaniyi, tebulo lidzapeza koyamba, mwachilengedwe zisungunuke zakutali.

Phunziro: Kukonza deta mu Excel

Njira 6: Kugwiritsa Ntchito Zosefera

Kuchotsa zingwe zomwe zimakhala ndi mfundo zina, mungagwiritsenso ntchito chida chotere monga kusefa. Ubwino wa njirayi ndikuti ngati mwadzidzidzi muli ndi mizere iyi nthawi zonse izi zimafunikiranso, mutha kuzibweza nthawi zonse.

1. Timatsindika tebulo lonse kapena mutu ndi chotembereredwa ndi batani lakumanzere. Dinani pa batani lodziwika bwino ndi "mtundu ndi sefa", yomwe ili mu tabu yakunyumba. Koma nthawi ino "Fyuluta" imasankhidwa kuchokera pamndandanda woyamba.

   

   Monga mwa njira yapita, ntchitoyi imathanso kuthetsedwa kudzera mu data ya data. Kuti muchite izi, mukadali mmenemo, muyenera dinani batani la "Fyuluta", yomwe ili mu "mtundu wa" chida.



2. Pambuyo pochita chilichonse pamwambapa, chizindikiritso chimawonekera pafupi ndi malire a khungu lililonse la kapu, ngodya pansi. Timadina pachifaniziro ichi mu khola pomwe mtengo wake udzachotsa mizere.



3. Mndandanda wosema umatseguka. Chotsani nkhupakupa kuchokera pamikhalidwe imeneyi m'mizere yomwe tikufuna kuchotsa. Pambuyo pake, dinani batani la "OK".

Chifukwa chake, mizere yomwe ili ndi mfundo zomwe mumachotsa mabokosiwo zidzabisika. Koma amatha kubwezeretsedwanso nthawi zonse, kuchotsa zosefera.

Phunziro: Zosefera pa Excel

Njira 7: Mawonekedwe

Ngakhale molondola kwambiri, mutha kukhazikitsa magawo posankha mizere ngati mumagwiritsa ntchito zida zamagetsi limodzi ndi kusanja kapena kusefa. Pali zosankha zambiri zomwe zikuthandizira pamenepa, motero timaganizira za chitsanzo chapadera kuti mumvetsetse momwe mungagwiritsire ntchito mwayiwu. Tiyenera kuchotsa mizere yomwe kuchuluka kwa ndalamazo kumakhala kochepera ma ruble 11,000.

1. Timagawa ndalama za "ndalama", komwe tikufuna kugwiritsa ntchito mawonekedwe. Kukhala mu "kunyumba" tabu, timadina pa "mawonekedwe a" zomwe zili pa tepi mu "masitayilo" block. Pambuyo pake, mndandanda wazomwe amatsegula. Timasankha udindo "Malamulo a magawidwe a maselo". Kenako, mndandanda wina wakhazikitsidwa. Imafunika kusankha mwachindunji tanthauzo la lamuloli. Payenera kusankhidwa kale, kutengera ntchito yeniyeni. Pankhani yathu ina, muyenera kusankha "zochepa ...".



2. Zenera lokhala ndi mawonekedwe oyambira limayambitsidwa. M'munda wamanzere, khazikitsani mtengo wa 11000. Makhalidwe onse omwe sakhala ochepa kuposa omwe adzafalitsidwa. Mu gawo loyenera, ndizotheka kusankha mtundu uliwonse, ngakhale kuti mungathenso kusiya phindu pamenepo. Zikhazikiko zitatha, dinani batani la "OK".



3. Monga mukuwonera, maselo onse omwe mumakhala ochepera ma ruble 11,000, adapaka utoto wosankhidwa. Ngati tikufuna kupulumutsa dongosolo loyambirira, titachotsa mizere, timapanga zowonjezera pamtengo wapafupi ndi tebulo. Tidayambitsa zenera lokonzeka kale kwa "ndalama zofananira" ndi njira zilizonse zomwe zidafotokozedwa pamwambapa.



4. Windo la kukonza limatseguka. Monga nthawi zonse, timaganizira za "chinthu cha data cha data chomwe chimakhala" chinaima chizindikiro. Mu "Mtundu wa" sungani "ndalama" ndalama. Mu "mtundu", khazikitsani "mtundu wa maselo". M'munda wotsatira, sankhani utoto, mizere yomwe muyenera kuchotsa, malinga ndi mawonekedwe. Kwa ife, izi ndi mtundu wa pinki. Mu "dongosolo", timasankha komwe zidutswa zodziwika bwino zidzagawidwa: kuchokera kumwamba kapena pansipa. Komabe, ilibe kufunika kofunikira. Ndikofunikanso kudziwa kuti dzina "Lolemba" litha kusunthidwa kumanzere kwa mundawo. Pambuyo pa zoika zonse zapamwambazi zimapangidwa, kanikizani batani la "OK".



5. Monga tikuwona, mizere yonse yomwe pali maselo owerengedwa amaphatikizidwa. Adzakhala pamwamba kapena pansi pa tebulo, kutengera magawo omwe amapezeka pazenera. Tsopano ingosankha zowuma izi pogwiritsa ntchito njira yomwe tikufuna, ndipo timachotsedwa pogwiritsa ntchito batani kapena batani la tepi.



6. Mutha kusintha zomwe zili patsamba lomaliza kuti tebulo lathu lizichita chimodzimodzi. Mbali yosafunikira yomwe ndi manambala imatha kuchotsedwa posankha ndikukaniza batani "Chotsani" pa riboni.

Ntchitoyo idathetsedwa pazomwe zidanenedwazo.

Kuphatikiza apo, ndizotheka kubalanso zomwezi ndi mawonekedwe ofananira, koma pokhapokha atatha kuzimiririka.

1. Chifukwa chake, timagwiritsa ntchito mawonekedwe ogwirizana ndi "ndalama zowonjezera" zomwe zili ndi mawonekedwe ofanana. Phatikizani zosefera patebulo mu njira imodzi yomwe idanenedweratu pamwambapa.



2. Zithunzizi zitawonekera mumutu, zikuimira Fyuluta, dinani ndi iwo, omwe ali mu ngongole. Mumenyu zomwe zimatsegula, sankhani "zosefera". Mu chipika cha "maluwa" a cell, sankhani "osadzaza" mtengo wake.



3. Monga mukuwonera, zitachitika izi, mizere yonse yomwe idadzazidwa ndi utoto pogwiritsa ntchito mawonekedwe omwe asowa. Amabisidwa ndi Fyuluta, koma ngati mungachotse kusefa, ndiye kuti zinthu zotchulidwa zidzawonetsedwanso mu chikalatacho.

Phunziro: Mawonekedwe ogwirizana

Monga mukuwonera, pali njira zambiri m'njira zochotsera mizere yosafunikira. Zomwe lingaliro limatengera ntchitoyi ndi kuchuluka kwa zinthu zomwe zachotsedwa. Mwachitsanzo, kuchotsa mizere imodzi kapena iwiri, ndizotheka kuchita ndi zida zochotsa SOLO. Koma pofuna kusiyanitsa mizere yambiri, ma cell osowa pa mkhalidwe wopatsidwa, pali algorithms pazomwe zimatsogolera kwambiri ntchito ya ogwiritsa ntchito ndikusunga nthawi yawo. Zida zoterezi zimaphatikizaponso zenera losankha gulu la maselo, kukonza, kusefa, kapangidwe kake, ndi zina.