Chotsani maselo mu Microsoft Excel

Pogwira ntchito ndi matebulo a Excel, nthawi zambiri mumafunikira kuti musangomangika ma cell, komanso kuzimitsa. Njira yochotsera nthawi zambiri imakhala yothandiza, koma pali njira zingapo zomwe mungagwiritse ntchito, zomwe si onse omwe adamvapo. Tiphunzire zochuluka za njira zonse zochotsera maselo ena kuchokera ku Excel spreadsheet.

Werengani komanso: Momwe mungachotse mzere ku Excel

Ndondomeko Yachidule Kwamaselo

Kwenikweni, njira yochotsera maselo mu Excel ndikusintha kwawowonjezera. Itha kugawidwa m'magulu awiri akuluakulu: kufufuta odzaza ndi opanda kanthu. Mawonedwe omaliza, kuwonjezera apo, amatha okhaokha.

Ndikofunikira kudziwa kuti pochotsa maselo kapena magulu awo, m'malo mizere yolimba ndi mizati, deta imasinthidwa patebulo. Chifukwa chake, kukhazikitsa njirayi kuyenera kuzindikira.

Njira 1: mndandanda wanthawi zonse

Choyamba, tiyeni tiwone kuperekedwa kwa njirayi kudzera mumenyu yanthawi yonse. Ichi ndi chimodzi mwamitundu yotchuka kwambiri yochita opareshoni iyi. Itha kugwiritsidwa ntchito pazinthu zonse zodzazidwa komanso zopanda kanthu.

1. Sankhani chinthu chimodzi kapena gulu lomwe tikufuna kuti lithetse. Dinani pa kusankha ndi batani la mbewa yoyenera. Zosintha zamakambirano zayambitsidwa. Mmenemo timasankha udindo Chotsani ... ".



2. Iwindo laling'ono lochotsa maselo limayambitsidwa. Mmenemo muyenera kusankha zomwe tikufuna kuchotsa. Zosankha zotsatirazi zilipo:
   • Maselo Akusiyira Kumanzere;
   • Maselo omwe amasunthika;
   • Chingwe;
   • Kholamu.

   Popeza tikuyenera kufufuta maselo, osati mzere wonse kapena mzati, sitimalabadira zosankha ziwiri zomaliza. Sankhani chochita chomwe chikugwirizana ndi zosankha ziwiri zoyambayo, ndikukhazikitsa kusintha koyenera. Kenako dinani batani "Zabwino".



3. Monga mukuwonera, izi zitatha, zinthu zonse zosankhidwa zichotsedwa, ngati chinthu choyamba kuchokera pamndandanda chomwe chatchulidwa pamwambapa chidasankhidwa, kenako ndikusintha.

Ndipo, ngati chinthu chachiwiri chidasankhidwa, ndiye kuti musunthe kumanzere.

Njira 2: zida za tepi

Mutha kuzimitsanso maselo ku Excel pogwiritsa ntchito zida zomwe zimaperekedwa pa riboni.

1. Sankhani chinthucho kuti chithe. Pitani ku tabu "Pofikira" ndipo dinani batani Chotsaniili pa riboni m'bokosi la chida "Maselo".



2. Pambuyo pake, chinthu chosankhidwa chimachotsedwa ndikusunthidwa. Chifukwa chake, kusiyanasiyana kwa njirayi sikupatsa wogwiritsa ntchito njira yosankhira kukameta ubweya.

Ngati mukufuna kuchotsera gulu loyima maselo motere, ndiye kuti malamulo otsatirawa agwiranso ntchito.

1. Timatulutsa gulu lazinthu zopingasa. Dinani batani Chotsanikuyikidwa tabu "Pofikira".



2. Monga momwe zidasinthira kale, zinthu zomwe zidasankhidwa zimachotsedwa ndikusunthira mmwamba.

Ngati tikufuna kuchotsa gulu la zinthu, ndiye kuti izi zidzachitika.

1. Sankhani gulu la ofukula. Dinani batani. Chotsani pa tepi.



2. Monga mukuwonera, kumapeto kwa njirayi, zinthu zomwe zidasankhidwa zidachotsedwa ndikusinthira kumanzere.

Ndipo tsopano tiyeni tiyesetse kusintha njira zingapo pogwiritsa ntchito njira iyi, yomwe ili ndi mbali zonse zoyang'ana kumbali ndi kuzungulira.

1. Sankhani izi ndikudina batani. Chotsani pa tepi.



2. Monga mukuwonera, panthawiyi zinthu zonse zomwe zidasankhidwa zidachotsedwa ndikumanzere.

Amakhulupirira kuti kugwiritsa ntchito zida pa tepi sikumagwira bwino ntchito pochotsa menyu malinga ndi momwe zinthu ziliri. Koma sichoncho. Pogwiritsa ntchito zida zomwe zili pa tepi, muthanso kuchotsa maselo posankha njira yosunthira nokha. Tiyeni tiwone momwe ziziwonekera pa zitsanzo za zomwezo zomwe zili pagome.

