Pamene mukugwira ntchito ndi Excel spreadsheets, nthawi zambiri pamafunikira osati kungoika maselo, komanso kuchotsa. Ndondomeko yowonongeka imakhala yovuta, koma pali njira zambiri zomwe mungachite kuti mugwire ntchitoyi, zomwe osagwiritsa ntchito onse adamva. Tiyeni tiphunzire zambiri za njira zonse zochotsera maselo ena kuchokera ku spreadsheet ya Excel.
Onaninso: Chotsani mzere ku Excel
Njira Yotsitsira Cell
Kwenikweni, ndondomeko yochotsa maselo ku Excel ikutsutsana ndi ntchito yowonjezera. Ikhoza kugawa m'magulu akulu awiri: kuchotsa maselo odzazidwa ndi opanda kanthu. Mtundu wotsirizawu, pambali pake, ukhoza kukhala wokhazikika.
Ndikofunika kudziwa kuti pochotsa maselo kapena magulu awo, osati mizere ndi mizere yolimba, deta yomwe yasintha imasinthidwa. Choncho, kukhazikitsidwa kwa njirayi kuyenera kukhala mwachangu.
Njira 1: mndandanda wamakono
Choyamba, tiyeni tione momwe ntchitoyi ikugwiritsidwira ntchito kudzera mndandanda wamakono. Ichi ndi chimodzi mwa mitundu yotchuka kwambiri yopanga opaleshoniyi. Ikhoza kugwiritsidwa ntchito pa zinthu zonse zodzazidwa ndi zopanda kanthu.
- Sankhani chinthu chimodzi kapena gulu limene tikufuna kuchotsa. Dinani pasankhidwe ndi batani lamanja la mbewa. Menyu yotsatira ikuyambitsidwa. Mmenemo timasankha malo "Chotsani ...".
- Amathamangitsira zenera laling'ono lochotsamo selo. Muyenera kusankha chomwe tikufuna kuchotsa. Pali zotsatirazi:
- Maselo, achoka kusintha;
- Kusinthitsa Maselo;
- Mzere;
- Mzere.
Popeza tikufunikira kuchotsa maselo, osati mzere kapena mizere yonse, sitimasamalira njira ziwiri zomaliza. Sankhani zochita zomwe zikugwirizana ndi zoyamba ziwiri, ndikuyikira pa malo oyenera. Kenaka dinani pa batani. "Chabwino".
- Monga mukuonera, mutatha izi, zinthu zonse zosankhidwa zidzachotsedwa: ngati chinthu choyamba kuchokera pa mndandanda watchulidwa pamwambapa ndisasunthike mmwamba.
Ndipo, ngati chinthu chachiwiri chidasankhidwa, ndiye kuti mutembenuzire kumanzere.
Njira 2: Zida za tepi
Kuchotsa maselo mu Excel kungathenso kuchitidwa pogwiritsira ntchito zida zomwe zimaperekedwa pa tepi.
- Sankhani chinthu chomwe chiyenera kuchotsedwa. Pitani ku tabu "Kunyumba" ndipo dinani pa batani "Chotsani"yomwe ili pa tepiyi mu zida za zipangizo "Maselo".
- Pambuyo pake, chinthu chosankhidwa chidzachotsedwa ndi kusintha. Kotero, njira iyi ya njirayi siyilola wogwiritsa ntchito kusankha njira ya kusintha.
Ngati mukufuna kuchotsa gulu losakanikirana la maselo mwanjira iyi, ndiye malamulo otsatirawa adzagwiritsidwa ntchito.
- Sankhani gulu ili lazinthu zamakono. Dinani pa batani "Chotsani"inayikidwa pa tabu "Kunyumba".
- Monga momwe zinalili kale, zinthu zosankhidwa zimachotsedwa ndi kusintha kosintha.
Ngati tiyesa kuchotsa gulu loyang'anapo, ndiye kusintha kumeneku kudzachitika kwinakwake.
- Sankhani gulu la zinthu zomwe zikuwoneka bwino. Dinani pa batani. "Chotsani" pa tepi.
- Monga momwe mukuonera, kumapeto kwa ndondomekoyi, zinthu zomwe anasankhidwa zinachotsedwa ndi kusintha kwamanzere.
Ndipo tsopano tiyesera kuchotsa mwa njira iyi ya mitundu yambiri yomwe ili ndi zinthu ziwiri zonse zozungulira komanso zowongoka.
- Sankhani izi ndipo dinani batani. "Chotsani" pa tepi.
- Monga momwe mukuonera, pa nkhaniyi, zinthu zonse zosankhidwa zinachotsedwa ndi kusintha kuseri.
Amakhulupirira kuti kugwiritsa ntchito zipangizo pa riboni sikungagwire ntchito kusiyana ndi kuchotsa kupyolera mumakondomu, chifukwa chosankha ichi sichipatsa wopha kusankha ufulu wosankha. Koma si choncho. Pogwiritsira ntchito zipangizo pa riboni, mukhoza kuchotsa maselo posankha chitsogozo cha kusintha. Tiyeni tiwone momwe ziwonekere pa chitsanzo cha zomwezo mu tebulo.
- Sankhani mitundu yambiri, yomwe iyenera kuchotsedwa. Pambuyo pake, dinani pa batani palokha. "Chotsani", ndi pa katatu, komwe kuli pomwepo kumanja. Amagwiritsa ntchito mndandanda wa zochita zomwe zilipo. Iyenera kusankha kusankha "Chotsani maselo ...".
- Izi zikutsatiridwa ndi kukhazikitsidwa kwawindo lazitsulo, lomwe talidziwa kale ndi ife poyambirira. Ngati tifunika kuchotsa magawo ambirimbiri ndi kusintha komwe kuli kosiyana ndi zomwe zimachitika mukangosindikiza batani "Chotsani" pa tepi, muyenera kusuntha makasitomala kuti muyambe "Maselo, ndi kusintha kwake". Kenaka dinani pa batani. "Chabwino".
- Monga momwe mukuonera, patatha izi, ndondomekoyi inachotsedwa pamene makonzedwe adatchulidwa muwindo lawonetsera, ndiko, ndi kusintha kosintha.
Njira 3: Gwiritsani ntchito zotentha
Koma njira yofulumira kwambiri yopangira ndondomeko yophunzirira ikhoza kugwiritsidwa ntchito pogwiritsa ntchito makina otentha.
- Sankhani mtundu umene tikufuna kuchotsa pa pepala. Pambuyo pake, yesani kuphatikizira "Ctrl" + "-" pabokosi.
- Fenjelo lodziwika kale lochotsa zinthu likuyambitsidwa. Sankhani zoyenera kusintha ndikusindikiza pa batani. "Chabwino".
- Monga mukuonera, patatha izi, zinthu zomwe zasankhidwa zinachotsedwa ndi kutsogolo kwa kusintha, zomwe zasonyezedwa m'ndime yapitayi.
PHUNZIRO: Ma Keys Otentha ku Excel
Njira 4: Chotsani Zinthu Zowonongeka
Pali zifukwa pamene mukufunika kuchotsa mipangidwe yambiri yomwe ili pafupi, ndiko kuti, ali mbali zosiyanasiyana pa tebulo. Inde, iwo akhoza kuchotsedwa ndi njira zilizonse zomwe tazitchula pamwambapa, kuchita njirayi mosiyana ndi chinthu chilichonse. Koma zingatenge nthawi yambiri. N'zotheka kuchotsa zinthu zosiyana kuchokera pa pepala mofulumira. Koma pazimenezi, makamaka, zonse ziyenera kuwonetsedwa.
- Timasankha chinthu choyamba mwanjira yodalirika, kugwiritsira pansi batani lamanzere ndi kupukusa kuzungulira ilo ndi chithunzithunzi. Ndiye muyenera kugwira batani Ctrl ndipo dinani maselo otsalira omwe atsala pang'ono kapena kuzungulira mitsinje ndi chithunzithunzi chopanikizidwa ndi batani lamanzere.
- Mutatha kusankha, mutha kuchichotsa pogwiritsa ntchito njira zitatu zomwe tafotokozera pamwambapa. Zosankha zonse zidzachotsedwa.
Njira 5: Chotsani Maselo Opanda
Ngati mukufuna kuchotsa zinthu zopanda kanthu patebulo, ndiye kuti njirayi ikhale yosasunthika ndipo sizimalekanitsa aliyense payekha. Pali njira zingapo zothetsera vutoli, koma njira yosavuta yochitira izi ndi yothandizira gulu la magulu.
- Sankhani tebulo kapena china chilichonse pa pepala pamene mukufuna kuchotsa. Kenaka dinani pa fungulo la ntchito pa kambokosi. F5.
- Windo la kusintha likuyamba. Iyenera kudina pa batani "Konzani ..."anaikidwa mu ngodya yake ya kumanzere.
- Pambuyo pake mawindo a gululo amasankhidwa. Iyenera kukhazikitsa chosinthana ku malo "Maselo opanda kanthu"ndiyeno dinani batani "Chabwino" kumbali ya kumanja yazenera yawindo ili.
- Monga mukuonera, mutatha ntchito yomaliza, zinthu zonse zopanda kanthu muzinthu zomwe zafotokozedwa zinasankhidwa.
- Tsopano tikuyenera kuchotsa zinthu izi ndi njira zilizonse zomwe zili mu njira zitatu zoyambirira za phunziroli.
Pali zina zomwe mungachite pochotsa zinthu zopanda kanthu, zomwe zikufotokozedwa mwatsatanetsatane m'nkhani yapadera.
PHUNZIRO: Mmene mungatulutse maselo opanda kanthu mu Excel
Monga mukuonera, pali njira zambiri zochotsera maselo mu Excel. Momwe ambiri a iwo alili ofanana, kotero posankha zochita zina, wogwiritsa ntchito amatsogoleredwa ndi zofuna zake. Koma ndibwino kuti muzindikire kuti njira yofulumira kwambiri yopangira ndondomekoyi ndi kugwiritsa ntchito makina otentha. Kumeneko ndiko kuchotsedwa kwa zinthu zopanda kanthu. Mukhoza kusuntha ntchitoyi pogwiritsa ntchito chida chosankhira selo, koma mutha kugwiritsa ntchito chimodzi mwazomwe mungasankhe kuchotsa mwachindunji.
