Monga lamulo, kwa ogwiritsa ntchito ambiri, kuwonjezera maselo akamagwira ntchito ku Excel sikuimira ntchito yovuta kwambiri. Koma, mwatsoka, si aliyense amene amadziwa njira zonse zochitira izi. Koma nthawi zina, kugwiritsa ntchito njira inayake kungathandize kuchepetsa nthawi yomwe imagwiritsidwa ntchito pochita njirayi. Tiyeni tiwone mitundu yosankha yowonjezera maselo atsopano ku Excel.
Onaninso: Momwe mungapangire mzere watsopano mu tebulo la Excel
Momwe mungayikitsire mzati mu Excel
Ndondomeko Yowonjezera Ma Cell
Tidzangolabadira momwe mbali yaukadaulo njira yowonjezerera maselo imachitikira. Kwakukulukulu, zomwe timazitcha kuti "kuwonjezera" kwenikweni ndizoyenda. Ndiye kuti, maselo amangosunthira pansi kumanja. Ma mfundo omwe ali kumapeto kwenikweni kwa pepalali amachotsedwa pomwe maselo atsopano amawonjezeredwa. Chifukwa chake, ndikofunikira kuyang'anira njira zomwe zikuwonetsedwa ngati pepalalo ladzazidwa ndi data ndi oposa 50%. Ngakhale, kupezeka kuti m'matembenuzidwe amakono, Excel ili ndi mizere 1 miliyoni ndi mizati pa pepala, pochita izi ndikosowa kwambiri.
Kuphatikiza apo, ngati mukuwonjezera maselo, osati mzere wathunthu ndi mzati, muyenera kuganizira kuti patebulopo pomwe mumagwira ntchito, idatha imasunthika, ndipo mawonekedwe sangafanane ndi mizere kapena mzati womwe mudafanana kale.
Chifukwa chake, tsopano tiyeni tisunthire njira zina zowonjezeramo pepala.
Njira 1: Menyu yankhani
Njira imodzi yofotokozera maselo mu Excel ndikugwiritsa ntchito menyu.
- Sankhani pepala lomwe tikufuna kuyikamo foni yatsopano. Timadulira pomwepo ndi batani la mbewa. Zosintha zamakambirano zayambitsidwa. Sankhani malo mmenemu "Patani ...".
- Pambuyo pake, zenera laling'ono loyika limatsegulidwa. Popeza timakondwera ndi kukhazikitsidwa kwa maselo, osati mizere yonse kapena mizati, mfundo zake "Mzere" ndi Kholamu sitinyalanyaza. Timapanga kusankha pakati pa mfundo "Maselo, asinthidwa kumanja" ndi "Maselo osinthika", mogwirizana ndi mapulani awo pokonzekera tebulo. Pambuyo kusankha kwapangidwa, dinani batani "Zabwino".
- Ngati wogwiritsa ntchito wasankha "Maselo, asinthidwa kumanja", pamenepo zosinthazo zitenga mawonekedwe ofanana ndi omwe ali patebulo pansipa.
Ngati njira idasankhidwa ndipo "Maselo osinthika", ndiye tebulo lisintha motere.
Momwemonso, mutha kuwonjezera magulu onse a maselo, pokhapokha pokhapokha, musanapite ku menyu yazomwe mukufuna, muyenera kusankha kuchuluka kwa zinthu zomwe zili papepala.
Pambuyo pake, zinthuzo zidzawonjezedwa molingana ndi algorithm yomweyo yomwe tafotokozera pamwambapa, koma kokha ndi gulu lonse.
Njira 2: Chingwe cha Ribbon
Mutha kuwonjezera zinthu pa pepala la Excel kudzera pabatani. Tiyeni tiwone momwe angachitire.
- Sankhani chinthucho m'malo mwa pepalalo pomwe tikufuna kuwonjezera khungu. Pitani ku tabu "Pofikira"ngati tili pano. Kenako dinani batani Ikani mu bokosi la zida "Maselo" pa tepi.
- Pambuyo pake, chinthucho chidzawonjezedwa ku pepalalo. Komanso, mulimonsemo, adzawonjezedwa ndi chopondera pansi. Chifukwa chake njirayi idasinthasintha kuposa momwe idalili kale.
Pogwiritsa ntchito njira yomweyo, mutha kuwonjezera magulu a maselo.
- Sankhani gulu loyang'ana pazinthu za pepala ndikudina chizindikiro chomwe tikudziwa Ikani pa tabu "Pofikira".
- Pambuyo pake, gulu lazinthu zamatsenga zidzayikidwa, monga zowonjezera kamodzi, ndikusunthira pansi.
Koma posankha gulu la maselo ofukula, timapeza zotsatira zosiyana.
- Sankhani magulu ofukula a zinthu ndikudina batani Ikani.
- Monga mukuwonera, mosiyana ndi zomwe zidasankhidwa kale, pamenepa gulu la zinthu zosinthira kumanja zidawonjezeredwa.
Chingachitike ndi chiani ngati tiwonjezera zinthu zomwe zili zowongoka komanso zowongoka m'njira yomweyo?
- Sankhani makonda amtundu woyenera ndikudina batani lomwe tikudziwa kale Ikani.
- Monga mukuwonera, panthawiyi, zinthu zosintha kumanja zidzayikidwa m'malo osankhidwa.
Ngati mukufunabe kutchula mwachindunji malo omwe ayenera kusunthidwa, mwachitsanzo, mukawonjezera gulu, mukufuna kuti kusintha kusachitike, ndiye kuti muyenera kutsatira lotsatira.
- Sankhani chinthu kapena gulu la zinthu zomwe tikufuna kuyikapo. Timadina batani lomwe sitilimva bwino Ikani, ndi mmbali mwa makona atatu, omwe akuwonetsedwa kumanja kwake. Mndandanda wa zochita umatseguka. Sankhani zomwe zili mmenemo "Ikani ma cell ...".
- Pambuyo pake, zenera loyika, lomwe limazolowera mwanjira yoyamba, limatseguka. Sankhani chosankha. Ngati ife, monga tafotokozera pamwambapa, tikufuna kuchitapo kanthu ndikusintha, ndiye kuti tiyimitseni "Maselo osinthika". Pambuyo pake, dinani batani "Zabwino".
- Monga mukuwonera, zinthuzo zidawonjezedwa ndi pepalalo ndi kosunthira pansi, ndiko kuti, ndendende momwe tidakhazikitsira.
Njira 3: Otsuka
Njira yofulumira kwambiri yowonjezerera zinthu za pepala mu Excel ndikugwiritsa ntchito kuphatikiza kwa hotkey.
- Sankhani zinthu zomwe tikufuna kuyikapo. Pambuyo pake timalemba pa kiyibodi kuphatikiza mafungulo otentha Ctrl + Shift + =.
- Kutsatira izi, zenera laling'ono loyika zinthu zomwe timazidziwa kale lidzatseguka. Mmenemo muyenera kukhazikitsa cholakwika kumanja kapena pansi ndikudina batani "Zabwino" momwemo momwe tidapangira mobwerezabwereza m'mbuyomu njira zomwe tidapangira kale.
- Pambuyo pake, zinthu zomwe zili papepala zidzayikidwa, malingana ndi zoyambirira zomwe zidapangidwa m'ndime yapitayi ya malangizowa.
Phunziro: Okhazikika ku Excel
Monga mukuwonera, pali njira zitatu zazikulu zokhazikitsira maselo pagome: kugwiritsa ntchito menyu wankhani, mabatani pa riboni, ndi mafungulo otentha. Pankhani ya magwiridwe antchito, njirazi ndi zofanana, chifukwa posankha, choyambirira, kuphatikiza kwa wogwiritsa ntchito kumawerengedwa. Ngakhale, motalikira, njira yothamanga kwambiri ndikugwiritsa ntchito ma cookke. Koma, mwatsoka, si onse ogwiritsa ntchito omwe amazolowera kusunga zomwe zikupezeka mu Excel hotkey kukumbukira kwawo. Chifukwa chake, kutali ndi aliyense njira yachangu iyi ikhale yabwino.