1. Sankhani makonda apamwamba kwambiri omwe ayenera kuchotsedwa. Pambuyo pake, dinani batani palokha Chotsani, koma pamakona atatu, omwe amakhala pomwepo kumanja kwake. Mndandanda wamachitidwe omwe akupezeka ndi woyambitsa. Iyenera kusankha njira "Chotsani maselo ...".



2. Kutsatira izi, zenera lakuchotsa limayamba, lomwe tikudziwa kale kuchokera koyamba. Ngati tikufunika kuchotsa makulidwe ophatikizira amitundu ndi kusintha kosiyana ndi komwe kumachitika batani litadina Chotsani pa tepi, muyenera kusunthira kusinthaku "Maselo osunthira mmwamba". Kenako dinani batani "Zabwino".



3. Monga mukuwonera, zitatha izi zidachotsedwa pomwe zoikamo zimasungidwa pazenera lofufutira, ndiye kuti ndikusintha.

Njira 3: gwiritsani ntchito ma cookie

Koma njira yachangu kwambiri yokwaniritsira njira yomwe mwaphunzira ndi mothandizidwa ndi magulu angapo a hotkey.

1. Sankhani mtundu womwe uli patsamba lomwe tikufuna kuchotsa. Pambuyo pake, akanikizire kuphatikiza kiyi "Ctrl" + "-" pa kiyibodi.



2. Zenera lakuchotsa zinthu zomwe timazidziwa kale limayamba. Sankhani komwe mukufuna ndikusintha ndikudina batani "Zabwino".



3. Monga mukuwonera, zitatha izi zidasankhidwa ndikuwongolera kosunthira, zomwe zidanenedwa m'ndime yapitayi.

Phunziro: Excel Hotkeys

Njira 4: chotsani zopatukana

Pali nthawi zina pamene muyenera kuchotsa maulalo angapo omwe si oyandikana, ndiye kuti, ali m'malo osiyanasiyana patebulo. Zachidziwikire, zimatha kuchotsedwa ndi njira zilizonse pamwambazi, ndikuchita mwanjira iliyonse payokha. Koma zimatha kutenga nthawi yambiri. Ndikotheka kuchotsa zinthu zosiyanazo ndi pepalalo mwachangu kwambiri. Koma chifukwa cha ichi, choyambirira, ayenera kukhala odziwika.

1. Choyambirira chimasankhidwa mwanjira zonse, chogwirizira batani lakumanzere ndikulizungulira ndi cholozera. Kenako muyenera kugwira batani Ctrl ndikudina ma cell omwe alipo



2. Kusankha kukamalizidwa, mutha kuuchotsa pogwiritsa ntchito njira zitatu zomwe tafotokozazi. Zinthu zonse zosankhidwa zidzachotsedwa.

Njira 5: chotsani maselo opanda kanthu

Ngati mukufunikira kuchotsa zinthu zopanda kanthu patebulo, njirayi imatha kudzipangira zokha osasankha iliyonse payokha. Pali njira zingapo zothetsera vutoli, koma njira yosavuta yochitira izi ndi kugwiritsa ntchito chida cha masankhidwe a gulu.

1. Sankhani tebulo kapena mtundu uliwonse pa pepalalo pomwe mukufuna kufafaniza. Kenako dinani pa batani la ntchito pa kiyibodi F5.



2. Windo lodumpha likuyamba. Mmenemo, dinani batani "Sankhani ..."ili kumakona ake amunsi kumanzere.



3. Pambuyo pake, zenera pakusankha magulu a maselo limatseguka. Mmenemo, ikani kusintha kwa Maselo opanda kanthukenako dinani batani "Zabwino" kumunsi kwakumanja kwa zenera ili.



4. Monga mukuwonera, pambuyo poti chichitike chomaliza, zinthu zonse zopanda pake zomwe zidasankhidwa zidasankhidwa.



5. Tsopano titha kungochotsa zinthu izi ndi zosankha zilizonse zomwe zikuwonetsedwa mu njira zitatu zoyambirira za phunziroli.

Pali njira zina zochotsera zopanda kanthu, zomwe zimakambidwa mwatsatanetsatane munkhani ina.

Phunziro: Momwe mungachotsere maselo opanda kanthu mu Excel

Monga mukuwonera, pali njira zingapo zochotsera maselo ku Excel. Makina a ambiri aiwo amafanana, chifukwa chake, posankha njira inayake, wogwiritsa ntchito amayang'ana zomwe amakonda. Koma ndikofunikira kudziwa kuti njira yachangu kwambiri yochitira njirayi ndi mothandizidwa ndi makiyi otentha. Kupatukana ndikuchotsa zinthu zopanda kanthu. Ntchitoyi ikhoza kukhala yotha kugwiritsa ntchito chida chosankhira maselo, koma kuchotsa mwachindunji mukufunabe kugwiritsa ntchito imodzi mwazomwe mungasankhe.